Cost effective Business Intelligence Solution for Finance Sector
Engagement Details
Primary Operations: USA
Associated since:
July 2015 – June 2016
Service Type:
Application development & maintenance
Service Model:
Professional services
Status: Completed
Methodology: Agile
Scope/Challenges/Key objectives
Business Case:
Customer is looking for providing dashboards to their executives through which business performance can be monitored in an effective manner. Data distributed across different sources to be validated before it is used to generate necessary reports and dashboards. KPIs identified as a part of business goals to be derived using existing data assets and presented. The software licenses of tableau to be effectively utilized.
Challenges:
- Data distributed across various database systems
- Data quality is a concern
- Full-fledged BI implementation is not in the current scope
- Under-utilization of software licenses
- Data islands
- No consolidated reports/dashboards for business monitoring
- Manual procedures to prepare datasets required for reporting
Solution, Technical Environment, Benefits
Solution / Project Engagement:
- Identifying the KPIs to be reported, calculation methods, and their sources
- Building necessary data marts to fulfil reporting and dashboards requirements using existing software licenses of microsoft SQL server
- Developing reports & dashboards provided by the customer, testing & deployment
- Automating manual procedures using TSQL procedures, functions, triggers, etc.
- Addressing the data quality concerns through automated procedures before loading data into data marts
- Building master data repository using existing software licenses and eliminating data duplication
Technical Environment:
Microsoft SQL server with SQL & TSQL
Tableau
Python
0 Investment on software & hardware
Number of KPIs increased from 250+ to 3200+
Dashboards update rate is brought down to 15+ minutes from days
Manual procedure reduction by 90 %