Learning Microsoft Power BI

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.

Audience

This video is for BI professionals, developers, engineers, IT Managers, or power users who want to gain insights from their business data using Microsoft Power BI.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Project Requirements and Getting Data
    1. The Course Overview
    2. What Is the Flow of Report Development for a Business Analyst?
    3. Reviewing Project Requirements and Determining Data Sources
    4. Connecting to (Almost) Any Data Source with Power Query
    5. Importing Data and Power Query Fundamentals
    6. Connecting to a Folder as a Data Source
    7. Table Types and Relational Data Modeling
  2. Chapter 2 : Common Data Transformations
    1. Common Data Transformations with Power Query
    2. Intelligent Data Filtering with Power Query
    3. Adding New Columns with Power Query
    4. Merging Tables with Power Query
  3. Chapter 3 : Data Modeling and Relationships
    1. Creating Table Relationships in Power BI
    2. Understanding the Data View in Power BI
    3. Column Settings and Hierarchies In Power BI
  4. Chapter 4 : Data Analytics with DAX Measures
    1. Translating Report Requirements into DAX Measures
    2. Report View Walkthrough
    3. DAX Concepts and Fundamentals
    4. Creating Basic DAX Measures
    5. Creating a DAX Measures Table
    6. Referencing DAX Measures
  5. Chapter 5 : Data Visualization and Modern Reporting
    1. Visual Cues and Chart Types
    2. Creating Visualizations – Matrix Table
    3. Creating Visualizations – Running Total Chart
    4. Creating Visualizations – Column and Line Chart (Year-Over-Year Profits %)
    5. Creating Visualizations – Conditional Formatting and Waterfall Charts
    6. Creating Visualizations – Card Visualizations and Title Section
    7. Slicers and Filter Settings
    8. Formatting and Report Design
  6. Chapter 6 : Report Publishing and the Power BI Service
    1. Publishing a Report to the Power BI Service
    2. Creating an App Workspace
    3. Creating a Dashboard
    4. Setting Up Scheduled Refreshes
    5. Learning Microsoft Power BI: Course Completed

Product information

  • Title: Learning Microsoft Power BI
  • Author(s): Reid Havens
  • Release date: October 2018
  • Publisher(s): Packt Publishing
  • ISBN: 9781789347104