Power BI in Banking
Location: USA
Industry: Banking & Finance
Problems
The bank sought Allied Consultants help to address specific challenges such as:
Lack of data centralization within different ERP systems including DCI (Data Center Inc., a core banking software and Q2, a cloud-based digital baking software. Each ERP had its separate database making it difficult and time-consuming to reconcile and report data to the CEO, CFO and CTO of the bank.
Multiple IDs for the same customer (customer ID for e-Banking transactions & loan/deposit data from branch banking was different)
Poor visibility of loan, savings, and deposit data for respective customers, products, geography, time, salesperson, distribution channel and month of the year.
Static data reporting: The IT team, BMs, and CFO were using Excel, PowerPoint, and third-party services to analyze and present their data. It was mostly
Manual extraction and reporting of bank’s KPIs about savings, loan accounts, CDARs, and saving certificates
Solutions
Our BI consultants executed a detailed study of the customer’s IT environment and obtained data from the IT team ( in the form of CSV and Excel files). This led to the implementation of a pilot project in which Allied Consultants provided an executive (CEO) dashboard using Power BI.
Other tasks performed include:
- Determined and mapped customer’s IT infrastructure (systems, hardware, DBMS, Network, End-User tools, development tools, and data access tools)
- Developed data warehouse Schema design
- Data warehouse development & reporting
- Development of agreed-upon Power BI reports
- Power BI analysis on DCI (Data Central Inc.,), Q2, CDAR and RDC files
Tech Stack
- ERPs (DCI, Q2)
- Power BI Desktop
- Power BI report server & Sharepoint
- SQL
- SSIS for ETL
- SSAS for Cube
Get In Touch With Us
we believe in cutting edge solutions and are committed to your success