Advanced Calculations in tableau - اتقان الحسابات في تابلو
Master Tableau calculations! Learn different formula types for powerful data analysis and visualization. #Tableau #DataAnalysis #Calculations
Course Content
Advanced Calculations in tableau - اتقان الحسابات في تابلو is an all-levels Udemy course taught by Mohamed Ibrahim. It runs 2h 55m, is taught in Arabic, and includes a certificate of completion. Learners rate it 5.0 out of 5 from 1 review, with 3 students enrolled. It is a paid course, first published January 2024.
Mastering Tableau Calculations: A Comprehensive Guide
This course delves into the world of data manipulation within Tableau, covering a wide range of calculation types to unlock deeper insights from your data. Learn to create powerful and flexible calculations for various analytical needs.
Section 1: Row-Level and Aggregate Calculations
- Introduction to Calculations: Get a foundational understanding of calculations in Tableau and their importance in data analysis.
- Data Types in Tableau: Explore the different data types Tableau recognizes and how they impact your calculations.
- Operators and Keywords: Become proficient with the operators and keywords used to build complex calculation formulas.
- Row-Level Calculations: Learn how to perform calculations on a row-by-row basis, enabling granular analysis.
- When & How to Use Row Level Calculations: Understand the best scenarios for row-level calculations.
- Concatenate Text Fields: Combine text fields to create new, informative fields.
- Using
Split()Function: Divide text fields into multiple columns. - Using Transform Option to Split: Utilize Tableau's built-in split functionality.
- Using Transform Option to Use Custom Split: Implement custom splitting logic.
- Using
IFCondition: Create conditional calculations based on specific criteria. - Using
LEFT()Function: Extract characters from the left side of a string. - Using
LEN()Function: Determine the length of a string.
- Aggregate Calculations: Discover how to aggregate data to summarize and analyze trends.
- When & How to Use Aggregate Calculations: Understand when to use aggregation for meaningful insights.
- Using
SUM()Function: Calculate the sum of values. - Change Field Default Properties: Customize how fields are aggregated by default.
- Measure Names & Measure Values: Understand the difference between measures and their values.
- Level of Detail & Aggregation: Control the level at which data is aggregated.
- Date Calculations: Master date-related calculations for time-series analysis.
- Using
DATE()Function: Extract the date portion from a datetime field. - Using
DATEDIFF()Function: Calculate the difference between two dates. - Gantt Chart: Create visual timelines using date calculations.
- Using
- Using Parameters with Calculated Fields: Enhance your calculations with dynamic parameters.
- Create Parameters: Define user-adjustable parameters.
- Using Reference Line: Add reference lines to your visualizations.
- Boolean Calculated Field: Create calculations that return true or false values.
- Using Parameter in Calculated Field: Dynamically control calculations based on parameter values.
- Ad Hoc Calculations: Build custom calculations tailored to specific analytical requirements.
Section 2: Level of Detail (LOD) Calculations
- Introduction to LOD Calculation: Understand the power of LOD calculations for performing calculations at different levels of granularity.
- Distinguish Between Different Levels of Detail: Learn the nuances of fixed, include, and exclude LOD expressions.
- When & How to Use LOD: Determine the appropriate use cases for LOD calculations.
- Types of LOD Calculation:
- Fixed: Calculate at a specific level of detail, ignoring the view's dimensions.
- Include: Include specified dimensions in the calculation, regardless of the view's dimensions.
- Exclude: Exclude specified dimensions from the calculation.
- Fixed Level of Detail Calculation: In-depth exploration of fixed LOD calculations.
- Fixed Level of Detail Calculation Part 1
- Fixed Level of Detail Calculation Part 2
- Include Level of Detail Calculation: Detailed explanation and examples of include LOD calculations.
- Exclude Level of Detail Calculation: Detailed explanation and examples of exclude LOD calculations.
Section 3: Table Calculations
- Introduction to Table Calculations: Explore calculations that operate on the data within the current table.
- Overview of Table Calculations: Understand the fundamental concepts and capabilities of table calculations.
- Tableau's Order of Operations: Learn how Tableau evaluates table calculation expressions.
- Quick Table Calculations: Perform common table calculations with ease.
- Running Total
- Difference
- Percent Difference
- Percent of Total
- Rank
- Moving Average
- YTD Total
- Year over Year Growth
- Table Calculation Concepts:
- Relative (Scope and Direction): Understand how to calculate values relative to other rows or the entire table.
Want AI in your product? Hire the team behind TutorialSearch.io
LLM features, RAG, agents and automation wired into a real product — built by the devs who shipped this site.