Microsoft Power BI for Beginners: Get Started with Power BI

Import and combine multiple CSV files from a folder in Power BI, transform data with Power Query, split product into product and location, and load the model.

Import data from an Excel workbook and a text file using Power Query Editor, inspect applied steps, and load the country, products, and salads prep tables into Power BI.

Learn to fix broken Power BI queries by editing the source path in Power Query Editor, browse to the new file location, and refresh to apply changes.

Normalize the model by creating a location lookup table from the sales prep query, referencing the source, removing duplicates, and adding an index column for fast Power BI queries.

Merge queries in Power Query to create a sales fact table by linking location and product data, expand and rename keys, and load the result into the Power BI model.

Learn how to prevent a query from loading into Power BI Desktop by disabling load for the sales prep table in Power Query Editor, reducing model clutter and load time.

Create relationships between fact and dimension tables in the model by dragging keys to establish one-to-many connections and verify filter directions, then use manage relationships to review or adjust links.

Create a dynamic date table in Power BI using DAX calendar to enable time intelligence, span the model’s full date range, and support custom fields.

learn how to mark a table as a date table in Power BI by selecting the date column in data view and confirming with OK.

Use model view to hide unused fields and declutter the report view, keeping only needed fields. Create key relationships, such as linking sales dates to the dates table.

Create a measure using countrows on the sales fact table to count all orders, format as a whole number with a thousand separator, and test in a monthly visual.

Use the CALCULATE function to total weekend and non-weekend revenue, reusing the base measure and applying the dates table weekend filter in Power BI, with results formatted as British pounds.

Compute the year-over-year revenue delta by creating total Rev year death and its percentage using divide with total Rev prev year, then format as pounds sterling, display in a table.

Practice exercise guides you through the introduction to Dax measures in Power BI, with a file to open and an answer version to check your measures against.

Create and format cards to show total revenue and number of orders, adjusting titles, data labels, units, and borders for a clean, consistent Power BI report.

Add a clustered column chart to your report to compare total revenue by category across years. Configure axes, legend, and tool tips; turn on data labels and apply consistent formatting.

Create and customize a Power BI map to plot revenue by location, sizing bubbles by total revenue, with tooltips and zoom, plus style options like road and light.

Explore slicer visualizations to filter Power BI reports, using a date timeline to adjust all visuals, with between, before, and after options, and switch between list and dropdown.

Replace the map with a line graph on the variance report, using month names on the axes from the dates table to show revenue trend, and tooltips for year-over-year revenue.

Showcase the matrix visualization, like a pivot table, to display revenue by year and location for a selected country, with curated formatting and sorting options.

Open file five high for nine practice exercise and follow the instructions to add visuals to your report; a completed version is available to check your work, enjoy.

Master conditional formatting in Power BI to highlight key values across tables, charts, and maps using color scales, data bars, and custom rules based on total revenue.

Tackle the practice exercise to edit interactions and filters in a Power BI report. Open the seven-for-practice-exercise file, follow the instructions, compare with the complete version, and have fun.

Publish your report to the Power BI service after signing in, choose a workspace, and share via browser access; explore interactivity with filters and slicers from anywhere.

Explore sharing options for your Power BI report, including export to PowerPoint or PDF, email sharing with a Power BI Pro license, pbix download, analyze in Excel, and embed codes.

Open the practice exercise to publish a Power BI report to the Power BI service, sign up for a free account at powerbi.com, then publish to the default my workspace.

Wrap up this Power BI introduction course, and create stunning interactive reports with knowledge from the course, while exploring new features and tax formulas as Power BI evolves.