Power BI

Power BI for dashboards, reports, and data modeling.

Core concepts

• Data model — Relationships, star/snowflake schemas
• DAX — Calculated columns, measures, and time intelligence
• Power Query — ETL and data shaping before load
• Report vs dashboard — Reports are interactive; dashboards are pinned visuals

Quick tips

• Use measures over calculated columns when possible (better performance)
• Time intelligence (DATEADD, SAMEPERIODLASTYEAR) requires a proper date table
• Row-level security (RLS) filters data by user role
• Power Query steps are applied in order; optimize for readability and reuse