Learning Microsoft Power BI

Video description

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.

Special assignment labs and student files on every hands-on concept for better understanding

What You Will Learn

  • Connect to nearly ANY data source quickly and easily
  • Easily transform data and automate data tasks with Power Query
  • Understand the importance of Data Modeling for optimization and performance
  • Create powerful calculations and analytics with DAX
  • Importance of a Calendar Table
  • Picking the right visual based on your data
  • Create interactive reports with slicers
  • Publishing reports and creating dashboards

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.

About The Author

Reid Havens: Reid Havens is the Founder of Havens Consulting Inc. and a Microsoft MVP. He has a formal background in technology and organizational management, having obtained separate Master's Degrees in Organizational Development & Business Analytics. Reid has experience working with many of the Fortune 50, 100, & 500 companies. Additionally he guest lectures at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization.

Reid is also an avid content developer, having authored numerous articles and videos on various blog sites and video platforms. He's also written multiple training curriculum's for PowerPivotPro, and taught them as a Principal Consultant at dozens of companies around the world. He also developed college level classes for Bellevue College and The University of Washington. Reid is also currently developing multiple online video series on Learning & Mastering Power BI for Packt Publishing.

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