Learn Tableau and Ace the Tableau Certified Data Analyst Exam

Video description

Learn Tableau and crack the Tableau Certified Data Analyst Exam with detailed video tutorials, exam notes PDF, tips and tricks, and a full practice test along with solutions.

About This Video

  • Learn Tableau from scratch to ace the Tableau Certified Data Analyst Exam
  • Study guide PDF and quizzes provided to revise and reinforce the concepts learned
  • Discover a dedicated section for the practice tests and their solutions

In Detail

This course is designed considering the fact that you are an absolute beginner, and you will be taught even the most basic concepts in Tableau from scratch so that after completing this course, you will be able to create rich visualizations easily and confidently.

It will help you prepare for and clear your Tableau Certified Data Analyst Exam. In this course, you will find practice tests designed keeping the current exam format in mind; you will find similar kinds of questions in the exam. We will also show you how to solve the questions in a faster way and all the detailed solutions are provided for the hands-on questions.

This course starts with the basic concepts of Tableau to refresh your knowledge. Then, you will look at field and chart types, and how to organize and simplify data. You will then move on to execute calculations, mapping, and analytics. After that, dashboards and data connections will be covered.

Finally, you will be looking at some practice tests to reinforce your learning. The data analyst topics covered include data connections, organizing and simplifying data, field and chart types, calculations, mapping, analytics, and dashboards.

By the end of this course, you will be able to create rich visualizations easily and confidently, and you will be ready to ace your Tableau Certified Data Analyst Exam.

Audience

This course is ideal for anyone who wants to learn Tableau and an experienced individual working on Tableau can benefit from this course in order to pass the Tableau Certified Data Analyst Exam.

An individual with an attitude of willingness to learn is the basic requirement. Working knowledge of Tableau is a plus but not mandatory.

Publisher resources

Download Example Code

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. Ratio Calculations
    9. Write Aggregate Functions
    10. Use Level of Detail (LOD) Expressions
    11. Fixed LOD
    12. Fixed LOD - Cohort Analysis
    13. Include LOD
    14. Exclude LOD
    15. 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