Business Challenges
- Lack of Slicing and Dicing of Risk Management complex KPI’s across various dimensions.
- Need to make BI self Service across the organization.
- Need to create a client-centric reporting framework.
Scope of Work
- Develop a Data Warehouse to accommodate data from different OLTP systems.
- Create reports using Microsoft Power Pivot to cater to Accounting and Risk management users.
- Create Tableau visual analytical reports to assist Executives, Risk Management team, and external clients based on each client's business model to better understand current state and expected future state.
- Create a BI portal interface to view SSRS and Tableau Reports.
