Microsoft Power BI - The Practical Guide

BY
Udemy

A detailed description on how to import, transform, and visualize data with Power BI, along with practical exercises and a case study.

Mode

Online

Fees

₹ 599 4099

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course overview

Power BI is an application for Data Visualization and Business Intelligence that turns data from various data sources into interactive dashboards and BI reports. Power BI suite includes different software, connectors, and services, such as Power BI desktop, Power BI service based on SaaS, and mobile Power BI apps for different platforms. Manuel Lorenz, a Professional Business Analyst at a major consultancy firm and an investment bank, and Maximilian Schwarzmüller, a web developer, designed the  Microsoft Power BI - A Complete Introduction [2022 EDITION] online certification, which is available on Udemy.

The Microsoft Power BI - A Complete Introduction [2022 EDITION] online training provides 18 hours of digital lessons backed by 25+ articles aimed to teach candidates the core ideas required to comprehend and create applications with Power BI. The Microsoft Power BI - A Complete Introduction [2022 EDITION] online course focuses on strategies and concepts such as analyzing data from different data sources and defining their own datasets, as well as learning how to use the Query Editor to connect Power BI to various source types, and creating a report with various interactive visualization types.

The highlights

  • 18 hours of on-demand video
  • 25+ articles plus resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Program offerings

  • 18 hours of videos
  • Unlimited access on mobile and tv
  • Certificate of completion
  • 30-day money-back guarantee.

Course and certificate fees

Fees information
₹ 599  ₹4,099
certificate availability

Yes

certificate providing authority

Udemy

What you will learn

Knowledge of data visualization

After completing the Microsoft Power BI - The Practical Guide [2023 EDITION] certification course, the applicant will learn about Power BI Desktop and its components such as how to use the Query Editor to make calculated columns and measures, the relationships between different tables, making reports with different types of interactive visualization, and using Power BI Pro to make dashboards and access results from multiple devices.

The syllabus

Getting Started

  • Welcome to This Course
  • What is Power BI?
  • Installing Power BI Desktop
  • Connecting Power BI Desktop to Source Files
  • Creating our First Visuals
  • Join our Online Learning Community
  • Comparing Excel & Power BI
  • Course Outline 
  • The Two Ways (Paths) Of Taking This Course
  • How to Get the Most Out of This Course
  • Important: How to Access Course Resources, Project Files & Slides

Understanding the Power BI Desktop Basics & Preparing the Course Project

  • Module Introduction
  • The Power BI Desktop Workflow
  • Interface Tour
  • Important! Creating the Project Template & Recommended Settings

Data Preparation in the Power Query Editor

  • Module Introduction
  • Understanding Data Preparation / Cleaning / Cleansing
  • Connecting Power BI Desktop to Source Files
  • How Power BI Queries Data
  • Understanding Basic Row Operations
  • Filtering Data
  • Analyzing Columns & Removing Blank Fields
  • Understanding & Using the Append Feature
  • Choosing & Removing Columns
  • Append Behind the Scenes
  • Understanding the Transpose Feature
  • Replacing Values
  • Working with Dates - The Basics
  • Understanding Data Formats
  • Handling Data Format Errors
  • Understanding Pivoting & Unpivoting
  • Applying Pivoting & Unpivoting
  • Fixing a Sorting Problem
  • Extracting Data, Splitting Columns & Sorting Multiple Columns
  • Introducing the "Group By" Feature
  • Improving the Project Structure
  • Wrap Up

Data Transformation in the Power Query Editor

  • Module Introduction
  • Data Warehouse, Data Model & Data Schema
  • The Star Schema - Theory
  • Applying the Star Schema to our Project
  • Understanding References
  • Comparing References & Duplicates
  • Importing Country & Region Codes
  • Using "Enter Data" to Create a Table
  • Understanding the Merge Feature
  • How to Join Tables
  • Understanding Outer, Inner & Anti Joins
  • Join Kind in Practice
  • Handling Merge Errors
  • Understanding the DIM-age Table
  • Bringing Back the "age-group" Column
  • Getting the Maximum Values From Each Age Group
  • Creating Conditional Columns
  • Creating an Index Column
  • Creating a DIM-gender Table
  • Understanding the FACT Table
  • Finishing the FACT Table
  • Applying Basic Mathematical Operations
  • Using the Enable Load Feature
  • Wrap Up
  • Time to Practice - Query Editor

The Data Model: Working with Relationship & DAX (Data Analysis Espressions)

  • Module Introduction
  • Query Editor vs Data Model
  • Understanding Relationships
  • Creating our First Relationship
  • Understanding Cardinality & Difference Relationship Types
  • One to Many & Many to One
  • One to One
  • Many to Many
  • Fixing the Column Order Bug
  • Understanding the Cross Filter Direction
  • Understanding Active Properties
  • Adding Relationships to the Project
  • M-Language vs DAX (Data Analysis Expressions)
  • Creating a Custom Column with the M-Language
  • Creating a Calculated Column with DAX
  • M vs DAX - What Should I Choose?
  • The DAX Basics
  • The Core DAX Syntax
  • DAX Data Types
  • DAX Operators
  • DAX Core Functions
  • Creating a Table with the CALENDAR Function
  • Extracting Data with the DOT Notation
  • Adding & Dividing Columns
  • Working with IF Functions
  • Understanding Relationship Functions
  • Calculated Column vs Measure
  • Understanding & Creating Measures
  • Working with FILTER & CALCULATE Functions - Theory
  • Combining CALCULATED & FILTER Functions
  • Adding the Filter Condition to CALCULATE
  • Using Measures in Measures
  • Changing the Measure's Home Table
  • Understanding the Data Category
  • Wrap Up
  • Time to Practice - Data Model & Relationships

