BI Migration

Report Migration from Cognos to Power BI

Cognos Migration to Power BI
A Financial Services company needed to migrate its Credit Card Network’s set of executive dashboards from Cognos to Power BI in order to understand the business performance at a glance. The requirement was to be able to track critical and fast changing data on various platforms including mobile devices.

Client Challenges and Requirements

  • The requirement was to be able to track critical and fast changing data on various platforms including mobile devices.

Bitwise Solution

  • Assessed existing Cognos environment and critical business requirements.
  • Setup and configured required data connections. Loaded the data from the database into Power BI. Established relationships between different data sources and created the data model in Power BI.
  • With the help of the existing Cognos reports as mockup, created Power BI visualizations.
  • Provided filtering capabilities and created DAX calculations for the custom fields.
  • Incremental refresh was implemented for high volume data to optimize the data refresh performance.
  • Power BI features were leveraged to enhance the visualizations. Optimized the ‘Ask Question’ feature of Power BI for self service of the reporting requirement.
  • Performed data validations and quality checks. Published reports with role-based permissions.

Tools & Technologies We Used

Cognos

Teradata

Power BI

Key Results
Group 3

Eases decision-making and tracking of management strategy and business plans

code (1)

Mobile compatibility provided flexibility and insights on the go

test (4)

Integrated Power BI dashboards with the organization’s portal to increase visibility and flexibility

Group 3

Powerful modelling of Power BI was leveraged for easy and user-friendly capability

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?