Markovdata > Courses > Data Analysis & Visualization using Tableau

Data Analysis & Visualization using Tableau

Abstract Tableau About the Tutorial Tableau is a Business Intelligence tool for visually analyzing the data. Users can create and distribute an interactive and shareable dashboard, which depict the trends, variations, and density of the data in the form of graphs and charts. Tableau can connect to files, relational and Big Data sources to acquire […]

Instructor
Markov Data
10 students enrolled

Abstract

Tableau About the Tutorial Tableau is a Business Intelligence tool for visually analyzing the data. Users can create and distribute an interactive and shareable dashboard, which depict the trends, variations, and density of the data in the form of graphs and charts. Tableau can connect to files, relational and Big Data sources to acquire and process data. The software allows data blending and real-time collaboration, which makes it very unique. It is used by businesses, academic researchers, and many government organizations for visual data analysis. It is also positioned as a leader Business Intelligence and Analytics Platform in Gartner Magic Quadrant.

Instructor

Eng/Abdelazim Mahjoub

Duration

2 Weeks

Sessions

Weekdays, 6:00 to 10:00PM

Duration

Live Streaming (on-line)

Prerequisites

Fundamentals and basic knowledge of excel, English and data analysis

1
Module 1: Introduction to Tableau Desktop

Module Overview

  • Concept: Exploring the Desktop Workflow
  • Demo 1: Making Your First Data Connection
  • Activity 1: Connect to Global Library Excel Data
  • Demo 2: Analyzing Data in the Workspace
  • Activity 2: Analyze Your Data in Two Views
  • Demo 3: Sharing Your Analysis in a Dashboard
  • Activity 3: Share Library Data in a Dashboard
2
Module 2: Connecting to Data

Module Overview

  • Concept: How Tableau Desktop Connects to Data
  • Demo: Connecting to a File-Based Data Source
  • Activity: Connect to an Excel File
3
Module 3: Customizing a Data Source

Module Overview

  • Demo: Editing and Saving a Data Source
  • Demo: Updating the View with New Data
  • Activity: Change and Save a Data Source
4
Module 4: Filtering Your Data

Module Overview

  • Demo: Creating Filters on Your Data
  • Demo: Changing Filter Options
  • Demo: Using Date Filters
  • Activity: Create and Customize Filters
5
Module 5: Sorting Your Data

Module Overview

  • Concept: Sorting Your Data to Find Answers
  • Demo: Using Computed and Manual Sorts
  • Activity: Sort by Fields in a View
  • Activity: Sort by Fields Not in a View
6
Module 6: Creating Groups in Your Data

Module Overview

  • Demo: Organizing Your Data with Groups
  • Activity: Create a Group
  • Activity: Create Visual Groups
7
Module 7: Creating Hierarchies in Your Data

Module Overview

  • Demo: Organizing Your Data with Hierarchies
  • Activity: Create a Hierarchy
8
Module 8: Working with Data Fields: Discrete and Continuous Time

Module Overview

  • Concept: Working with Dates
  • Concept: Discrete and Continuous Fields
  • Demo: Changing Date Fields into Discrete or Continuous Fields
  • Demo: Using Discrete and Continuous Date Fields
  • Activity: Show Data Across Discrete and Continuous Months
9
Module 9: Working with Data Fields: Custom Dates

Module Overview

  • Demo: Creating Custom Dates
  • Activity: Apply Custom Dates
10
Module 10: Working with Multiple Measures: Dual Axis and Combo Charts

Module Overview

  • Demo: Building Dual Axis and Combo Charts
  • Activity: Build a Combo Chart
11
Module 11: Working with Multiple Measures: Combined Axis Charts

Module Overview

  • Demo: Building a Combined Axis Chart
  • Activity: Build a Combined Axis Chart
12
Module 12: Showing Relationships between Numerical Values

Module Overview

  • Demo: Building Scatter Plots
  • Activity: Build a Scatter Plot
13
Module 13: Mapping Data Geographically

