Module Three: Telling Stories with Data – Tableau for Beginners

  Data is like a box of LEGO pieces
     🟦 🟥 🟩 🟨
  Each piece is one fact (a number or name)
  Tableau helps us build a castle out of them!
  

  Tableau = Magic Paintbrush 🖌️
  Numbers (data)  →  🎨  →  Beautiful Chart
  

  +-------------------+-------------------+
  |   DIMENSION       |    MEASURE        |
  | (Categories)      | (Numbers)         |
  +-------------------+-------------------+
  | Fruit             | Quantity sold     |
  | City              | Temperature       |
  | Month             | Total Sales       |
  +-------------------+-------------------+
  

  Step 1: Open Tableau
  Step 2: Click "Connect to Data"
  Step 3: Choose your file (e.g., Excel)
  Step 4: Click "Open" – now your data is ready!
  

  🍎 Apples   ████████████████████  80
  🍌 Bananas  ████████████████      60
  🥭 Mangoes  ██████████            40
  

  Sales
    |
  60|    * 
  50|   * *
  40|  *   *
  30| *     *
  20|*       *
  10|         *
    +--------------
    Jan Feb Mar Apr
  

  All Data  →  Filter  →  Only what you need
  [🌍]         [🔍]       [🌽] (just corn data)
  

  +-------------------------------------------------+
  |  🏆 DASHBOARD                                   |
  |  +------------+  +------------+                 |
  |  | Bar Chart  |  | Line Chart |                 |
  |  | Sales by   |  | Sales over |                 |
  |  | Product    |  | Time       |                 |
  |  +------------+  +------------+                 |
  |  +------------+                                 |
  |  | Map        |                                 |
  |  | Sales by   |                                 |
  |  | Region     |                                 |
  |  +------------+                                 |
  +-------------------------------------------------+
  

  [Product]  →  Drag to Columns
  [Sales]    →  Drag to Rows
  Result: Bar chart appears!
  

  Marks Card:
  [Colour]  →  Choose red, blue, green
  [Size]    →  Make bars thicker or thinner
  [Label]   →  Show numbers on the bars
  

  Story Point 1  →  Story Point 2  →  Story Point 3
  [Sales Chart]     [Profit Chart]    [Future Plan]
  

  Tableau → Export → PDF / Image / Tableau Public
  Then you can share with anyone!
  

  Data Types:
  🔢 Number: 10, 3.14, 1000
  🔤 String: "Hello", "Nigeria"
  📅 Date: 2026-07-04
  

  Connect to Data
        |
        V
  Drag Dimension to Columns
        |
        V
  Drag Measure to Rows
        |
        V
  Chart Appears!
        |
        V
  Customise with Marks Card
  

  0:00 – Open Tableau
  2:00 – Connect to data
  4:00 – Drag first dimension
  6:00 – Drag first measure
  8:00 – Add filter
  10:00 – Save your work
  

📊 Module 6 · Certified Tableau for Data Analysis Expert

Module Title: Making Data Smarter – Calculations, Parameters & Forecasting

Welcome, data superstar! In this module, we will learn how to make our data even smarter. We will use calculations (like adding or multiplying numbers), parameters (like a slider that changes numbers), and forecasting (like predicting the future).

Imagine you have a magic calculator that can not only add numbers but also guess what might happen next week. That is what we will do with Tableau!

🎯 Learning Objectives

By the end of this module, you will be able to:

• Create simple calculations in Tableau (like adding two fields).
• Use parameters to let users change values.
• Understand what forecasting is and how to use it.
• Build a dashboard that includes calculations and parameters.
• Explain how forecasting helps in real life.

🌟 Warm-up Story: Chidi's Lemonade Stand

Chidi is a smart boy in Enugu. He sells lemonade every Saturday. He keeps a record of how many cups he sells and how much money he makes.

One day, he thought, “I want to know my total money for the whole month without adding each day manually.” So he used a calculation to add all his daily sales.

Then he thought, “What if I raise my price by 50 naira? How much more money will I make?” He used a parameter to change the price and see the result instantly.

Finally, he wondered, “How many cups will I sell next Saturday?” He used forecasting to guess based on past data.

Chidi became the lemonade king of his street!

📚 Main Lessons

Lesson 1: What is a Calculation?

Definition: A calculation is a math operation you do on your data, like addition, subtraction, multiplication, or division.

Why important: Calculations help you get new numbers from existing data.

Simple explanation: If you have “number of apples” and “price per apple”, you can multiply to get “total cost”.

Real-life example: A shopkeeper calculates total sales by adding all items sold.

School example: Your teacher calculates your total score by adding marks from all subjects.

Home example: You calculate your pocket money by adding what you get each week.

Nigerian example: A farmer calculates total harvest by adding yams from each field.

  CALCULATION EXAMPLE
  Sales (cups) × Price (naira) = Total Money
  20 cups × 100 naira = 2000 naira

Mini summary: Calculations turn raw numbers into useful information.

Lesson 2: Creating a Calculation in Tableau

Definition: In Tableau, you write a formula using fields and math symbols (+, -, *, /).

Why important: You can create new fields that don't exist in your original data.

Simple explanation: Like making a new recipe by mixing ingredients.

Real-life example: A store creates a “profit” field by subtracting cost from sales.

School example: Create a “total marks” field by adding all subject marks.

Home example: Create a “total chores” field by adding chores done each day.

Nigerian example: Create a “total rainfall” field by adding daily rainfall amounts.

  STEPS TO CREATE CALCULATION
  1. Right-click in the Data pane.
  2. Choose “Create Calculated Field”.
  3. Give it a name (e.g., “Total Profit”).
  4. Write the formula: [Sales] - [Cost].
  5. Click OK.

Mini summary: You can create new data fields by writing formulas in Tableau.

Lesson 3: Types of Calculations – Row-level vs Aggregate

Definition: Row-level calculations work on each row of data. Aggregate calculations work on groups of rows (like sum or average).

Why important: Different situations need different types.

Simple explanation: Row-level is like counting each apple separately. Aggregate is like counting all apples in a basket.

Real-life example: Row-level: price of each item. Aggregate: total price of all items.

School example: Row-level: score for each test. Aggregate: average score.

Home example: Row-level: temperature each hour. Aggregate: average temperature for the day.

Nigerian example: Row-level: rainfall each day. Aggregate: total rainfall for the month.

  ROW-LEVEL vs AGGREGATE
  +----------------------+------------------------+
  | Row-level (each row) | Aggregate (group)      |
  | Price per item       | Sum of all prices      |
  | Score per student    | Average score          |
  +----------------------+------------------------+

Mini summary: Row-level works on single rows, aggregate works on groups.

Lesson 4: Using SUM, AVG, MIN, MAX

Definition: SUM adds numbers, AVG finds the average, MIN finds the smallest, MAX finds the largest.

Why important: These are the most common calculations.

Simple explanation: SUM = total, AVG = middle, MIN = smallest, MAX = largest.

Real-life example: SUM of all sales, AVG of customer ratings.

School example: SUM of marks, AVG score, MIN score, MAX score.

Home example: SUM of expenses, AVG daily temperature.

Nigerian example: SUM of harvest from all farms.

  EXAMPLES
  SUM([Sales]) = total sales
  AVG([Sales]) = average sale
  MIN([Sales]) = smallest sale
  MAX([Sales]) = largest sale

Mini summary: SUM, AVG, MIN, MAX help you summarise data.

Lesson 5: What is a Parameter?

Definition: A parameter is a variable that the user can change, like a slider or a dropdown.

Why important: Parameters let users explore “what if” scenarios.

Simple explanation: Like a volume knob – you turn it and the sound changes.

Real-life example: A price slider on a shopping website.

School example: A parameter to change the passing mark.

Home example: A parameter to change the dinner time.

Nigerian example: A parameter to change the exchange rate for dollars to naira.

  PARAMETER EXAMPLE
  [Price Increase] = 10%  (user can change)
  New Price = Old Price * (1 + [Price Increase])

Mini summary: Parameters let users change values and see results instantly.

Lesson 6: Creating a Parameter in Tableau

Definition: In Tableau, you create a parameter by right-clicking in the Data pane and choosing “Create Parameter”.

Why important: You can use parameters in calculations, filters, and dashboards.

Simple explanation: Like setting up a dial that users can turn.

Real-life example: A restaurant creates a parameter for tip percentage.

School example: A parameter for the number of weeks in a term.

Home example: A parameter for the number of family members.

Nigerian example: A parameter for the price of a bag of rice.

  STEPS TO CREATE PARAMETER
  1. Right-click in Data pane → Create Parameter.
  2. Name it (e.g., “Discount”).
  3. Choose data type (e.g., Float, Integer).
  4. Set value range (e.g., 0 to 100).
  5. Click OK.

Mini summary: Creating a parameter is easy and makes your dashboard interactive.

Lesson 7: Using a Parameter in a Calculation

