What you'll learn:
- Understanding LOD expressions and using them confidently
- Performing calculations in Tableau that are at a different level of detail than the view
- Analyzing and solving complex analytical challenges
- Understanding the different levels of details of multivariate datasets
- Cohort analysis
- Market basket analysis
- User retention analysis
- Binning aggregates by dimensions
- Proportional brushing
- Relative comparison of values/ categories
- Nesting LOD expressions
Have you ever had analytical questions that are easy to ask, but surprisingly hard to answer with regular analytical tools? Do you often find yourself asking questions involvingdifferent data layers?Like comparing a single category toa whole table;or applying filterson particular fields;ortracking the behaviour of custom cohorts overtime - just to mention a few classic examples.
Do you want to know how to compare data aggregatedatdifferent levels ofgranularity?
Do you often bump into the error message: 'Cannot mix aggregate and non-aggregate values'?
Do Tableau termsFIXED, INCLUDE or EXCLUDE confuse you? Are you struggling choosing the right one for particular tasks?
Do you want to step up your daily analytical game and gain new, useful skills?
If you are a passionate Tableau user and youcan associate yourself with one or moreof the questions above, then this course is for you. Scenarioslike theones mentioned aboveoccur on adaily basis, and they can cause quite a bit ofheadache for the analyst. Tableau has many great tools and functions including table calculations that make everyday life easier for the data scientist.
One strong point of the software is its responsiveness. Plotting measures against variables has never been easier: each change tothe shelves is instantly and automatically applied on the view -a great environment tointeractwith the data. This strong point, however, can easily be turned into a weakness, if you want your analysis to step out ofthe borders of the view level of detail.
In Tableau, to solveclassic analytical problems(such ascohort analysis, retention analysis orbinning aggregates by dimensions), or toproceedwithspecial filtering scenarios (like proportional brushing or relative comparisons) you need to be familiar with a special tool set called the level of detail (LOD) expressions.
In this course, you will learn about the general mechanics of LOD expressions both in theory and practice. We start from the very basics and then we proceed to more advanced techniques in a stepwise manner. If you are not familiar with the concept of LOD expressionsyet, but you are already a Tableau user, then taking this course will most probably improve your analytical skills and broaden your tool set.
After completing this course, you will be able to solve all abovementioned analytical challenges and even more, because LOD expressions let the analystcome up with creative solutions for custom scenarios. Instead of asking the questionsyou can be the onein the officewho always has a practical answer or a constructive idea. Take a look at the content of this course, and I bet you won’t regret it.