GOMINDZ ACADEMY
Assignment
Create a word document file in your folder and name it as G_A Assignment-List
DATA ANALYTICS (BUSINESS INTELLIGENCE)
Module 1. Introduction
• What is Tableau & Course Overview
• Software Installation
• Some Additional Resources!
Module 2. Tableau Basic
• The Business Challenge
• Connecting Tableau to a Data File - CSV File
• Navigating Tableau
• Creating Calculated Fields
• Adding Colors
• Adding Labels and Formatting
• Exporting Your Worksheet
• Get The Viz!
• Quiz 1 - Tableau Basics
Module 3: Time series, Aggregation, and Filters
• 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
• Quiz 2: Timeseries, Aggregation, and Filters
Module 4: Maps, Scatterplots, and Your First Dashboard
• Relationships vs Joins (v2020.2 update)
• 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 3 - Maps, Scatterplots, and Your First Dashboard
Module 5 - Joining and Blending Data, PLUS: Dual Axis Charts
• Understanding how LEFT, RIGHT, INNER, and OUTER Joins Work
• Joins With Duplicate Values
• joining on Multiple Fields
• Data Blending in Tableau
• The Showdown: Joining Data vs. Blending Data in Tableau
• Dual Axis Chart
• Creating Calculated Fields in a Blend (Advanced Topic)
• New challenge and dataset!
• The data model (v2020.2 update)
• Working with Relationships in Tableau (v2020.2 update)
• Quiz 4: Joining and Blending Data, PLUS: Dual Axis Charts
Module 6: 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 Tree Map Chart
• Creating a Customer Segmentation Dashboard
• Advanced Dashboard Interactivity
• Analyzing the Customer Segmentation Dashboard
• Creating a Storyline
• Quiz 5: Table Calculations, Advanced Dashboards, Storytelling
Module 7: 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
• Quiz 6: Advanced Data Preparation