
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.
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.
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.
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.
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.
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.
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.
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.
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.