Product Dashboard
In this section, you’ll learn how to turn raw data into an interactive Power BI report. We’ll cover everything you need to know to create a complete project from start to finish. By the end of this topic, you’ll be able to create a complete dashboard:
1. Connect Power BI to your data source, download the database from below link.
link: https://iqratechnology.com/academy/sql-training/sql-installing-ssms/
2. Understand the Tables of your data set, we have six tables in the data set:
• Product: Contains metadata about the products available for sale.
• Product Category: Groups products into broader categories.
• Product Subcategory: Groups products into more specific subcategories within a category.
• Product Inventory: Tracks inventory details for each product.
• Location: Represents locations where products are stored or sold.
• Sales Order Details: Holds the line-item transactional details for every product sold in each sales order.
3. Build relationships between different tables to show data connections.
1. Sales Order Details to Product
• Join Type: Many-to-One
• Key: Product ID
• Description: This relationship links each product to multiple records in the Sales Order Details table,
allowing product and quantity details to be associated with the corresponding order.
2. Product to Product Subcategory
• Join Type: Many-to-One
• Key: Product SubCategory ID
• Description: This relationship links the Product Subcategory table to multiple records in the Product table,
helping track product Sub Category to be associated with specific product.
3. Product Category to Product Subcategory
• Join Type: One-to-Many
• Key: Product Category ID
• Description: This relationship links Product Category records to multiple Product Subcategory, enabling
the tracking of product sub category associated with product category.
4. Product to Product Inventory
• Join Type: One-to-Many
• Key: Product ID
• Description: This relationship connects Product records to multiple Product Inventory, allowing the tracking
of inventory for each product.
5. Location to Product Inventory
• Join Type: One-to-Many
• Key: Location ID
• Description: This relationship makes one to many between Location and Product Inventory, it allow to
track the products location.
4. Create Visualisations to display important information in charts, tables, and maps. Your dashboard should match the below layout.
Product dashboard
