Tableau vs Excel — Comparison for Beginners

# Excel — a working analysis.
# The classic analyst workflow: raw data → pivot → conclusion.

# ── Step 1: Raw data in a sheet ──
# Columns: order_id, order_date, region, product, amount, quantity

# ── Step 2: Pivot table ──
# Rows: region
# Columns: month (from order_date)
# Values: SUM(amount), COUNT(order_id)
#
# This gives you revenue by region per month in about 30 seconds.

# ── Step 3: Formulas ──
# In a new column, add:
#   =IF(D2>100000, "High", "Normal")
#   =SUMIFS(amount_range, region_range, "North")
#   =VLOOKUP(customer_id, customers, 2, FALSE)
#
# Each formula is a small decision.

# ── Step 4: Basic charts ──
# Insert → Pivot Chart → column chart
# Add data labels, format axes, done.

# What Excel does well:
# - Fast to start (open, click, done)
# - Universal (every stakeholder has it)
# - Great for one-off analysis and financial models
# - Formula-based logic is transparent
#
# What Excel struggles with:
# - Large data (>1M rows gets slow)
# - Interactive dashboards (filters require re-running)
# - Sharing at scale (files get copied, versions diverge)
# - Reproducibility (manual steps are not auditable)
#
# Excel is the working analysis. Not the delivery.

-- Tableau — what the dashboard runs under the hood.
-- Every Tableau chart sends queries to the data source.

-- The "revenue by region and month" chart sends:

SELECT
  region,
  DATE_TRUNC('month', order_date) AS month,
  SUM(amount) AS revenue,
  COUNT(*) AS orders
FROM orders
WHERE order_date >= '2026-01-01'
GROUP BY region, month
ORDER BY month, region;

-- The dashboard view then:
-- - Renders a bar chart or treemap
-- - Lets the user filter by product category
-- - Lets the user click a region to drill into that region
-- - Refreshes when the underlying data changes

-- What Tableau adds on top:
-- - Interactivity: user filters and drills without re-querying by hand
-- - Visual sophistication: maps, treemaps, scatter, dual axes
-- - Publishing: share one dashboard with hundreds of viewers
-- - Live connection: refresh from the warehouse, not a file

-- What Tableau does NOT do:
-- - Clean your data (Excel or SQL does that)
-- - Build a financial model (Excel is better for that)
-- - Do quick one-off calculations (Excel is faster)

-- Tableau is the delivery layer. Not the working analysis.
--
-- The two together:
-- - Excel does the thinking and cleaning
-- - Tableau does the showing and sharing

# The full pipeline — Excel + Tableau together.
# This is what real analytics work looks like.

# ── Step 1: Excel for the working analysis ──
# - Load the raw CSV
# - Clean it (dates, categories, duplicates)
# - Do the exploratory pivot tables
# - Answer: "Which regions grew fastest last quarter?"
# - Build the financial model if needed
#
# Excel is where the actual analysis happens.

# ── Step 2: SQL for scaling ──
# - Once you know what to measure, move to SQL
# - Query the warehouse instead of a 500K-row CSV
# - Save the query so it can be re-run next month
#
# SQL is the transition from "one-off" to "repeatable".

# ── Step 3: Tableau for the delivery ──
# - Connect Tableau to the warehouse (or the cleaned CSV)
# - Build the dashboard: revenue by region, growth trends, drill-downs
# - Publish it to the team
# - Update it with a scheduled refresh
#
# Tableau is where the analysis reaches the people who need it.

# ── The full picture ──
#
#   Raw data
#      ↓
#   Excel (clean + explore)
#      ↓
#   SQL (scale + save)
#      ↓
#   Tableau (deliver + share)
#      ↓
#   Business decision
#
# Each tool does one thing well:
# - Excel: fast, flexible, universal
# - SQL: scalable, repeatable, auditable
# - Tableau: interactive, visual, shareable
#
# Do not compare them. Combine them.

# The interview question:
# "How would you build a dashboard for our sales team?"
# The answer is not "with Tableau" or "with Excel".
# The answer is: "Excel or SQL to prepare the data,
#                Tableau to deliver the dashboard,
#                and a refresh schedule to keep it current."