Why data connections are the starting point in Tableau - Business Case Study

Scenario Mode

👤 Your Role: You are a business analyst working with Tableau to create reports for your company.

📋 Request: Your manager wants you to build a sales dashboard but emphasizes that the data must be accurate and up-to-date. They ask you to explain why setting up data connections correctly is the first and most important step.

📊 Data: You have access to a sales data Excel file with columns: Date, Region, Product, Sales Amount, and Quantity Sold.

🎯 Deliverable: Create a Tableau workbook that connects to the sales data, and prepare a simple sales summary chart. Also, provide a clear explanation of why establishing the data connection first is crucial.

Sample Data

Date	Region	Product	Sales Amount	Quantity Sold
2024-01-01	North	Widget A	1000	10
2024-01-02	South	Widget B	1500	15
2024-01-03	East	Widget A	1200	12
2024-01-04	West	Widget C	800	8
2024-01-05	North	Widget B	1100	11
2024-01-06	South	Widget C	1300	13
2024-01-07	East	Widget B	1400	14
2024-01-08	West	Widget A	900	9

1

Step 1: Open Tableau and connect to the sales data Excel file.

In Tableau, click 'Connect to Data', select 'Microsoft Excel', and choose the sales data file.

Expected Result

Tableau successfully connects to the sales data and shows the data preview.

2

Step 2: Verify the data types and column names in Tableau's data source tab.

Check that 'Date' is a date type, 'Sales Amount' and 'Quantity Sold' are numbers, and other columns are text.

Expected Result

All columns have correct data types, ensuring accurate analysis.

3

Step 3: Create a simple sales summary chart showing total Sales Amount by Region.

Drag 'Region' to Rows, drag 'Sales Amount' to Columns, and set aggregation to SUM.

Expected Result

A bar chart appears showing total sales for each region.

4

Step 4: Explain why data connection is the starting point.

Write a short note: 'Connecting to the right data source ensures that the data is accurate, complete, and up-to-date. Without a proper connection, any analysis or visualization will be unreliable.'

Expected Result

Clear understanding that data connection is the foundation for trustworthy reports.

Final Result

Sales Summary by Region

Region   | Total Sales
-----------------------
North    | ██████████ 2100
South    | ███████████ 2800
East     | ██████████ 2600
West     | ████████ 1700

(Bar lengths represent sales amounts proportionally)

✓Data connection is essential to access accurate and current data.

✓Correct data types prevent errors in calculations and visualizations.

✓A simple sales summary by region helps identify top-performing areas.

Bonus Challenge

Add a filter to the dashboard that allows users to select a date range and see sales only for that period.

Show Hint

Use Tableau's date filter feature by dragging the 'Date' field to the Filters shelf and setting the range.