This global leader in Digital Media built a Financial DW using SQL Server and SSIS.  This environment was the trusted source for financial data provided to the company’s executives and finance team. Although this solution worked well for the financial data, it was not scalable for the data volumes and complexities of click stream and other online data.  A Netezza Performance Server was chosen for the long term solution, and after an initial new subject area was built on the Netezza platform, it was time to migrate the Financial data off of SQL Server and SSIS.  The DW team knew that the migration had to be done quickly and correctly to satisfy the needs of the business and to prevent down time during the transition, while their existing resources maintained the current solution. Read more here
 

This mid-size eBusiness client had significant needs to access large volumes of information to analyze click-stream data, customer behavior, product effectiveness, and advertising revenue.  The small data warehouse they had started with had grown to a multi-terabyte system with 15 cubes.  The expense and labor required to deliver reports and queries to the business had become too expensive and too unresponsive to meet the business demands. Read more here
 

Fortune 100 Grocery Retailer - Promotional Analysis System

Brightlight Consulting took full ownership of the Business Intelligence aspects of this initiative.  We designed a highly optimized data model and migrated some existing data from Oracle to the new Netezza Data Warehouse Appliance.  We designed and built all the ETL processes, pulling data from multiple source systems.  We also designed and built a new generation of reports on MicroStrategy which adhered to existing MicroStrategy standards.  We closed the engagement by providing detailed documentation on all aspects of the project and trained the client on the use of the new system. Read more here

Fortune 200 Hospitality Company - Drives One View of the Customer with BI

This Worldwide Hotel company embarked on a BI initiative to consolidate their existing disparate technologies and build an Enterprise Data Warehouse (EDW). Their existing systems were comprised of Divisional/Departmental Data Warehouses and Data Marts on a wide range of technology platforms including Oracle, DB2, UDB, and SQL Server.  The objectives of the Enterprise Data Warehouse initiative were to reduce existing infrastructure cost and provide data access and information insight across the enterprise that had not been seen before.   Read more here