Tableau
Tableau is an interactive, self-service reporting and analytics tool that enables faculty and staff to integrate and combine data from multiple sources into visualizations and be accessed in a single desktop environment usingTableau Desktop or through a shared dashboard...
EY, Facebook, Dell, General Motors, KPMG, Bank of America & other 30,000 MNCs worldwide use Tableau across industries
About this course
Learn Tableau 10 for Data Science step-by-step. Real-Life Data Analytics Exercises & Quizzes Included. Learn by doing!
Course Content
- What is Tableau & Course Overview
- Installation
- How Quick is Tableau Exercise - Get Excited!
Tableau Basics: Your First Bar chart
- The Business Challenge - Who Gets the Annual Bonus?
- Connecting Tableau to a Data File - CSV
- Navigating Tableau
- Creating Calculated Fields
- Adding Colors
- Adding Labels and Formatting
- Exporting Your Worksheet
- Get The Viz
- Tableau Basics
Time series, Aggregation, and Filters
- Section Intro
- Working with Data Extracts in Tableau
- Working with Time Series
- Understanding Aggregation, Granularity, and Level of Detail
- Creating an Area Chart & Learning About Highlighting
- Adding a Filter and Quick Filter
- Quiz Time: Time series, Aggregation, and Filters
Maps, Scatterplots, and Your First Dashboard
- Joining Data in Tableau
- Creating a Map, Working with Hierarchies
- Creating a Scatter Plot, Applying Filters to Multiple Worksheets
- Let's Create our First Dashboard!
- Adding an Interactive Action - Filter
- Adding an Interactive Action - Highlighting
- Quiz Time: Maps, Scatterplots, and Your First Dashboard
Joining and Blending Data, PLUS: Dual Axis Charts
- Understanding how LEFT, RIGHT, INNER, and OUTER Joins Work
- Joins With Duplicate Values
- Joining in Multiple Fields
- The Showdown: Joining Data v.s. Blending Data in Tableau
- Data Blending in Tableau
- Dual Axis Chart
- Creating Calculated Fields in a Blend (Advanced Topic)
- Quiz Time: Joining and Blending Data, PLUS: Dual Axis Charts
Table Calculations, Advanced Dashboards, Storytelling
- Downloading the Dataset and Connecting to Tableau
- Mapping: how to Set Geographical Roles
- Creating Table Calculations for Gender
- Creating Bins and Distributions For Age
- Leveraging the Power of Parameters
- How to Create a TreeMap Chart
- Creating a Customer Segmentation Dashboard
- Advanced Dashboard Interactivity
- Analyzing the Customer Segmentation Dashboard
- Creating a Storyline
- Quiz Time: Table Calculations, Advanced Dashboards, Storytelling
Advanced Data Preparation
- What Format Your Data Should Be In
- Data Interpreter
- Pivot
- Splitting a Column into Multiple Columns
- MetaData Grid
- Fixing Geographical Data Errors in Tableau
- Advanced Data Preparation
Analytics with Tableau
- The Challenge: Startup Expansion Analytics
- Custom Territories Via Groups
- Custom Territories Via Geographic Roles
- Adding a Highlighter
- Clustering In Tableau
- Cross-Database Joins
- Modeling With Clusters
- Saving Your Clusters
- New Design Features
- Quiz Time: Advanced Analytics
Groups and Sets
- Project Brief: 1,000 Startups
- Working with Groups
- Creating Static Set
- Creating Dynamic Set
- Combining Sets
- Controlling Sets With Parameters
- Dashboard: The Startup Quadrant
- Dashboard Tricks
- Section Recap
- Groups and Sets
Advanced Data Preparation and Analytics
- Project Brief: Retail Sector Forecasts
- Building Box Plots in Tableau
- Analysing Box Plots
- Working with Large Data Sources
- Pivot & Split
- What Does Real World Retail Look Like
- Primary Use Case For Data Source Filters
- Trendlines
- Data Prep Exercise
- Advanced Time series Blending
- Calculating Sales Per Ca pita
- Forecasting in Tableau
- How to Present a Storyline
Level of Detail
- Project Brief: Regional Profit Analysis
- Preparing the workbook
- Aggregation and Granularity (refresher)
- LOD Calculations Intuition
- LOD Type 1: INCLUDE
- Understanding ATTR() in Tableau
- LOD Type 2: EXCLUDE (Part 1)
- LOD Type 2: EXCLUDE (Part 2)
- Multiple fields in an LOD Calculation
- LOD Type 3: FIXED
- Finalizing the Visualization
Advanced Charts
- Pop up Chart
- Waterfall chart
- Pareto chart
- Butterfly chart
- Word cloud
Case Study in Tableau
The board of countries is reviewing the 1,000 potentially interesting startups. Create a analytical solution using Tableau which helps them decide the ones they should invest in.