Definition: You can use a parameter inside a calculation to create dynamic values.

Why important: It makes your analysis flexible.

Simple explanation: You write a formula that includes the parameter, and when the user changes the parameter, the result changes.

Real-life example: Sales * (1 + [Commission Rate]).

School example: Score * [Weighting Factor].

Home example: Budget * [Emergency Factor].

Nigerian example: Harvest * [Storage Loss Percentage].

  CALCULATION WITH PARAMETER
  [Sales] * [Discount]  (Discount is a parameter)
  If Discount = 0.1, result = Sales * 0.9 (10% off)
  If Discount = 0.2, result = Sales * 0.8 (20% off)

Mini summary: Parameters in calculations let you test different scenarios.

Lesson 8: What is Forecasting?

Definition: Forecasting is predicting future values based on past data.

Why important: It helps us plan for the future.

Simple explanation: Like guessing the weather tomorrow based on past weather.

Real-life example: A shop predicts next month's sales to order stock.

School example: Predicting next year's student population.

Home example: Predicting next month's electricity bill.

Nigerian example: Predicting next season's crop yield.

  FORECAST EXAMPLE
  Past Sales: 100, 120, 140, 160
  Forecast for next month: 180 (if trend continues)

Mini summary: Forecasting uses past data to guess the future.

Lesson 9: Adding a Forecast in Tableau

Definition: In Tableau, you can add a forecast by right-clicking on a chart and choosing “Forecast”.

Why important: It's easy and gives you a visual prediction.

Simple explanation: You click a button, and Tableau draws a future line.

Real-life example: Forecasting sales for the next quarter.

School example: Forecasting how many students will pass next year.

Home example: Forecasting when you will finish your savings.

Nigerian example: Forecasting rainfall for the next planting season.

  STEPS TO ADD FORECAST
  1. Create a line chart with time on the x-axis.
  2. Right-click on the chart.
  3. Choose “Forecast”.
  4. Tableau will add a forecast line (often dashed).

Mini summary: Tableau can add a forecast to your chart with a few clicks.

Lesson 10: Understanding Forecast Models

Definition: Tableau uses models like Exponential Smoothing to make forecasts.

Why important: The model affects how accurate the forecast is.

Simple explanation: Think of it like choosing a recipe – different recipes give different cakes.

Real-life example: A store uses a model that gives more weight to recent sales.

School example: A model that predicts attendance based on last 5 years.

Home example: A model that predicts grocery spending based on last 3 months.

Nigerian example: A model that predicts harvest based on the last 5 seasons.

  FORECAST MODEL TYPES
  +------------------------+---------------------------+
  | Simple Exponential     | Smoothing (no trend)      |
  | Double Exponential     | Smoothing with trend      |
  | Triple Exponential     | Smoothing with trend & season |
  +------------------------+---------------------------+

Mini summary: Tableau has different forecast models for different data patterns.

Lesson 11: Forecast Accuracy – How Good is the Guess?

Definition: Accuracy tells us how close the forecast is to the real values.

Why important: We need to know if we can trust the forecast.

Simple explanation: If you guess the weather and it rains when you said sunny, your guess was not accurate.

Real-life example: A store checks if their sales forecast was close to actual sales.

School example: Check if the predicted number of students matches actual enrolment.

Home example: Check if predicted electricity bill matches actual bill.

Nigerian example: Check if predicted harvest matches actual harvest.

  ACCURACY MEASURES
  - MAPE: Mean Absolute Percentage Error (lower is better)
  - RMSE: Root Mean Square Error (lower is better)

Mini summary: We check forecast accuracy to see if we can believe the prediction.

Lesson 12: Combining Calculations, Parameters, and Forecasting

Definition: You can use all three together in one dashboard for powerful analysis.

Why important: This gives you a complete tool for exploring data.

Simple explanation: Like having a Swiss Army knife – many tools in one.

Real-life example: A dashboard shows sales, allows changing discount (parameter), and forecasts future sales.

School example: A dashboard shows scores, allows changing passing mark (parameter), and predicts next year's scores.

Home example: A dashboard shows expenses, allows changing budget (parameter), and forecasts future expenses.

Nigerian example: A dashboard shows farm data, allows changing price (parameter), and forecasts next harvest.

  COMBINED DASHBOARD
  +--------------------------------------+
  | Sales Data                           |
  | +--------+ +--------+ +------------+ |
  | | Chart  | | Filter | | Parameter  | |
  | +--------+ +--------+ +------------+ |
  | Forecast: future sales               |
  +--------------------------------------+

Mini summary: Combining calculations, parameters, and forecasting makes a super dashboard.

Lesson 13: Practical Uses of Forecasting in Nigeria

Definition: Forecasting helps in agriculture, business, and government.

Why important: It helps people make better decisions.

Simple explanation: Like looking at a map before a journey.

Real-life example: A farmer forecasts rainfall to decide when to plant.

School example: A school forecasts enrolment to plan for new teachers.

Home example: A family forecasts expenses to save money.

Nigerian example: The government forecasts tax revenue to plan the budget.

  NIGERIAN FORECAST USES
  - Farming: predict harvest
  - Business: predict sales
  - Transport: predict passenger numbers
  - Health: predict patient numbers

Mini summary: Forecasting is used everywhere in Nigeria to plan ahead.

Lesson 14: Sharing Your Smart Dashboard

Definition: You can share your dashboard with calculations, parameters, and forecasts.

Why important: Others can benefit from your smart analysis.

Simple explanation: Like sharing your secret recipe with friends.

Real-life example: A business shares its sales dashboard with managers.

School example: A teacher shares a dashboard with students.

Home example: Share your family budget dashboard with parents.

Nigerian example: A farmer shares a dashboard with other farmers.

  SHARING OPTIONS
  - Tableau Public
  - Email
  - PDF
  - Embedded in a website

Mini summary: Share your smart dashboards to help others make decisions.

📖 Key Vocabulary

• Calculation: A math operation (add, subtract, etc.).
• Parameter: A value the user can change.
• Forecast: A prediction of future values.
• Aggregate: A summary of many rows (like sum or average).
• Row-level: Works on each row individually.
• Exponential Smoothing: A way to forecast by giving more weight to recent data.
• Accuracy: How close the forecast is to reality.

🧠 Important Concepts

• Calculations turn raw data into meaningful numbers.
• Parameters let users explore different scenarios.
• Forecasting helps predict the future.
• Combining these tools creates powerful dashboards.
• Sharing dashboards helps others learn and decide.

🔢 Step-by-Step Explanations

How to Create a Calculated Field

1. In Tableau, go to the Data pane.
2. Right-click and choose “Create Calculated Field”.
3. Name it (e.g., “Total Sales”).
4. Type the formula: [Sales] * [Quantity].
5. Click OK.

How to Create a Parameter

1. Right-click in the Data pane → Create Parameter.
2. Name it (e.g., “Discount Rate”).
3. Choose data type (Float).
4. Set values (e.g., 0 to 1, step 0.05).
5. Click OK.

How to Add a Forecast

1. Create a line chart with a date field.
2. Right-click on the chart.
3. Choose “Forecast”.
4. Adjust options if needed.

🌍 Real-life Examples

• Retail: A store calculates total sales, uses a parameter for discount, and forecasts next month's sales.
• Healthcare: A hospital calculates average patient wait time, uses a parameter for bed capacity, and forecasts patient admissions.
• Sports: A team calculates average player scores, uses a parameter for training hours, and forecasts win percentage.

🇳🇬 Nigerian Examples

• Agriculture: A farmer calculates total harvest, uses a parameter for price, and forecasts next season's yield.
• Transport: A bus company calculates total passengers, uses a parameter for fuel price, and forecasts passenger numbers.
• Education: A school calculates average scores, uses a parameter for passing mark, and forecasts student performance.

🧸 Fun Examples Children Relate To

• Video Games: Calculate your total score, use a parameter for difficulty level, and forecast your next high score.
• Chores: Calculate total chores done, use a parameter for allowance, and forecast how much you will earn by month end.
• Candy: Calculate total candies, use a parameter for sharing percentage, and forecast how many you will have left.

🏠 Everyday Examples

• Budget: Calculate total expenses, use a parameter for savings goal, and forecast when you will reach it.
• Weather: Calculate average temperature, use a parameter for humidity, and forecast next week's weather.
• Health: Calculate steps walked, use a parameter for goal, and forecast when you will reach your goal.

🧑‍🏫 Teacher Notes

• Use simple examples (like lemonade sales) to introduce calculations.
• Show how parameters are like “what if” tools.
• Encourage students to think of scenarios where forecasting is useful.
• Use group work to build a dashboard combining all three concepts.

👪 Parent Tips

• Help your child collect data (e.g., daily temperature) and create a forecast.
• Discuss how forecasting is used in your family (e.g., budgeting).
• Encourage them to change parameters and see what happens.

✨ Interesting Facts

