BI Modernization

Report Migration from Cognos to Tableau

A Banking company had an organization wide requirement to migrate from Cognos to self-service Tableau platform.

Client Challenges and Requirements

  • Cut-down on servers
  • Reduce maintenance cost
  • Better data visualization and data representation
  • Make reporting User friendly
  • Faster Insights and Ease of Use

Bitwise Solution

    • Perform Impact Analysis based on Cost and Resource Utilization to help the business in decision making for reporting tool selection.
    • Migrate Cognos Cubes to Tableau Extract / Hyper, Whiteboard and Default views were created to retain the look and feel of Cognos PowerPlay studio and Analysis studio.
    • Modify reports with redundant logic to use independently published data sources.
    • Develop Charts/Maps and Dashboards for real time tracking of business information.
    • Design data sources to be used independently as well as blended when required to reduce redundancies.
    • Enhance executive dashboards to provide data alert feature and receive alerts when conditions are met.
    • Implement dynamic parameters to optimize query performance and fetch only subset of data.
    • Implement data extracts and schedules for periodic data refresh and report distribution. Used intermediate tables for performance optimization.
    • Create reports/dashboards for mobile devices for easy accessibility.

 

Tools & Technologies We Used

Tableau
Teradata
Cognos

Key Results

Excellent visualization and self-service environment

Reduced server and maintenance cost

Real Time Data Tracking Dashboards with important timely alerts

Implementing Story boards and dashboard functionalities

Extract and hyper files feature was leveraged to optimize performance

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?