Data Analysis | Power Bi
Revenue
1.04M
Income Statement Dashboard
Power BI Desktop
DISCOUNTS
REVENUE
Goal:- (-48.1%)
42M
Profit
136.54K
TOTAL GROSS SALES
4M
46M
PROFIT
COGS
4.14M
38M
Goal: 200000 (-31.73%)
Gross Proft Over Time
All
Sum of Sales by Units Sold and Discount Band
GrossProfitMargin
2
5M
1
0M
ry
ry rch pril
ay une
a
M
ua rua
J
A
n
M
Ja Feb
ly ust m… ber m… m…
g
o
e
e
e
Au ept Oct Nov Dec
S
0
Discount Band
Ju
Sum of Sales
Select Financial Year
Sum of COGS
GrossProfitMargin
All
Sum of Profit
Total Profit & COGS
Select Country
Impact of Discounts on Sales
High
Low
Medium
1M
0M
0K
1K
2K
Units Sold
Month
Impact of Sales On Profit
Qtr 1
Qtr 2
Qtr 3
Month
Qtr 4
Decem…
Novem…
October
20K
Average of Profit
0.0M
July
40K
Septem…
60K
0.5M
June
Sum of COGS
August
Small Business
Average of Profit
May
Segment
February
All
4K
Revenue, COGS Analysis in Relation to profit
80K
January
Product
Average of Sales
Average of Sales
April
All
3K
March
Select Month
None
Revenue and Target 2013
Sum of Profit
30M
20M
15M
1.0M
10M
0.5M
5M
0M
0.00M
8.34M
50M
Revenue and Target-M
Qtr 1 Qtr 2 Qtr 3 Qtr 4
Quarter
0.00M
34.09M
120M