📉 Data Analytics — Visualisation Guide

Visualisation Tools — Tableau & Power BI Complete Guide

“A picture is worth a thousand rows.” Data visualisation transforms numbers into visual stories that anyone can understand — from the CEO to the frontline manager. Tableau and Power BI are the industry’s two most dominant tools. This guide teaches you both, from first chart to published dashboard.

▶ Tableau vs Power BI — Which Should You Learn?

🎯 Verdict for India: Learn Power BI first — it’s free (Desktop), integrates with Excel and Teams, and is the #1 requested tool in Indian job descriptions. Learn Tableau if you’re targeting global companies or consulting firms.

🔷 Tableau — Core Concepts & Chart Types

Tableau works with a simple drag-and-drop interface. Understanding its building blocks is all you need to start creating:

• 📦 Data Source: Connect to Excel, CSV, SQL Server, Google Sheets, Salesforce. Tableau creates an extract (.hyper file) for performance.
• 📐 Dimensions vs Measures: Dimensions = Blue pills (text/date — slice your data). Measures = Green pills (numbers — aggregate your data). Drag blue to Rows, green to Columns to start a chart.
• 📊 Show Me panel: Tableau suggests chart types based on what you’ve dragged. Select fields → click Show Me → choose the best chart.
• 🧮 Calculated Fields: Create new metrics: SUM([Revenue]) / SUM([Units]) = Average Selling Price. Use IF/THEN logic: IF [Profit] > 0 THEN "Profitable" ELSE "Loss" END
• 🎨 Chart Types: Bar (comparison), Line (trend over time), Scatter (correlation), Map (geographic), Treemap (part-of-whole), Gantt (project timelines), Bullet (KPI vs target)

💡 Example — Sales Dashboard in Tableau:

🔷 Power BI — Reports, Dashboards & DAX

Power BI has 3 key components: Power BI Desktop (build reports), Power BI Service (publish & share online), and Power BI Mobile (view on phone). The workflow:

📥 Get Data  →  🔧 Transform (Power Query)  →  🔗 Model (Relationships)  →  🧮 DAX Measures  →  📊 Visuals  →  🌐 Publish

• 📥 Get Data: Connect to Excel, SQL Server, SharePoint, Web, Azure, REST APIs. Over 150 connectors available.
• 🔧 Power Query: The ETL engine inside Power BI. Remove columns, filter rows, split text, unpivot, merge tables — all without writing code (M language behind the scenes).
• 🔗 Data Model: Create relationships between tables — like a database. Star schema is best practice: one Fact table surrounded by Dimension tables.
• 🧮 DAX (Data Analysis Expressions): The formula language of Power BI. Used to create calculated columns and measures.

💡 Essential DAX Formulas:

🔷 Dashboard Design Principles

• 🎯 One question, one dashboard: Don’t cram everything. Each dashboard should answer ONE business question (“How is sales performance this month?”).
• 👁️ Visual hierarchy: Most important KPI at top-left (eye reads left to right, top to bottom). Use large numbers for headline KPIs, smaller charts for detail.
• 🎨 Colour rules: Use max 3–4 colours. Red = bad/negative, Green = good/positive, Blue/Grey = neutral. Never use colour just for decoration.
• 📊 Right chart for the right data: Bar for comparison | Line for trend | Scatter for correlation | Pie for proportion (max 5 slices) | Card for single KPI | Table for detailed lookup
• 🚫 Avoid: 3D charts (distort perception), pie charts with many slices, too many gridlines, dark backgrounds with small text, unexplained abbreviations
• 📱 Mobile view: Power BI has a mobile layout view — always design it. Executives check dashboards on phones.

🔷 Data Storytelling with Visuals

Data storytelling is the art of combining data + visuals + narrative to drive decisions. A chart with no context is just a picture. A chart with a title, annotation, and call-to-action is a business tool.

📊 Chart  +  📝 Context  +  🎯 Insight  +  ✅ Action = 💡 Data Story

• Bad title: “Monthly Revenue Chart” → Good title: “Revenue fell 23% in March — driven by supply chain disruption in South region”
• Add annotations: Mark the exact point on the line chart where the drop occurred. Add a text box explaining the reason.
• Waterfall charts: Perfect for showing “bridge” analysis — starting value, each driver of change, ending value. Use in P&L variance presentations.
• Executive summary card: Always start a report with 3–5 KPI cards: Revenue | Profit | Growth % | Top Product | Risk Flag. Execs make decisions from the summary card, not the detail.

✅ Publishing & Sharing Reports

• 🌐 Power BI Service (app.powerbi.com): Publish from Desktop → Share with colleagues → Schedule automatic data refresh (daily/hourly). Free with Microsoft 365 licence.
• 📧 Subscribe & Email: Set up email subscriptions so stakeholders receive a snapshot of the dashboard at 8 AM every Monday — automatically.
• 🔗 Embed in Teams / SharePoint: Power BI reports can be embedded directly into Microsoft Teams channels or SharePoint pages — no separate login needed.
• 🌍 Tableau Public: Free hosting for public dashboards at public.tableau.com. Great for portfolio building — recruiters can see your live dashboards.
• 🔒 Row-Level Security (RLS): Restrict what each user sees — e.g., Regional Manager only sees their region’s data, even though it’s one report. Set up in Power BI or Tableau Server.