• Forecasting is used by weather experts, economists, and even sports analysts.
• Tableau's forecasting uses advanced math that happens in the background.
• Parameters were introduced in Tableau to make analysis more interactive.

💡 Did You Know?

• You can use parameters to switch between different charts!
• Forecasting in Tableau can handle seasonal data like holiday sales.
• You can create a parameter that changes the colour of your chart.

🔔 Remember This

• Calculations help you create new data.
• Parameters let you explore different scenarios.
• Forecasting predicts the future.
• Combining them makes your dashboard powerful.

⚠️ Common Mistakes

• Forgetting to use the correct field names in calculations.
• Using a parameter without applying it in a calculation.
• Adding a forecast to data that doesn't have a date.
• Not checking forecast accuracy.
• Overcomplicating calculations – keep them simple.

✅ Best Practices

• Name your calculations and parameters clearly (e.g., “Total Sales” not “Calc1”).
• Use parameters to allow user input.
• Add a forecast only when you have enough data (at least 2 years).
• Test your dashboard with different parameter values.

🎨 ASCII Illustrations

Calculation Flow

  Data (Sales, Cost)
       |
       V
  Calculation: Sales - Cost
       |
       V
  New Field: Profit

Parameter Usage

  Parameter: Discount (0 to 1)
       |
       V
  Calculation: Sales * (1 - Discount)
       |
       V
  Result: Discounted Sales

Forecast Flow

  Past Data (2019-2024)
       |
       V
  Forecast Model (Exponential Smoothing)
       |
       V
  Future Prediction (2025-2026)

📊 Comparison Table: Calculation vs Parameter vs Forecast

📊 Comparison Table: Row-level vs Aggregate

📌 End-of-Module Summary

Excellent work! You have learned three powerful tools: calculations, parameters, and forecasting. Calculations help you create new numbers from your data. Parameters let you and others change values to see different results. Forecasting helps you predict the future based on past data. By combining these tools, you can build interactive and smart dashboards that help people make better decisions. Now you are ready to use these skills in your projects and even in real life!

❓ Frequently Asked Questions

1. Can I use a parameter in a filter? Yes, you can use parameters in filters.
2. What kind of data do I need for forecasting? You need data with a date or time field.
3. Can I create a calculation with text? Yes, you can use string calculations (e.g., combining names).
4. How many parameters can I have? As many as you need.
5. Is forecasting always accurate? No, it's a guess, so check accuracy.
6. Can I save my parameter values? Yes, in the workbook.
7. What is the difference between a parameter and a filter? A filter limits data, a parameter changes a value.
8. Can I use a calculation in a forecast? Yes, you can forecast a calculated field.
9. How do I show a parameter on a dashboard? Drag it to the dashboard as a control (slider or dropdown).
10. Can I share a dashboard with parameters? Yes, others can use the parameters too.

📝 Review Questions

1. What is a calculation?
2. Name two types of calculations.
3. What is a parameter?
4. How do you create a parameter in Tableau?
5. What is forecasting?
6. How do you add a forecast in Tableau?
7. What does SUM do?
8. What does AVG do?
9. Why are parameters useful?
10. Can you use a parameter in a calculation?
11. What is forecast accuracy?
12. Name one Nigerian example of forecasting.
13. What is the difference between row-level and aggregate calculations?
14. How do you share a dashboard with calculations?
15. What should you check after creating a forecast?

✏️ Fill-in-the-Blank Exercises

1. A _________ is a math operation on data. (calculation)
2. A _________ is a value the user can change. (parameter)
3. _________ predicts future values. (forecast)
4. SUM, AVG, MIN, MAX are _________ calculations. (aggregate)
5. _________ Smoothing is a forecast model. (Exponential)

✅ True or False

1. You can only use numbers in calculations. (False, you can use text too)
2. Parameters are fixed and cannot be changed. (False)
3. Forecasting always gives perfect predictions. (False)
4. You can create a parameter from the Data pane. (True)
5. SUM adds all numbers in a group. (True)

🔘 Multiple Choice Questions

1. What does a calculation do?
   A) Creates new data B) Deletes data C) Sorts data D) Filters data
   Answer: A
2. Which is an aggregate function?
   A) SUM B) Parameter C) Forecast D) Row-level
   Answer: A
3. What is a parameter?
   A) A fixed number B) A user-changeable value C) A chart type D) A filter
   Answer: B
4. How do you add a forecast?
   A) Drag and drop B) Right-click chart → Forecast C) Create parameter D) Write a formula
   Answer: B
5. Which is NOT a forecast model?
   A) Exponential Smoothing B) Linear Regression C) ARIMA D) Pie Chart
   Answer: D
6. What does AVG do?
   A) Adds numbers B) Finds average C) Finds smallest D) Finds largest
   Answer: B
7. Why use a parameter?
   A) To make a chart colourful B) To allow “what if” analysis C) To delete data D) To sort data
   Answer: B
8. Which is a Nigerian example of forecasting?
   A) Predicting snowfall B) Predicting yam harvest C) Predicting sunset D) Predicting ocean tides
   Answer: B
9. What is row-level calculation?
   A) Works on each row B) Works on all rows C) Works on groups D) Works on dates
   Answer: A
10. Can you share a dashboard with parameters?
    A) Yes B) No C) Only with password D) Only in Nigeria
    Answer: A
11. What is forecast accuracy?
    A) How colourful the chart is B) How close the forecast is to reality C) How many rows D) The title
    Answer: B
12. How do you create a calculated field?
    A) Drag a field B) Right-click → Create Calculated Field C) Add a filter D) Change chart type
    Answer: B
13. What is the MIN function?
    A) Finds maximum B) Finds minimum C) Finds average D) Finds sum
    Answer: B
14. Can you use a parameter in a calculation?
    A) Yes B) No C) Only in filters D) Only in titles
    Answer: A
15. What should you do before forecasting?
    A) Delete all data B) Ensure you have enough data C) Change colours D) Add a title
    Answer: B

🔗 Matching Exercises

Match the term with its description.

Answers: 1-B, 2-C, 3-A, 4-D

📝 Short Answer Questions

1. Explain why calculations are important in data analysis.
2. Describe how a parameter can help a business owner.
3. What steps do you take to create a forecast in Tableau?

🎭 Scenario-based Exercises

Scenario: You are a data analyst for a supermarket. The manager wants to see monthly sales, allow a discount (parameter), and predict next month's sales.

1. What calculation would you create?
2. What parameter would you add?
3. How would you add a forecast?

👥 Group Activity

In groups of 4, collect data on daily temperatures for the last 2 weeks. Use Tableau to calculate the average temperature, add a parameter to increase or decrease the temperature by 2 degrees, and forecast the temperature for the next week. Present your findings.

🧑 Individual Activity

Create a dashboard using your own data (e.g., your weekly study hours). Include a calculation (total hours), a parameter (goal hours), and a forecast for next week's study hours.

💬 Classroom Discussion Questions

1. How can forecasting help Nigerian farmers?
2. Why is it important to check forecast accuracy?
3. How would you use a parameter in your daily life?

🛠️ Mini Project

Project: Create a dashboard that shows monthly sales of a small shop. Include a calculation for profit, a parameter for discount, and a forecast for the next 3 months. Present your dashboard to the class.

💻 Practical Assignment

Using Tableau Public, create a dashboard with the following:

• A line chart of sales over time.
• A calculation showing total sales.
• A parameter for a discount percentage.
• A forecast for the next 6 months.

Publish and share the link.

🏆 Challenge Exercise

Create a story with 3 pages: Page 1 shows sales data, Page 2 shows calculations and parameters, Page 3 shows the forecast. Add a caption to each page explaining what you see. Share the story link.

🔑 Quiz Answers

(Answers provided within the multiple choice and matching sections above.)

🎯 Key Takeaways

• Calculations create new data from existing data.
• Parameters let users change values and explore scenarios.
• Forecasting uses past data to predict the future.
• Combining these tools makes dashboards powerful and interactive.
• Always check forecast accuracy and keep your dashboard simple.

🔜 Preparation for Module 7

In the next module, we will explore advanced visualisations like heat maps, tree maps, and box plots. We will also learn how to combine multiple data sources. Make sure you are comfortable with calculations, parameters, and forecasting because we will use them in more advanced ways. Get ready to create stunning visual stories!

End of Module 6 · Keep making data smarter!

📊 Module 7 · Certified Tableau for Data Analysis Expert

Module Title: Fancy Charts – Heat Maps, Tree Maps, Box Plots & Combined Data

Welcome, data artist! In this module, we will learn how to create fancy charts that make our data look like a beautiful painting. We will use heat maps (like a temperature map), tree maps (like a family tree), and box plots (like a box that shows data spread).

We will also learn how to combine data from different sources, like mixing two colours to make a new one. By the end, you will be able to create amazing and colourful charts that everyone will love to see!

🎯 Learning Objectives

By the end of this module, you will be able to:

