Microsoft Power BI - A Complete Introduction [2020 EDITION]

Video description

Discover how to use Microsoft's Power BI Tools, including Power BI Desktop, Power BI Pro (Service) and Power BI Developer

About This Video

  • Get to grips with the different tools in the Power BI ecosystem and learn how to use them
  • Analyze data from different data sources and create datasets
  • Create and publish visually appealing charts quickly and easily

In Detail

Whether you want to analyze data from single or multiple sources or create impressive visualizations from datasets and share your results with colleagues, Power BI is the tool that’ll help you to achieve your business intelligence goals. With this video course, you'll learn how to use Power BI’s set of business intelligence tools effectively.

The course starts by taking you through the course objectives and introducing you to Power BI Desktop. Next, you’ll connect Power BI to various source types using the Query Editor, understand the data model, and add relationships between different tables. Moving ahead, you’ll create visuals in the report view and share your work with colleagues and others using Power BI Pro. As you advance, you’ll get prepared to import data from sources such as JSON, REST APIs, and MySQL Server. Later, you’ll explore tips to stay ahead in the Power BI world and create custom visuals using TypeScript and Power BI Developer tools. Toward the end, you’ll test your skills by working through interesting projects and reinforce your knowledge by revising old topics in Power BI.

By the end of this course, you’ll have become familiar with Power BI tools and have developed the skills you need to use them confidently.

Who this book is for

