Data Visualization _Basics
In this module, you will be introduced to the basics of charts and the
Excel functions that are used to create basic charts and pivot chart
visualizations. By learning how to manipulate these features and
creating visualizations, you will begin to understand the important role
charts play in telling a data-driven story.
Create basic charts such as line and bar & Bar chart charts using
Excel.
5000
4000
3000
2000
1000
0
Jan Feb Mar April May
This is a line chart
1. compare differente but related data sets
2. show how data value change in relation to a continuous variable eg
time
3. can display trends
exa: how has the sale of producst or multiple products over time
0 5000 10000 15000
France 15580
Morocco 13002
germany 11829
usa 11775
spain 9674
italy 7257
tunisia 7076
algeria
united kingdom
6413
5728
Année 3
This is a bar char
1. Most used
2. easy to create
3. Great to comparing related data sets or parts
Exam: we can see the population number of 10 countries and how
they compare to one another
Youtube ads Social media
20% 20%
blogging Google ads
20% 20%
Pid influencer
20%
This is Pie chart
can show the breack down of the entity to a sub parts
the proportion of the sub parts in relation to one another
eg: marketing compaign
social site
native advertising
paid influence
live events
Série 1 Série 2
20
15
10
0
Élément 1 Élément 2 Élément 3
This is a coulmn char
1. can compare value side by side
2. show changes over times
exam: showing page view vs users session over month to months
basis
Gharb Grande casablanca Agadir
Bouknadel
Kenitra
rabat
Sud
Sous-groupe 5
Groupe 4
Tanger
Ouest maroc
Sous-groupe 6
Sous-groupe 8 Sous-groupe 9
Sale
Groupe 3
Sous-groupe 7
This is a treemaps
1. useful for displaying complex hiearchies using nested rectangles
Example:
state wide employemnt rate
size of rectangle represeant the population
color represent the employemnt rate
This is funel chart
trying to display a pipeline or differents stage of a continuous
process
Example:
the funel chart showing the converstion rate at each stage at sales
from lead generation to finale sale
This is scatter chart
1. circle colors represent the categories of data
2. the circle size are indicative of the volume of data
example:
the number of units solde and the revenue it brings
This is a Bubule chart
1. variant of scatter chart
2. useful for comparing a handful of categories to one another
example : understanding areas of significant expenditure in an
organization’s sales
This is sparkline using in trends
1. Using in finance or more like line chart but one line show trend
2. display trends simply and effectively
example : srock market price fluctuation from the opening to closing
of trading day
