Live Updates
Initializing JARVIS Data Stream... Synchronizing Feeds...
Important

Anti-Fraud Alert: This portal does not charge any service fees from candidates. All services provided here are 100% Free of Cost. Please stay cautious of unauthorized individuals asking for money.

Tableau & Visual Analytics – Complete Masterclass Notes

📊 Tableau & Visual Analytics Masterclass

Business Intelligence Architecture, Dimensions vs Measures, Discrete vs Continuous, Level of Detail (LOD) Calculations, Dual-Axis Visuals aur Interactive Executive Dashboards ka complete guide.

Module 01

1️⃣ Tableau Product Suite & Core Architecture

Definition: Tableau (Salesforce dwara owned) duniya ka leading visual analytics aur data exploration platform hai jo query language VizQL use karta hai. VizQL drag-and-drop actions ko directly backend relational/cloud database queries me translate karta hai.

Tableau Product Deployment / Role Key Responsibility
Tableau Desktop Authoring Client (PC/Mac) Workbooks, complex calculations aur rich dashboards build karna.
Tableau Prep Builder ETL Tool Data clean, shape, pivot aur merge karna visualization se pehle.
Tableau Server / Cloud Enterprise Hosting (Cloud/On-prem) Dashboards secure publish karna, automatic schedule refresh aur team collaboration.
Module 02

2️⃣ Dimensions vs Measures & Blue vs Green Pills

Tableau data fields ko do alag angles se categorize karta hai:

Categorization What It Represents Color in Tableau Visual Outcome
Dimension Qualitative / Categorical context (Names, Regions, Dates) Blue or Green depending on continuity Adds headers, slices data granularity.
Measure Quantitative / Numerical data (Sales, Profit, Quantity) Blue or Green depending on continuity Aggregates into an axis ($O(1)$ dynamic math).
Discrete (Blue) Individually separate values (Categories) Blue Pill Creates discrete Row/Column Headers.
Continuous (Green) Unbroken infinite scale (Trend axis) Green Pill Generates continuous Numeric/Time Axis.
Module 03

3️⃣ Connecting Data: Physical Layer vs Logical Layer

  • Relationships (Logical Layer - Orange Noodle): Smart, context-aware connection jo multiple tables ke alag-alag level of detail ko maintain rakhta hai bina row duplication kiye.
  • Joins (Physical Layer): Traditional SQL Inner, Left, Right aur Full Outer joins jo data ko flat physical table me combine karte hain.
  • Live Connection vs Data Extract (.hyper):
    • Live: Real-time database queries shoot karta hai.
    • Extract: High-speed in-memory columnar extract jo complex dashboards ko ultra-fast render karta hai.
Module 04

4️⃣ Essential Visuals & Dual Axis Charts

Dual Axis Chart: Do alag-alag metrics ko single chart space me combine karna (e.g. Bar chart for Sales + Line chart for Profit Ratio):

// Calculated Field: Profit Ratio
SUM([Profit]) / SUM([Sales])

// Formatting as Percentage:
// Right-click Profit Ratio → Default Properties → Number Format → Percentage (1 decimal)
Synchronize Axis: Dual-axis banate waqt secondary axis par right-click karke hamesha "Synchronize Axis" check karein taaki data comparison accurate rahe.
Module 05

5️⃣ Level of Detail (LOD) Calculations

LOD expressions current view ke dimension level se independent hokar granular math execute karte hain:

LOD Expression Syntax Structure Behavior / Use Case
FIXED { FIXED [Region] : SUM([Sales]) } Current visual dimensions ko ignore karke strictly specified dimension par calculate karta hai.
INCLUDE { INCLUDE [Customer ID] : AVG([Sales]) } Current visual me present dimensions ke alawa aur deep granularity add karta hai.
EXCLUDE { EXCLUDE [Sub-Category] : SUM([Sales]) } Current view me maujood kisi specific dimension ko calculation se drop karta hai.
Live Tableau VizQL & LOD Engine Simulator
[VizQL Engine]: Ready. View Granularity: [Category] × [Sub-Category] | Active Filters: None
Module 06

6️⃣ Parameters, Sets & Dynamic Interactivity

  • Parameters: Workbook-wide global dynamic variable (e.g. "Top N Customers", "Select Currency Converter") jise user interactive slider se change kar sakta hai.
  • Sets: Data points ka custom subset jo specific conditions ke basis par IN ya OUT categorize hota hai (e.g. Customers with Sales > ₹1,00,000).
  • Bins & Histograms: Continuous measures ko discrete equal groups me tod kar frequency distribution chart banana.
Module 07

7️⃣ Interactive Dashboards & Filter Actions

Executive analytics ke liye multi-worksheet interactive layout build karna:

Tableau Dashboard Actions:
• Filter Action: Kisi bar chart ke segment par click karne par poore dashboard ke doosre charts dynamically filter ho jaate hain.
• Highlight Action: Matching categories ko bright highlight karta hai jabki baaki elements dim ho jaate hain.
• Go to URL Action: Clicked data point ke parameters ke sath external CRM ya ticketing link open karna.

Latest Vacancies