← All tracks
Analysis & Visualization
Intermediate6–8 hrsComing soon
Raw data se pivot, model aur chart bana ke business question ka jawab de sakte ho.
This track's lessons are still being written.
M1 · Thinking in Data
20 minTidy data rules: one row = one observationSoon
Fact table vs dimension table — reporting ki neevSoon
Rows / Columns / Values / Filters — 4 boxes ka logicSoon
Value Field Settings: % of total, % of parent, running total, rank, difference fromSoon
Grouping: dates (month/quarter/year), numeric bins, manual groupsSoon
Calculated Fields aur Calculated Items — aur inke trapsSoon
Slicers aur Timelines, ek slicer se multiple pivots connect karnaSoon
Pivot ChartsSoon
GETPIVOTDATA — pivot se report cell bananaSoon
M3 · Power Query Basics
90 minPower Query kya hai aur formulas se better kab haiSoon
Import: CSV, folder (multiple files ek saath), web tableSoon
Core transforms: remove columns, split, change type, replace, fill downSoon
Unpivot — wide report ko analysable table me badalnaSoon
Merge (joins) vs Append — VLOOKUP ka scalable versionSoon
Query dependencies, staging queries, refresh settingsSoon
Common gotchas: locale/date errors, hardcoded file paths, type stepsSoon
Data Model aur relationships — multiple tables bina VLOOKUPSoon
Measures vs calculated columnsSoon
CALCULATE — DAX ka sabse important functionSoon
SUM vs SUMX (row context vs filter context)Soon
Time intelligence: YTD, MTD, same period last yearSoon
Chart choice matrix: trend / comparison / composition / distribution / relationshipSoon
Line, column, bar — aur pie chart kab use nahi karnaSoon
Combo charts aur secondary axis ka sahi useSoon
Scatter, histogram, waterfall, funnelSoon
Sparklines aur in-cell data barsSoon
Chartjunk hatao: gridlines, direct labels, axis truncation ethicsSoon
M6 · Dynamic Arrays
60 minSpill ranges aur # operatorSoon
FILTER — formula se live filtered tableSoon
UNIQUE, SORT, SORTBYSoon
SEQUENCE, RANDARRAY, TOCOL/TOROWSoon
LET — formula readable aur fast bananaSoon
LAMBDA basics — apna custom functionSoon
M7 · KPI Thinking
30 minLeading vs lagging indicators, vanity metrics se bachoSoon
MoM, YoY, CAGR, run rate — formulas aur interpretationSoon
Variance vs target, RAG status logicSoon
M8 · Capstone
45 minCapstone: 50k-row retail dataset — Power Query model + 4 pivots + 3 charts + insight summarySoon