This project was built using a structured and cleaned dataset consisting of four main tables:
- Orders Table
- Contains individual transaction records
- Fields:
Order ID, Product ID, Customer ID, Order Date, Revenue, Quantity, Region ID
- Products Table
- Contains product-level details
- Fields:
Product ID, Product Name, Category, Unit Price
- Customers Table
- Contains customer information
- Fields:
Customer ID, Customer Name, Segment, Country
- Regions Table
- Contains geographic data for mapping and filtering
- Fields:
Region ID, Region Name
Each of these datasets was:
- Imported into SQL Server for querying
- Cleaned and transformed using SQL
- Connected to Power BI for data modeling and visualization