• Create a heat map to show patterns.
• Build a tree map to show parts of a whole.
• Make a box plot to show data distribution.
• Combine data from two or more sources.
• Choose the right chart for your data.

🌟 Warm-up Story: Ada's Art Gallery

Ada loves art. She has a gallery with many paintings. She wants to show which colours are most popular in her gallery.

She used a heat map to show where the most colourful paintings are. She used a tree map to show how many paintings are in each colour category (red, blue, green). And she used a box plot to show the range of prices for each colour.

She also combined data from her sales records and her visitor records to see which colours sell best.

Ada's gallery became the most popular in Lagos because she could show her art data in such a beautiful way!

📚 Main Lessons

Lesson 1: What is a Heat Map?

Definition: A heat map uses colours to show values. Darker colours mean higher values, lighter colours mean lower values.

Why important: It helps you see patterns and hot spots quickly.

Simple explanation: Like a weather map where red means hot and blue means cold.

Real-life example: A map showing where most car accidents happen (red for high, green for low).

School example: A heat map showing which subjects students find hardest (red = difficult, green = easy).

Home example: A heat map of room temperatures (red = hot rooms, blue = cold rooms).

Nigerian example: A heat map of rainfall in different states (dark blue = heavy rain, light blue = little rain).

  HEAT MAP EXAMPLE
  +----+----+----+----+
  | 10 | 20 | 30 | 40 |  (numbers)
  +----+----+----+----+
  | 🟥 | 🟧 | 🟨 | 🟩 |  (colours)
  +----+----+----+----+
  Red = highest, Green = lowest

Mini summary: Heat maps use colours to show values – darker = more, lighter = less.

Lesson 2: Creating a Heat Map in Tableau

Definition: In Tableau, you create a heat map by putting a field on Colour and another on Rows or Columns.

Why important: It's easy and shows patterns instantly.

Simple explanation: Like colouring a grid by number – high numbers get dark colours.

Real-life example: A store creates a heat map of sales by day and hour.

School example: A heat map of test scores by subject and student.

Home example: A heat map of chores done by family member and day.

Nigerian example: A heat map of harvest by region and crop.

  STEPS TO CREATE HEAT MAP
  1. Drag a dimension to Columns (e.g., Region).
  2. Drag another dimension to Rows (e.g., Product).
  3. Drag a measure to Colour (e.g., Sales).
  4. Choose a colour palette.

Mini summary: Heat maps are easy to create in Tableau and show data patterns.

Lesson 3: What is a Tree Map?

Definition: A tree map shows data as rectangles. Bigger rectangles mean bigger values.

Why important: It shows parts of a whole at a glance.

Simple explanation: Like a pizza cut into slices, but the slices are rectangles.

Real-life example: A tree map of a company's sales by product – the biggest rectangle is the top-selling product.

School example: A tree map of marks by subject – the biggest rectangle is the subject with the highest total marks.

Home example: A tree map of expenses – rent is the biggest rectangle.

Nigerian example: A tree map of crops by farm – maize takes the biggest rectangle.

  TREE MAP EXAMPLE
  +------------------+---------+
  |                   |         |
  |    MAIZE          |  RICE   |
  |   (biggest)       |         |
  +------------------+----+----+
  |   CASSAVA         |YAM|    |
  |                   |   |    |
  +-------------------+---+----+

Mini summary: Tree maps use rectangles to show values – bigger = more.

Lesson 4: Creating a Tree Map in Tableau

Definition: In Tableau, you create a tree map by selecting the Tree Map chart type.

Why important: It's a great way to show proportions.

Simple explanation: You choose the tree map icon, and Tableau does the rest.

Real-life example: A tree map of market share by brand.

School example: A tree map of library book categories.

Home example: A tree map of food items in your fridge.

Nigerian example: A tree map of jobs by sector (farming, trading, etc.).

  STEPS TO CREATE TREE MAP
  1. Choose a dimension (e.g., Category).
  2. Choose a measure (e.g., Sales).
  3. Click on the Tree Map chart type.
  4. Drag a dimension to Colour if you want more detail.

Mini summary: Tree maps show parts of a whole with rectangles.

Lesson 5: What is a Box Plot?

Definition: A box plot shows the spread of data. It shows the minimum, maximum, median, and quartiles.

Why important: It shows how data is distributed – are most values close or spread out?

Simple explanation: Like a box with a line in the middle. The box shows the middle 50% of data, and the whiskers show the rest.

Real-life example: A box plot of students' exam scores – shows the range and average.

School example: A box plot of heights in a class.

Home example: A box plot of daily temperatures for a month.

Nigerian example: A box plot of salaries in different professions.

  BOX PLOT EXAMPLE
  +----+----+----+----+----+
  |    |    |    |    |    |
  |    |    |    |    |    |
  |    |    |    |    |    |
  |    |    |    |    |    |
  +----+----+----+----+----+
  Min   Q1   Med   Q3   Max
  (Q1 = 25th percentile, Q3 = 75th percentile)

Mini summary: Box plots show the spread and middle of data.

Lesson 6: Creating a Box Plot in Tableau

Definition: In Tableau, you create a box plot by using the “Box Plot” chart type.

Why important: It's the best way to see outliers and distribution.

Simple explanation: You select the box plot icon, and Tableau draws the box and whiskers.

Real-life example: A box plot of customer ages in different regions.

School example: A box plot of test scores by grade.

Home example: A box plot of weekly allowance.

Nigerian example: A box plot of temperatures in different cities.

  STEPS TO CREATE BOX PLOT
  1. Drag a measure to Rows (e.g., Sales).
  2. Drag a dimension to Columns (e.g., Region).
  3. Change the chart type to “Box Plot”.
  4. Optionally, add more dimensions to Colour.

Mini summary: Box plots are easy to create and show data distribution.

Lesson 7: Understanding Quartiles and Outliers

Definition: Quartiles divide data into four equal parts. Outliers are values that are far from the rest.

Why important: They help us understand the spread and find unusual data.

Simple explanation: Quartiles are like cutting a cake into four equal pieces. Outliers are like a very big or very small piece.

Real-life example: A box plot of house prices – outliers are very expensive or very cheap houses.

School example: A box plot of test scores – outliers are very high or very low scores.

Home example: A box plot of daily steps – outliers are days you walked very little or very much.

Nigerian example: A box plot of business profits – outliers are businesses that made very high or very low profit.

  QUARTILES
  +----+----+----+----+
  | Q1 | Q2 | Q3 | Q4 |  (each 25%)
  +----+----+----+----+
  Outliers are far from Q1 or Q3.

Mini summary: Quartiles split data into four parts; outliers are far from the middle.

Lesson 8: Choosing the Right Chart

Definition: Different charts are good for different types of data.

Why important: Choosing the right chart makes your data easy to understand.

Simple explanation: Like choosing the right tool for a job – you wouldn't use a hammer to paint a picture.

Real-life example: Use a bar chart for comparing categories, a line chart for trends, a heat map for patterns.

School example: Use a bar chart for comparing marks in subjects.

Home example: Use a pie chart for showing expenses by category.

Nigerian example: Use a tree map for showing crops by farm.

  CHART SELECTION GUIDE
  +----------------+-------------------+
  | Data type      | Best chart        |
  +----------------+-------------------+
  | Comparison     | Bar chart         |
  | Trend          | Line chart        |
  | Proportion     | Pie / Tree map    |
  | Pattern        | Heat map          |
  | Distribution   | Box plot          |
  +----------------+-------------------+

Mini summary: Pick the chart that best shows your data story.

Lesson 9: Combining Data Sources – What and Why

Definition: Combining data means bringing together data from different files or databases.

Why important: It gives you a fuller picture.

Simple explanation: Like mixing ingredients to make a cake – each ingredient alone is good, but together they are better.

Real-life example: A store combines sales data and customer feedback data.

School example: A school combines student grades and attendance data.

Home example: A family combines income and expense data.

Nigerian example: A farm combines weather data and harvest data.

  COMBINING DATA
  Data Source 1 (Sales)  +  Data Source 2 (Customer Info)  =  Full Picture

Mini summary: Combining data gives you more insights.

Lesson 10: Types of Joins in Tableau

Definition: A join is how you combine two tables of data. Types: Inner, Left, Right, and Full Outer.

Why important: Different joins show different parts of the data.

Simple explanation: Like holding two puzzle pieces together – you can hold them in different ways.

Real-life example: Inner join shows only rows that match in both tables.

School example: Left join shows all students and their grades if they have any.

Home example: Right join shows all expenses and the person who paid for them.

Nigerian example: Full outer join shows all farmers and all crops, even if no relation.

  JOIN TYPES
  +------------------+----------------------+
  | Join Type        | What it shows        |
  +------------------+----------------------+
  | Inner            | Only matching rows   |
  | Left             | All left + matching  |
  | Right            | All right + matching |
  | Full Outer       | All rows from both   |
  +------------------+----------------------+

Mini summary: Joins combine data in different ways.

