"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.

1. Sum of ei Sl) and Sum of Se) by as Sum of Ay a
om

= 4k (208%)

0% —

Sum of lost
R

x

on |
.

Sin) ac er a at pr

ab gall pul Sum of r Sum of yal Year
‘Acct gu 8,125.00 1,375.00 780 1,625.00 <i! 10 6500 6750 585.00 2016 Qtr
Acct yl 5,000.00 850.00 480 1,000.00 wail 10 4000 4150 360.00 2012 Qtr
‘Acct ec 8,875.00 1,501.00 852 1,775.00 wisi! 7100 7374 639.00 1996 Qtr|
acct as 4,687.50 197.50 450 937.50 wisi 3750 3890 337.50 2014 Qt
Acct Jos 9,187.50 1,553.50 882 1,837.50 4! 7350 7634 661.50 1994 Qtr)
Acct gs 5,250.00 892.00 504 1,050.00 sill 10 4200 4358 378.00 2009 Qtr
HR pla 5,000.00 850.00 480 1,000.00 äywı 10 4000 4150 360.00 2008 Qtr
HR 16 5,250.00 892.00 504 1,050.00 ait! 10 4200 4358 378.00 2006 Qtr
HR 3522 4,375.00 745.00 420 875.00 aul! 10 3500 3630 315.00 2003 Qtr
Total 110,375. 18,713. 10596 22,075.00 170 88300 91662 00

2. out Formulas Data Review View Developer Help Draw Acrobat

N M L K 1 D sc 5 o c 8 A
6438 1312 10 558 744 7750 | 1550 | 6200 7/1/2000 | 1 de 101
Sa 6126 1249 10 531 708 7375 | 1475 | 5900 1/1/2001 | It yu 102
= 5814 1186 10 504 672 7000 | 1400 | 5600 1172002 | m | m 103
Suu) | 7634 15535 10 6615 | esz | 9187.5 | 1837.5 | 7350 7/1/1994 | ac | ys 104
[ass | 7378 1501 10 639 852 8875 | 1775 | 7100 7/1/1996 | Acct | Se 105
qe 4358 892 10 378 504 5250 | 1050 | 4200 7/1/2009 | Acct | 29. 106
= 4150 850 10 360 480 5000 | 1000 | 4000 1/1/2012 | Acer | ate 107
63 3890 797.5 10 3375 | aso | 46875 | 9375 | 3750 1/1/2014 | Acct |S 108
FF 4358 892 10 378 504 5250 | 1050 | 4200 7/1/2006 | HR | wis 109
pes 4150 850 10 360 480 sooo | 1000 | 4000 1/7/2008 | HR | pu 110)
ses 3630 745 10 315 420 4375 875 3500 1/5/2003 | HR | spas aa
pes 4670 955 10 405 540 5625 | 1125 | 4500 2/8/2000 | MR | te 112
pen 5190 1060 10 450 600 6250 | 1250 | sooo] 1/5/2003 | sales | 113)
En 5710 1165 10 495 660 6875 | 1375 | 5500 2/7/2022 | Sales | o's 114
Sey | 6230 1270 10 540 720 7500 | 1500 | 6000 1/8/1999 | sales | abo 115

rm 5190 1060 10 450 600 6250 | 1250 | sooo] 1/1/2008] nr | ati 120

gy | 6750 1375 10 585 780 sis | 1625 | «soo 2/1/2016 | Acct | > 120

Al
T
ed + data

16

3. Sara Ebrahim

