Scribd
Upload
2 views4 pages

Program 9

The document outlines steps to analyze revenue in a sales dataset using various visualizations such as a choropleth map, line chart, binning for age, donut chart, butterfly chart, and a calculated field for average revenue per state. Each visualization has specific instructions for creating and displaying data effectively. The final goal is to build a comprehensive sales dashboard that presents these analyses.

Uploaded by

Sannidhi Rajesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
2 views4 pages

Program 9

The document outlines steps to analyze revenue in a sales dataset using various visualizations such as a choropleth map, line chart, binning for age, donut chart, butterfly chart, and a calculated field for average revenue per state. Each visualization has specific instructions for creating and displaying data effectively. The final goal is to build a comprehensive sales dashboard that presents these analyses.

Uploaded by

Sannidhi Rajesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

9.

Analysis of revenue in sales dataset:


i) Create a choropleth map (fill the map) to spot the special trends to show the state
which has the highest revenue.
ii) Create a line chart to show the revenue based on the month of the year.
iii) Create a bin of size 10 for the age measure to create a new dimension to show the
revenue.
iv) Create a donut chart view to show the percentage of revenue per region by creating
zero access in the calculated field.
v) Create a butterfly chart by reversing the bar chart to compare female & male
revenue based on product category.
vi) Create a calculated field to show the average revenue per state & display profitable
& non-profitable state.
vii) Build a dashboard.

i. Create a choropleth map (fill the map) to spot the special trends to show the
state which has the highest revenue
Select Filled map
[Link] the State to the “Location”.
[Link] the State to the “Legend”.
[Link] the Max of Revenue to the “Tooltip”.

ii. Create a line chart to show the revenue based on the month of the year
Steps to followed :
Select Line Chart
1. Drag the month field to the “X-Axis” field
2. Drag the Sum of revenue field to the “Y-Axis” field.
iii. Create a bin of size 10 for the age measure to create a new dimension to show the
revenue
Steps to followed
Select Stacked Column Chart
1. Drag the Sum of revenue field to the “Y-Axis” field.
2. Right-click on the age field and choose “New group”.
In the “Group” window, select “Bin” and set the bin size to 10.
Drag the New Customer Age (Bins) field to the “X-Axis” field.

iv. Create a donut chart view to show the percentage of revenue per region by creating
zero access in the calculated field
Steps to followed
Select Donut Chart
[Link] the State to the “Legend”.
[Link] Sum of Revenue to the “Values”.
[Link] format visual >> detail labels >> position >>inside.

v. Create a butterfly chart by reversing the bar chart to compare female and male based
on the product category.
Steps to followed
Select Stacked Column Chart
[Link] the Product Category to the “X-axis”.
[Link] the Sum of revenue the “Y-axis.
[Link] Customer Gender to the “Legend”.
[Link] filter>>Product Category.
There except blank select all other.
vi. Create a calculated field to show the average revenue per state & display profitable &
non-profitable state.
Steps to followed
Select Table
[Link] Modelling>>New measure
AverRevPerState=AVERAGEX(VALUES(SalesTable[State]),CALCULATE(SUM(Sales
Table[Revenue])))
[Link] Modelling>>New Column
ProfitableStatus=IF(SalesTable[AverRevPerState]>1000,"Profitable","Non Profitable")
[Link] State, AverRevPerState, ProfitableStatus to the “Column”.
Final Sales Dashboard

You might also like