Module Overview

  • Concept: Mapping Your Data
  • Demo: Creating a Symbol Map
  • Activity: Build a Symbol Map
14
Module 14: Using Crosstabs: Totals and Aggregation

Module Overview

  • Demo: Creating and Editing Crosstabs
  • Demo: Working with Totals and Aggregation
  • Activity: Show Sales Totals in a Crosstab
  • Activity: Create a Weighted Average
15
Module 15: Using Crosstabs: Highlight Tables

Module Overview

  • Demo: Creating Highlight Tables
  • Activity: Build a Highlight Table
16
Module 16: Using Crosstabs: Heat Maps

Module Overview

  • Demo: Creating Heat Maps
  • Activity: Build a Heat Map
17
Module 17: Using Calculations: Customize Your Data

Module Overview

  • Concept: Using Calculated Fields
  • Demo: Exploring the Calculation Editor
18
Module 18: Using Calculations: Working with Strings, Dates, and Type Conversion Functions

Module Overview

  • Demo: Working with String Calculations
  • Activity: Manipulate Strings and Convert the Data Type
  • Demo: Using Date-Specific Calculations
  • Activity: Create a Date Calculation
19
Module 19: Using Calculations: Working with Aggregations

Module Overview

  • Concept: How Calculations Work with Aggregation
  • Demo: Building Calculations with Aggregations
  • Activity: Create a Calculation with Aggregation
20
Module 20: Using Quick Table Calculations to Analyze Data

Module Overview

  • Concept: Applying Quick Table Calculations
  • Demo: Using Running Total and Percent of Total
  • Demo: Leveraging Rank Calculations
  • Activity: Apply a Year over Year Table Calculation
  • Activity: Apply a Rank Table Calculation
21
Module 21: Showing Breakdowns of the Whole

Module Overview

  • Demo: Making Effective Pie Charts
  • Activity: Build a Pie Chart
  • Demo: Showing Hierarchy with Tree Maps
  • Activity: Build a Tree Map
22
Module 22: Using Calculations: Customize Your Data

Module Overview

  • Concept: Using Calculated Fields
  • Demo: Exploring the Calculation Editor
23
Module 23: Highlighting Data with Reference Lines

Module Overview

  • Demo: Using Reference Lines and Bands
  • Activity: Add Two Types of Reference Lines
24
Module 24: Create a Dashboard: Combining Your Views

Module Overview

  • Concept: Introduction to Dashboards
  • Demo: Building a Dashboard
  • Demo: Adding Interactivity to Dashboards
  • Activity: Build an Interactive Dashboard
25
Module 25: Create a Dashboard: Add Actions for Interactivity

Module Overview

  • Concept: Using More Actions in Dashboards
  • Demo: Adding Highlight Actions to a Dashboard
  • Demo: Adding Filter Actions
  • Demo: Adding URL Actions to a Dashboard
  • Activity: Add Actions to a Dashboard
26
Module 26: Sharing Your Work

Module Overview

  • Concept: The Tableau File Types
  • Demo: Sharing Your Work with Others
27
Module 27: Working with a Data Extract

Module Overview

  • Concept: Deciding When to Use an Extract
  • Demo: Extracting Data
  • Activity: Create a Data Extract
28
Module 28: Joining Tables

Module Overview

  • Concept: Using Table Joins
  • Demo: How to Join Tables
  • Activity: Join Tables and Build a View
29
Module 29: Joining Tables Using Calculations

Module Overview

  • Demo: Writing Join Calculations
  • Activity: Use a Calculation to Join Data
30
Module 30: Blending Multiple Data Sources

Module Overview

  • Concept: Using Data from Multiple Sources
  • Demo: Blending Data in a View
  • Activity: Blend Data from Two Sources
31
Module 31: Blending Data without a Common Field

Module Overview

  • Demo: Blending with Custom Relationships and Calculations
  • Activity: Blend Data Using Custom Relationships