Creating Visuals in the Report View

  • Module Introduction
  • The Power BI Workflow & Understanding Basics Visual Elements
  • Creating & Duplicating Pages
  • Organizing Visuals
  • Creating a New Visual
  • Creating Line & Column Charts
  • How FILTER Affects the Visual
  • Understanding Interactions
  • Hierarchies & Drill Down
  • Formatting Chart Colors
  • The Canvas
  • Formatting the Page Background / Wallpaper
  • Formatting the Filter Pane & Filter Cards
  • Formatting Visuals: General Settings
  • Diving Deeper Into Formatting Visuals
  • Working with Report Themes
  • Finishing the Report Theme
  • Understanding the Slicer
  • Default Summarization & Sorting Order
  • Creating Treemaps & Working with Multiple Slicers
  • Creating Tables
  • Syncing Slicers
  • Filter on Visual, Page & Report Level
  • Creating Single & Multi Row Cards
  • Adding a Secondary Y-Axis
  • Combining Column & Line Charts
  • The Waterfall Chart
  • Importing Visuals
  • Finishing Touches
  • Wrap Up
  • Time to Practice - Visualizations

Power BI Pro & Mobile: Sharing & Collaborating with Workspaces & Apps

  • Module Introduction
  • The Next Steps
  • Power BI Pro Pricing
  • Power BI Pro Interface Tour
  • Publishing & My Workspace - Theory
  • Publishing / Importing Power BI Desktop Projects to Pro
  • Datasets Walkthrough
  • List View vs Lineage View
  • Exploring Reports In Pro
  • Understanding Dashboards
  • Creating Reports & Dashboards
  • Diving Deeper Into "My Workspace", Understanding Refresh and a Refresh Error
  • Gateways - Theory
  • Gateways: Configuring Manual & Scheduled Refreshes
  • Sharing Data From "My Workspace" via Direct Access
  • Sharing Links
  • Understanding Collaboration Workspaces - Theory
  • Creating Collaboration Workspaces
  • Sharing Data via Apps
  • Publishing & Unpublishing Apps
  • Deleting Collaboration Workspaces
  • Workspaces vs Apps
  • Working with Power BI Mobile
  • Wrap Up

Other Data Sources

  • Module Introduction
  • Importing JSON Data
  • Updated Star Wars API URL
  • Importing Data from REST APIs
  • Preparation: Setting up a MySQL Server
  • Importing Data from a MySQL Server (and other SQL Servers)
  • Wrap Up

How to Stay Up-to-Data in the Power BI World?

  • Module Introduction
  • Helpful Resources
  • Using Preview Features

Course Round Up

  • Congratulations! What you Learned & How to Continue

Optional: Power BI Desktop Crash Course/ Introduction & Summary

  • Module Introduction
  • Project Setup
  • Connecting Power BI Desktop to the Source Files
  • Query Editor Walkthrough
  • Removing Blank Rows & Fixing Format Errors
  • Saving the Project
  • Duplicates vs References
  • Appending Queries
  • Splitting Columns & Extracting Data
  • Basic Column Interactions
  • Data Modelling Theory
  • Creating the "Orders" Table
  • Working with Indexes
  • The Formula Bar
  • Merging Queries
  • Loading Data Into the Data Model
  • Creating Line Charts
  • Understanding Relationships
  • Formatting Numbers in Charts
  • Understanding Interactions
  • Hierarchies & Drill-Down
  • Sorting Axis Values
  • Formatting Visuals & Applying Report Themes
  • Reports, Map Visual & Default Summarization
  • The Data Category
  • Applying Filters to Visuals
  • Understanding Slicers
  • Creating Tables
  • Working with DAX ("Data Analytics Expressions")
  • Sorting Weekdays with Calculated Columns
  • Fixing the Revenue Calculation
  • Introducing Measures
  • Working with Quick Measures

Bonus: Selected Features by Example & Refresher Project

  • About this Module
  • Understanding Column from Examples
  • Group By, Big Data & DAX Studio
  • Please Read: Bonus Project Introduction
  • Taxi Project - Query Editor
  • Taxi Project - Data Model & Visuals
  • Taxi Project - Power BI Service

This Course Was Completely Updated

  • Old Course Content Download

[OLD COURSE] An Introduction to the Query Edition

  • Time to Practice - Query Editor

[OLD COURSE] Working on our Data Model: Data & Relationship View

  • Time to Practice - Data Model

[OLD COURSE] Course Roundup

  • Bonus: More Content!

Instructors

Mr Manuel Lorenz
Instructor
Freelancer

Mr Maximilian Schwarzmuller

Mr Maximilian Schwarzmuller
Instructor
Udemy

Other Masters

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books