So in this post, I will outline the notes I have taken to summarise the course content in order to make things easier for those who don’t want to watch the videos or don’t have the time to. Before I start here is the course link Data Visualization and Dashboards with Excel and Cognos
*Line chart
Displaying trends and show how a data value is changing in relation to a continuous variable
*Pie charts
This type of chart can show the breakdown of an entity into its sub-parts and the proportion of the subparts in relation to one another. Each portion of the pie represents a static value or category, and the sum of all categories is equal to a 100 percent
* Bar charts
This type of chart is the most common as they are easy to create and are great for comparing related data sets or parts of a whole
* Column charts
This type of chart can be used quite effectively to show change over time and to compare values side-by-side
* Tree Maps
treemaps, which are useful for displaying complex hierarchies using nested rectangles
* Funnel charts
Trying to display a pipeline or different stages of a continuous process, then funnel charts are the way to go
* Scatter chart
A scatter chart can be great for revealing trends, clusters, patterns, and correlations between data points.
It’s used to compare two numerical data sets and shows the relationship between them.
* Bubble charts
This is a variant of scatter charts, and they are useful for comparing a handful of categories to one another in terms of relative significance
* Histograms
Shows the distribution of data grouped into bins.
* Map chart
Shows and compares data across geographical regions
* Sparklines
Chart used to show trends and seasonal changes on data sets
