POWER BI Assignment :

Data

$1.$ Combine sales files into $1$ dataset, $$Total$\_$Sales$$

$2.$ Create a group for the $$old$/$outdated$$ files, $$Old$\_$Files$$ move Sales files for $2015,2016,2017$ in there

$3.$ Check the column formats for all datasets

$4.$ For the Products $,$ add a new column with a formula for $($Net$)$ Profit Margin, I want to know how much money the company makes per product in $\%$ terms. Call it Profit$\_$Margin

$($Tip: Check Google if you don$$t know the formula$)$

$5.$ Create another column where if the margin is below $20\%-$Low profit$,$ if over $20\%$ but less than $40\%-$ Average Profit$,$ if over $40\%$ but less than $70\%-$High Profit$,$ if over $70\%$ but less than $100\%-$Top Profit$,$ if $100\%-$Asset Transfer$.$ Call the column Profit$\_$Category

$($Tip : $$IF$,$AND$)$

Model

Connect datasets

Data

$6.$ In the Total$\_$Sales dataset create a column $$Product$\_$Price$$ which brings ProductPrice values from Products dataset

$7.$ Create another Column in Total$\_$Sales, name it $$Revenue$\_$per$\_$Product$,$ multiple Product$\_$Price and OrderQuantity columns

$8.$ In the Products dataset $,$ ProductColor $,$ replace N$/$A$$s with $$No Color$$

Report

$1.$ Create a tree map. I want to see Top $10$ products Names by Revenue, I also want to see profit margin for each of them on the chart

$2.$ Rename or delete the Title. I don$$t want to see $\_$ signs and lengthy naming

$3.$ Add a map, Use Revenue for the size and Continent as location. Align the map and fix the title

$4.$ Create a donut chart. I want to see what are the most popular colors. Use ProductColor and Revenue per Product $.$ Adjust the chart in the way anyone can easily read it$.$ Fix labels and titles. If you have red color it has to be a red color in the $$Data colors$.$

$5.$ Add slicer, use order date from Total$\_$Sales dataset

$6.$ Add table, with the Product name $,$ filter it by top $10$ by revenue per product. Add Profit$\_$Category to the table

$($You can see the visual sample below Page $3)$

Adjust your report in the way it looks proficient. Work on fonts, background, titles and labels accordingly