Client Challenges and Requirements
- Lack of skilled resources within Business
- High Licensing cost
- Export existing Cognos Report to Excel file. Use the file as mockup for Qlik report.
- Setup and Configure required data sources in Qlik.
- Create QVD files to load data from each data base table. Develop data model using Qlik data files (.QVD).
- Establish relationships between different data sources. Historical / point in time data was migrated from Cognos cubes to database.
- Implement Star Schema approach to avoid loop; develop fast and flexible applications.
- Implement role-based data security using section access.
- Schedule the monthly process to push dashboard output to business through email using Nprinting.
- Build dashboards in Qlik and schedule the monthly process to push dashboard output to business through email.
Tools & Technologies We Used
Share This Case Study
Download Case Study
Bitwise provides comprehensive solution for all your data projects
Data Warehouse and
Modernize and transform Enterprise Data Warehouse reporting systems to become more competitive for meeting today’s business challenges