Lesson 11: How to Combine Data in Tableau

Definition: In Tableau, you combine data by dragging tables to the canvas and choosing a join type.

Why important: It's easy and visual.

Simple explanation: You drag and drop tables like building blocks.

Real-life example: A store combines orders and customers by Customer ID.

School example: A school combines students and classes by Class ID.

Home example: A family combines expenses and categories by Category ID.

Nigerian example: A farm combines fields and crops by Field ID.

  STEPS TO COMBINE DATA
  1. Connect to your first data source.
  2. Drag the second data source to the canvas.
  3. Choose a join type (e.g., Inner).
  4. Select the fields to join on (e.g., ID).

Mini summary: Combining data in Tableau is a visual drag-and-drop process.

Lesson 12: Data Blending – Another Way to Combine

Definition: Data blending is like a join, but it works on aggregated data from different sources.

Why important: It's useful when you can't do a direct join.

Simple explanation: Like mixing two different paints to get a new colour.

Real-life example: A store blends sales data from a database with exchange rates from a website.

School example: A school blends student data from a spreadsheet with library data from another system.

Home example: A family blends bank account data with expense tracker data.

Nigerian example: A farm blends weather data from a website with harvest data from a spreadsheet.

  DATA BLENDING
  Primary Data Source  +  Secondary Data Source  =  Blended Data
  (Aggregated)         (Aggregated)

Mini summary: Data blending combines data from different sources at an aggregated level.

Lesson 13: Best Practices for Combining Data

Definition: Best practices are rules to follow when combining data.

Why important: They ensure your analysis is correct.

Simple explanation: Like following a recipe to make sure the cake tastes good.

Real-life example: Always check that the fields you join on are the same type (e.g., both are numbers).

School example: Make sure student IDs are the same format in both tables.

Home example: Make sure dates are in the same format.

Nigerian example: Make sure state names are spelled the same way.

  BEST PRACTICES
  - Use consistent field names.
  - Use the same data types.
  - Test your joins with small data first.
  - Understand the meaning of each join type.

Mini summary: Follow best practices to combine data correctly.

📖 Key Vocabulary

• Heat Map: A chart that uses colours to show values.
• Tree Map: A chart that uses rectangles to show proportions.
• Box Plot: A chart that shows data spread.
• Quartile: One of four equal parts of data.
• Outlier: A value far from the rest.
• Join: A way to combine tables.
• Data Blending: Combining data from different sources.

🧠 Important Concepts

• Heat maps show patterns with colours.
• Tree maps show parts of a whole.
• Box plots show data distribution.
• Joins combine tables at row level.
• Data blending combines at aggregate level.

🔢 Step-by-Step Explanations

How to Create a Heat Map

1. Open Tableau and connect to your data.
2. Drag a dimension to Columns (e.g., Region).
3. Drag another dimension to Rows (e.g., Product).
4. Drag a measure to Colour (e.g., Sales).
5. Choose a colour palette.

How to Create a Tree Map

1. Select the Tree Map chart type from Show Me.
2. Drag a dimension to Colour (e.g., Category).
3. Drag a measure to Size (e.g., Sales).

How to Create a Box Plot

1. Drag a measure to Rows (e.g., Sales).
2. Drag a dimension to Columns (e.g., Region).
3. Change the chart type to Box Plot.

How to Combine Data with a Join

1. Connect to your first table.
2. Drag the second table to the canvas.
3. Choose a join type (Inner, Left, etc.).
4. Select the fields to join on (e.g., ID).

🌍 Real-life Examples

• Retail: Heat map of sales by store and day of week.
• Healthcare: Box plot of patient wait times by hospital.
• Education: Tree map of student enrolment by subject.

🇳🇬 Nigerian Examples

• Agriculture: Heat map of crop yield by state and season.
• Transport: Box plot of bus delays by route.
• Market: Tree map of market sales by product category.

🧸 Fun Examples Children Relate To

• Toys: Heat map of toy popularity by age group.
• Games: Box plot of game scores by player level.
• Snacks: Tree map of snack consumption by type.

🏠 Everyday Examples

• Budget: Tree map of monthly expenses.
• Weather: Heat map of daily temperatures.
• Health: Box plot of steps per day.

🧑‍🏫 Teacher Notes

• Show students how to access different chart types in Show Me.
• Use examples they can relate to (e.g., favourite snacks).
• Explain why we use different charts for different purposes.
• Encourage students to experiment with joins and blending.

👪 Parent Tips

• Help your child collect data from family activities (e.g., chores) and create a tree map.
• Discuss how different charts show different perspectives.
• Encourage them to combine data from different sources (e.g., school grades and study hours).

✨ Interesting Facts

• Heat maps were originally used in matrix algebra.
• Tree maps were invented by a professor at the University of Maryland.
• Box plots are also called “box-and-whisker plots”.

💡 Did You Know?

• You can create a heat map with any two dimensions and one measure.
• Tree maps can show hierarchical data (like a family tree).
• Box plots can show skewness (if data is uneven).

🔔 Remember This

• Heat maps = colours for values.
• Tree maps = rectangles for proportions.
• Box plots = boxes for distribution.
• Joins combine tables at row level.
• Blending combines at aggregate level.

⚠️ Common Mistakes

• Using a heat map when a bar chart would be better.
• Putting too many categories in a tree map – it becomes messy.
• Ignoring outliers in a box plot.
• Joining on the wrong fields.
• Forgetting that data blending uses aggregated data.

✅ Best Practices

• Choose the chart that best tells your story.
• Keep tree maps simple – use colour to help.
• Explain the quartiles in your box plot.
• Test your joins to ensure they work correctly.
• Use data blending when joins are not possible.

🎨 ASCII Illustrations

Heat Map Example

  +---------+----+----+----+----+
  | Product | Mon | Tue | Wed | Thu |
  +---------+----+----+----+----+
  | Apples  | 10 | 20 | 30 | 40 |  (values)
  | Oranges | 15 | 25 | 35 | 45 |
  +---------+----+----+----+----+
  Colour scale: 🟥 🟧 🟨 🟩

Tree Map Example

  +------------------+---------+
  |                   |         |
  |    MAIZE          |  RICE   |
  |   (biggest)       |         |
  +------------------+----+----+
  |   CASSAVA         |YAM|    |
  |                   |   |    |
  +-------------------+---+----+

Box Plot Example

  +----+----+----+----+----+
  |    |    |    |    |    |
  |    |    |    |    |    |
  |    |    |    |    |    |
  |    |    |    |    |    |
  +----+----+----+----+----+
  Min   Q1   Med   Q3   Max

Join Types

  INNER JOIN
  +--------+   +--------+
  | Table A |   | Table B |
  +--------+   +--------+
  | ID | A |   | ID | B |
  | 1  | X |   | 1  | Y |
  | 2  | Z |   | 3  | W |
  +--------+   +--------+
  Result: only ID 1 (matching)

📊 Comparison Table: Heat Map vs Tree Map vs Box Plot

📊 Comparison Table: Join vs Data Blending

📌 End-of-Module Summary

Wonderful job! You have learned how to create three fancy charts: heat maps, tree maps, and box plots. You also learned how to combine data using joins and data blending.

Heat maps help you see patterns with colours. Tree maps show parts of a whole with rectangles. Box plots show the spread of data.

Combining data gives you a fuller picture. Now you can choose the right chart for your data and combine data from different sources to tell a complete story.

You are becoming a true data expert!

❓ Frequently Asked Questions

1. Can I use a heat map for text data? No, heat maps need numeric values.
2. What is the difference between a tree map and a pie chart? Tree maps use rectangles, pie charts use slices.
3. What do the lines (whiskers) in a box plot mean? They show the range of the data (min and max).
4. Can I join more than two tables? Yes, you can join multiple tables.
5. What is data blending used for? To combine data from different sources that don't have a direct match.
6. How do I choose the right chart? Think about what you want to show – comparison, trend, proportion, pattern, or distribution.
7. Can I add colours to a tree map? Yes, by dragging a dimension to Colour.
8. What is an outlier? A value that is very different from the rest.
9. Can I combine data from Excel and a database? Yes, Tableau can connect to many data sources.
10. Do I need to clean data before joining? Yes, make sure fields match.

📝 Review Questions

1. What is a heat map?
2. What does a tree map show?
3. What is a box plot?
4. What are quartiles?
5. What is an outlier?
6. Name two chart types used for proportions.
7. What is a join?
8. What is data blending?
9. How do you create a heat map in Tableau?
10. What is the difference between a join and data blending?
11. When would you use a box plot?
12. What does a tree map use to show values?
13. Can you combine data from two different Excel files?
14. What is the median in a box plot?
15. Why is it important to choose the right chart?

✏️ Fill-in-the-Blank Exercises

1. A _________ map uses colours to show values. (heat)
2. A _________ map uses rectangles to show proportions. (tree)
3. A _________ plot shows data distribution. (box)
4. _________ divide data into four equal parts. (Quartiles)
5. A _________ combines data from different tables. (join)

