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

Read 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

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.

What You Will Learn

  • Learn basic concepts of Tableau to refresh your knowledge
  • Look at field and chart types along with organizing and simplifying data
  • Execute calculations, mapping, and analytics
  • Use dashboards and data connection
  • Manipulate string, date and arithmetic calculations, logic statements
  • Connect to spatial files and look at forecasting, trend lines, and model

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.

About The Author

Vivek P.: Vivek P. is a Tableau Certified Associate with more than 12 years of IT experience with different technologies. He is enthusiastic about working with technology and strongly believes in hands-on learning. His teaching methodology is also driven by this belief.

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