Microsoft Power BI Mastery: From Beginner to Intermediate

Import and combine four csv sales files from a folder into Power BI Desktop, prep with Power Query by splitting product and location and cleaning data, then load SalesPrep.

Import data from Excel workbooks and text files, preview tables and sheets, refine queries in the Power Query Editor, and load results into Power BI.

Learn to fix missing query sources in Power BI by editing the Source step in Power Query editor, browse to the new file location, and apply changes to refresh queries.

Create a location lookup table from the SalesPrep fact table by referencing it, removing unused columns, adding a Location ID index, and loading the table into the model.

Create sales fact table by merging queries in Power Query, using left outer joins to bring location and product IDs as foreign keys, then load into the Power BI model.

Prevent the SalesPrep table from loading in Power BI Desktop to reduce clutter and load times, using the Power Query editor to disable load and apply changes.

Engage in a hands-on practice exercise to get and transform data in Power BI, following file 2-6 instructions and comparing your work with the complete version.

Build one-to-many relationships between sales and product, location and country to filter visuals correctly; use model view and drag-and-drop to create and verify relationships.

Create a dynamic dates table with DAX using the calendar function, driven by the min and max dates from the sales data to power time intelligence and date fields.

Create additional date columns in the dates table with DAX calculated columns, including year, month number, month name, day, weekday number, weekday name, and IsWeekend.

Learn how to sort month and weekday names in Power BI by using sort by column and month number or weekday number, ensuring correct chronological order in reports.

Mark the date table in Power BI by selecting the dates table in data view, clicking mark as date table in the Table Tools ribbon, and choosing the date column.

Switch to model view to hide unnecessary fields in sales and products, decluttering the field list and streamlining reporting while establishing a relationship with the dates table.

Engage in the data modeling practice exercise for power bi by opening the 3-7-practice-exercise file, following the instructions, and comparing your results with the completed version to verify your work.

Create and test a DAX measure to sum the sales.amount column, format as pound sterling with two decimals, and reuse the measure across visuals while illustrating table relationships.

Create a measure called number of orders using the count rows function on the sales fact table, then test it in a visual with total revenue.

Use the CALCULATE function to create conditional revenue totals, including weekend and non-weekend, by reusing the total revenue measure and adjusting filter context with IsWeekend.

Create a measure to calculate total revenue from the previous year using sameperiodlastyear and calculate, supported by a dates table and time intelligence visuals.

Calculate year over year revenue changes by creating measures for total revenue difference and its percentage using the safe divide function, and display results in a table visual.

Practice exercise for the introduction to DAX measures module guides you through opening the 4-6 Power BI file, following the instructions, and checking your measures against the complete version.

Create and format card visuals in a Power BI report page named summary, dragging total revenue and number of orders, then adjust title, data labels, and borders.

Create a clustered column chart to compare total revenue by category, with tooltips for orders and data labels, and turn off the y axis and title.

Explore how to build a map visualization in Power BI to plot revenue by location, using country as location, total revenue as size, and interactive tooltips.

Explore how slicers filter report visuals in Power BI, using a date timeline, between and before/after options, and switch to year dropdowns with single or multi-select controls.

Learn to use a key performance indicator visual to compare this year's total revenue against the previous year, using DAX measures and a goal to track performance.

Replace the map with a line graph on the yearly variance report, plot total revenue by month using the year slicer, and enable tooltips with prev-year and year-diff data.

Explore the matrix visualization, a pivot-table style view, showing revenue by location and year for a selected country via the country slicer, with formatting and sorting by total.

Create a Power BI table visualization to show the top eight products by revenue for the selected country, using product name, total revenue, and orders, with a top N filter.

Follow the module's practice exercise to add visualizations to your Power BI report, using file 5-9-practice-exercise and compare against 5-9-practice-exercise-complete to verify your work, and have fun.

Insert shapes and a text box to create a banner, adjust the background to yellow, and use the selection pane to keep the slicer, banner, and header visible across pages.

Use Power BI themes to instantly standardize colors and fonts across visuals, explore and import JSON themes from the gallery, and customize or export for consistency.

Learn to apply conditional formatting in Power BI across tables, charts, and maps, using font color, icons, data bars, color scales, and custom rules for TotalRevenue.

Engage with the report design module's practice exercise by opening the 6-4-practice-exercise file, following instructions, and comparing your design with the completed version to sharpen Power BI skills.

Learn how to edit interactions between visuals in Power BI, choose between filter, highlight, or none, and tailor how charts, cards, map, and tables respond.

Explore the filter pane in Power BI to filter a visual, page, or all pages by fields like country, total revenue, and orders, with data filters and product filters.

Apply Power BI drill through to turn the By Country page into a detail view from the summary page, filtering by country via the map and a customizable button.

Master editing interactions and filters in Power BI through a guided practice exercise, following file 7-4 instructions and verifying your work against the completed version.

Publish your report to the Power BI service on powerbi.com and share it via workspaces. Log in to access and interact with filters and slicers in the browser.

Learn multiple ways to share Power BI reports, from export options and email sharing to embed codes, download, and analyze in Excel, with admin controls and licensing considerations.

Open the 8-3 Power BI file and publish the report to the Power BI service, signing up for a free account at powerbi.com if needed.

Apply the techniques from this Power BI introduction course to create stunning interactive reports, and continue learning with new features and DAX formulas through blogs and advanced courses.

Learn to import, transform, and analyze data in Power BI beyond the basics. Recap basics for Excel users and follow along to build reports and dashboards across two course halves.

watch this essential video to maximize your learning and access downloadable instructor files, with tips on unzipping, viewing in high definition, and adjusting playback speed.

Set up for success by reviewing six data files, configuring Power BI options, enabling auto-detect relationships, and adjusting regional settings before importing and tidying data in Power Query.