✅ True or False

1. A heat map is best for showing distribution. (False)
2. A tree map shows parts of a whole. (True)
3. Box plots show the median. (True)
4. Data blending works at the row level. (False)
5. You can join more than two tables in Tableau. (True)

🔘 Multiple Choice Questions

1. Which chart uses colours to show values?
   A) Tree map B) Heat map C) Box plot D) Bar chart
   Answer: B
2. Which chart uses rectangles?
   A) Heat map B) Tree map C) Box plot D) Line chart
   Answer: B
3. What does a box plot show?
   A) Proportion B) Distribution C) Pattern D) Trend
   Answer: B
4. What is a quartile?
   A) A type of chart B) 25% of data C) An outlier D) A join
   Answer: B
5. What is an outlier?
   A) A value far from others B) A normal value C) A median D) A quartile
   Answer: A
6. Which join shows only matching rows?
   A) Left B) Right C) Inner D) Full Outer
   Answer: C
7. What is data blending?
   A) Combining tables at row level B) Combining at aggregate level C) A chart type D) A filter
   Answer: B
8. Which chart is best for proportions?
   A) Heat map B) Tree map C) Box plot D) Line chart
   Answer: B
9. What does the median show in a box plot?
   A) The average B) The middle value C) The minimum D) The maximum
   Answer: B
10. Can you combine data from Excel and a text file?
    A) Yes B) No C) Only with a join D) Only with blending
    Answer: A
11. Which is NOT a chart type?
    A) Heat map B) Tree map C) Box plot D) Join
    Answer: D
12. What does a heat map show best?
    A) Patterns B) Proportions C) Distribution D) Trends
    Answer: A
13. What is the purpose of a tree map?
    A) Show spread B) Show parts C) Show patterns D) Show trends
    Answer: B
14. Which join shows all rows from the left table?
    A) Inner B) Left C) Right D) Full Outer
    Answer: B
15. Why use data blending?
    A) To combine data from different sources B) To create charts C) To filter data D) To sort data
    Answer: A

🔗 Matching Exercises

Match the chart with its description.

Answers: 1-C, 2-A, 3-B

📝 Short Answer Questions

1. Explain why a heat map is useful.
2. Describe how a tree map shows proportions.
3. What information can you get from a box plot?

🎭 Scenario-based Exercises

Scenario: You are a data analyst for a supermarket. You have sales data and customer data.

1. Which chart would you use to see sales patterns by hour and day?
2. Which chart would you use to show sales by product category?
3. How would you combine the two data sources?

👥 Group Activity

In groups of 4, collect data on favourite fruits, sports, and colours. Create a heat map for one, a tree map for another, and a box plot for the third. Present your charts to the class.

🧑 Individual Activity

Create a tree map of your monthly expenses. Use categories like food, transport, and fun. Share your tree map with a friend.

💬 Classroom Discussion Questions

1. Which chart do you like best and why?
2. How can heat maps help businesses in Nigeria?
3. Why is it important to combine data?

🛠️ Mini Project

Project: Create a dashboard with three sheets: a heat map of sales by region and product, a tree map of sales by category, and a box plot of sales by region. Combine your data from at least two sources. Present your dashboard.

💻 Practical Assignment

Using Tableau Public, create a heat map of daily temperatures for the last month. Then create a tree map of your expenses. Finally, create a box plot of your study hours. Publish your workbook.

🏆 Challenge Exercise

Create a story with 4 pages: Page 1 – Heat map of sales, Page 2 – Tree map of products, Page 3 – Box plot of sales by region, Page 4 – Combined data story. Use data from at least two sources. Share the story link.

🔑 Quiz Answers

(Answers provided within the multiple choice and matching sections above.)

🎯 Key Takeaways

• Heat maps show patterns with colours.
• Tree maps show parts of a whole.
• Box plots show data distribution.
• Joins combine data at row level.
• Data blending combines at aggregate level.
• Choose the right chart for your data.

🔜 Preparation for Module 8

In the next module, we will dive into advanced analytics like creating calculated fields with logic (IF statements), using table calculations, and creating parameters for dynamic analysis. Make sure you are comfortable with the charts and joining techniques from this module. Get ready to become a Tableau master!

End of Module 7 · Keep creating beautiful charts!

📊 Module 8 · Certified Tableau for Data Analysis Expert

Module Title: Smart Calculations – IF Statements, Table Calculations & Dynamic Parameters

Welcome, data wizard! In this module, we will learn how to make our data even smarter using IF statements (like making decisions), table calculations (like calculating across rows), and dynamic parameters (that change automatically).

Imagine you have a robot that can decide what to do based on rules. That's what IF statements do. Table calculations are like running a race – you look at the runner behind you and ahead of you. Dynamic parameters are like a thermostat that adjusts itself.

By the end, you will be able to create powerful formulas and dynamic dashboards!

🎯 Learning Objectives

By the end of this module, you will be able to:

• Create IF statements to make decisions in your data.
• Use table calculations like Running Total and Difference.
• Create dynamic parameters that update automatically.
• Combine these tools for advanced analysis.
• Apply these skills to real-world data.

🌟 Warm-up Story: Kofi's Decision Robot

Kofi is a smart boy in Accra. He has a robot that can sort his toys. The robot uses IF statements to decide: "If the toy is red, put it in the red box. If it's blue, put it in the blue box."

Kofi also uses table calculations to count his toys. He wants to know the running total of toys he collects each month. He uses a table calculation to add them up as he goes.

Finally, he uses dynamic parameters to change the sorting rule automatically. If he gets a new colour toy, the robot learns to sort it.

Kofi's robot became the smartest toy sorter in the neighbourhood!

📚 Main Lessons

Lesson 1: What is an IF Statement?

Definition: An IF statement is a rule that says: "If this is true, then do this; otherwise, do that."

Why important: It helps you make decisions in your data.

Simple explanation: Like a fork in the road – if you go left, you see a lake; if you go right, you see a forest.

Real-life example: If sales are high, give a bonus; otherwise, give a small reward.

School example: If a student scores above 70, they pass; otherwise, they take a retest.

Home example: If it's raining, take an umbrella; otherwise, wear a cap.

Nigerian example: If a farmer has enough rain, the crop grows well; otherwise, they need irrigation.

  IF STATEMENT EXAMPLE
  IF [Sales] > 1000 THEN "High"
  ELSE "Low"
  END

Mini summary: IF statements help you make decisions based on conditions.

Lesson 2: Creating an IF Statement in Tableau

Definition: In Tableau, you write an IF statement in a calculated field.

Why important: It allows you to create new categories or values.

Simple explanation: You write a formula that says: if this, then that.

Real-life example: Create a field called "Profit Category" – if profit > 500, "Good", else "OK".

School example: Create a field called "Grade" – if score > 80, "A", else "B".

Home example: Create a field called "Weather" – if temp > 30, "Hot", else "Cool".

Nigerian example: Create a field called "Harvest" – if yield > 1000, "Abundant", else "Average".

  STEPS TO CREATE IF STATEMENT
  1. Create a Calculated Field.
  2. Write: IF [Field] > Value THEN "Result" ELSE "Other Result" END.
  3. Click OK.

Mini summary: IF statements are easy to write and create new categories.

Lesson 3: Using ELSE IF for Multiple Conditions

Definition: ELSE IF lets you check many conditions in one statement.

Why important: You can have more than two outcomes.

Simple explanation: Like a menu – if you want rice, choose rice; if you want beans, choose beans; otherwise, choose bread.

Real-life example: IF sales > 1000 THEN "High", ELSE IF sales > 500 THEN "Medium", ELSE "Low".

School example: IF score > 90 THEN "A", ELSE IF score > 70 THEN "B", ELSE "C".

Home example: IF temp > 35 THEN "Very Hot", ELSE IF temp > 25 THEN "Warm", ELSE "Cool".

Nigerian example: IF rainfall > 200 THEN "Flood", ELSE IF rainfall > 100 THEN "Normal", ELSE "Drought".

  ELSE IF EXAMPLE
  IF [Sales] > 1000 THEN "High"
  ELSEIF [Sales] > 500 THEN "Medium"
  ELSE "Low"
  END

Mini summary: ELSE IF allows multiple conditions and outcomes.

Lesson 4: What are Table Calculations?

Definition: Table calculations are calculations you apply to the table of data, like running totals or differences.

Why important: They help you see trends and patterns across rows.

Simple explanation: Like looking at a line of people and seeing how each person compares to the one before.

Real-life example: Running total of sales over months.

School example: Difference in marks between tests.

Home example: Running total of steps walked each day.

Nigerian example: Running total of harvest over seasons.

  TABLE CALCULATION EXAMPLE
  Month   Sales   Running Total
  Jan     100     100
  Feb     120     220  (100+120)
  Mar     130     350  (220+130)

Mini summary: Table calculations work on the data table to show summaries.

