Enterprise Business Intelligence and reporting solution for a leading Internet retailer

About the client:
Client is one of the most trusted Internet retailers online. Dedication, commitment to quality service, high level of professionalism, product dependability, and competitive prices are reasons that underline its success in the auto industry. Through the years of providing superior quality automotive parts and accessories nationwide, the client has been distinguished as one of the most established auto parts retailers online.

Business Requirements:

  • To design and implement a comprehensive solution readiness approach and framework for various data sources.
  • To ensure that global solution deployment is managed in a centralized and consistent manner, providing a hub for the spokes of the subsidiary.
  • To develop a reporting solution to provide scalability, comprehensive analysis to assess the impact and ROI of the client’s operational performance.

Solution Highlights:

  • Building a platform to bring all these different data sources on one platform and creating a robust data warehouse using Datamart and Cubes.
  • Reporting based on Online Analytical Processing (OLAP) using complex Media Data Extended (MDX) queries.

.NET and ETL using SSIS 2008