"Data Analysis Dashboard in Excel & Power BI

This presentation is a comprehensive guide to building professional dashboards using Excel and Power BI. It walks you through the complete process of transforming raw data into clear, interactive, and visually appealing reports. Starting with data cleaning and preparation, it demonstrates how to apply advanced Excel formulas, pivot tables, and charts, then moves into Power BI to create dynamic dashboards that bring insights to life. The content is designed for analysts, consultants, and business professionals who want to make smarter decisions through data-driven strategies. Whether you are a beginner exploring data visualization or an experienced professional looking to refine your skills, this resource provides practical examples, step-by-step methods, and best practices that can be applied in real business scenarios.

2. | Formules

Data

Review

View

Developer

Draw

Acrobat

a 6438 1312 10 558 744 7750 1550 6200 335 | 7/1/2000 | 1 de 101
ee 6126 1249 10 531 708 7375 | 1475 | 5900 an | 1472001 | tt a> 102
> 5814 1186 10 504 672 7000 1400 5600 1/1/2002 t dans 103
gs) | 7638 1553.5 10 6615 | es | 91875 | 18375 | 7350 x 7/1/1994 | Acct | ys 104
ges | 7378 1501 10 639 852 8875 | 175 | 7100 59 [717196] Act | oe 105
pes 4358 892 10 378 504 5250 1050 4200 FI 7/1/2009 | Acct 239 106
pe 4150 850 10 360 480 ‚5000 1000 4000 1/1/2012 | Acct Die 107
pe 3890 797.5 10 337.5 450 4687.5 937.5 3750 1/1/2014 | Acct ws 108)
pes 4358 892 10 378 504 5250 1050 4200 7/1/2006 | HR er 109
pes 4150 850 10 360 480 5000. 1000 4000 1/7/2008 HR pue 110
> 3630 745 10 315 420 4375 875 3500 1/5/2003 | HR Spans 11
ges 4670 955 10 405 540 5625 | 1125 | 4500 2/4/2000 | HR | Gia 112
es 5190 1060 10 450 600 6250 1250 5000 1/5/2003 | Sales e 113
yes 5710 1165 10 495 660 6875 | 1375 | ssoo 2/7/2022 | Sales | ¿to 114
ga 6230 1270 10 540 720 7500 1500 6000 1/8/1999 | sales | iabu 115
> 5190 1060 10, 450 600 6250 1250 5000 ss] 1/1/2008 | te E] 120
u 6750 1375 10 585 780 8125 | 1625 | esoo | ausm | 2/1/2016 | acer | uo 120

3. al and Sum of Fe) by az

os

on

4k 208%)

ax 210%)

Sum of Ay is

Sum of lys

x

Sum of tise!
a> 8,125.00 1,375.00 780 1,625.00 ail 10 6500 6750 585.00 2016 Qt
Ls 5,000.00 850.00 480 1,000.00 sait 10 4000 4150 360.00 2012 Qt
Ic 8,875.00 1,501.00 852 1,775.00 wJoill 10 7100 7374 639.00 1996 Qty
us 4,687.50 797.50 450 937.50 coi 10 3750 3890 337.50 2014 Qtr
as 9,187.50 1,553.50 882 1,837.50 Wü 10 7350 7634 661.50 1994 Qtr
3 5,250.00 892.00 504 1,050.00 sl 10 4200 4358 378.00 2009 Qtr
o 5,000.00 850.00 480 1,000.00 dut 10 4000 4150 360.00 2008 Qtr
b 5,250.00 892.00 504 1,050.00 ¿vin 10 4200 4358 378.00 2006 Qtr
ama 4,375.00 745.00 420 875,00 duit! 10 3500 3630 315.00 2003 Qtr

4. Fle Home insert Page Layout Formulas Dala Review View Developer Help Draw Acrobat PwvoiChart Analyze Design Format

aa v 23 E
MASA .
| 7) PivotChart Fields TX
| 8| cote Tg) Dial beeen ses
1.9 | add to report: Dtos
110! Gear
m DY re
P m Eier Er zes
Dumas | aa
Sem cfs at Sun ofp | Sum of ten sal Sim of th Sm of n>} nm DES
15) Roma
CHART TITLE fis) Outras FE
so [| Baie = =
Lie! © sont = 5
“se DR ess
vs wa [| cu Pal
Serra g fz) Der >
somot aus m >| Dia 1 tages)
mdr a fas] Doeacanoos |S vie 5
Sum of pT ot D 2 Br
ha oo AIS
m | | | | Eras
° aU call vod In all il in He) Brom
+ B vo
Sum of abgal a, &
sia ale E CT |
= E Smal gla >
Ian en,

- SEEN Dita

