2 Week BI Health Check

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!!!

Team Foundation Server

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
Aderant Expert 7.5

Aderant v8.0 Classic & Framework

Microsoft BI
SQL server Database Management System

Carpe Diem Time recording


SAP Business Objects

Hadoop Big Data

Contact us & find out how our services can help improve your business