English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 2h 28m | 508 MB
Turn complex data into meaningful visualization to gain insights by creating perfect charts and histograms
A lot of us who work with data know how to make charts, but don’t know how to make effective visualizations that send a clear, efficient, and truthful message. Many of us don’t realize what makes charts speak and how to remove noise and focus only on what’s important.
This course takes a different approach, focusing instead on various data science tools, typical workflows in data projects, algorithms, and the math behind data science. You will work on presenting and communicating with data using visual media such as charts, plots, and histograms with real-world datasets.
By working with the four most popular chart types, you will dissect each of them at a microscopic level while using interesting real-world datasets with practical examples in Excel. The aim of the course is to show you where charts work and where they don’t and what makes these charts easier to understand.
By the end of the course, you will have learned how to implement the principles of effective visual communication using Excel.
This course adopts a top-down approach where you will learn the most popular data visualization techniques. You will be walked through real-world datasets to show how you can get insights visually from a huge amount of data.
What You Will Learn
- Apply a top-down approach in data analysis by starting with high-level questions, sketches, and metric definitions for more effective communication with data.
- Work with real-life noisy data and communicate findings that are relatable to real life with clarity and truthfulness
- Dissect common elements of an ideal chart to get an understanding of how to use it to tell a clear story
- Discover how elements of each chart type serve to add clarity and substance to the chart message
- Build perfect charts using Excel, one of the most popular statistical applications used worldwide
Table of Contents
Introduction – Work with Visualization Elements
1 The Course Overview
2 Building Blocks of a Successful Visualization
3 Tips to Make Visualizations Clearer, Understandable, and Concise
Making a Perfect Line Chart
4 Overview of a Line Chart
5 How to Create a Perfect Line Chart in Excel
6 How to Create a Stepped Line Chart in Excel
Making a Perfect Bar Chart
7 Overview of a Bar Chart
8 Types of Bar Charts and When to Use Them
9 Things That Make a Better Bar Chart
10 Building a Simple Bar Chart with Enhancements
11 Building Stacked Bar Charts
Creating Meaningful Scatterplots
12 Questions That Scatterplot Can Answer
13 Tips to Make a Meaningful Scatterplot
14 Making a Scatterplot with Trendlines and Dynamic Point Size
15 Making a Scatterplot with a Categorical Variable
Making a Perfect Histogram
16 What Is Histogram and How to Build It
17 What Makes a Meaningful Histogram
18 Making a Histogram with Extreme Outliers
Resolve the captcha to access the links!