7+ Hours of Video Instruction
Discover how you can use Power BI to help your organization to become more data driven. Whether you are new to analytics or have been stuck preparing and delivering data using legacy BI tools, this video shows you how to use Microsoft Power BI with confidence.
In this video, learn ways to import data from various sources as well as how to transform and cleanse data prior to loading it to a report-ready, self-service-enabled data model. Create visualizations in the Power BI Desktop and then secure, share, and collaborate using the various features in the Power BI service.
Using his years of experience teaching Power BI to a variety of learners, Microsoft Certified Trainer Chris Sorensen explains the core concepts of Power BI to expose you to the most widely used features and functions in Power BI. He carefully explains the why behind using those features, not just the how. In his engaging style grounded in real-world scenarios, Chris gives you the confidence to navigate and build effective Power BI solutions, quickly and effectively. Build good habits and develop in your career as a business analyst or data-driven business user.
Lesson 1: Getting started with Power BI
Learning objectives 1.1 Introduce the Data Lifecycle 1.2 Introduce the Power BI environment 1.3 Introduce Power BI licensing 1.4 Introduce Power BI release cycles 1.5 Set up your environment Lesson 2: Importing and transforming data using Power Query Editor
Learning objectives 2.1 Navigate the Power Query Editor 2.2 Explore data sources 2.3 Load data from a website 2.4 Load data from files 2.5 Load a folder of data 2.6 Explore data source settings 2.7 Rename columns and set data types 2.8 Reduce rows 2.9 Manage columns 2.10 Append queries 2.11 Add columns 2.12 Merge queries 2.13 Transform and cleanse data 2.14 Organize and manage queries Lesson 3: Building a Data Model to support self-service reporting
Learning objectives 3.1 Navigate the Power BI Desktop 3.2 Introduce Dimensional Modeling 3.3 Create relationships and manage settings 3.4 Modify column properties 3.5 Modify column formatting 3.6 Create hierarchies 3.7 Introduce DAX 3.8 Create basic DAX expressions 3.9 Understand contexts 3.10 Introduce time intelligence 3.11 Introduce CALCULATE 3.12 Introduce quick measures 3.13 Discuss data model cleanup Lesson 4: Developing reports and visualizations using the Power BI Desktop
Learning objectives 4.1 Navigate the Power BI Desktop report view 4.2 Use a page background and theme 4.3 Create a clustered column chart 4.4 Create a funnel chart 4.5 Explore drill through 4.6 Create a line chart 4.7 Explore drill down 4.8 Create a card and KPI visualization 4.9 Create slicers 4.10 Explore the filter pane 4.11 Edit interactions between visuals 4.12 Create bookmarks 4.13 Explore the structure of a pbix file Lesson 5: Enhancing the experience in the Power BI Service
Learning objectives 5.1 Publish to my workspace 5.2 Explore the Power BI Service 5.3 Create a report in the Power BI Service 5.4 Build a dashboard 5.5 Explore Power BI Mobile 5.6 Configure tiles 5.7 Use quick insights 5.8 Setup and use Q&A 5.9 Set alerts on a tile Lesson 6: Securing, Sharing and Collaborating using the Power BI Service
Learning objectives 6.1 Share dashboards and reports 6.2 Explore comments in reports and dashboards 6.3 Setup row level security Summary