1 / 16

Data warehousing for Profit Analysis By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar

Data warehousing for Profit Analysis By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar. Business Needs. A specialized OLAP system for information on a product profitability. Why Datawarehouse ?.

zihna
Download Presentation

Data warehousing for Profit Analysis By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar

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. Data warehousingforProfit AnalysisByA Sai KrishnaGeethika LokanadhamMithun RajannaKV Kumar

  2. Business Needs A specialized OLAP system for information on a product profitability

  3. Why Datawarehouse? • Faster and more efficient decisions-Provide timely access to vast amount of data available across the bank • Current and Historical information on a customer risk information • Optimize cost per customer-User based Access • Improve decision making through standardized reporting and definitions

  4. Objective • Profit from a particular customer at any given point of time • Aggregate Profit from wholesale/retail customers at any given point of time • Profit for any given country’s customer • Profit for a particular product customer

  5. Star Schema • More effective for handling simpler queries for users to write, and databases to process. • Queries are written with simple inner joins between the facts and a small number of dimensions. • Star joins are simpler than possible in snowflake schema. Where conditions need only to filter on the attributes desired, and aggregations are fast. • To optimize user ease-of-use and retrieval performance by minimizing the number of tables to join to materialize a transaction

  6. Fact Table PROFIT table

  7. Dimension Table

  8. Star Schema

  9. Measures • A measure is a property on which calculations (e.g., sum, count, average, minimum, maximum) can be made using pre-computed aggregates.

  10. Product-Profit-Time: In the second quarter of 2011 year the profit of a product p13

  11. ReportsProfit for a particular bank during a course of an year/month/which week of the month/whether if it’s a holiday or weekday

  12. Profit for a particular bank during a course of an year/month/which week of the month/whether if it’s a holiday or weekday and whether if the customer is retail or wholesale customer.

  13. Profit based on location for a wholesale or retail customer

  14. Profit from retail or wholesale customers for a particular country for a year » quarter » month

  15. For BOFA for a year->month and for a particular country » state

  16. Thank you …….

More Related