PowerBI References for Beginners who wants to learn Data Analyst

PowerBI References

1. Financial Times Visual Vocabulary:
Power BI Edition

March 2019

Credits: SQLJason

Bismart Barcelona rt Mad
gate canela 145 portes
sarna 2035 Madi

134981786880 EU infoabismartcom À wow dismartcom

— ll SS

2. Visual Vocabulary

ick any section below to

There are somany ways to visuals data how do we know which one t pik? Con category below to decide which data relationships most important inyour story, then ook view the charts
a the different types of charts within the category to form some ntl des about what might work best. This st snot mean o be eshaustive, nora wizer, bits useful

A A | |
Deviation Correlation Ranking

Emphasise variations (+) from a fixed reference point. Showthe relationship between two or more variables. Be Usewhereanitem's position in an ordered list is more
Typically the reference point is zero butitcan alsobe a target mindful that, unless you tell them otherwise, many readers important than ts absolute or relative value, Don't be afraid to
or long-term average. Can lso be used to show sentiment _ willassume the relationships you show them to be causal (Le. highlight the points of interest

(positive/neuteal/negative) fone causes the other)
O NN, EN

Distribution Change over Time Part-to-Whole

Show values in adataset and how often they occur. The shape Give emphasis to changing trends, These can be short ‘Show how a single entity can be broken down into its
(or'skew) ofa distribution can be a memorable way of (ntra-day) movements or extended serias traversing decades component elements, If the reader's interests solely inthe
highlighting the lack of uniformity or equality in the data, or centuries: Choosing the correct time period is important to size of the components, consider a magnitude-type chart

provide suitable context for the reader. instead.

E A EEE
Magnitude Spatial Flow

Show size comparisons, These can be relative (just being able Used only when precise locations or geographical patternsin Show the reader volumes or intensity of movement between

tosee larger/bigger) or absolute (need to see fine differences). data are more important tothereaderthananythingelse. to or more states or conditions. These might be logical
Usually these show a ‘counted’ number (for example, barrels, sequences or geographical locations

dollars or people) rather than a calculated rate or per cent

Po amies “ ae na a

3. Deviation

Emphasise variations (+/-) from a fixed reference point. Typically the reference point is zero but it can al
(positive/neutral/negative).

0 be a target or a long-term average. Can also be used to show sentiment
Diverging Bar

Diverging Stacked Bar

ri ara nativa cie. Sera)
o
==
E De
e A 1
==
==> =
==

Spine Chart

Surplus/Deficit
»acomponent (eg. Malema)

sd Line

4. Correlation

Show the relationship between two or more variables. Be mindful that, unless you tell them otherwise, many readers will assume the relationships you show them to be causal (Le
one causes the other)

peeolewithoeh à gd
He à if
” . en sé “ vu an so sm iS
.
se". » HE on
> .
in ne -— DES en
o. (se
g: .
_— as FE
ro | us um 72 am

5. Ranking

Use where an item's position in an ordered list is more important than its absolute or relative value. Don't be afraid to highlight the points of interest.

Ordered Bar Ordered Column Ordered Proportional Symbol

or bar charts dite rares valu much more sally when Star bar charts display erario! values much more el when sorted. Usewhan there are big variationsbetween ales a

RS _ = .
E | 1 2608,
= 5 28 sr o
February m + a. 7

6. Distribution

Show values in a dataset and how often they occur. The shape (or ‘skew’) of a distribution can be a memorable way of highlighting the lack of uniformity or equality in the data

Histogram

Thostandaré way to show satel detritos keep
the eos besan columns ara to gg te aha 1

Dot Strip Plot
Dots picas morder oi ar poc ficient

pe
ia.
onde ce

Boxplot
Summarie mail striations by showing the median
(corte) ancrangeot the date

Dot Plot
simple of agen change or rang inn of
rentar ——
= ..
Ewen
uk ©
pa — —
ct —
soto ©

Violin Plot

Sinsartoaboxplotbut mor effective wire

stas (dota tt canette sumar th

Simple average)

Barcode Plot

te ot plots, gps or ping al th gota mo

Population Pyramid
‘standard way fr showing tage ae sexbreakdown at

Cumulative Curve
Konad np of showing how naqusindirtbution ety

; i. pun
j xo
j=

7. Change over Time

Give emphasis ta changing trends, These can be short (intraday) movements or extended series traversing decades or centuries: Choosing the correct ime period is important to
provide stable context Forte rade

tine Column Lin + column Steck rice
Aves hort anchor ComectedScttrlt
pus Piety Tne cdeTimaina Solomogrm

600000!
-.o9-000-:e9

comme...

a)
=
E => =>]
Lo 5
=a
=
=

9. Magnitude
s

(990) or absolute (eed tose fine differences), Usually these show coumted'number (for example,

. o tititiitit
MME i= +g “ettttetite

eat
ray a

10. Spatial

Used only when precise locat

a are more important to the reader than anything else,

Basic Choropleth (rate/rati

sé
ZA

Dot Density

Proportional Symbol (count/magnitude) Flow Map Contour Map

=

Equalized Cartogram

HP

o.

11. Chord

12. Find out more
www.bismart.com

bimart.