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.
Learn How To
Import and transform data in Power Query Editor
Build a data model that supports self-service analysis
Develop reports and visualizations using the Power BI Desktop
Enhance the experience in the Power BI Service
Secure, share, and collaborate on dashboards and reports using the Power BI Service
Who Should Take This Course Organizations increasingly expect employees to deliver data-driven insights as part of their job. This is almost everyone in an organization, including: Business users who need to level up their data knowledge and experience with business intelligence (BI) toolsBusiness analysts who need to work on end-to-end data analysis with Microsoft Power BI and develop best practices for building and sharing reports and visualizationsIT professionals or analysts who use Excel or other BI tools to analyze data and want to learn the foundations of how to deliver compelling, easy to maintain solutions using Power BI
Power BI Desktop installed on your machine
Access the Power BI service
Familiarity with Excel or data tables would be an asset
Table of Contents
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