E2E BI solution for consolidated one enterprise view, creating data marts & reporting solution as Market intelligence

Client’s Global Marketing Operations (GMO) provides strategic recommendations and tactical support to Marketing and Sales organizations to enable optimization of relationship marketing and revenue generation. GMO capitalizes on a number of analytic and technical databases and tools to make it possible to have a full changeover of marketing and sales from intuition-driven to quantity-driven processes and capabilities.

Business Challenge

  • Various reports presented different versions of the same information.
  • Scattered, redundant and inconsistent data.
  • Reporting measures accuracy issues
  • Lack of Central Reporting system
  • Report performance challenges

Business Solution

  • Effective implementation of Dimension model, Star schema data mart with  pre-calculated/aggregated data
  • Application of Data cleansing and integration techniques
  • Views/Index views for OLTP environment
  • Centralized reporting solution for Marketing and Sales department
  • SharePoint Dashboard and reports
  • Improved reporting performance and user experience

Tools and Technologies
SQL Server 2005, SSIS, SSAS, SSRS