Lesson 5: Types of Table Calculations

Definition: Common types: Running Total, Difference, Percent Difference, Rank, and Moving Average.

Why important: Each gives a different view of the data.

Simple explanation: Like different lenses on a camera – each shows something new.

Real-life example: Running Total shows cumulative sales. Difference shows change from previous month.

School example: Rank shows your position in class. Moving Average smooths out ups and downs.

Home example: Running Total of savings. Difference in daily expenses.

Nigerian example: Running Total of votes in an election. Difference in crop yield year over year.

  TABLE CALCULATION TYPES
  +------------------+---------------------------+
  | Type             | What it does              |
  +------------------+---------------------------+
  | Running Total    | Adds up as you go         |
  | Difference       | Previous - Current        |
  | Percent Diff     | Percentage change         |
  | Rank             | Orders from high to low   |
  | Moving Average   | Average of last few rows  |
  +------------------+---------------------------+

Mini summary: Table calculations come in different types for different insights.

Lesson 6: Creating a Table Calculation in Tableau

Definition: You add a table calculation by right-clicking on a measure and choosing "Add Table Calculation".

Why important: It's easy and you can choose the type.

Simple explanation: Like choosing a tool from a toolbox.

Real-life example: Add a Running Total to a sales line chart.

School example: Add a Rank to student scores.

Home example: Add a Difference to daily temperature.

Nigerian example: Add a Moving Average to monthly rainfall.

  STEPS TO ADD TABLE CALCULATION
  1. Right-click on the measure in the view.
  2. Choose "Add Table Calculation".
  3. Select the type (e.g., Running Total).
  4. Choose the direction (e.g., Across or Down).
  5. Click OK.

Mini summary: Adding a table calculation is a few clicks away.

Lesson 7: Understanding the Direction of Table Calculations

Definition: Direction tells Tableau how to compute – across rows, down columns, or by pane.

Why important: It affects the result.

Simple explanation: Like reading a book – left to right or top to bottom.

Real-life example: Across – sales by month. Down – sales by product.

School example: Across – scores by subject. Down – scores by student.

Home example: Across – expenses by day. Down – expenses by category.

Nigerian example: Across – harvest by season. Down – harvest by crop.

  DIRECTION EXAMPLE
  +--------+-------+-------+-------+
  |        | Jan   | Feb   | Mar   |  (Across)
  +--------+-------+-------+-------+
  | Sales  | 100   | 120   | 130   |
  | Profit | 20    | 25    | 30    |  (Down)
  +--------+-------+-------+-------+

Mini summary: Direction tells Tableau how to compute the calculation.

Lesson 8: What is a Dynamic Parameter?

Definition: A dynamic parameter is a parameter that changes automatically based on a field or calculation.

Why important: It makes your dashboard smarter and more responsive.

Simple explanation: Like a thermostat that adjusts the temperature automatically.

Real-life example: A parameter that sets the discount based on the total sales.

School example: A parameter that sets the passing mark based on the average score.

Home example: A parameter that sets the budget based on last month's expenses.

Nigerian example: A parameter that sets the price of rice based on the harvest.

  DYNAMIC PARAMETER IDEA
  Parameter: Discount = IF [Sales] > 1000 THEN 0.1 ELSE 0.05
  (The discount changes automatically)

Mini summary: Dynamic parameters change automatically based on data.

Lesson 9: Creating a Dynamic Parameter in Tableau

Definition: You create a parameter and then use a calculation to set its value.

Why important: It automates decision-making.

Simple explanation: You set up a rule that updates the parameter.

Real-life example: Parameter = Running Total of Sales.

School example: Parameter = Average Score.

Home example: Parameter = Total Expenses.

Nigerian example: Parameter = Total Harvest.

  STEPS TO CREATE DYNAMIC PARAMETER
  1. Create a parameter (e.g., "Dynamic Discount").
  2. Create a calculation that uses the parameter.
  3. Use a table calculation or IF statement to set the parameter value.
  4. Note: In Tableau, parameters are not fully dynamic but you can use workarounds with calculations.

Mini summary: Dynamic parameters update based on calculations.

Lesson 10: Using Parameters in Table Calculations

Definition: You can use a parameter to control a table calculation, like changing the number of periods in a moving average.

Why important: It gives users control over the calculation.

Simple explanation: Like a slider that changes the window size for a moving average.

Real-life example: Parameter to choose the number of months for a moving average.

School example: Parameter to choose the number of tests to average.

Home example: Parameter to choose the number of days for a moving average.

Nigerian example: Parameter to choose the number of seasons for a moving average of harvest.

  PARAMETER IN TABLE CALCULATION
  Moving Average with parameter [Window Size]

Mini summary: Parameters can control table calculations.

Lesson 11: Combining IF Statements and Table Calculations

Definition: You can use IF statements to create categories, then use table calculations on those categories.

Why important: It gives you powerful insights.

Simple explanation: First, you decide what group something belongs to, then you calculate across groups.

Real-life example: IF sales are high, then calculate the running total of high sales.

School example: IF student is in grade A, then rank them.

Home example: IF expense is food, then calculate total food expenses.

Nigerian example: IF crop is maize, then calculate running total of maize harvest.

  COMBINED EXAMPLE
  IF [Sales] > 1000 THEN "High" ELSE "Low" END
  Then Running Total of Sales for each category.

Mini summary: You can combine IF and table calculations for deeper analysis.

Lesson 12: Best Practices for Advanced Calculations

Definition: Best practices are rules to make your calculations clear and correct.

Why important: They prevent errors and make your work easy to understand.

Simple explanation: Like following a recipe to avoid mistakes.

Real-life example: Name your calculations clearly, like "Running Total of Sales".

School example: Use comments in your formulas to explain what they do.

Home example: Test your calculations with small data to make sure they work.

