Process Flow

  1. Explore the Dataset
  2. Clean the Dataset (Using Power Query)

Cleaning 2 correct date.png

-remove the first rows and then promote the second row as the header.

-The format of the Date column values isn't consistent. It has two different delimiters. Some of them use the dd-mm-yyyy format, and others use dd/mm/yyyy. Replace all / by - to format all dates the same way.

  1. Transform the Dataset

3 Transform Data Create new column year month.png

-Create new column using the DAX function Date.YEAR,Date.MONTH.

-Compute total sales by adding a new measure called total sales to using sum function.

4 Compute total sales by adding a new measure.png

  1. visualization

5 Vizualization total sales.png

-Create visualization for Total Sales using: a.The Year column b.The Category column c.The #Total sales measure

  1. Analysis

6 Vizualization Net Profit By Segment.png

-Compute the Total Sales by Year with Category -Top Three Sales on Average -Compute the Net Profit for 2016 by Segment