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

About the Author

Cybersecurity Trainer MS in Cybersecurity Expertise in Healthcare and Finance Industries Penetration tester and compliance auditor

View Articles