Description
Pavel Nacev – CFI Education – Advanced Tableau – LOD Calculations download, Pavel Nacev – CFI Education – Advanced Tableau – LOD Calculations review, Pavel Nacev – CFI Education – Advanced Tableau – LOD Calculations free
Pavel Nacev – CFI Education – Advanced Tableau – LOD Calculations
Advanced Tableau – LOD Calculations
This course uses Tableau LOD Calculations to break down and solve the types of business problems that BI analysts and financial analysts typically face.
Overview
Advanced Tableau – Level of Detail Calculations Overview
This Advanced Tableau course provides next-level training to be able to prep and display data in an efficient way.
In this course, you’ll utilize Tableau to break down and solve the types of business problems that BI analysts and financial analysts typically face. This course will open the hood of Tableau’s SQL processing to give you a deeper understanding of how these calculations work. You’ll also be applying what you learn to 7 different business scenarios, which we hope you’ll publish into a Tableau Public profile to show off your work.
By the end, you’ll have a deeper understanding of Tableau and the confidence to tackle a huge variety of problems.
Advanced Tableau – LOD Calculations Learning Objectives
Upon completing this course, you will be able to:
Define level of detail and other critical concepts
Identify the grain and level of detail of a data set
Troubleshoot common errors
Apply fixed, include, and exclude LOD calculations to business scenarios
Identify how different LODs are affected by context and dimension filters
Compare LOD calculations to table calculations
Who should take this course?
This Tableau course is perfect for professionals who have a solid understanding of data analysis and want to expand their skill set to include Tableau’s world-leading visualizations. This course is designed to equip anyone who desires to begin a career in business analysis—or other roles that require displaying and analyzing data sets—with the advanced skills to create dynamic data-viewing experiences.
What you’ll learn
Introduction
Course Introduction
Learning Objectives
Download Student Files
Defining Level of Detail
What is Level of Detail
Dataset Overview
Replicate Dataset LOD in Tableau
Visual Level of Detail
Common Errors with LOD and Aggregation
Solving the LOD Aggregation Problem
Aggregation
Row Vs View Level Aggregation
Why use LOD Expressions
Interactive Exercise 1
FIXED LODs
Level of Detail Expressions: FIXED
FIXED LOD Use Case: Totals and % of Total
Table Calculation Settings
Order Of Operations
Interactive Exercise 2
FIXED LOD Use Case: Customer Order Frequency
FIXED LOD Use Case: Cohort Analysis
FIXED LOD Use Case: New vs. Returning
FIXED LOD Use Case: Full Year YoY %
Stay organized with folders
Interactive Exercise 3
Chapter Review
INCLUDE & EXCLUDE LODs
INCLUDE LOD
INCLUDE LOD Use Case: Average by Hidden Dimension
EXCLUDE LOD
Basic EXCLUDE LOD
EXCLUDE LOD Use Case: Comparative Analysis
Interactive Exercise 4
LOD Review
Course Summary
Visual Formatting
Conclusion
Qualified Assessment
Qualified Assessment Advanced Tableau
