Maven Toys - Sales Dashboard

In This Project, I am provided with 5 Datasets in CSV, 1 Transactional/Fact Table, and 4 Dimension tables.

The Fact Table is known as the Sales table, and the dimension tables are the Products Table, Stores table, calendar table, and inventory.

The First step is to identify the primary keys in all dimension tables and fact tables.

Sales : Sales ID Inventory: Products ID Calendar: Date Stores: Store ID

The relationship cardinality used in all tables from Dimension to Fact tables in one is to many.

For the Report, three pages have been created

1) Sales Executive Summary which contains the ff:

-Four KPI Cards containing the Revenue, Profit, sales, and number of Orders -A Line Chart Trend with 2 Series , the Revenue and the Previous Month Revenue -A Bar chart containing the Top 5 most profitable Products,

-A column chart with Product Categories by Revenue as compared to the previous month revenue

-Two Donut charts of profit represented by product categories, and store regions.

2) Store locations

-Contains a slicer that lets you select which metric to use on the charts below (Sales, Revenue, Profit, and ORders)

-A shape map of Mexico

-A Matrix containing the stores in Mexico

3) Product Details -Contains a Bubble Chart and Scatterplot that compares Cost to Sales and Profit

-A matrix containing all Product categories and Product names