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.


  • 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



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 %