IMPORTING DATA
First thing done was to import the data from the source file.
FORMATING
After the data being imported, in the Data tab, I formatted the data as required for visualization.
MODELLING
In the Model tab, the relationships between the 5 tables in the data set are modeled
CREATING THE DASHBOARD
For the dashboard, the next visualizations are added to serve the purpose of this project:
1- KPI for Total Sales and Gross profit
2- Stacked bar chart showing Sales by State and Category
A Stacked bar chart was created to show sales value by state and category of product.
3- Column Chart showing Sales and Gross profit by Year
A column chart (Line and clustered column chart) was created to show the total sales and gross profit by year (2017,2018 and 2019).
4- Area Chart showing Sales by month
Created an area chart that shows the total sales of products over a span of 12 months
5- Multi-row card
A multi-row card was created to show the information related to product categories, total sales per category, total units sold, and gross profit.
6- Map showing total units sold by state
Added a map showing total units sold per state in the USA.
7- Slicer for Sub-categories of products
Added a Slicer for Subcategories of products in the record. Using this slicer, users can select specific categories and filter through data.
FINAL DASHBOARD
For th project description: https://reemalraeai.wordpress.com/portfolio/sales-performance-overview/