Microsoft Power BI: The Complete Guide

Connect to data sources in Power BI, load the races CSV from the Formula One dataset using delimiter comma, and transform it with the Power Query editor to promote headers.

Explore splitting and extracting information from columns in the Power Query Editor for Power BI, including delimiters, whitespace, leftmost or all occurrences, and date components.

Master simple mathematical operations in Power BI, including adding to a column, subtracting across columns, and calculating averages. Apply row-level versus column-level statistics like sum and median.

Learn to duplicate a column, add an index column with configurable start and increment, and build conditional columns with top-to-bottom clause evaluation in Power Query editor.

Refresh the source data in the Power Query editor to update transformations, manage remove blank rows and top rows, and handle header changes without altering the original source.

Append queries in the Power Query editor to combine multiple tables with matching columns into a single table. Use append options and careful renaming to keep columns aligned.

discover how to transpose a table in Power Query Editor, reverse rows, and count rows to obtain a scalar value, with a hands-on dummy table example.

Import a tab-delimited driver text file, transform data by removing unused columns, merging forename and surname, replacing backslashes with nulls, and setting correct data types to load the drivers table.

Load the constructors csv, transform and clean it by removing address and url columns, and rename columns to underscore formats like constructor_id and nationality, and save the query as constructors.

Explore the group by operation in Power Query Editor to aggregate data by one or more columns, applying functions like count, sum, average, min, and max.

Learn to pivot and unpivot in Power Query Editor by turning a city column into columns with sales as values, creating a matrix, and then reversing it with an unpivot.

Download the Power BI file for part one from GitHub, and modify the query editor source steps to point to local data files for all five queries to enable refresh.

Relate tables in the model view of API, define relationships and cardinality, distinguish active and inactive relationships, and apply the start and snowflake schema to enable visualizations and charts.

Explore many to many cardinality in Power BI by building a bridge table in Power Query and configuring cross-filter direction to filter both tables.

Establish in Power BI a one-to-one relationship by linking two tables on unique race ID values and setting cross filter direction to both, then remove the bridge table.

Explore Power BI relationships using the auto detect feature to create and restore connections, and manage active versus inactive states to keep visuals accurate.

Learn to merge multiple tables in Power BI by linking on the common driver id, and apply left, right, full, inner, and anti-joins, handling matches, nulls, and duplicates.

Download the part two Power BI desktop file by visiting the GitHub repository, locating the Formula One Analysis Project Part Two folder, then clicking into it to download.

Explore visualizations, create your first visuals, and study main chart types with extensive examples as you build a Formula One report dashboard.

Create and compare table and matrix visuals in Power BI, sort by columns, drill down into constructors and drivers, and apply conditional formatting, sparklines, and total points aggregation.

Master bar and column charts in Power BI, including stacked and clustered visuals with axes and legends; apply 100% stacking and filtering to build a country Grand Prix race count.

Explore how report page visualizations interact through cross-filter and cross-highlight, adjust interactions with filter or highlight, and synchronize slicers to unify selections.

Explore small multiples to create separate visualizations by a chosen dimension. Duplicate pages, and switch between small multiple grid and table to add rows or columns for each country.

Explore line charts, area charts, and ribbon charts in Power BI, visualizing trends over time with date hierarchies, secondary axes, and rank changes among drivers.

Build and analyze a combo chart combining a line and a column chart to show points and races, and fix cross-filter direction from single to both in the data model.

Add bookmarks to save and restore a report state, using the bookmark pane to name states and quickly return to a selected filter.

Apply best practice tips to design a Power BI report for a sports blog, comparing Formula One drivers and constructors by race wins and podiums, with map visuals.

Explore the Power BI Pro interface to manage datasets, reports, dashboards, and workspaces in Power BI online, install apps, and collaborate across personal and organizational content.

Discover dashboards in Power BI service, a page that tells a story with tiles pinned from reports, movable and resizable, with options to add text, web content, images, and videos.

Learn how to refresh a power bi dataset by configuring an on-premises data gateway, installing a personal gateway, signing in to credentials, and scheduling daily or weekly refreshes.

Explore Power BI filter functions, using calculate and filter to sum unit sold by region, such as North America, and compare their effects on filter context and all().

Download the Power BI desktop file for part five from the GitHub folder at GitHub.com slash Malavika one slash power BI, click into the part five folder and download.