University Data Warehousing and Mining: Online Brokerage Project

This project details the design and implementation of a data warehouse for an online brokerage company. It begins with a data warehouse design, including fact and dimension tables (Accounts, Sales, Customers, Dates, Trades, Securitydetails). The implementation section demonstrates creating database connections using SQL Developer, creating tables (customerdata, trading, commissiondata), and inserting records. The assignment then moves on to OLAP queries, providing SQL codes and results for specific scenarios like trades placed in July by a specific customer and commission earned per quarter based on customer profit trade scores. The project utilizes SQL queries to retrieve and analyze data, demonstrating data warehousing and mining principles.