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