Road Construction firm uses BI tools to enhance performance

Location: USA

Industry: Construction

Problems

With over 200 data sources distributed across the globe, it was very difficult for Colas management to track:

  • Staff working days - Actual versus available
  • Cash balance - Actual versus baseline
  • Cost of construction
  • Time for construction
  • Day to day project completion
  • Productivity
  • Profitability
  • Repeat business

The company needed a dashboard in which it would be able to see each of the KPI/ Metrics. Key performance indicators have always been the most critical part of a company.

2b348f217fc42e5b8b4aa36763953e34
Gray-and-Light-Pink-Simple-Site-Map-Chart-14

Solutions

Allied Consultants helped the company design, model and implement data warehouse. We helped Colas to develop ETL (Extract, Transform & Load) packages to enable daily processing of data sets into its data warehouse.

ETL provides a method of moving the data from various sources into a data warehouse.

Other services provided by Allied Consultants include:

  • Creation and configuration of SSAS (SQL Server Analysis Services) database for multidimensional cubes and applying mining algorithms.
  • Creating dashboards/reports with Excel/SSRS using SQL/MDX queries.

Tech Stack

  • SQL Server
  • SSIS
  • SSAS
  • SSRS
  • SharePoint

Get In Touch With Us

we believe in  cutting  edge solutions  and are committed to your  success

Let's Work Together