Nigerian example: Always check the direction of your table calculation.

  BEST PRACTICES
  - Use clear names.
  - Add comments (// comment).
  - Test with small data.
  - Check the direction.
  - Keep it simple.

Mini summary: Follow best practices to create reliable calculations.

Lesson 13: Real-World Application – Sales Dashboard

Definition: You can build a dashboard that uses IF statements, table calculations, and parameters.

Why important: It shows your skills in action.

Simple explanation: You create a dashboard that a business can use.

Real-life example: A sales dashboard with Running Total, Moving Average, and a parameter for discount.

School example: A grade dashboard with IF for pass/fail, Running Total of scores, and a parameter for pass mark.

Home example: A budget dashboard with IF for spending categories, Running Total of expenses, and a parameter for savings goal.

Nigerian example: A farm dashboard with IF for crop health, Running Total of harvest, and a parameter for price.

  DASHBOARD EXAMPLE
  +--------------------------------------+
  | Sales Dashboard                      |
  | +----------+ +---------------------+ |
  | | IF Sales | | Running Total       | |
  | | Category | | of Sales            | |
  | +----------+ +---------------------+ |
  | +----------+ +---------------------+ |
  | | Parameter| | Moving Average      | |
  | | Discount | | of Sales            | |
  | +----------+ +---------------------+ |
  +--------------------------------------+

Mini summary: Combine all tools to build a powerful dashboard.

📖 Key Vocabulary

• IF Statement: A rule that makes decisions.
• Table Calculation: A calculation on the table of data.
• Running Total: Adds up as you go.
• Difference: Shows change between rows.
• Moving Average: Average of a window of rows.
• Parameter: A value the user can change.
• Dynamic Parameter: A parameter that changes automatically.

🧠 Important Concepts

• IF statements create new categories.
• Table calculations show patterns across rows.
• Parameters give users control.
• Dynamic parameters automate changes.
• Combining these tools gives powerful insights.

🔢 Step-by-Step Explanations

How to Create an IF Statement

1. Create a Calculated Field.
2. Type: IF [Sales] > 1000 THEN "High" ELSE "Low" END.
3. Click OK.

How to Add a Table Calculation

1. Right-click on the measure in the view.
2. Choose "Add Table Calculation".
3. Select Running Total, Difference, etc.
4. Choose the direction (Across or Down).
5. Click OK.

How to Use a Parameter in a Table Calculation

1. Create a parameter (e.g., Window Size).
2. In the table calculation, choose "Moving Average".
3. In the "Length" box, select the parameter.

🌍 Real-life Examples

• Retail: IF sales are high, give a discount. Running Total of monthly sales.
• Finance: Moving Average of stock prices.
• Healthcare: Difference in patient wait times.

🇳🇬 Nigerian Examples

• Agriculture: IF harvest is above average, store surplus. Running Total of harvest.
• Transport: Difference in bus delays by route.
• Education: IF student passes, promote; else, retake.

🧸 Fun Examples Children Relate To

• Games: IF score > 100, level up. Running Total of points.
• Chores: IF chores done, get allowance. Running Total of allowance.
• Candy: IF candy count > 10, share with friends.

🏠 Everyday Examples

• Budget: IF expense > budget, alert. Running Total of expenses.
• Weather: IF temperature > 30, wear shorts. Moving Average of temperature.
• Health: IF steps > 10000, goal met. Running Total of steps.

🧑‍🏫 Teacher Notes

• Use simple analogies like decisions at a fork in the road.
• Show how table calculations can be used in sports (e.g., running total of points).
• Encourage students to create their own IF statements.
• Demonstrate the difference between Across and Down directions.

👪 Parent Tips

• Help your child create an IF statement for their study plan (e.g., IF score > 80, reward).
• Discuss how table calculations are used in family budgeting.
• Encourage them to use parameters to change things and see what happens.

✨ Interesting Facts

• IF statements are used in almost all programming languages.
• Table calculations were introduced in Tableau 8.
• Dynamic parameters are a newer feature in Tableau.

💡 Did You Know?

• You can use IF statements with dates (e.g., IF [Date] > TODAY() THEN "Future").
• Table calculations can be nested – you can have a running total of a moving average.
• Parameters can be used to switch between different table calculations.

🔔 Remember This

• IF statements make decisions.
• Table calculations work on rows.
• Parameters give user control.
• Dynamic parameters update automatically.
• Combine them for powerful analysis.

⚠️ Common Mistakes

• Forgetting to close the IF statement with END.
• Using the wrong direction in table calculations.
• Not testing parameters with different values.
• Overcomplicating IF statements – keep them simple.
• Using table calculations on non-numeric data.

✅ Best Practices

• Always close your IF statements with END.
• Test your table calculations with different data.
• Give parameters clear names and descriptions.
• Use comments in your formulas.
• Keep your calculations simple and clear.

🎨 ASCII Illustrations

IF Statement Flow

  Condition
      |
      V
  Is it true?
      |
   +--+--+
   |     |
  Yes   No
   |     |
   V     V
  Do A  Do B

Running Total Example

  Month   Sales   Running Total
  Jan     100     100
  Feb     120     220  (100+120)
  Mar     130     350  (220+130)
  Apr     150     500  (350+150)

Moving Average Example

  Month   Sales   Moving Avg (3 months)
  Jan     100     -
  Feb     120     -
  Mar     130     116.7  (100+120+130)/3
  Apr     150     133.3  (120+130+150)/3

📊 Comparison Table: IF vs Table Calculation

📊 Comparison Table: Running Total vs Moving Average

📌 End-of-Module Summary

Fantastic work! You have learned three powerful tools: IF statements, table calculations, and dynamic parameters.

IF statements help you make decisions in your data. Table calculations show patterns across rows – like running totals and moving averages. Dynamic parameters change automatically to make your dashboards smarter.

By combining these tools, you can create advanced analyses that help people make better decisions.

You are now ready to tackle even more complex data challenges!

❓ Frequently Asked Questions

1. Can I use IF statements with text? Yes, you can create text categories.
2. What is the difference between Running Total and Moving Average? Running Total adds up; Moving Average smoothes.
3. Can I use a parameter in an IF statement? Yes, you can use a parameter in an IF statement.
4. What is the direction in table calculations? It tells Tableau whether to compute across or down.
5. Can I have multiple ELSE IF conditions? Yes, you can have as many as you need.
6. What is a dynamic parameter? A parameter that updates automatically.
7. Can I use table calculations in a dashboard? Yes, they appear in the charts.
8. How do I test my IF statement? Create a view with it to see the results.
9. What is the most common table calculation? Running Total.
10. Can I combine IF and table calculations? Yes, it's very powerful.

📝 Review Questions

1. What is an IF statement?
2. What does a Running Total do?
3. What is a table calculation?
4. What is a dynamic parameter?
5. How do you create an IF statement in Tableau?
6. What is the difference between Across and Down direction?
7. What is a Moving Average?
8. How do you add a table calculation?
9. Can you use a parameter in a table calculation?
10. What is the purpose of ELSE IF?
11. Why are dynamic parameters useful?
12. What is a common mistake with IF statements?
13. How do you test a table calculation?
14. What is the best practice for naming calculations?
15. Can you combine multiple tools in one dashboard?

✏️ Fill-in-the-Blank Exercises

1. An _________ statement makes decisions. (IF)
2. A _________ total adds up as you go. (Running)
3. A _________ average smoothes out data. (Moving)
4. A _________ is a value the user can change. (parameter)
5. A _________ parameter changes automatically. (dynamic)

✅ True or False

1. IF statements can only have two outcomes. (False)
2. Running Total is a table calculation. (True)
3. Parameters are always static. (False)
4. You can use IF statements with text. (True)
5. Table calculations work on the original data, not the table. (False)

🔘 Multiple Choice Questions

1. What does an IF statement do?
   A) Adds numbers B) Makes decisions C) Sorts data D) Filters data
   Answer: B
2. Which is a table calculation?
   A) IF statement B) Running Total C) Parameter D) Dimension
   Answer: B
3. What is a Moving Average?
   A) Adds up B) Smoothes trend C) Makes decisions D) Filters
   Answer: B
4. What is a dynamic parameter?
   A) Fixed value B) Changes automatically C) A chart D) A filter
   Answer: B
5. How do you add a table calculation?
   A) Drag and drop B) Right-click → Add Table Calculation C) Create parameter D) Use IF
   Answer: B
6. What does ELSE IF do?
   A) Adds more conditions B) Ends the statement C) Starts the statement D) Filters
   Answer: A
7. Which direction computes across columns?
   A) Down B) Across C) Both D) Neither
   Answer: B
8. Can you use a parameter in an IF statement?
   A) Yes B) No C) Only in Tableau D) Only in Python
   Answer: A
9. What is the purpose of a Running Total?
   A) Show growth B) Show average C) Show difference D) Show rank
   Answer: A
10. What is a common mistake in IF statements?
    A) Using END B) Forgetting END C) Using ELSE D) Using THEN
    Answer: B
11. What is a parameter used for?
    A) To make decisions B) To allow user input C) To calculate averages D) To sort
    Answer: B
12. Which is NOT a table calculation?
    A) Running Total B) Difference C) Moving Average D) IF statement
    Answer: D
13. What does the direction in table calculations affect?
    A) The result B) The colour C) The title D) The filter
    Answer: A
14. Can you combine IF and table calculations?
    A) Yes B) No C) Only in Tableau D) Only in Excel
    Answer: A
15. What is the best practice for naming calculations?
    A) Use short names B) Use clear names C) Use numbers D) Use symbols
    Answer: B

🔗 Matching Exercises

Match the term with its description.

Answers: 1-B, 2-A, 3-C, 4-D

📝 Short Answer Questions

1. Explain how an IF statement works.
2. Describe what a Running Total does and why it's useful.
3. What is the benefit of using a parameter in a table calculation?

🎭 Scenario-based Exercises

Scenario: You are a data analyst for a school. You have student scores and want to create a dashboard.

1. Write an IF statement to classify students as Pass or Fail.
2. Add a Running Total of scores.
3. Create a parameter to change the pass mark.

👥 Group Activity

In groups of 4, collect data on daily temperatures for 2 weeks. Create a dashboard with: IF statement for hot/cold, Running Total of temperatures, Moving Average (3-day), and a parameter to change the moving average window. Present your dashboard.

🧑 Individual Activity

Create a dashboard of your study hours. Include: IF statement for productive/unproductive, Running Total of hours, Moving Average of hours, and a parameter to change the goal. Share with a friend.

💬 Classroom Discussion Questions

1. How can IF statements help in decision-making?
2. Why is Running Total useful for tracking progress?
3. How would you use dynamic parameters in a business?

🛠️ Mini Project

Project: Create a sales dashboard for a small shop. Include:

• IF statement to classify sales as High, Medium, Low.
• Running Total of sales over months.
• Moving Average of sales (3-month).
• Parameter to change the moving average window.

Present your dashboard.

💻 Practical Assignment

Using Tableau Public, create a dashboard with:

• IF statement to classify products by profit.
• Running Total of sales.
• Moving Average of sales with a parameter.

Publish and share the link.

🏆 Challenge Exercise

Create a story with 4 pages: Page 1 – IF statement classification, Page 2 – Running Total, Page 3 – Moving Average with parameter, Page 4 – Combined insights. Use your own data. Share the story link.

🔑 Quiz Answers

(Answers provided within the multiple choice and matching sections above.)

🎯 Key Takeaways

• IF statements make decisions and create categories.
• Table calculations show patterns across rows.
• Running Total adds up, Moving Average smoothes.
• Parameters give users control.
• Dynamic parameters update automatically.
• Combining tools gives powerful insights.

🔜 Preparation for Module 9

In the next module, we will explore advanced visualisations like Gantt charts, waterfall charts, and scatter plots. We will also learn how to use sets and groups for deeper analysis.

Make sure you are comfortable with IF statements, table calculations, and parameters.

Get ready to create even more stunning and insightful visualisations!

End of Module 8 · Keep making smart calculations!