[3-In-1] Data Viz Bundle: Tableau, Excel & Looker Studio

Learn and compare the three most used data visualization tools in one course- Tableau, Microsoft Excel & Google's Looker

What you'll learn

Develop proficiency in using Tableau, Excel and Looker Studio for creating effective data visualizations.

Learn how to connect and integrate data from various sources for data analysis and visualization.

Explore the differences between Tableau, Excel and Looker in terms of functionality, features and use cases.

Understand how to combine data sources and use joins and blends in Tableau, Excel and Looker.

Explore how to create and customize charts, graphs and maps in Tableau, Excel and Looker.

Develop an understanding of how to share and publish dashboards and visualizations in Tableau, Excel and Looker.

Discover best practices for data visualization and storytelling in Tableau, Excel and Looker.

Requirements

A PC with internet connection. Installation instructions for the tools used are covered in the course.

Description

Are you ready to unlock the power of data visualization and take your data analytics to the next level? If so, then our course, "[3-in-1] Data Viz Bundle: Tableau, Excel & Google's Looker Studio," is perfect for you!In this course, you will explore and compare the three most popular data visualization tools- Tableau, Microsoft Excel & Google's Looker Studio. By the end of this course, you will have mastered the art of data visualization using these powerful tools, and will be able to develop dynamic and effective visualizations for your business or personal use.Here are some of the key values this course will bring:Develop proficiency in Tableau, Excel and Looker Studio for data visualizationMaster the skills to create interactive dashboards and visualizationsExplore and compare different visualization techniques and choose the best tool for your use caseUnderstand how to import, clean, and transform data for visualizationCreate compelling visualizations to present and communicate data insightsData visualization is an essential skill for anyone working with data today. With the amount of data available, the ability to create insightful and visually appealing visualizations can give you a competitive advantage in your career.During this course, you will complete various activities, such as hands-on projects and quizzes, to reinforce your learning and get hands-on experience with Tableau, Excel and Google's Looker Studio.Our course is unique because it combines the three most popular data visualization tools in one comprehensive course, enabling you to compare and contrast their capabilities and learn which tool is best suited for your use case. Our instructors are industry experts with years of experience in data analysis and visualization, ensuring you get the best possible education.So, if you want to take your data analysis skills to the next level, enroll in our "[3-in-1] Data Viz Bundle: Tableau, Excel & Looker Studio" course today and become a data visualization expert!

Overview

Section 1: Introduction

Lecture 1 Introduction

Lecture 2 Course Resources

Lecture 3 Why Tableau

Lecture 4 This is a milestone!

Lecture 5 Tableau Products

Section 2: Installation and getting started

Lecture 6 Installing Tableau desktop and Public

Lecture 7 About the data

Lecture 8 Connecting to data

Lecture 9 Live vs Extract

Section 3: Combining data to create Data model

Lecture 10 Combining data from multiple tables

Lecture 11 Relationships in Tableau

Lecture 12 Joins in Tableau

Lecture 13 Types of Joins in Tableau

Lecture 14 Union in Tableau

Lecture 15 Physical Logical layer and Data models

Lecture 16 The visualization screen - Sheet

Section 4: Data categorization in Tableau

Lecture 17 Types of Data - Dimensions and Measures

Lecture 18 Types of Data - Discreet and Continuous

Lecture 19 Changing Data type in Tableau

Section 5: Most used charts

Lecture 20 Bar charts

Lecture 21 Line charts

Lecture 22 Scatterplots

Section 6: Customizing charts using Marks shelf

Lecture 23 Marks cards

Lecture 24 Dropping Dimensions and Measures on marks card

Lecture 25 Dropping Dimensions on Line chart

Lecture 26 Adding marks in scatterplot

Section 7: Other important charts

Lecture 27 Text tables, heat map and highlight tables

Lecture 28 Pie charts

Lecture 29 Area charts

Lecture 30 Creating custom hierarchy

Lecture 31 Tree map

Lecture 32 Dual combination charts

Lecture 33 Creating Bins

Lecture 34 Histogram

Section 8: Grouping and Filtering data

Lecture 35 Grouping Data

Lecture 36 Filtering data

Lecture 37 Dimension filters

Lecture 38 Measure filters

Lecture 39 Date-Time filters

Lecture 40 Filter options

Lecture 41 Types of filters and order of operation

Lecture 42 Customizing visual filters

Lecture 43 Sorting options

Section 9: Map chart in Tableau

Lecture 44 How to make a map chart

Lecture 45 Considerations before making a Map chart

Lecture 46 Marks card for customizing maps

Lecture 47 Customizing maps using map menu

Lecture 48 Layers in a Map

Lecture 49 Visual toolbar on a map

Lecture 50 Custom background images

Lecture 51 Territories in maps

Lecture 52 Data blending for missing geocoding

Section 10: Calculations and Analytics

Lecture 53 Calculated fields in Tableau

Lecture 54 Functions in Tableau

Lecture 55 Table calculations theory

Lecture 56 Table calculations in Tableau

Lecture 57 Understanding LOD expressions

Lecture 58 LOD expressions examples

Lecture 59 Analytics pane

Section 11: Sets and Parameters

