English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 8h 52m | 3.45 GB
Data visualization in Excel, Tableau, Python, and R. Create stunning charts and learn the most in-demand skills in 2020
Do you want to learn how to create a rich variety of graphs and charts?
Do you wish you had superior data interpretation skills?
Does your workplace require data visualization proficiency?
Yes, yes, and most likely yes.
The Complete Data Visualization Course is here for you with TEMPLATES for all the common types of charts and graphs in Excel, Tableau, Python, and R!
These are 4 different data visualization courses in 1 course!
Whether your preferred environment is Excel, Tableau, Python, or R, this course will enable you to start creating beautiful data visualizations in no time!
You will not only learn how to create charts, but also how to label them, style them, and interpret them. Moreover, you will receive immediate access to all templates we work with in the lessons. Simply download the course files, replace the dataset, and amaze your audience!
Graphs and charts included in The Complete Data Visualization Course:
- Bar chart
- Pie chart
- Stacked area chart
- Line chart
- Histogram
- Scatter plot
- Scatter plot with a trendline (regression plot)
We live in the age of data. And being able to gather good data, preprocess it, and model it is crucial.
However, there is nothing more important than being able to interpret that data. And data visualization allows us to achieve just that.
Data visualization is the face of data. Many people look at the data and see nothing. The reason for that is that they are not creating good visualizations. Or even worse – they are creating nice graphs but cannot interpret them accurately.
This course will tackle both of these problems. We will make sure you can confidently create any chart that you need to provide a meaningful visualization of the data you are working with. Not only that – you will be able to label and style data visualizations to achieve a ready-for-presentation graph. Furthermore, through this course, you will learn how to interpret different types of charts and when to use them. We will provide examples of great charts as well as terrible charts. We will spare no effort in transforming you into the key person for data visualizations in any team.
We are confident that by the time you complete this course, creating and understanding data visualizations will be a piece of cake for you!
What you’ll learn
- Master data visualization
- Learn how to label and style a graph
- Interpret data
- Select the right type of chart
- Discover findings through data visualization
- Create stunning visualizations
- How to create a Bar chart
- How to create a Pie chart
- How to create a Stacked area chart
- How to create a Line chart
- How to create a Histogram
- How to create a Scatter plot
- How to create a Scatter plot with a trendline (regression plot)
Table of Contents
Introduction
1 What Does the Course Cover
2 Why Learn Data Visualization
3 How to Choose the Right Visualization – Popular Approaches and Frameworks
4 Colors and Color theory
5 How to Choose the Right Data Visualization Color Palette
6 Download all resources
7 FAQ
Setting Up the Working Environments
8 Setting Up The Environments – Do Not Skip, Please
9 Tableau – Downloading Tableau
10 Python – Why Python and Why Jupyter
11 Python – Installing Anaconda
12 Python – Jupyter Dashboard – Part 1
13 Python – Jupyter Dashboard – Part 2
14 Python – Installing the Seaborn Package
15 R – Installing R and RStudio
16 R – Quick Guide to RStudio
17 R – Changing the Appearance in RStudio
18 R – Installing Packages and Using Libraries
Bar Chart – A Brief Intro To Each Environment
19 Bar Chart – Introduction – General Theory and Dataset
20 Download all resources
21 Bar Chart – Excel – How to Create a Bar Chart
22 Bar Chart – Tableau – How to Create a Bar Chart
23 Bar Chart – Python – How to Create a Bar Chart
24 Bar Chart – R – How to Create a Bar Chart
25 Bar Chart – Interpretation & What Makes a Good Bar Chart
26 Bar Chart – Homework
27 Bar Chart – Homework II
Pie Chart
28 Pie Chart – Introduction – General Theory and Dataset
29 Pie Chart – Excel – How to Create a Pie Chart
30 Pie Chart – Tableau – How to Create a Pie Chart
31 Pie Chart – Python – How to Create a Pie Chart
32 Pie Chart – R – How to Create a Pie Chart
33 Pie Chart – Interpretation
34 Pie Chart – Why You Should Never Use a Pie Chart
Stacked Area Chart
35 Stacked Area Chart – Introduction – General Theory and Dataset
36 Stacked Area Chart – Excel – How to Create an Stacked Area Chart
37 Stacked Area Chart – Tableau – How to Create an Stacked Area Chart
38 Stacked Area Chart – Python – How to Create an Stacked Area Chart
39 Stacked Area Chart – R – How to Create an Stacked Area Chart
40 Stacked Area Chart – Interpretation
41 Stacked Area Chart – What Makes a Good Stacked Area Chart
42 Stacked Area Chart Homework
43 Stacked Area Chart Homework II
Line Chart
44 Line Chart – Introduction – General Theory and Dataset
45 Line Chart – Excel – How to Create a Line Chart
46 Line Chart – Tableau – How to Create a Line Chart
47 Line Chart – Python – How to Create a Line Chart
48 Line Chart – R – How to Create a Line Chart
49 Line Chart – Interpretation
50 Line Chart – What Makes a Good Line Chart
51 Line Chart Homework
Histogram
52 Histogram – Introduction – General Theory and Dataset
53 Histogram – Excel – How to Create a Histogram Chart
54 Histogram – Tableau – How to Create a Histogram Chart
55 Histogram – Python – How to Create a Histogram Chart
56 Histogram – R – How to Create a Histogram Chart
57 Histogram – Interpretation
58 Histogram – How to Choose the Right Number of Bins
59 Histogram – What Makes a Good Histogram Chart
60 Histogram – Homework
Scatter Plot
61 Scatter Plot – Introduction – General Theory and Dataset
62 Scatter Plot – Excel – How to Create a Scatter Plot
63 Scatter Plot – Tableau – How to Create a Scatter Plot
64 Scatter Plot – Python – How to Create a Scatter Plot
65 Scatter Plot – R – How to Create a Scatter Plot
66 Scatter Plot – Interpretation
67 Scatter Plot – What Makes a Good Scatter Plot
68 Scatter Plot – Homework
Combo Plots Part 1 – Scatter and Trendline (Regression Plot)
69 Regression Plot – Introduction – General Theory and Dataset
70 Regression Plot – Excel – How to Create a Regression Plot
71 Regression Plot – Tableau – How to Create a Regression Plot
72 Regression Plot – Python – How to Create a Regression Plot
73 Regression Plot – R – How to Create a Regression Plot
74 Regression Plot – Interpretation
75 Regression Plot – What Makes a Good Regression Plot
76 Regression Plot – Homework
Combo Plots Part 2 – Bar and Line Chart
77 Bar and Line Chart – Introduction – General Theory and Dataset
78 Bar and Line Chart – Excel – How to Create a Bar and Line Plot
79 Bar and Line Chart – Tableau – How to Create a Bar and Line Plot
80 Bar and Line Chart – Python – How to Create a Bar and Line Plot
81 Bar and Line Chart – R – How to Create a Bar and Line Plot
82 Bar and Line Chart – Interpretation
83 Bar and Line Chart – What Makes a Good Bar and Line Chart
84 Bar and Line Chart – Homework
Advanced Topics – Dashboards, Pivot Dashboard – Excel
85 Dashboard in Excel – Introduction
86 Dashboard in Excel – Getting to Know the Data Set
87 Dashboard in Excel – Creating the Desing for the Excel Dashboard
88 Dashboard in Excel – Creating a Drop-down List in Excel
89 Dashboard in Excel 😯 Using the Developer Tab and Creating Radio Buttons in Excel
90 Dashboard in Excel – Including Additional Features to the Data Set
91 Dashboard in Excel 😯 Pivot Tables
92 Dashboard in Excel – Tables 😯 Creating LTM and YTD References in Excel
93 Dashboard in Excel – Tables 😯 Creating Month, Year and Selected Dates Fields in
94 Dashboard in Excel 😯 Tables -Calculating Net Sales
95 Dashboard in Excel 😯 Tables -Calculating GP% and Distribution Costs
96 Dashboard in Excel – Tables 😯 Volume by Size
97 Dashboard in Excel – Tables 😯 Volume by Client Type 😯 Homework
98 Dashboard in Excel 😯 Charts – Bar and Line Combination Chart
99 Dashboard in Excel – Charts 😯 Clustered Bar Chart I
100 Dashboard in Excel – Charts 😯 Clustered Bar Chart II
101 Dashboard in Excel 😯 Adding KPIs and a Slicer to the Dashboard
102 Dashboard in Excel – Customizing the Appearance of the Dashboard
103 Dashboard in Excel – Customizing the Appearance of the Slicer
104 Dashboard in Excel – Interpretation
Advanced Topics – Dashboards – Tableau
105 Dashboard in Tableau – Introduction
106 Dashboard in Tableau – Loading the Data and Preparing the Sheets for the Tableau
107 Dashboard in Tableau – Bar and Line Combination Chart
108 Dashboard in Tableau – Horizontal Bars Chart I
109 Dashboard in Tableau – Horizontal Bars Chart II
110 Dashboard in Tableau – Adding KPIs to the Tableau Dashboard
111 Dashboard in Tableau – Creating the Tableau Dashboard and Adding a Brand Filter
112 Dashboard in Tableau – Incorporating a Date Filter into the Dashboard
113 Dashboard in Tableau – Styling the Tableau Dashboard
114 Dashboard in Tableau – Interpretation
115 Completing 100%
Resolve the captcha to access the links!