Tableau Certification Course - Data Analysis - eLearning

Tableau Certification Course - Data Analysis - eLearning

The Tableau Certification course teaches you how to build visualizations, organize data, and design charts and dashboards to empower more meaningful business decisions. You’ll be exposed to the concepts of Data Visualization, different combo charts, and stories, working with filters, parameters, and sets, and building interactive dashboards.

Prerequisites:There are no prerequisites for taking this training.

Target Audience

• Analytics professionals
• IT developers and testers
• Data analysts
• Data scientists
• BI and reporting professionals
• Project managers

Learning Objectives

When you complete this course, you will be able to accomplish the following:

• Become an expert on visualization techniques such as heat map, treemap, waterfall, Pareto
• Understand metadata and its usage
• Work with Filter, Parameters, and Sets Master special field types and Tableau-generated fields and the process of creating and using parameters
• Learn how to build charts, interactive dashboards, story interfaces, and how to share your work
• Master the concepts of data blending, create data extracts and organize and format data
• Master arithmetic, logical, table, and LOD calculations

Course Outline

Lesson 1: Getting Started with Tabeau

• Getting Started with Excel
• Download and Install Tableau Public
• Load Data from Excel
• User Interface of Tableau
• Key Takeaways

Lesson 2: Core Tableau in Topics

• Core Topics in Tableau
• Dimensions vs. Measures
• Discrete vs Continuous
• Application of Discrete and Continuous Fields
• Aggregation in Tableau
• Key Takeaways

Lesson 3: Creating Charts in Tableau

• Creating Charts in Tableau
• Bar Chart
• Stacked Bar Chart
• Line Chart
• Scatter Plot
• Dual-Axis Charts
• Combined-Axis Charts
• Funnel Chart
• Cross Tabs
• Highlight Tables
• Maps Measure Names and Measure Values
• Key Takeaways
• Hands-on project: Customer Analysis

Lesson 4: Working with Metadata

• Working with Metadata
• Data Types
• Rename, Hide, Unhide and Sort Columns
• Default Properties of Fields
• Key Takeaways

Lesson 5: Filters in Tableau

• Filters in Tableau
• Dimension Filter
• Date Filter
• Measure Filter
• Visual filter
• Interactive Filter
• Data Source Filter
• Context Filter
• Key Takeaways
• Hands-on project Product Analysis

Lesson 6: Applying Analytics to the worksheet

• Applying Analytics to the Worksheet
• Sets
• Parameters Group
• Calculated Fields
• Date Functions
• Text Functions
• Bins and Histogram
• Sort
• Reference and Trend Lines
• Table Calculations
• Pareto Chart
• Waterfall Chart
• Key Takeaways

Lesson 7: Dashboard in Tableau

• Dashboards in Tableau
• Dashboard Working with Layout
• Objects in Dashboard
• Making Dashboards Interactive
• Actions in Dashboard
• Best Practices for Dashboard Creation
• Dashboard for Mobile
• Story
• Case Study
• Key Takeaways
• Hands-on project Sales Dashboard

Lesson 8: Modifications to Data Connections

• Modifications to Data Connections
• Edit Data Source
• Unions
• Joins
• Data blending
• Key Takeaways

Lesson 9: Introduction to Level of Details in Tableau (LODS)

• Level of Details
• Introduction to Level of Detail (LODs)
• Fixed LOD
• Include LOD
• Exclude LOD
• Publish to Tableau Public
• Key Takeaways

End Projects

Project 1: Comparative Study of Countries

Build a dashboard to do a comparative study on various parameters of different countries, using the sample insurance and world development indicators dataset.

Project 2: Sales Performance Analysis

Build a dashboard to present monthly sales performance by product segment and product category for the purposes of identifying the areas that have met or exceeded their sales targets.

Project 3: Customer Analysis

Build a dashboard that presents customer statistics, ranking them by profit ratio and sales. Also, include statistics regarding profit performance by region.

Project 4: Product Analysis

Build a dashboard that presents sales by product category over time, with the ability to drill down to the product and regional level to check if the products are correctly priced.

Project 5: Sales Dashboard

Build a dashboard that presents metrics about products (e.g. sales, profits, profit ratio) and the trends of statistics over a given period of time, filtering down to a number of geographic regions.