The Data Visualization Course: Excel, Tableau, Python, R
Last updated 5/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.55 GB | Duration: 8h 52m
Last updated 5/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 3.55 GB | Duration: 8h 52m
Data visualization in Excel, Tableau, Python, and R. Create stunning charts and learn the most in-demand skills in 2020
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)
Requirements
No prior experience is required. We will start from the very basics
You’ll need to install at least one of the 4 software (Excel, Tableau, Python, or R). We will show you how to do that step by step
Description
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 chartPie chartStacked area chartLine chartHistogramScatter plotScatter 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 makes this course different from the rest of the Data Visualization courses out there?4 different data visualization courses in 1 course – we cover Excel, Tableau, Python and RReady-to-use templates for all charts included in the courseHigh-quality production – Full HD and HD video and animations crafted professionally by our experienced team of visual artistsKnowledgeable instructor team with experience in teaching on UdemyComplete training – we will cover all common graphs and charts you need to become an invaluable member of your data science teamExcellent support - if you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 1 business dayDynamic - we don’t want to waste your time! The instructor sets a very good pace throughout the whole courseWhy do you need these skills?Salary/Income – careers in the field of data science are some of the most popular in the corporate world today. Literally every company nowadays needs to visualize their data, therefore the data viz position is very well paidPromotions – being the person who creates the data visualizations makes you the bridge between the data and the decision-makers; all stakeholders in the company will value your input, ensuring your spot on the strategy teamSecure future – being able to understand data in today’s world is the most important skill to possess and it is only developed by seeing, visualizing and interpreting many datasetsPlease bear in mind that the course comes with Udemy’s 30-day money-back guarantee. And why not give such a guarantee? We are certain this course will provide a ton of value for you.Let's start learning together now!
Overview
Section 1: Introduction
Lecture 1 What Does the Course Cover
Lecture 2 Why Learn Data Visualization
Lecture 3 How to Choose the Right Visualization - Popular Approaches and Frameworks
Lecture 4 Colors and Color theory
Lecture 5 How to Choose the Right Data Visualization Color Palette
Lecture 6 Download all resources
Lecture 7 FAQ
Section 2: Setting Up the Working Environments
Lecture 8 Setting Up The Environments - Do Not Skip, Please!
Lecture 9 Tableau - Downloading Tableau
Lecture 10 Python - Why Python and Why Jupyter
Lecture 11 Python - Installing Anaconda
Lecture 12 Python - Jupyter Dashboard - Part 1
Lecture 13 Python - Jupyter Dashboard - Part 2
Lecture 14 Python - Installing the Seaborn Package
Lecture 15 R - Installing R and RStudio
Lecture 16 R - Quick Guide to RStudio
Lecture 17 R - Changing the Appearance in RStudio
Lecture 18 R - Installing Packages and Using Libraries
Section 3: Bar Chart - A Brief Intro To Each Environment
Lecture 19 Bar Chart - Introduction - General Theory and Dataset
Lecture 20 Download all resources
Lecture 21 Bar Chart - Excel - How to Create a Bar Chart
Lecture 22 Bar Chart - Tableau - How to Create a Bar Chart
Lecture 23 Bar Chart - Python - How to Create a Bar Chart
Lecture 24 Bar Chart - R - How to Create a Bar Chart
Lecture 25 Bar Chart - Interpretation & What Makes a Good Bar Chart
Lecture 26 Bar Chart - Homework
Lecture 27 Bar Chart - Homework II
Section 4: Pie Chart
Lecture 28 Pie Chart - Introduction - General Theory and Dataset
Lecture 29 Pie Chart - Excel - How to Create a Pie Chart
Lecture 30 Pie Chart - Tableau - How to Create a Pie Chart
Lecture 31 Pie Chart - Python - How to Create a Pie Chart
Lecture 32 Pie Chart - R - How to Create a Pie Chart
Lecture 33 Pie Chart - Interpretation
Lecture 34 Pie Chart - Why You Should Never Use a Pie Chart
Section 5: Stacked Area Chart
Lecture 35 Stacked Area Chart - Introduction - General Theory and Dataset
Lecture 36 Stacked Area Chart - Excel - How to Create an Stacked Area Chart
Lecture 37 Stacked Area Chart - Tableau - How to Create an Stacked Area Chart
Lecture 38 Stacked Area Chart - Python - How to Create an Stacked Area Chart
Lecture 39 Stacked Area Chart - R - How to Create an Stacked Area Chart
Lecture 40 Stacked Area Chart - Interpretation
Lecture 41 Stacked Area Chart - What Makes a Good Stacked Area Chart
Lecture 42 Stacked Area Chart Homework
Lecture 43 Stacked Area Chart Homework II
Section 6: Line Chart
Lecture 44 Line Chart - Introduction - General Theory and Dataset
Lecture 45 Line Chart - Excel - How to Create a Line Chart
Lecture 46 Line Chart - Tableau - How to Create a Line Chart
Lecture 47 Line Chart - Python - How to Create a Line Chart
Lecture 48 Line Chart - R - How to Create a Line Chart
Lecture 49 Line Chart - Interpretation
Lecture 50 Line Chart - What Makes a Good Line Chart
Lecture 51 Line Chart Homework
Section 7: Histogram
Lecture 52 Histogram - Introduction - General Theory and Dataset
Lecture 53 Histogram - Excel - How to Create a Histogram Chart
Lecture 54 Histogram - Tableau - How to Create a Histogram Chart
Lecture 55 Histogram - Python - How to Create a Histogram Chart
Lecture 56 Histogram - R - How to Create a Histogram Chart
Lecture 57 Histogram - Interpretation
Lecture 58 Histogram - How to Choose the Right Number of Bins
Lecture 59 Histogram - What Makes a Good Histogram Chart
Lecture 60 Histogram - Homework
Section 8: Scatter Plot
Lecture 61 Scatter Plot - Introduction - General Theory and Dataset
Lecture 62 Scatter Plot - Excel - How to Create a Scatter Plot
Lecture 63 Scatter Plot - Tableau - How to Create a Scatter Plot
Lecture 64 Scatter Plot - Python - How to Create a Scatter Plot
Lecture 65 Scatter Plot - R - How to Create a Scatter Plot
Lecture 66 Scatter Plot - Interpretation
Lecture 67 Scatter Plot - What Makes a Good Scatter Plot
Lecture 68 Scatter Plot - Homework
Section 9: Combo Plots Part 1 - Scatter and Trendline (Regression Plot)
Lecture 69 Regression Plot - Introduction - General Theory and Dataset
Lecture 70 Regression Plot - Excel - How to Create a Regression Plot
Lecture 71 Regression Plot - Tableau - How to Create a Regression Plot
Lecture 72 Regression Plot - Python - How to Create a Regression Plot
Lecture 73 Regression Plot - R - How to Create a Regression Plot
Lecture 74 Regression Plot - Interpretation
Lecture 75 Regression Plot - What Makes a Good Regression Plot
Lecture 76 Regression Plot - Homework
Section 10: Combo Plots Part 2 - Bar and Line Chart
Lecture 77 Bar and Line Chart - Introduction - General Theory and Dataset
Lecture 78 Bar and Line Chart - Excel - How to Create a Bar and Line Plot
Lecture 79 Bar and Line Chart - Tableau - How to Create a Bar and Line Plot
Lecture 80 Bar and Line Chart - Python - How to Create a Bar and Line Plot
Lecture 81 Bar and Line Chart - R - How to Create a Bar and Line Plot
Lecture 82 Bar and Line Chart - Interpretation
Lecture 83 Bar and Line Chart - What Makes a Good Bar and Line Chart
Lecture 84 Bar and Line Chart - Homework
Section 11: Advanced Topics - Dashboards, Pivot Dashboard - Excel
Lecture 85 Dashboard in Excel - Introduction
Lecture 86 Dashboard in Excel - Getting to Know the Data Set
Lecture 87 Dashboard in Excel - Creating the Desing for the Excel Dashboard
Lecture 88 Dashboard in Excel - Creating a Drop-down List in Excel
Lecture 89 Dashboard in Excel – Using the Developer Tab and Creating Radio Buttons in Excel
Lecture 90 Dashboard in Excel - Including Additional Features to the Data Set
Lecture 91 Dashboard in Excel – Pivot Tables
Lecture 92 Dashboard in Excel - Tables – Creating LTM and YTD References in Excel
Lecture 93 Dashboard in Excel - Tables – Creating Month, Year and Selected Dates Fields in
Lecture 94 Dashboard in Excel – Tables -Calculating Net Sales
Lecture 95 Dashboard in Excel – Tables -Calculating GP% and Distribution Costs
Lecture 96 Dashboard in Excel - Tables – Volume by Size
Lecture 97 Dashboard in Excel - Tables – Volume by Client Type – Homework
Lecture 98 Dashboard in Excel – Charts - Bar and Line Combination Chart
Lecture 99 Dashboard in Excel - Charts – Clustered Bar Chart I
Lecture 100 Dashboard in Excel - Charts – Clustered Bar Chart II
Lecture 101 Dashboard in Excel – Adding KPIs and a Slicer to the Dashboard
Lecture 102 Dashboard in Excel - Customizing the Appearance of the Dashboard
Lecture 103 Dashboard in Excel - Customizing the Appearance of the Slicer
Lecture 104 Dashboard in Excel - Interpretation
Section 12: Advanced Topics - Dashboards - Tableau
Lecture 105 Dashboard in Tableau - Introduction
Lecture 106 Dashboard in Tableau - Loading the Data and Preparing the Sheets for the Tableau
Lecture 107 Dashboard in Tableau - Bar and Line Combination Chart
Lecture 108 Dashboard in Tableau - Horizontal Bars Chart I
Lecture 109 Dashboard in Tableau - Horizontal Bars Chart II
Lecture 110 Dashboard in Tableau - Adding KPIs to the Tableau Dashboard
Lecture 111 Dashboard in Tableau - Creating the Tableau Dashboard and Adding a Brand Filter
Lecture 112 Dashboard in Tableau - Incorporating a Date Filter into the Dashboard
Lecture 113 Dashboard in Tableau - Styling the Tableau Dashboard
Lecture 114 Dashboard in Tableau - Interpretation
Lecture 115 Completing 100%
Ideal for beginners,Anyone who wants to start a career in data science or business intelligence,People who want to level-up their career with data visualization skills,Anyone who wants to add value to their company