
Discover Power BI data flow from external data to online service through Power Query Editor, Power BI Desktop, and publishing to workspaces and dashboards, covering data sources, relationships, and DAX.
Download the free Power BI desktop from the Microsoft site. Install the setup, meet the 16 GB RAM minimum, and note the free online service has limited capabilities.
Explore the Power BI Desktop interface, from creating and opening reports to navigating the canvas, report, table, model, DAX, and tabular model views, with visuals, slicers, and data tools.
Explore external data sources and Power BI workflows, perform ETL with Power Query, and transform, clean, and load CSV and Excel data into the data model for Big Baker case.
Learn how to connect to data sources in Power BI by loading CSV and Excel files, creating a PBIX file, and loading customer and group tables into a data model.
Learn row operations in Power BI by adding a product table, removing blank rows, using the first row as headers, and applying a simple filter to enhance data modeling.
Clean a Power BI data model by removing unused columns, adjusting data types, splitting the audit timestamp into date and time, and replacing small x with small.
Day 3 covers combining common table and data operations, adding sales data via folder load, and creating a calendar table in the query editor within Power BI Desktop.
Compare merge and append operations to combine tables in Power BI, and learn loading yearly sales files into a single table or via folder-based automatic updates.
Learn to manage date formats in Power BI, handle UK and US styles, and avoid load errors by adjusting locale; then create a custom date table and split date time.
Explore data relationships and schemas in Power BI, linking the calendar to sales, and compare star versus snowflake designs to optimize a central fact table with dimension tables.
Explore Power BI Desktop coding tools, including M-Code in the query editor, and extend with DAX to develop measures, filtering, and calculate functions for advanced reporting.
Compare mCode and DAX in Power BI, and learn to create mCode in the query editor and DAX expressions for calculations in the Big Baker data model.
Explore how measures deliver dynamic scalar values in power bi, compare them with calculated columns, and learn to create, group, and move measures into a dedicated measure table.
Create and use DAX measures with filter and calculate to break down total sales by country—England, France, USA, and others—and verify card visuals with a year slicer.
Explore logic functions in Power BI using DAX switch and if statements to categorize sales transactions into small, medium, and large by creating a new column in the sales table.
Learn to build report pages in Power BI, create visuals in the report view on Power BI Desktop, connect to BigBaker data model, and apply formatting for the desired appearance.
Build a Power BI sales summary page by creating visuals, adding a header and image, and configuring year and month slicers, while managing pages and z-order.
Develop and complete sales summary report in Power BI by adding cards and charts, formatting totals like total sales and gross margin, and arranging visuals for month, day, and product.
Extend the Day 5 report in Power BI dataflow using the desktop, add two pages, navigation buttons, drill-through, and bookmark-driven slice clears, preparing the report for publishing.
Learn to build navigation with buttons, synchronize year and month slicers across pages, add detail tables, and implement clear slices for sales by country and group.
Create drill-through buttons from pie charts, set drill-through pages for sales by group and country, use bookmarks, and a return button to clear filters.
Introduce the Big Baker personnel report to publish a multi-report dashboard. Examine the summary and drill-through pages, and prepare to publish to the Power BI online service.
Publish your reports to the online service, set up a free online Power BI account, and explore workspaces, dashboards, and business integration options.
Create a free online Power BI account, log in, and learn how workspaces store reports, semantic models, dashboards, data, and apps; publish reports from desktop or create them in service.
Publish reports from Power BI Desktop to the Power BI Service, log in to My Workspace, and explore semantic model online with a free account; paid subscriptions enable commercial use.
Learn how Power BI workspaces organize reports, differentiate paid licenses from free My Workspace, and build dashboards with tiles by pinning visuals and assigning admin, member, contributor, or viewer roles.
Discover how to deploy and share Power BI reports in a business environment by using Power BI service, apps, Teams sharing, PowerPoint embeds, Excel ad hoc reporting, PDFs, and subscriptions.
Wrap up a seven-day introduction to Power BI Desktop and Online by guiding new and existing users to refresh knowledge, engage with reviews, and pursue excellent data analysis and reporting.
This video series is a concise jump start into Power BI.
Over seven days we run through all that is needed to start using Power BI.
Day 1 : An introduction to the environment describing the different tools used to
create our reports and the roles they play.
We then look at how to download the free desktop environment.
We also look at the data for our sample model, "The Big Baker".
Day 2 : The Query editor. We run through the basics of preparing data for use in our data model. We look at the basics of creating an Extract, Transform, Load (ETL) process.
Day 3 : Tables and Data Relationships. Extending our work with the query editor we enhance our tables and create table relationships. We look at different schema types and Microsoft recommended approach to schema design.
Day 4 : Dax Functions. We add functionality to be used in visuals with Measures and additional column functions. We look at common Dax functions including Date, Filter and Logic functions.
Day 5 : The report view. We create a basic Summary Report Page.
We do a rapid build of a Sales summary page that includes common visuals and then run through positioning and formatting them.
Day 6 : The report view. We continue developing our Sale report with the use of buttons and drill-throughs.
Day 7 : The Power BI Service. We look at publishing to and using the Power BI online service. We create a dashboard and look at other key features of the service.