1 / 25

Benchmark financial brokers

Benchmark financial brokers. Data Warehousing and Data Mining. Terry Lee Sandeep Udhani Tran Ngo Navin Negi. UNIVERSITY OF HOUSTON-CLEAR LAKE. Business Need. Helps owner and regional managers keep track of revenue (sales commission) from each branch.

kimn
Download Presentation

Benchmark financial brokers

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. Benchmark financial brokers Data Warehousing and Data Mining Terry Lee Sandeep Udhani Tran Ngo Navin Negi UNIVERSITY OF HOUSTON-CLEAR LAKE

  2. Business Need • Helps owner and regional managers keep track of revenue (sales commission) from each branch. • Strategic information needed in order to protect client investments. • Strategic information needed to better inform customers about the risk of their investments.

  3. Business Measurements • Revenue by State • Revenue by Investment • Customers with High Risk Investments • High Risk Investments by Employee

  4. Initial Snowflake Design

  5. Revised Star Schema

  6. Relational Implementation - Access

  7. Physical Data – Transaction Table

  8. Physical Data – Investment Table

  9. Physical Data – Employee Table

  10. Physical Data – Customer Table

  11. Physical Data – Date-Time Table

  12. Attribute Relationships

  13. Creating Dimensional Hierarchies

  14. Cube Implementation in SQLServer

  15. Browsing The Cube

  16. Create Reports with Report Services

  17. Designing Reports

  18. Designing Reports

  19. Designing Reports

  20. Customers with High Risk Investments

  21. Sales Revenue by State

  22. Revenue by Investment

  23. High Risk Investments by Employee

  24. General Conclusions • There are a few employees who are regularly selling High Risk Investments • Texas is our highest grossing State

  25. The END • Any Questions or Comments?

More Related