Acme One 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 Acme One 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.