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
Group 3

Excellent visualization and self-service environment

code (1)

Reduced server and maintenance cost

test (4)

Real Time Data Tracking Dashboards with important timely alerts

Group 3

Implementing Story boards and dashboard functionalities

code (1)

Extract and hyper files feature was leveraged to optimize performance

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?