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