Data Analytics with Tableau


The “Data Analytics with Tableau” course builds on the beginner and intermediate Business Intelligence skills you have already mastered either on the job or personally. This course is designed for individuals with beginner or intermediate skills in Tableau. In this course, you will learn how to create and share interactive reports and visualizations and dashboards using Tableau. You will learn the features embedded in Tableau service to provide quick insights into your data.


Target Audience
  • Beginners (Completely new to using Tableau)
  • Experienced users of Tableau and other visualization tools
Course Dates & Duration

The normal course duration is 60 hours, spread over 8 weeks. Classes will be held on weekends

Prerequisites

Basic understanding of database design and concepts

Cost & Payment Terms

The cost of this 8 week course is $1,500.


There are 2 payment options:
  • Option 1: Full payment due at the beginning of the course
  • Option 2: Half due at the beginning of the course and remaining half due by the beginning of week 3

Discounts are available to those who qualify

Delivery format
  • Both in-class and online class options will be available. Homework is assigned after every class
  • Students will be assigned individual projects at the beginning of the course which they will work on throughout the duration of the course using the skills learned in class
  • At the end of the course, each student will give a presentation on the assigned project
  • We provide continuous support after completion of this program. Students are also given 24/7 access to online resources


Course Outline

Part I: Introduction to Tableau
Getting Started
  • Tableau Desktop Installation
  • Understanding Tableau interface
Connecting to Data
  • Getting started with data
    • Connecting to different data sources
    • Live data sources vs Extract
  • Connecting to Data
    • Data prep with text and Excel files
    • Pivot
    • Split
    • Metadata grid
    • Split
    • Custom Split
Connecting to Cubes
    • Cube overview
    • Connecting to cubes
    • Understanding Hierarchies and Filters
Data Blending
  • Data Blending Overview
    • What is data blending
    • Blending relationship
    • How to blend
    • Swapping primary and secondary data source
  • Understanding Join types
    • Inner Joins
    • Right Joins
    • Outer Joins
    • Union
  • Cross database joins
    • Integrating multiple sources into unified model
Part II: Dashboards and Stories
Getting started with dashboards and stories
  • Dashboards and Stories Overview
  • Working with views
  • Working with sheets
  • Building a dashboard
  • Adjusting Dashboard sizes
  • Adding Views to a dashboard
  • Fitting sheets
  • Adding Legends and Quick Filters
  • Adding Filters to a dashboard
Dashboard layouts and formatting
  • Tiled and floating layouts
  • Titles and Dynamic Values
  • Format Menu
  • Layout containers
Dashboard Interactivity using actions
  • Understanding Actions
  • Highlight actions
  • Filter actions
  • URL actions
Drill Down and Hierarchies
  • Hierarchy drill down
  • Data drill down
  • Building hierarchies
  • Date hierarchies
Grouping
  • Grouping Overview
  • Grouping from the header
  • Grouping from the data pane
  • Using a grouped field
  • Grouping marks – visual grouping
Filters
  • Pill types and filtering
  • Filtering dimensions
  • Filtering measures
  • Filtering continuous dates
Interactive Filters
  • Understanding Interactive Filters
  • Basic interactive filters
  • Layout mode for interactive filters
  • Cascading interactive filters
Parameters
  • What is a parameter
  • Parameter types
  • Using parameters
  • parameters with filters
  • parameters with sets
  • parameters with calculated fields
  • parameters with reference lines
Formatting
  • Labels
  • Annotations
  • Tooltips
  • Formatting specific parts of the view
  • Editing and formatting axes
Forecasting
  • Creating a forecast
  • Forecast options
  • Describing the forecast
  • Forecast fields
  • Forecasting constraints
Part III: Working with Calculations
Getting started with calculations
  • Types of calc. functions
  • In-Shelf Calculation
  • Calculation syntax
LOD (Level of Details) Calculation
  • Syntax
  • Dimension or Measure
  • Fixed and Include
  • Comparison of Average and Profits
Table Calculations
  • Definition and examples
  • Field Set
  • Quick table Calculation
  • Manual Table Calculation
Aggregate Calculations
  • Attribute Calculations
  • Aggregated vs Level Calculations
Date Calculations
  • Creating Tableau Dates
  • Calculate time between dates
Logic Calculations
Part IV: Deployment, Maintenance and Administration
Publishing to Tableau server and Tableau Online
Tableau server management
  • Scheduling Extracts
  • Server Administrative Overview
  • Data security with user filters.