This course is designed for anyone who has never worked with Power BI and wants to understand how to use the different tools, those interested in learning how to connect the different Power BI tools with each other, and others who want to understand how to create customized visuals with Power BI Developer tools. A basic understanding of data analysis will be beneficial but is not mandatory.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Introduction
    1. Course Introduction
    2. What is Power BI?
    3. First Project 1/3: Installing Power BI Desktop and Source File Connection
    4. First Project 2/3: Working in the Query Editor
    5. First Project 3/3: The Data View and Creating Your First Visuals
    6. Course Outline - What's Inside the Course?
    7. How to Get the Most out of the Course?
  2. Chapter 2 : Introducing Power BI Desktop
    1. Module Introduction
    2. Using the Attached Project Files
    3. Understanding the Power BI Desktop Workflow
    4. Exploring the Interface of the Data Model
    5. Understanding the Query Editor Interface
    6. Creating the Project File and Recommended Settings
  3. Chapter 3 : Working in the Query Editor
    1. Module Introduction
    2. Connecting Power BI Desktop to Source Files
    3. Keeping and Removing Rows
    4. Working with Filters
    5. Removing Empty Rows
    6. Saving the Project Draft
    7. Appending Queries
    8. Working with Columns
    9. Replacing Values
    10. Formatting Data and Handling Formatting Errors
    11. Pivoting and Unpivoting Data
    12. Splitting Columns
    13. Creating Groups and Cleaning- Up the Project
    14. What You Have Achieved and How to Continue?
    15. Theory Time: The Star Schema
    16. How Do You Use the Star Schema in Your Project?
    17. Query Duplicates vs References
    18. Creating the DIM-Region Table and Removing Duplicates
    19. Creating Tables Manually
    20. Theory Time: Merging Queries
    21. Understanding "Join Kind"
    22. Merging Queries Applied
    23. Finishing the DIM-Region Table
    24. The Next Steps - Completing our Star Schema
    25. Creating the DIM-Age Table
    26. Understanding "Extract"
    27. Working with Conditional Columns
    28. Creating the FACT-Table
    29. Understanding Basic Mathematical Operations
    30. Performance Optimization
    31. Module Summary
  4. Chapter 4 : Understanding the Data Model - Data and Relationship View
    1. Module Introduction
    2. Understanding Relationship View
    3. Cardinality: Many-to-One and One-to-One
    4. Cross Filter Direction and Many-to-Many
    5. Understanding Active Properties
    6. M-Language vs Data Analysis Expressions (DAX)
    7. M-Language vs Data Analysis Expressions (DAX) - A Practical Example
    8. Understanding the Data Analysis Expressions (DAX) Basics
    9. The Data Analysis Expressions (DAX) Syntax
    10. Supported Data Analysis Expressions (DAX) Data Types
    11. Diving into Operators
    12. Data Analysis Expressions (DAX) Functions - An Overview
    13. Understanding the CALENDAR Function
    14. Applying the Data Analysis Expressions (DAX) Basics
    15. Understanding IF and RELATED Functions
    16. Calculated Columns vs Measures
    17. Creating Your First Measures
    18. Understanding the CALCULATE and FILTER Functions
    19. Applying CALCULATE and FILTER in Measures
    20. Creating Measures with Measures
    21. Understanding "Data Category"
    22. Module Summary
  5. Chapter 5 : Creating Visuals in the Report View
    1. Module Introduction
    2. Understanding Basic Visual Concepts
    3. Getting Started with Visuals and Reports
    4. Creating Your First Visuals
    5. Understanding Tooltips and Interactions
    6. Diving Into Hierarchies and Drill Mode
    7. Data Colors and Conditional Formatting
    8. Formatting Report Pages
    9. Formatting Visuals
    10. Working with Report Themes
    11. Using the Slicer
    12. Understanding Default Summarization and Sorting
    13. Working with Treemaps and Tables
    14. Syncing Slicers
    15. Understanding Filter Types (Visual, Page, and Report)
    16. Working with (Multi) Row Cards
    17. Creating Combined Visuals and Waterfalls
    18. Using Custom Visuals
    19. Module Summary
  6. Chapter 6 : Taking the Project to the Cloud with Power BI Pro (Service)
    1. Module Introduction
    2. Why You Need Power BI Pro (Service)
    3. Power BI: Service vs Pro vs Premium
    4. Exploring the Power BI Pro Interface
    5. Understanding Workspaces
    6. Connecting Power BI Pro and Power BI Desktop
    7. Understanding Datasets in Power BI Pro
    8. Working with Reports
    9. Creating Dashboards
    10. Exploring "My Workspace"
    11. Refreshing Data with Gateways
    12. Sharing Data from "My Workspace"
    13. Understanding Collaboration Workspaces
    14. Workspaces vs Apps vs Content Packs
    15. Publishing an App
    16. Workspace or App - Which one Should You Choose?
    17. Working with Power BI Mobile
    18. Module Summary
  7. Chapter 7 : Other Data Sources
    1. Module Introduction
    2. Importing JSON Data
    3. Importing Data from REST APIs
    4. Preparation: Setting up a MySQL Server
    5. Importing Data from a MySQL Server (and other SQL Servers)
    6. Module Summary
  8. Chapter 8 : How to Stay Up-to-Date in the Power BI World?
    1. Module Introduction
    2. Helpful Resources
    3. Using Preview Features
  9. Chapter 9 : Creating Custom Visuals (Power BI for Developers)
    1. Module Introduction
    2. Why Custom Visuals?
    3. The Required Tools
    4. Setting Up and Installing the Required Tools
    5. Creating a New Visual
    6. Analyzing the Project and the Code
    7. Rendering Content to the Screen
    8. Using d3.js and a First Shape
    9. Getting Started with the Bars
    10. Rendering a Chart for Dummy Data
    11. Binding Real Data
    12. Coloring the Bars
    13. Adding an Axis
    14. Module Summary
  10. Chapter 10 : Course Round Up
    1. Congratulations! What You Have Learned and How to Continue?
  11. Chapter 11 : Bonus: Selected Features by Example and Refresher Project
    1. Understanding Columns from Examples
    2. Group By, Big Data, and Data Analysis Expressions (DAX) Studio
    3. Taxi Project - Query Editor
    4. Taxi Project - Data Model and Visuals
    5. Taxi Project - Power BI Service
  12. Chapter 12 : Getting Started
    1. Welcome to this Course
    2. Understanding the Power BI Tools
    3. Initial Project 1/3: Installing Power BI Desktop and Connecting to Data
    4. Initial Project 2/3: Working in the Query Editor
    5. Initial Project 3/3: Working in the Data Model and Creating a Visualization
    6. Course Outline
    7. How to Use the Attached Project Files?
  13. Chapter 13 : An Introduction to Power BI Desktop
    1. An Overview of the Workflow of Power BI Desktop
    2. Introducing the Different Views of the Data Model
    3. Taking a Closer Look at the Query Editor Interface
    4. Before You Dive Deeper: Recommended Settings
  14. Chapter 14 : An Introduction to the Query Editor
    1. Module Introduction
    2. Just to be sure: What is the Query Editor?
    3. Connecting Power BI Desktop to Your Data Sources
    4. Editing Rows
    5. Understanding Append Queries
    6. Editing Columns
    7. Replacing Values
    8. Formatting Data
    9. Pivoting and Unpivoting Columns
    10. Splitting Columns
    11. Creating a New Group for Your Queries
    12. What we Achieved until Now and How to Continue
    13. Introducing the Star Schema
    14. Duplicating and Referencing Queries
    15. Creating the DIM Region Table
    16. Entering Data Manually
    17. Merging Queries
    18. Finishing the DIM Region Table
    19. Introducing the DIM Age Group Table
    20. Creating an Index Column
    21. Duplicating Columns and Extracting Information
    22. Creating Conditional Columns
    23. Creating the FACT Population Table
    24. Performing Basic Mathematical Operations
    25. Improving Performance and Loading Data into the Data Model
    26. Module Summary
  15. Chapter 15 : Working on Your Data Model: Data and Relationship View
    1. Module Introduction
    2. Query Editor vs. Data Model
    3. Introducing and Understanding Relationships
    4. Editing Relationships
    5. Understanding Cardinality
    6. Cross Filter Selection and Many-To-Many Relationships
    7. Active Properties
    8. Understanding the differences between the M-Language and Data Analysis Expressions (DAX)
    9. M-Language vs. Data Analysis Expressions (DAX) applied: Calculated Columns
    10. M-Language vs. Data Analysis Expressions (DAX): Conclusion
    11. Data Analysis Expressions (DAX) - Basic information
    12. Data Analysis Expressions (DAX) and Calculated Columns
    13. Calculated Columns vs. Measures
    14. Introducing Data Analysis Expressions (DAX)-Measures
    15. Data Analysis Expressions (DAX)-Measures Continued
    16. Categorizing Data
    17. Module Summary
  16. Chapter 16 : Working in the Report View to Visualize Your Results
    1. Module Introduction
    2. Understanding the Interface of the Report View
    3. Creating Your First Visualizations
    4. Editing Interactions and Adding Tooltips
    5. Adding Color Saturation
    6. Understanding Hierarchies and Adding Drill-Down
    7. Formatting Charts and Sorting
    8. Introducing Slicers
    9. Adding Treemaps and Tables
    10. Applying different Filter Types
    11. Creating (Multi-Row) Cards
    12. Understanding Combined Visualizations and Waterfalls
    13. Module Summary
  17. Chapter 17 : Power BI Service Power BI Mobile - How to Continue?
    1. Module Introduction
    2. Continuing Your Work and Why You Need Power BI Service?
    3. Comparing Power BI Free, Pro and Premium
    4. Logging in to Power BI Service
    5. Understanding the Interface
    6. Importing Your Data from Power BI Desktop to Power BI Service
    7. Understanding the Dataset Menu
    8. Working on Reports
    9. Introducing Dashboards
    10. Exploring Your Workspace
    11. Understanding Gateways
    12. Comparing Personal and On-Premise Gateway and Installing a Gateway
    13. Working Alone or Collaborating with Colleagues
    14. Collaborating in App Workspaces
    15. Sharing the Results
    16. Publishing the App
    17. Content Packs from Online Services
    18. Power BI Mobile: Installing and Understanding the Mobile App
    19. One Last Thing: Excluding Datasets from Sharing
    20. Module Summary
  18. Chapter 18 : Creating Custom Visuals (Power BI for Developers)
    1. Module Introduction
    2. How Do Custom Visuals Work?
    3. Using Data Driven Documents (D3)
    4. Creating and Using a Visual
    5. Installing an IDE (Code Editor)
    6. Understanding the visuals.ts File
    7. Understanding the Project Structure
    8. Installing d3.js (Data Driven Documents)
    9. Adding a First Shape
    10. Connecting Shapes to Data
    11. Scaling Shapes
    12. Managing Visual Capabilities to Allow Data Input
    13. Starting the Data Extraction
    14. Limiting the Data Input
    15. Extracting Data
    16. Displaying the User Data
    17. Optimizing the Code
    18. Adding Dynamic Coloring
    19. Making Bars Selectable (Cross-Visual)
    20. Adding X-Axis Labels
    21. Adding Custom Visuals Settings
    22. Extracting the Visual Configuration
    23. Informing Power BI about the Custom Configuration
    24. Next Steps
    25. Packaging the Custom Visual
    26. Wrap Up
  19. Chapter 19 : Course Roundup
    1. Congratulations

Product information

  • Title: Microsoft Power BI - A Complete Introduction [2020 EDITION]
  • Author(s): Academind by Maximilian Schwarzmüller
  • Release date: November 2020
  • Publisher(s): Packt Publishing
  • ISBN: 9781789959031