32
Module 32: Using Unions to Combine Data

Module Overview

  • Concept: Appending Row Data with Unions
  • Demo: Creating a Union Manually
  • Activity: Union Data and Merge Fields
33
Module 33: Filtering Across Data Sources

Module Overview

  • Demo: Filtering Across Data Sources
  • Activity: Apply a Filter to Multiple Data Sources
34
Module 34: Using Sets to Highlight Data

Module Overview

  • Demo: Creating Sets
  • Activity: Use Combined Sets
35
Module 35: Using Context Filters to Limit Scope

Module Overview

  • Demo: Adding a Context Filter
  • Activity: Add a Filter to Context
36
Module 36: Using Split and Custom Split

Module Overview

  • Demo: Splitting Data Fields
  • Activity: Show Profitability as a Percent of Total
37
Module 37: Controlling Table Calculations

Module Overview

  • Concept: Specifying Scope and Direction
  • Demo: Controlling Scope and Direction
  • Activity: Show Profitability as a Percent of Total
38
Module 38: Using Level of Detail Expressions

Module Overview

  • Concept: Exploring Level of Detail Expressions
  • Demo: Writing Calculations Fixed to a Dimension
  • Activity: Calculate the Average Product Profit by Category
39
Module 39: Filtering and LOD Expressions

Module Overview

  • Concept: Using LOD Expressions with Filters
  • Demo: Controlling a Filter's Impact on Percent of Total
  • Activity: Filter Percent of Sales
40
Module 40: Using Parameters to Control Data in the View

Module Overview

  • Concept: Using Parameters to Give Control
  • Demo: Adding Parameters to a View
  • Activity: Use a Parameter in a Filter
41
Module 41: Parameters: Swap Measures

Module Overview

  • Demo: Using Parameters to Swap Measures
  • Activity: Create a Parameter for Switching Measures
  • Activity: Use a Nested Parameter for Dynamic Selection
42
Module 42: Advanced Mapping: Modifying Locations

Module Overview

  • Demo: Editing Location Data
  • Activity: Add Location Data
43
Module 43: Advanced Mapping: Customizing Tableau’s Geocoding

Module Overview

  • Demo: Customizing Geocodes for Addresses
  • Activity: Build a Map with Custom Geocoding
44
Module 44: Advanced Mapping: Using a Background Image

Module Overview

  • Concept: Plotting Data on a Custom Background
  • Demo: Adding an Image and Plotting Data
  • Activity: Plot Data on an Image
45
Module 45: Viewing Distributions

Module Overview

  • Demo: Building Histograms
  • Activity: Use a Histogram to View Distributions
  • Demo: Building Box and Whisker Plots
  • Activity: Use a Box Plot to View Distributions
46
Module 46: Comparing Measures Against a Goal

Module Overview

  • Demo: Building Bar-in-Bar Charts
  • Activity: Create a Bar-in-Bar Chart
  • Demo: Building Bullet Graphs
  • Activity: Create a Bullet Graph
47
Module 47: Showing Statistics and Forecasting: Use the Analytics Pane and Trend Lines

Module Overview

  • Demo: Adding Trend Lines in the View
  • Activity: Create Trend Lines with Small Multiples
  • Demo: Generating a Forecast in the View
  • Activity: Add a Forecast to a View
48
Module 48: Advanced Dashboards: Using Design Techniques and Filter Actions

Module Overview

  • Concept: Planning for a Successful Dashboard
  • Demo: Using Design Best Practices
  • Activity: Improve a Dashboard's Design
  • Demo: Using Advanced Filter Actions
  • Activity: Create Advanced Filter Actions
49
Module 49: Telling Stories with Data

Module Overview

  • Concept: Introduction to Tableau Stories
  • Demo: Creating a Data Story
  • Demo: Formatting a Story
  • Activity: What's the Story?

Be the first to add a review.

Please, login to leave a review
Register
30-Day Money-Back Guarantee

Includes

Full lifetime access
Access on mobile and TV