Data Analysis

Power BI

Microsoft's flagship BI tool. Power BI Desktop vs Service vs Mobile vs Report Server, getting data (CSV, Excel, SQL Server, Snowflake, BigQuery, REST APIs, SharePoint, Dataverse), Power Query M language for ETL, merging & appending queries, data types & profiling, the data model (star schema, fact & dimension tables), relationships (one-to-many, many-to-many, bidirectional, USERELATIONSHIP), DAX language deep dive — calculated columns vs measures, row context vs filter context, CALCULATE, FILTER, ALL, ALLEXCEPT, time intelligence (TOTALYTD, SAMEPERIODLASTYEAR), variables & VAR, building reports (visuals — bar, column, line, area, pie, donut, treemap, map, matrix, table, KPI, gauge), bookmarks & drillthrough, sync slicers, custom visuals from AppSource, theming, mobile layouts, paginated reports (RDL), incremental refresh, gateways (on-prem & VNet), Power BI Service (workspaces, apps, datasets, dataflows, datamarts), row-level security (RLS) & object-level security, sharing & permissions, scheduled refresh, deployment pipelines, Power BI Embedded for ISVs, integration with Power Automate / Power Apps / Teams / SharePoint, Copilot for Power BI, certification (PL-300 Microsoft Certified Data Analyst Associate). 30 units, 450 lessons.