Cloud Migration

Report Migration from Cognos to PowerBI

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

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

Mobile compatibility provided flexibility and insights on the go

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

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

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?