- Published 5/21/2021
- 1st Edition
- Online video 978-0-13-745630-7
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.
Skill Level
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) tools
- Business 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 visualizations
- IT 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
Course Requirements
- 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
Introduction
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
