Personal Banking Dashboards

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

• Download Case Study
   

  Name *

  Last Name *

  Company Email *

  Company Name *

---

---

• Stay on top of the latest trends and best practices from our blog

  View our articles

• Site map

  • Nearshore
  • About Us Our trajectory Mission, Vision & Values Executive Team Case Studies
  • Solutions QA Automation IBM Legacy Systems IT Outsourcing Analytics Staff Augmentation Cloud & Infrastructure BOT RPA UX/UI
  • Our Work
  • Careers
  • Blog
  • Contact

• Location

  Novacomp. 200 SE 1st St #604, Miami, FL 33131, USA

  • +(786) 410-4962
  • lfernandez@crnova.com
  • Map

Novacomp utilizes Cookies to improve your experience on our site. Cookies enable certain features, grant social sharing options, offer functionality and tailor messages and display ads to your interest. They also help us understand how our site is being used. Find out more here. By continuing to use our site, you consent to the use of Cookies, in accordance with our Cookies Policy.