К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Advanced Tableau - LOD Calculations · LearnSpace
Назад в каталог
courseraБизнес

Advanced Tableau - LOD Calculations

Курс от Corporate Finance Institute
Продвинутый≈ 4.2 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

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. 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 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.

Навыки, которые вы освоите

Tableau SoftwareSQLData AnalysisData PresentationData Visualization SoftwareInteractive Data Visualization

Программа курса

6 модулей · 72 учебных материалов

01Getting Started4 материалов

Introduction

Course IntroductionВидеоLearning ObjectivesВидеоDownload Student FilesВидеоDownloadable materialЧтение
02Defining Level of Detail10 материалов

Учитесь у экспертов

CFI (Corporate Finance Institute)

Преподаватель курса

Advanced Tableau - LOD Calculations
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 4.2 ч

6 модулей

Язык: Английский

Субтитры: Арабский, Французский, Итальянский, Бразильский португальский, Корейский, Немецкий, Испанский, Японский, Казахский

Часть программы вашего университета

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 1PLUGIN
03FIXED LODs40 материалов

Level of Detail Expressions: FIXED

Level of Detail Expressions: FIXEDВидео

FIXED LOD Use Case: Totals and % of Total

Totals and % of TotalВидеоCalculate Total Category SalesВидеоFIXED with multiple dimensionsВидеоFixed LOD with No DimensionsВидеоCalculating % of Category TotalВидео

Table Calculation Settings

Table Calculation SettingsВидео% of Total as Table CalcВидео

Order Of Operations

Order Of OperationsВидеоFixed LOD with FiltersВидеоTranslating Tableau Operations to SQLВидеоFIXED LOD SQL LogicВидеоFIXED LOD SQL Logic for Dimensional FiltersВидео

Practice Exercise

Interactive Exercise 2PLUGIN

FIXED LOD Use Case: Customer Order Frequency

Customer Order FrequencyВидеоOrder Count as a MeasureВидеоOrder Count as a DimensionВидеоFiltering FIXED LODs - ExplorationВидеоFiltering FIXED LODs - SolutionВидеоOrder of Operations RecapВидео

FIXED LOD Use Case: Cohort Analysis

Cohort AnalysisВидеоCohort IdentificationВидеоCohort SalesВидеоCohort FormattingВидеоAcquisition Cohorts with FiltersВидео

FIXED LOD Use Case: New vs. Returning

New vs. ReturningВидеоIdentify New CustomersВидеоReturning Customers & SummaryВидеоNew vs. Returning ChartВидео

FIXED LOD Use Case: Full Year YoY %

Full Year YoY %ВидеоYoY Calculation Using TCalcВидеоMax Date in DatasetВидеоMin Date in Current YearВидеоMin and Max Dates in Previous YearВидеоCurrent and Previous Year SalesВидео

Stay organized with folders

Stay organized with foldersВидео

Practice Exercise

Interactive Exercise 3PLUGIN

Module Review

Chapter ReviewВидео
04INCLUDE & EXCLUDE LODs15 материалов

INCLUDE LOD

INCLUDE LODВидео

INCLUDE LOD Use Case: Average by Hidden Dimension

Average by Hidden DimensionВидеоAvg Sales By Cat for each RegionВидеоFlexibility with INCLUDE LODsВидеоINCLUDE LOD ReviewВидеоINCLUDE LOD with Dimension FilterВидеоINCLUDE LOD vs FIXED LODВидеоAVG Sales by Region Category & CustomerВидео

EXCLUDE LOD

EXCLUDE LODВидео

Basic EXCLUDE LOD

Basic EXCLUDE LODВидео

EXCLUDE LOD Use Case: Comparative Analysis

Comparative AnalysisВидеоComp Chart Part 1ВидеоComp Chart Part 2Видео

Practice Exercise

Interactive Exercise 4PLUGIN

Module Review

LOD ReviewВидео
05Course Conclusion2 материалов

Course Conclusion

Visual FormattingВидеоConclusionВидео
06Qualified Assessment1 материалов

Qualified Assessment

Qualified AssessmentЗадание
Discrete vs Continuous AxisВидео
Plotting YoY Sales GrowthВидео