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 dont 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/As 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 dont 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