Covers Extract, Transform and Load process which moves and transforms data from Finance / Practice Management Systems to the Data Warehouse
- Cube design: FACTS vs Dimensions, aggregations, granularity DataMart's
- Source control, Deployment and worst case risk mitigation, What if??
- Development, Test and Production environments reviews
- Resource requirements vs available resource across environments
- Data Warehouse strategy review for performance and future requirements compatibility
- Maintenance and housekeeping of end to end BI solution relative to existing client base and underlying Infrastructure review
- Presentation of Documentation with "AS IS" and any "To Be" recommendations
Business & Artificial Intelligence
End to End Design and Delivery of Best Practice BI Solution, shiny new reports and state of the art BI Architecture
- Business engagement to identify DWH functionality
- Kimball Data Warehouse design
- Presentation of Data marts, Fact and Dimensions modelling for sign off
- ETL for heavy lifting and Data transformations
- SSRS / Power View / WEBI for Presentation layer
- Performance optimisation!!!
We use TFS for source control and change set based deployments
- In other words, all developments are secured and released from one System
- Configuration of branching, MERGING between Development branches to TEST to PRODUCTION
- Configuration of Builds
- TFS Application set up for Backlogs, Sprint planning and prioritisation
Business As Usual Support
Our Day to Day Managed Services include:
- Aderant Expert - Form customisations
- Database Editor
- View Editor
- DB Gen
- Data Import & Investigations
- Month & Year End
- VAT Quarter End
- Employee Maintenance etc
