Using the exercise files - Tableau Tutorial

Contents

• Introduction Introduction

  • Welcome

    1m 14s
  • What you need to know

    58s
  • Using the exercise files

    35s
• 1. Introducing Calculations in Tableau 10 1. Introducing Calculations in Tableau 10

  • (Locked)
    Define data types and conversions

    2m 28s
  • (Locked)
    Define function syntax in Tableau 10

    3m 2s
  • (Locked)
    Create calculations using arithmetic operators

    2m 51s
  • (Locked)
    Use logical and comparison operators in calculations

    4m 23s
  • (Locked)
    Create a calculated field

    4m 37s
  • (Locked)
    Create an ad hoc calculation

    4m 15s
• 2. Summarizing Data Using Aggregate Functions 2. Summarizing Data Using Aggregate Functions

  • Calculate the sum of a collection of values

    2m 33s
  • (Locked)
    Calculate the average, median, minimum, and maximum of a set of values

    7m 5s
  • (Locked)
    Identify the percentile of a given value

    6m 7s
  • Find the variance and standard deviation of populations and samples

    6m 54s
  • (Locked)
    Count all values or distinct values in a data set

    3m 52s
  • (Locked)
    Find the value of an attribute

    1m 45s
• 3. Calculating Values Using Number Functions 3. Calculating Values Using Number Functions

  • (Locked)
    Find the absolute value or sign of a number

    4m 38s
  • (Locked)
    Round numbers up or down

    6m 26s
  • (Locked)
    Find the integer and decimal components of a division operation

    4m 25s
  • (Locked)
    Calculate the square or square root of a value

    3m 36s
  • (Locked)
    Identify the larger or smaller of two values

    3m 38s
  • (Locked)
    Return zero if a calculation includes a null value

    3m 21s
• 4. Working with Times and Dates 4. Working with Times and Dates

  • Return the current date or date and time

    4m 7s
  • (Locked)
    Return the day, month, or year component of a date

    4m 50s
  • (Locked)
    Identify part of a date using DATEPART

    5m 3s
  • (Locked)
    Add or subtract intervals from dates

    6m 37s
  • (Locked)
    Truncate a date

    3m 37s
  • (Locked)
    Identify the earlier or later of two dates

    3m 18s
• 5. Creating Conditional Calculations Using Logical Functions 5. Creating Conditional Calculations Using Logical Functions

  • (Locked)
    Create IF THEN expressions

    4m 12s
  • (Locked)
    Create IF THEN ELSE and ELSE IF expressions

    3m 5s
  • (Locked)
    Return true or false values using IIF

    6m 7s
  • (Locked)
    Define multilevel conditions using CASE expressions

    4m 45s
  • (Locked)
    Manage null values using IFNULL and ISNULL

    4m 41s
• 6. Creating Level of Detail (LOD) Expressions 6. Creating Level of Detail (LOD) Expressions

  • (Locked)
    Create a level of detail (LOD) expression

    3m 15s
  • Create level of detail expressions using FIXED

    4m 4s
  • (Locked)
    Create level of detail expressions using INCLUDE

    3m 42s
  • (Locked)
    Create level of detail expressions using EXCLUDE

    4m 14s
• 7. Summarizing Data Using Table Calculations 7. Summarizing Data Using Table Calculations

  • (Locked)
    Create a quick table calculation

    3m 46s
  • (Locked)
    Calculate a running total or moving average

    6m 5s
  • (Locked)
    Add a secondary table calculation

    4m 25s
  • (Locked)
    Rank table data

    3m 54s
  • (Locked)
    Identify a table row using INDEX

    2m 3s
  • (Locked)
    Count table rows from first or last row

    3m 40s
  • (Locked)
    Look up values using PREVIOUS_VALUE and LOOKUP

    5m 43s
  • (Locked)
    Return the number of rows in the partition

    3m 50s
  • (Locked)
    Summarize data within a defined window of rows

    5m 49s
• 8. Managing Text Strings 8. Managing Text Strings

  • (Locked)
    Convert and measure strings

    4m 32s
  • Find and replace text in a string

    4m 31s
  • (Locked)
    Trim and pad strings

    1m 28s
  • (Locked)
    Determine if a sequence occurs within a string

    4m 5s
  • (Locked)
    Return characters from part of a string

    5m 31s
• Conclusion Conclusion

  • (Locked)
    Next steps

    57s