1 / 19

DATAWAREHOUSE FOR BANKING by Amey Aras Deepesh Dhake Hatem Murad Nirav Hamlai

DATAWAREHOUSE FOR BANKING by Amey Aras Deepesh Dhake Hatem Murad Nirav Hamlai. Objective Most profitable Customer Decision of providing the credit card service to the customer Decision of providing the loan to the customer depending on the account balances. Objective ( contd )

fritzi
Download Presentation

DATAWAREHOUSE FOR BANKING by Amey Aras Deepesh Dhake Hatem Murad Nirav Hamlai

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATAWAREHOUSE FOR BANKINGbyAmey Aras Deepesh Dhake Hatem Murad Nirav Hamlai

  2. Objective • Most profitable Customer • Decision of providing the credit card service to the customer • Decision of providing the loan to the customer depending on the account balances.

  3. Objective (contd) • Most profitable branch • Most profitable product • Top 10 customer • Branch with most customers • Branch providing most services

  4. BUSINESS NEEDS • Understanding the needs and requirements of each customers. • Tracking the product and branch for profitability • Providing reports to help the bank understand consumer and market trends to increase profitability.

  5. BUSINESS NEEDS (CONTD) • Providing reports to help the bank understand consumer and market trends to increase profitability. • Continously improve customer services and increase profitability

  6. WHY DATAWAREHOUSE? • The idea of data warehouse is helpful. • Data warehouse allow us to capture data from various locations of various customers and then to store it. It can be accessed by high level management to analyze the data.

  7. WHY DATAWAREHOUSE?(CONTD) • Data warehouse allows high level manag- ement to have access to the Online Analytical Processing functions that will help to perform customer, product and branch analysis. • Data warehouse generates various reports related to customers, products and branch

  8. Star Schema

  9. Customer Business Dimension

  10. Customer Business Dimension Data

  11. Product Business Dimension

  12. Product Business Dimension Data

  13. Branch Business Dimension

  14. Branch Business Dimension Data

  15. Time Dimension

  16. Time Dimension Data

  17. Bank_Fact Table

  18. Bank_fact Table Data

  19. ANY QUERIES ?

More Related