Power BI and Python for Advanced Analytics and BI (22Hours)

Learn how to perform ETL in Power BI by extracting data from sources via Power Query, transforming and cleaning data, and loading it into the Power BI model for reporting.

Learn how dimension tables provide descriptive context and how fact tables store numerical data, linked by keys, with examples in Power BI showing date, region, and category hierarchies for analytics.

Explore how star schema and snowflake schema organize data with fact and dimension tables, and compare normalization, denormalization, hierarchies, space use, and query performance.

Learn to extract data in Power BI using import mode and direct query mode, comparing internal data model storage vs live data from the source and applying size-based mode selection.

Explore power query parameters in Power BI to dynamically filter data with reusable values, create and manage parameters, and apply them to fields like order priority and order quantity.

Create a dynamic calendar table using start and end date parameters, generate dates with list.dates and duration days in Power Query, then convert to a dim date with date parts.

Demonstrate creating an index in Power Query and applying group by in Power BI to summarize SQL Server data by vendor and region, calculating distinct invoice count, profit, and sales.

Derive a conditional column in Power Query to generate a priority code from order priority values in Power BI, using H001, M001, and L001, or no code for unmatched values.

Design a custom column in Power Query to apply conditional tax calculations based on order priority, using if-else logic in M query within Power BI.

Learn how to apply visual level, page level, report level, and drill through filters in Power BI to control visuals, pages, and drill through behavior across multiple pages.

Use Power BI slicers as canvas filters to apply filters. Link slicers to region and product category to control sales, discounts, and shipping costs.

Learn how to configure and customize Power BI slicers, use distinct slicer types and settings, and sync a single slicer across multiple pages to create dependent filters.

Use edit interactions in Power BI to control slicers and filter only selected visuals. Set visuals to none to prevent filtering of unselected data.

Learn to create a basic Power BI tooltip that shows vendor, total invoice amount, and tax amount on hover, using data from Excel orders and invoice tables.

Explore how to use Power BI's selection pane to hide and unhide visuals, manage layout of cards, tables, charts, and slicers, and prepare visuals for bookmarks.

Create and use bookmarks in Power BI to save report states, toggle between total sales, table data, and charts, and assign bookmarks to buttons for guided navigation.

Create dynamic reference lines in Power BI to compare actual values with targets, including min, max, and average lines, with calendar table and region-based charts.

Master conditional formatting in Power BI by applying rules, colors, and data bars to region and profit data; create color mappings and interactive visuals through data modeling.

Create a range parameter in Power BI to forecast sales, connect it to a slicer, and build a forecast measure using a dim date and key measure table.