BI Modernization

Report Migration from Cognos to Qlik

img-report-qlik-case-study
A U.S. healthcare organization needed to consolidate and modernize reporting tools by migration Cognos reports to Qlik.

Client Challenges and Requirements

  • Lack of skilled resources within Business
  • High Licensing cost

Bitwise Solution

  • 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

QlikView

QlikSense

Qlik Nprinting

Cognos

Key Results
Group 3

Excellent visualization with Improved the Scalability, Security and Availability

code (1)

Reduced server and maintenance cost

test (4)

Real Time Data Tracking Dashboards

Group 3

Implementing Story boards and dashboard functionalities

code (1)

Optimized performance with In-Memory Analysis and Data compressed features

Share This Case Study

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Data Warehouse and
    Business Intelligence

    Modernize and transform Enterprise Data Warehouse reporting systems to become more competitive for meeting today’s business challenges 

    Ready to start a conversation?

    Share This Case Study

    Download Case Study

    Bitwise provides comprehensive solution for all your data projects

    Related Solution

    Automated ETL Migration

    Risk-free conversion and optimization of source ETL jobs to a target ETL tool with maximum automation

    Ready to start a conversation?