Learn Tableau and Ace the Tableau Certified Data Analyst Exam

Learn Tableau and Ace the Tableau Certified Data Analyst Exam

by Vivek P.
Released February 2022
Publisher(s): Packt Publishing
ISBN: 9781801813235

Watch it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

Dive into the world of data visualization with this course, designed to guide you from beginner to proficient in Tableau, culminating in readiness for the Tableau Certified Data Analyst exam. You'll start with an overview of the exam structure and learn how to install and navigate the software. Through hands-on videos, you'll explore creating and customizing fields, connecting to various data sources, and structuring your data for effective analysis.

As you progress, you'll master creating complex visualizations, including bar charts, scatter plots, and geographical maps. The course also covers creating dynamic dashboards and stories, enhancing your ability to communicate data insights effectively. You'll practice advanced calculations and analytics, such as logical expressions, table calculations, and Level of Detail (LOD) expressions, crucial for real-world data analysis.

In the final sections, you'll prepare for the Tableau Certified Data Analyst exam with practice tests and solutions, ensuring you have a strong grasp of the exam content and format. With step-by-step guidance and expert tips, this course provides everything you need to confidently tackle the certification exam and leverage your Tableau skills in professional scenarios.

What you will learn

  • Navigate Tableau's interface and customize data fields effectively
  • Create and analyze complex visualizations and dashboards
  • Apply advanced calculations and Level of Detail (LOD) expressions
  • Integrate various data sources and perform data blending
  • Develop interactive stories and dynamic dashboards
  • Prepare confidently for the Tableau Certified Data Analyst exam

Audience

This course is designed for data enthusiasts, analysts, and business professionals aiming to gain Tableau certification. Basic knowledge of data concepts is recommended, but no prior experience with Tableau is necessary.

About the Author

Vivek P.: Vivek P. is a Tableau Certified professional with over 13 years of IT experience, spanning various technologies. Passionate about technology and hands-on learning, Vivek believes in an interactive teaching approach that empowers students to grasp complex concepts through practical experience.

Table of contents

  1. Chapter 1 : Getting Started with Tableau
    1. About the Exam
    2. Software Installation and Create Tableau Public Profile
    3. Software Walkthrough
  2. Chapter 2 : Customize Fields
    1. Dimensions and Measures
    2. Discrete and Continuous Fields
    3. Discrete Date Parts and Continuous Date Values
    4. Understand Tableau-Generated Fields
    5. Change Default Field Properties
    6. Rename Columns and Create Aliases
    7. Organize Data into Folders
  3. Chapter 3 : Connect to Data Sources
    1. Choose an Appropriate Data Source
    2. Create a Live Connection and Extract, Extract Filters
    3. Difference Between Live and Extract Connection
    4. Connect to a Data Source on Tableau Server
    5. Connect to Relational Databases and Pull Data Using Custom SQL Queries
    6. Replace the Connected Data Source with Another Data Source for an Existing Chart
  4. Chapter 4 : Structure the Data, Filters, and Parameters
    1. Apply Filters to Dimensions and Measures, and Configure Filter Settings
    2. Add Filters to Context
    3. Sets
    4. Hierarchies
    5. Groups
    6. Parameter (Swap Sheets, Top N)
  5. Chapter 5 : Create Charts
    1. Bar Chart and Stacked Bar Chart
    2. Line Chart
    3. Pie Chart and Annotation
    4. Data Tables (Cross Tab) and Highlight Table
    5. Scatter Plot
    6. Bins and Histogram
    7. TreeMaps, WordCloud, PackedBubbles
    8. Box plots
    9. Area Chart
    10. Dual Axis and Combo Chart
    11. Heat Map
    12. Bar in Bar Chart
    13. Gantt Chart
    14. Sort (Computed, Custom, Nested)
  6. Chapter 6 : Dashboard and Stories
    1. Hands-On Exercises (Profit Analysis)
    2. Solutions (Profit Analysis)
    3. Hands-On Exercises (Sales Analysis)
    4. Solutions (Sales Analysis)
    5. Dashboard Introduction
    6. Create Profit Analysis Dashboard
    7. Add Actions for Interactivity (Filter, URL, and Highlight Actions)
    8. Create Sales Analysis Dashboard
    9. Hands-On Exercise (Add Actions)
    10. Solution (Add Actions)
    11. Use Dashboard Objects (Navigation and Download)
    12. Create Stories
    13. Format a Story
    14. Swap Sheets Using Parameters
  7. Chapter 7 : Calculations
    1. Write String and Date Calculations
    2. Logical Expressions
    3. Write Number Functions
    4. Type Conversion Functions
    5. Create Quick Table Calculations
    6. Quick Table Calculations - Scope and Direction
    7. Custom Table Calculations - First, Last, Index, Rank
    8. Custom Table Calculations - YTD and MTD
    9. Ratio Calculations
    10. Write Aggregate Functions
    11. Use Level of Detail (LOD) Expressions
    12. Fixed LOD
    13. Fixed LOD - Cohort Analysis
    14. Include LOD
    15. Exclude LOD
    16. Exclude LOD - Example
  8. Chapter 8 : Mapping Data Geographically
    1. Symbol Maps
    2. Filled Maps
    3. Density Map
    4. Navigate Maps - Pan and Zoom, Filtering, Map Layering, Custom Territories
    5. Navigate Maps - Lasso and Radial Selection, Geographic Search
    6. Import and Manage Custom Geocoding
    7. Use a Background Image Map
    8. Connect to Spatial Files
  9. Chapter 9 : Analytics
    1. Build Totals and Sub-Totals
    2. Reference Lines
    3. Reference Bands
    4. Reference Distributions
    5. Trend Lines
    6. Trend Models
    7. Forecasting
  10. Chapter 10 : Prepare Data for Analysis
    1. Data Model
    2. Joins
    3. Use Relationships Instead of Joins
    4. Data Blending
    5. Use Relationships Instead of Blend
    6. Union
    7. Data Interpreter and Pivot
    8. Automatic and Custom Split
  11. Chapter 11 : Perform Data Transformation in Tableau Prep
    1. Introduction and Perform Filtering
    2. Shape Data Using Aggregations
    3. Combine Data Using Joins
    4. Combine Data Using Unions
    5. Shape Data Using Pivots
  12. Chapter 12 : Publish and Manage Content on Tableau Server and Tableau Online
    1. Create an Account and Publish a Workbook
    2. Publish a Data Source
    3. Schedule Data Extract Refreshes
    4. Schedule a Tableau Prep Workflow
    5. Create Subscriptions and Alerts
  13. Chapter 13 : Practice Test
    1. Solution - Questions 1 to 6
    2. Solution - Questions 7 to 12
    3. Solution - Questions 13 to 18
    4. Solution - Questions 19 to 24
    5. Solution - Questions 25 to 30
    6. Solution - Questions 31 to 36

Product information

  • Title: Learn Tableau and Ace the Tableau Certified Data Analyst Exam
  • Author(s): Vivek P.
  • Release date: February 2022
  • Publisher(s): Packt Publishing
  • ISBN: 9781801813235