Tableau Basics

The Tableau workspace is designed for visual, drag and drop analysis. You will spend most of your time in the Data Pane, the Shelves (Rows and Columns), and the Marks card which controls visual encodings such as color, size, and label. The Analytics pane provides quick summary calculations and reference lines, while the Show Me panel assists in choosing appropriate chart types based on selected fields. Familiarity with these areas speeds up exploration and dashboard creation.

Quick examples: preparing data for Tableau

Often you will prepare or cleanse data before connecting in Tableau. Below are small Python snippets showing common preparation steps and saving a CSV which Tableau can read.

# Example 1: Read a CSV and inspect columns
import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
print(df.head())  # Displays first 5 rows

# Example 2: Aggregate sales by region and save for Tableau
df_agg = df.groupby(["region", "category"], as_index=False)["sales"].sum()
df_agg.to_csv("../../assets/data/sales_by_region.csv", index=False)
print(df_agg.head())  # Aggregated sums ready for Tableau

import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
print(list(df.columns))  # e.g. ['order_id', 'date', 'region', 'category', 'sales']

import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv", parse_dates=["date"])
df["month"] = df["date"].dt.to_period("M").astype(str)
summary = df.groupby(["region", "month"], as_index=False)["sales"].sum()
pivot = summary.pivot(index="region", columns="month", values="sales").fillna(0)
pivot.to_csv("../../assets/data/sales_pivot_region_month.csv")
print(pivot.head())  # Pivot table ready for Tableau

Tableau connects smoothly to a wide range of sources: flat files like CSV or Excel, databases via native connectors, and cloud sources. You can choose a live connection for up-to-date queries or extract data to improve performance and portability. Preparing a clean, tidy dataset improves performance and makes creating visualizations faster. Below are example workflows showing how you might prepare or export data so Tableau can consume it quickly.

Examples: reading and exporting data

# Example: Read Excel for Tableau
import pandas as pd

xlsx = pd.ExcelFile("data/sales.xlsx")
print(xlsx.sheet_names)  # ['Sheet1', 'Sheet2']
# Read a sheet and preview
df = pd.read_excel(xlsx, sheet_name="Sheet1")
print(df.head())  # first 5 rows

# Example: Query SQL and save CSV for Tableau
from sqlalchemy import create_engine
import pandas as pd

# Use appropriate connection string for your DB
engine = create_engine("mssql+pyodbc://user:pass@server/db?driver=ODBC+Driver+17+for+SQL+Server")
df = pd.read_sql_query("SELECT TOP 500 * FROM sales", engine)
df.to_csv("../../assets/data/sql_sample.csv", index=False)
print(f"Rows fetched: {len(df)}")  # number of rows fetched

import pandas as pd

file = pd.ExcelFile("data/company_data.xlsx")
print(file.sheet_names)
df = pd.read_excel(file, sheet_name="Sales")
print(df.head())

from sqlalchemy import create_engine
import pandas as pd

engine = create_engine("postgresql://user:pass@host:5432/db")
query = "SELECT order_date, region, sales FROM orders"
df = pd.read_sql_query(query, engine)
df["month"] = pd.to_datetime(df["order_date"]).dt.to_period("M").astype(str)
monthly = df.groupby(["region", "month"], as_index=False)["sales"].sum()
monthly.to_csv("../../assets/data/monthly_revenue.csv", index=False)
print(monthly.head())

A clear understanding of dimensions and measures is essential in Tableau. Dimensions are categorical or discrete fields used to slice and label data, while measures are numeric fields that can be aggregated like sum or average. Tableau treats dates flexibly: they can act as dimensions (year, quarter) or continuous axes. Converting and cleaning types before importing makes it easier to use fields as intended in visualizations.

Examples: detect and convert types

# Example: Detect types and convert date
import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
print(df.dtypes)  # Inspect types

# Convert date and create year column for a dimension
df['order_date'] = pd.to_datetime(df['order_date'])
df['year'] = df['order_date'].dt.year
print(df[['order_date', 'year']].head())

# Example: Ensure numeric measure and create calculated ratio
df['sales'] = pd.to_numeric(df['sales'], errors='coerce')
df['cost'] = pd.to_numeric(df['cost'], errors='coerce')
df['margin'] = (df['sales'] - df['cost']) / df['sales']
print(df[['sales', 'cost', 'margin']].head())  # Calculated measure

import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
numeric_cols = df.select_dtypes(include='number').columns.tolist()
print(numeric_cols)

df['sales'] = pd.to_numeric(df['sales'], errors='coerce')
print(df['sales'].head())

import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
df['sales'] = pd.to_numeric(df['sales'], errors='coerce')
df['cost'] = pd.to_numeric(df['cost'], errors='coerce')

df['margin_pct'] = (df['sales'] - df['cost']) / df['sales'] * 100
print(df[['sales', 'cost', 'margin_pct']].head())

Tableau offers a wide set of chart types. Start with simple charts: bar, line, scatter, and pie, as they are effective for most analyses. Learn the sequence: connect your data, drag dimensions and measures to Rows and Columns, and use the Marks card to encode color, size, and labels. Below are quick data preparation snippets to create data that is ready to visualize in Tableau.

Bar chart: top categories

# Prepare top categories by sales for a bar chart
import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
cat_sales = df.groupby('category', as_index=False)['sales'].sum().nlargest(10, 'sales')
cat_sales.to_csv('../../assets/data/top_categories.csv', index=False)
print(cat_sales)  # Top 10 categories by sales

Scatter plot: sales vs profit

# Prepare scatter data to map sales vs profit with size as quantity
import pandas as pd

df = pd.read_csv("../../assets/data/sample_sales.csv")
df['sales'] = pd.to_numeric(df['sales'], errors='coerce')
df['profit'] = pd.to_numeric(df['profit'], errors='coerce')
scatter = df[['region', 'sales', 'profit', 'quantity']].dropna()
scatter.to_csv('../../assets/data/sales_profit_scatter.csv', index=False)
print(scatter.head())  # Ready for scatter in Tableau

import pandas as pd

df = pd.read_csv('../../assets/data/sample_sales.csv')
region_sales = df.groupby('region', as_index=False)['sales'].sum().sort_values('sales', ascending=False)
region_sales.to_csv('../../assets/data/region_sales.csv', index=False)
print(region_sales.head())

import pandas as pd

df = pd.read_csv('../../assets/data/sample_sales.csv')
agg = df.groupby('store_id', as_index=False).agg({
    'sales': 'sum',
    'profit': 'sum',
    'order_id': 'nunique'
}).rename(columns={'order_id': 'orders'})
agg.to_csv('../../assets/data/store_scatter.csv', index=False)
print(agg.head())

Show Me is a helpful Tableau panel that recommends chart types based on the fields you select. It inspects how many dimensions and measures are chosen and suggests the most appropriate visual encodings. Practicing with Show Me helps you learn which chart types suit different data shapes and analysis goals.