Personal Banking Dashboards

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)

    SQL Server 2018

    Power BI

    WCF MVC (4.0)

    Analysis Services

    SAML 2.0


    Data Feeds / Integrations:

    iLevel Solutions

    Integration Services

    Data Warehouse

    Master Data Management

    SQL Server Agent


    © Novacomp   |   Privacy Policies   |   Terms and Conditions