Lecture 60 Understanding sets in Tableau

Lecture 61 Creating Sets in Tableau

Lecture 62 Parameters

Section 12: Dashboard and Story

Lecture 63 Dashboard part -1

Lecture 64 Dashboard part - 2

Lecture 65 Story

Section 13: Appendix

Lecture 66 Connecting to SQL data source

Lecture 67 Connecting to cloud storage services

Section 14: Excel Charts

Lecture 68 Why are charts used?

Section 15: Excel Charts: Basics

Lecture 69 Excel Charts - Categories of messages that can be conveyed

Lecture 70 Elements of charts

Lecture 71 The easy way of creating charts

Section 16: Most important Charts & Best practices

Lecture 72 Bar and column charts

Lecture 73 Formatting charts - Part - 1

Lecture 74 Formatting charts - Part 2

Lecture 75 Best Practices: Bar chart

Lecture 76 Line Charts

Lecture 77 Avoiding the Spaghetti plot

Lecture 78 Area Charts

Lecture 79 Pie and Doughnut Charts

Lecture 80 Why we should avoid Pie charts

Lecture 81 Scatter plot or XY chart

Lecture 82 Frequency Distribution and Histograms

Lecture 83 Waterfall Charts

Lecture 84 Combination charts

Lecture 85 Highlighting chart message

Lecture 86 Eliminating Distractions from the Graph

Lecture 87 Avoiding clutter

Section 17: Pivot Charts

Lecture 88 Pivot table

Lecture 89 Pivot Charts

Section 18: Less used charts

Lecture 90 Stock charts

Lecture 91 Radar charts

Lecture 92 Surface charts

Lecture 93 Heatmaps

Section 19: Sparklines

Lecture 94 Mini charts: Sparklines

Section 20: Infographics using Excel charts

Lecture 95 Creative Infographic 1

Lecture 96 Creative Infographic 2

Section 21: New! Maps chart - Excel 2019 and above

Lecture 97 Maps chart

Section 22: Looker Studio

Lecture 98 Why Data Studio?

Section 23: Terminologies & Theoretical concepts for Data Studio

Lecture 99 Data Studio Home Screen & Dataset vs Data Source

Lecture 100 Structure of Input data

Lecture 101 Dimensions vs Measures (new definition)

Section 24: Practical part begins here

Lecture 102 Opening Data Studio and preparing data

Lecture 103 Adding data source

Lecture 104 Managing added data source

Section 25: Charts to highlight numbers

Lecture 105 Data Table

Lecture 106 Styling tab for data table

Lecture 107 Scorecards

Section 26: Charts for comparing categories : Bar charts and stacked charts

Lecture 108 Simple Bar and Column chart

Lecture 109 Stacked Column chart

Section 27: Charting maps of a country, continent, or region - Geomaps

Lecture 110 GeoMap

Section 28: Charting to highlight trends: Time Series, Line and Area charts

Lecture 111 Time Series

Lecture 112 Update to Time Series chart

Lecture 113 Line Chart and Combo Chart

Section 29: Highlighting contribution to total: Pie charts & Donut Chart

Lecture 114 Pie Chart and Donut Chart

Lecture 115 Stacked Area Charts

Lecture 116 Updated data file for area chart

Section 30: Relationship between two or more variables: Scatter plots

Lecture 117 Scatter Plots and Bubble charts

Section 31: Aggregating on two dimensions: Pivot tables

Lecture 118 Pivot tables for cross tabulation

Section 32: All about a single Metric: Bullet Chart

Lecture 119 Bullet Chart

Section 33: Chart for highlighting heirarchy: TreeMap

Lecture 120 TreeMaps

Section 34: Branding a Report

Lecture 121 Branding a Report: Brand Logo and Company Details

Lecture 122 Brand colors for report branding

Section 35: Giving the power to filter Data to viewers

Lecture 123 Filter controls for viewers

Section 36: Add Videos, Feedback form etc. to your Report

Lecture 124 URL Embed to include external content

Section 37: Sometimes data is in multiple tables

Lecture 125 Blending data from multiple tables

Lecture 126 Different types of Joins while blending data

Section 38: Sharing and Collaborating on Data Studio report

Lecture 127 Downloading report as PDF and Page Management

Lecture 128 Sharing report and Data Credentials

Lecture 129 Sharing report using a link

Lecture 130 Scheduling emails

Lecture 131 Embeding report on Website

Section 39: Google BigQuery Connection

Lecture 132 Connecting and Visualizing Data in Google BigQuery

Section 40: Charting Best Practices

Lecture 133 Highlighting chart message

Lecture 134 Eliminating Distractions from the Graph

Lecture 135 Avoiding clutter

Lecture 136 Avoiding the Spaghetti plot

Lecture 137 The final milestone!

Section 41: Congratulations & about your certificate

Lecture 138 Bonus Lecture

Students or beginners who are new to the field of data visualization and want to learn about the top tools in the market.,Business professionals who want to gain advanced skills in data visualization using the three most popular tools.,Analysts or managers who work with large sets of data and need to present them in an easy-to-understand manner to others.,Data enthusiasts who want to broaden their knowledge in data visualization and learn about the latest features in these tools.