Udemyallar

Advanced Calculations in tableau - اتقان الحسابات في تابلو

Master Tableau calculations! Learn different formula types for powerful data analysis and visualization. #Tableau #DataAnalysis #Calculations

5.0(1)
3students
2h 55m
Certificate
Mohamed Ibrahim
Mohamed IbrahimBI senior Consultant

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 IF Condition: 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 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.
$ whoami — the devs behind tutorialsearch.io

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.