age Layout Formulas Data Review View Developer Help Draw Acrobat
AAA # vee | Date =) Ell Conditions! Formatting + mer | 2 Ar O B ©
Tr me 17%) roms Bonete + Ir Sea da Cm CEPT
o LE] Bi Cell Styles > Forma“ | @ + Filter» Select“ 2 PDF for Excel Copilet
Font = Aignment Number Stes can eating Adobe Aasbat A RECO Y
Je =TODAY) v
1 4 Los F E [o E [Ls | A à
1
[Data TI 10/18/2025 2
=
years of service months of service Price Mileage Year of manufacture Fuel type Engine size Model Manufacturer [iy
25 300 3074 127300 10/12/2000 Petrol A 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 ir
21 261 1705 210814 1/6/2004 Hybrid 18 RAVA Toyota Le
25 302 4101 127869 8/3/2000 Petrol 1 Polo vw Lo
26 321 29204 33603 1/4/1999 Petrol 14 Focus Ford 10
34 413 14350 86686 5/5/1991 Diesel 18 Mondeo Ford nm
18 222 9977 73470 4/7/2007 Petrol 12 Polo vw 22
o 4 1049 262514 6/2/2025 Diesel 2 Focus Ford 13
45 543 17173 83047 7/6/1980 Diesel 2 Golf vw 14
4 BF 719 293666 1/1/2021 Petrol 2 74 BMW 15
34 409 7792 92697 9/7/1991 Diesel 12 Golf vw 16
25 304 16026 79393 6/6/2000 Petrol 22 RAV4 Toyota [az
. Sr ara ur at

br Investigate E Gs 1 + 100%

4. Sum of Mileage by Fuel type and Manufacturer u 100%

Fe = © >
u 1996 [TE
© EEE
u eS +
.» CEA
“ o EEE

ford @Porsche 6

ams +
zur Lg
2020 a:
A 2021 E:
3 os
A Sum of Engine size and Sum of Price by Model
ye 001k 0 Model
04M EE ra

5. [80 9- ¿agallas sae pue > El

File Home Insert Page Layout Formulas Data Review View Developer Help Draw Acrobat PwvotChart Analyze Design Format

outs fe
Gil EN sens = (ical as
>
.
°
1
si
o ve El
ca 5
Sim of ga ab Sm of 3] Sm o chet ta Sim o ac sh Sim ol ca tanh y ©
18
CHART TITLE 16
16000 17.
14000 m
w
ve san o
Dimas om a:
mn m a
pr B
ma ce

mt u lu ] J 14 E
E 7

im im m 2 mh 0 il Al A 20

i és a ‘i

A a

+ ot CS CN ES ETS

Ready IB Gy Acer Imestipate

Sas brain

PivotChart Fields

Conte [1
addto report: ®

Search p

SZ sont,
LA agai an
Dam
ia

À ojal
asta ih
LEP]

LA animal llo
Out

O wtp

D a

I ella tant

Boo

Drag fies between ares
below

Y Fite

Aga al g

= Ai (Categories)
Year -
Queer - I
le 7

E Legend (Serie)

E Values =

E Volver
Sum of abgallps Y
Sumo pal =
Sum ef lla. 7

DeferLayou..

6. Fle Home Insert Page Layout

formulas Data

view View Developer Help Draw Acrobat PivotTable Analyze Design

A he ach
. £ E o € 8 A
a abra] PivotTable Fields ex
Sum of gxzuall Jos] Bum of lod! ölyhum of Cela Y! JlazSum of jlg/kum of <äbgall 63} - Row Labels |; = =
9187.5 7350 1553.5 1837.5 104 1994 + 4 =
8875 7100 1501 1775 105 Brenan
7500 6000 1270 1500 115 1999: 6
13375 10700 2267 2675 213 2000» Seen x
7375 5900 1249 1475 102 2001: 8 ont a ve “
7000 5600 1186 1400 103 Bl: on a " |
10625 8500 1805 2125 224 2003 |. y
5250 4200 892 1050 109 2006: 1 ae
11250 9000 1910 2250 230 ere |
5250 4200 892 1050 106 2009 + B i
5000 4000 850 1000 107 2012|: Haan
4687.5 3750 797.5 937.5 108 2014: 15 sen u
8125 6500 1375 1625 120 2016: 16 e fa “|e
6875 5500 1165 1375 114 2022: Y J z I
110375 88300 18713 22075 1860 Grand Total | 3 =

ED mou

tt wae tala wf rh 100%

7. file

Home

Insert

Page Layout

h

Formulas

Data

Review View Developer

Help Draw Acrobat

8. File

3

Home

Insert

Page Layout
h

Formulas Data Review View Developer Help Draw Acrobat

P o N M L K i 1 4

9. <Back to report

14K (637%) = 00H (0%)
Kor \l
30K (11.54%) EE
Kor
50K (18.96%) 001K 10%)
AK (16825)

zo os

vu

Model
ara
Mondeo
colt

e718 cayman
fous

on
role

10. IK Beck toreport| | SUM OF MILEAGE AY FUEL TYPE AND MANUFACTURER

Manufacturer @EMW @Ford @Porsche Toyota @\

10M

osm

oom
Petrol Diesel Hybrid
Fuel ype

Fueltype BMW Ford Porsche Toyota VW

Petrol — [293666 160903 57850 422669 201339
Diesel 465974 175744
Hybrid A7I9U 121744

[2