Project 2 - Supply and Demand Gap Analysis
First i will create the Summary page
In that Summary page i will create some of the charts and maps and KPIs
Charts are Clustered bar chart and Pie chart and Line&Clustered column chart and Clustered column chart and Scatter chart
In that charts i will give the some of the data
In the Clustered bar chart i will take the data is Sales by Category and Chain
In that Pie chart i will take the data is Sales by Chain
In that Line&Clustered column chart i will take the data is Sale and Gross profit by FY Qtr
In that Clustered column chart i will take the data is Sales by State and Chain
In that Scatter chart i will take the data is Sales,Gp% and Gross profit by Category and FY Qtr
In that Maps i will take the data is State,Country
In that KPIs i will take the data is Sales by Date
And also i will take the slicer that slicer is State
Next i will create the another page i.e., Category,State,Buyer,Manager,Date
In that Page i will create some of the charts and maps
Charts are Clustered column chart and Stacked column chart and 100% Stacked column chart and Area chart
In that Clustered column chart i will take the data is Chain by Category
In that Stacked column chart i will take the data is Cost by State
In that 100% Stacked column chart i will take the data is Cost price by Buyer
In that Are chart i will take the data is Gross profit by Date
In that Map i will take the data is Postcode,Subrub,Country,Manager
And also i will take the sliceres that slicers are State and Chain and Buyer and Date and Manager