Introduction to Microsoft Power BI (Video)

Introduction to Microsoft Power BI (Video)

by Chris Sorensen
Released May 2021
Publisher(s): Microsoft Press
ISBN: 013745631X

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Video description

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.

Visit the author's GitHub site to download companion files: https://github.com/IterationInsights/Microsoft-Press-Introduction-to-Microsoft-Power-BI.

About the Instructor

Chris Sorensen CPA, CGA, is the Founder and President of Iteration Insights, a tech-enabled data analytics solutions provider based in Calgary, Alberta. In his career, he has led numerous Analytics projects in more than 15 industries across small to enterprise-sized organizations.

He is a Microsoft Certified Data Analyst Associate and Microsoft Certified Trainer with a combined 20+ years of industry-solution delivery and teaching experience. He has evangelized both Excel and Power BI with Microsoft since July 2015 and is the author of the Microsoft Press Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel and co-author of Data Analysis Fundamentals with Excel (Video) published by Microsoft Press.

Skill Level
  • Beginner-Intermediate
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

  1. Introduction
    1. Introduction to Microsoft Power BI: Introduction
  2. Lesson 1: Getting started with Power BI
    1. Learning objectives
    2. 1.1 Introduce the Data Lifecycle
    3. 1.2 Introduce the Power BI environment
    4. 1.3 Introduce Power BI licensing
    5. 1.4 Introduce Power BI release cycles
    6. 1.5 Set up your environment
  3. Lesson 2: Importing and transforming data using Power Query Editor
    1. Learning objectives
    2. 2.1 Navigate the Power Query Editor
    3. 2.2 Explore data sources
    4. 2.3 Load data from a website
    5. 2.4 Load data from files
    6. 2.5 Load a folder of data
    7. 2.6 Explore data source settings
    8. 2.7 Rename columns and set data types
    9. 2.8 Reduce rows
    10. 2.9 Manage columns
    11. 2.10 Append queries
    12. 2.11 Add columns
    13. 2.12 Merge queries
    14. 2.13 Transform and cleanse data
    15. 2.14 Organize and manage queries
  4. Lesson 3: Building a Data Model to support self-service reporting
    1. Learning objectives
    2. 3.1 Navigate the Power BI Desktop
    3. 3.2 Introduce Dimensional Modeling
    4. 3.3 Create relationships and manage settings
    5. 3.4 Modify column properties
    6. 3.5 Modify column formatting
    7. 3.6 Create hierarchies
    8. 3.7 Introduce DAX
    9. 3.8 Create basic DAX expressions
    10. 3.9 Understand contexts
    11. 3.10 Introduce time intelligence
    12. 3.11 Introduce CALCULATE
    13. 3.12 Introduce quick measures
    14. 3.13 Discuss data model cleanup
  5. Lesson 4: Developing reports and visualizations using the Power BI Desktop
    1. Learning objectives
    2. 4.1 Navigate the Power BI Desktop report view
    3. 4.2 Use a page background and theme
    4. 4.3 Create a clustered column chart
    5. 4.4 Create a funnel chart
    6. 4.5 Explore drill through
    7. 4.6 Create a line chart
    8. 4.7 Explore drill down
    9. 4.8 Create a card and KPI visualization
    10. 4.9 Create slicers
    11. 4.10 Explore the filter pane
    12. 4.11 Edit interactions between visuals
    13. 4.12 Create bookmarks
    14. 4.13 Explore the structure of a pbix file
  6. Lesson 5: Enhancing the experience in the Power BI Service
    1. Learning objectives
    2. 5.1 Publish to my workspace
    3. 5.2 Explore the Power BI Service
    4. 5.3 Create a report in the Power BI Service
    5. 5.4 Build a dashboard
    6. 5.5 Explore Power BI Mobile
    7. 5.6 Configure tiles
    8. 5.7 Use quick insights
    9. 5.8 Setup and use Q
    10. 5.9 Set alerts on a tile
  7. Lesson 6: Securing, Sharing and Collaborating using the Power BI Service
    1. Learning objectives
    2. 6.1 Share dashboards and reports
    3. 6.2 Explore comments in reports and dashboards
    4. 6.3 Setup row level security
  8. Summary
    1. Introduction to Microsoft Power BI: Summary

Product information

  • Title: Introduction to Microsoft Power BI (Video)
  • Author(s): Chris Sorensen
  • Release date: May 2021
  • Publisher(s): Microsoft Press
  • ISBN: 013745631X