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
- 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.