The Challenge:
Dashboard creation for Personal Banking (Mortgage, Auto Loans, Attrition, Channels, Payroll Loans).
- Extraction of information from IBMi´s DB2 Core Bank database to an SQL Stage Database in SQL Server 2008.
- Creation of data transformation processes as required by the business logic and storage in a Datawarehouse repository.
- Delivery of data transformation and cleaning processes.
- Dashboard creation taking data stored in the Datawarehouse as a source and publish it to provide visibility to the business area.
The Engagement:
Create support tools for decision-making.
- Show updated reliable and accurate information to support the business.
- The Tool must be easy to use for business users.
- The Dashboard must be able to incorporate new perspectives as required.
The Benefit:
Using cutting-edge technology for information visualization and data analysis.
- Allows business management to identify areas of penetration for the implementation of new products.
- Actively allows the control and monitoring of products.
- Monitoring and identification of risks in the implementation of some products.
- Summary management of data and information for decision making.
Key Technologies:
Net (4.5)
asp.net MVC (4.0)
SQL Server 2018
Analysis Services
Power BI
SAML 2.0
WCF
jQuery
Data Feeds / Integrations:
iLevel Solutions
Master Data Management
Integration Services
SQL Server Agent
Data Warehouse
Tableau