5. Sum of Mileage by Fuel type and Manufacturer 7 100%
ord @Porsche @ Toyora @VW

Manufacturer @8MW ©

1980
zu

206
ss
00;

‘Sum of Engine size and Sum of Price by Model

Sum of Mileage

ET Model

cus Ian e, a
Mondeo
ree wx 13:
E eco
son 18 Cayman
024 CEE
ari

6. Page Layout — Formulas Data Review View Developer Help Draw Acrobat [ = share ]
mm Date =) EN Condition formating- | insert + | Ze A
cu A À ele a nw | 7229 ©
een 87% 9 FifematasTabier Bde ~ TI Sona éd ce CRT e
u LE] car Ses + [Blrormat~ | > File Select~ PDF | for Excel Copilot
Font 5 Alignment 5 Number m Sites cat Eating Adobe Acrobat A RGopiet Y
Se -TopaY() “
1 4 E E E | ry © a A h
1
[Data [_10/18/2025 2
3
years of service monthsofservice Price Mileage _Yearofmanufacture Fueltype Enginesize Model Manufacturer [A
25 300 3074 127300 10/12/2000 Petrol 1 Fiesta Ford 5
39 473 49704 57850 5/12/1986 Petrol 4 718 Cayman Porsche 6
5 68 24072 39190 2/5/2020 Diesel 16 Mondeo Ford [7
21 261 1705 210814 1/6/2004 Hybrid 18 Rava Toyota [a
25 302 4101 127869 8/3/2000 Petrol 1 Polo vw >
26 321 29204 33603 1/4/1999 Petrol 14 Focus Ford 10
34 413 14350 86686 5/5/1991 Diesel 18 Mondeo Ford "
18 222 9977 | 73470 4/7/2007 Petrol 12 Polo vw 12
o 4 1049 262514 6/2/2025 Diesel 2 Focus Ford ES
45 543 17173 83047 7/6/1980 Diesel 2 Golf vw 14
4 57 719 293666 1/1/2021 Petrol 2 za BMW 15
34 409 7792 | 92697 9/7/1991 Diesel 12 Golf vw Is
25 304 16026 79393 6/6/2000 Petrol 22 RAVA Toyota [17
pes mn meer rer ana ru = ba
vestigate El m- 1 vom

7. Fle Home Insert Page

a v fe

Layout Formulas Data

Review View Devel

A B € o € 8 A
I an) Gba |] PivotTable Fie
Sum of Gal Jlaz] Sum of solu! öly)hum of CAcUaiz a! Jlsabum of jlg>UBum of Cäbyall q] - Row Labels | >
9187.5 7350 1553.5 1837.5 104 1994 |.
8875 7100 1501 1775 105 Be;
7500 6000 1270 1500 115 1999: |; ?
13375 10700 2267 2675 213 Settee
7375 5900 1249 1475 102 200100, e ui
7000 5600 1186 1400 103 BE oon
10625 8500 1805 2125 224 2003* |»
5250 4200 892 1050 109 2006: |. P
11250 9000 1910 2250 230 FT AR a
5250 4200 892 1050 106 Zu: 5°
5000 4000 850 1000 107 A AS
4687.5 3750 797.5 937.5 108 aoe); 2°“
8125 6500 1375 1625 120 [UT FRS
6875 5500 1165 1375 114 2022: |;
110375 88300 18713 22075 1860 Grand Total |
« ET pivo table

8. Fle Home Insert

Page Layout

k

Formulas Data Review View Developer Help Draw Acrobat

9. € Backtoreot | SUMOF ENGINE SIZE AND SUM OF PRICE BY MODEL

rar OOIK (0%)

Kor)
20K (154%) 7~ 82K GITE)
OK (0%)
50K (18.96%) 001K (0%)
44K (1682)
27K (1024) KR)

Sum of Engine size Sum of rice

Model
era

@Ntondeo
Colt

0718 Cayman
@Focus
Cars

@Folo

400
340
250
220
200
100
100

49704
30253
4766
14078
ng
3074
6512

10. File Home insert Page Layout Formulas Data Review View Developer Help Draw Acrobat
5 vlıixvk y
5 R Q a o N M t K

=
2

3

ñ

5

le

Cola 7
O

9

10

"

e

3

"

5

6

v

18

11. IX Back to report] | SUMOF MILEAGE BY FUEL TYPE AND MANUFACTURER

Manufacturer @8MW @Ford @Porsche O Toyota OVW

10M
d
E
= OSM
a

00M

Petrol Diesel Hybrid
Fueltype

Fuel type BMW Ford Porsche Toyota VW

Petrol | 293666 160903 57850 422669 201339
Diesel 465974 175744
Hybrid 471911 121744