O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Learning Microsoft Power BI

Learning Microsoft Power BI

by Reid Havens
Publisher: Packt Publishing
Release Date: October 2018
ISBN: 9781789347104
View table of contents
Start watching

Video Description

Create insightful dashboards with the help of interactive reports and compelling visualizations to analyze your data more effectively

About This Video

  • Connecting to, cleaning, and shaping your data using the Query Editor
  • Building a multidimensional data model using Power BI Desktop
  • Using modern visualization techniques to build a report and dashboard for PowerBI.com

In Detail

Tell your data story with Power BI and reach millions of users with a single click on any kind of a device. Using Power BI, you can combine your data sources, create stunning visualizations, and embed your story on your website within seconds. The goal of this course is to teach you how to use raw data, monitor it, and visualize it in a form that will provide rich insights with the help of dashboards.

You will start with a set of business requirements for an example project from a client. Initially, you will connect to a data file. You'll run through the process of connecting to your data, transform it, and then build the data model. This will help you understand and determine which DAX calculations are needed to meet the business requirements. Finally, you will build out an interactive and functional report and a detailed dashboard, and publish them on PowerBI.com.

When it comes to learning Power BI, this course will ensure that you have the necessary tricks of the trade for effective insights and simplified visual analytics.

Table of Contents

  1. Chapter 1 : Project Requirements and Getting Data
    1. The Course Overview 00:02:16
    2. What Is the Flow of Report Development for a Business Analyst? 00:04:03
    3. Reviewing Project Requirements and Determining Data Sources 00:03:54
    4. Connecting to (Almost) Any Data Source with Power Query 00:05:32
    5. Importing Data and Power Query Fundamentals 00:08:35
    6. Connecting to a Folder as a Data Source 00:07:45
    7. Table Types and Relational Data Modeling 00:05:31
  2. Chapter 2 : Common Data Transformations
    1. Common Data Transformations with Power Query 00:11:32
    2. Intelligent Data Filtering with Power Query 00:07:45
    3. Adding New Columns with Power Query 00:10:52
    4. Merging Tables with Power Query 00:12:56
  3. Chapter 3 : Data Modeling and Relationships
    1. Creating Table Relationships in Power BI 00:09:34
    2. Understanding the Data View in Power BI 00:05:04
    3. Column Settings and Hierarchies In Power BI 00:08:24
  4. Chapter 4 : Data Analytics with DAX Measures
    1. Translating Report Requirements into DAX Measures 00:03:17
    2. Report View Walkthrough 00:03:59
    3. DAX Concepts and Fundamentals 00:02:44
    4. Creating Basic DAX Measures 00:10:06
    5. Creating a DAX Measures Table 00:05:00
    6. Referencing DAX Measures 00:06:47
  5. Chapter 5 : Data Visualization and Modern Reporting
    1. Visual Cues and Chart Types 00:05:31
    2. Creating Visualizations – Matrix Table 00:09:02
    3. Creating Visualizations – Running Total Chart 00:11:36
    4. Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %) 00:13:34
    5. Creating Visualizations – Conditional Formatting and Waterfall Charts 00:09:39
    6. Creating Visualizations – Card Visualizations and Title Section 00:09:25
    7. Slicers and Filter Settings 00:08:37
    8. Formatting and Report Design 00:08:16
  6. Chapter 6 : Report Publishing and the Power BI Service
    1. Publishing a Report to the Power BI Service 00:04:09
    2. Creating an App Workspace 00:04:56
    3. Creating a Dashboard 00:07:11
    4. Setting Up Scheduled Refreshes 00:05:57
    5. Learning Microsoft Power BI: Course Completed 00:01:47