Hands on practical: Dashboard Creation for apt Visualization

SYNOPSIS

Cookies food limited had asked me to prepare a Dashboard board for them with the following concerns which will hold sway as the objectives. The objectives are to note:

1.?????Total sales and Total Profit for the period

2.?????The best selling product

3.?????The best ?customer

4.?????The month with the highest sales

The company has provided me with three dataset comprising of the Names of Customers and their ID, Products and their ID, Cost of the Product(Retail Price and Cost Price), Number of Units Sold, Date, and Location details.

N/B: This data set was sourced from the internet and thus the name of the Company is fictitious.

IMPLEMENTATION

To implement this, I used the Prepare, Model, Analyze, Visualize, Manage resources Process (PMAVM). And the tool used is MS. Excel 360

?

The three Dataset where transformed and cleaned properly using Power Query Editor

The?Power Pivot Table used in Modelling

Power Pivot Chart used in answering the objectives.

Objective 1: The Best Selling Product.

Objective 2: The Best Customer

Objectives 3: The City with the Highest sales

Objective 4: Fluctuations in the Market with respect to sales

The Dashboard of Cookies Food

The whole exercise was chiefly carried out by me, and thus I look forward to your opinion and insight. I am also available to answer questions where necessary and possibly take you through the hidden processes. You can drop a meassage if you are interested.