Google Sheets connection in Tableau - Real Business Scenario

Scenario Mode

👤 Your Role: You are a sales analyst at a retail company.

📋 Request: Your manager wants you to create a live sales dashboard in Tableau using sales data stored in a Google Sheets document.

📊 Data: You have a Google Sheets file with monthly sales data including columns: Date, Region, Product, Sales Amount, and Units Sold.

🎯 Deliverable: Connect Tableau to the Google Sheets file, create a dashboard showing total sales by region and product, and ensure the data updates automatically when the Google Sheet changes.

Sample Data

Date	Region	Product	Sales Amount	Units Sold
2024-01-01	North	Widget A	1200	30
2024-01-01	South	Widget B	850	20
2024-02-01	East	Widget A	950	25
2024-02-01	West	Widget C	1100	22
2024-03-01	North	Widget B	1300	35
2024-03-01	South	Widget C	900	18
2024-04-01	East	Widget B	1150	28
2024-04-01	West	Widget A	1250	30

1

Step 1: Open Tableau Desktop and start a new workbook.

No formula needed.

Expected Result

Tableau is ready for data connection.

2

Step 2: Connect Tableau to Google Sheets by selecting 'Google Sheets' under 'Connect' options.

Sign in with your Google account and allow Tableau to access your Google Sheets files.

Expected Result

You see a list of your Google Sheets files available for connection.

3

Step 3: Select the Google Sheets file containing the sales data.

Choose the correct sheet/tab with the sales data.

Expected Result

Sales data loads into Tableau's data source pane.

4

Step 4: Verify data types for each column: Date as date, Region and Product as text, Sales Amount and Units Sold as numbers.

Adjust data types if needed in Tableau data source view.

Expected Result

All columns have correct data types for analysis.

5

Step 5: Create a new worksheet to build a sales by region chart.

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

Expected Result

Bar chart showing total sales amount by region.

6

Step 6: Create another worksheet to show sales by product.

Drag 'Product' to Rows, drag 'Sales Amount' to Columns, aggregation SUM.

Expected Result

Bar chart showing total sales amount by product.

7

Step 7: Create a dashboard and add both worksheets.

Arrange charts side by side with clear titles and legends.

Expected Result

Dashboard displays sales by region and product clearly.

8

Step 8: Set the data source to refresh automatically to reflect changes in Google Sheets.

Configure Tableau's data refresh settings or use Tableau Online/Server for scheduled refresh.

Expected Result

Dashboard updates automatically when Google Sheets data changes.

Final Result

-----------------------------------------
|           Sales Dashboard              |
|---------------------------------------|
| Region Sales       | Product Sales     |
|                   |                  |
| [Bar Chart]       | [Bar Chart]       |
|                   |                  |
-----------------------------------------

✓North region has the highest total sales amount.

✓Widget A is the top-selling product overall.

✓Sales vary by region and product, useful for targeted marketing.

Bonus Challenge

Add a time filter to the dashboard to allow users to select a date range and see sales trends over time.

Show Hint

Use Tableau's date filter control and create a line chart showing monthly sales.