Udemy, inc. microsoft power bi - a complete introduction [2022 edition]

• Home
• Udemy
• Courses
• Microsoft Power BI A Complete Introduction 2022 Edition

BY

Udemy

Brochure

Online

₹ 455 3,499

Quick facts

Course and certificate fees

Fees information

₹ 455 ₹3,499

certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Introduction

• Welcome to the Course!
• What is Power BI?
• Installing Power BI Desktop & Project Setup
• Connecting Power BI Desktop to Source Files
• Join our Online Learning Community
• Working in the Query Editor
• Understanding the Data Model & Creating Visuals
• Course Outline - What's Inside the Course?
• How To Get The Most Out Of This Course
• Useful Resources & Links

Introducing Power BI Desktop

• Module Introduction
• Using the Attached Project Files
• Understanding the Power BI Desktop Workflow
• Exploring the Interface of the Data Model
• Understanding the Query Editor Interface
• Important! Creating the Project File & Recommended Settings
• Course Slides 2020
• Useful Resources & Links

Working in the Query Editor

• Module Introduction
• Connecting Power BI Desktop to Source Files
• Keeping & Removing Rows
• Working with Filters
• Removing Empty Rows
• Saving the Project Draft
• Appending Queries
• Working with Columns
• Replacing Values
• [Please Read]: Important Hint for the Next Lecture
• Formatting Data & Handling Formatting Errors
• Pivoting & Unpivoting Data
• Splitting Columns
• Creating Groups & Cleaning Up our Project
• What we Achieved & How to Continue
• Theory Time: The Star Schema
• How we Use the Star Schema in our Project
• Query Duplicates vs References
• Creating the DIM-Region Table & Removing Duplicates
• Creating Tables Manually
• Theory Time: Merging Queries
• Understanding "Join Kind"
• Merging Queries Applied
• Finishing the DIM-Region Table
• The Next Steps
• Creating the DIM-Age Table
• Understanding "Extract"
• Working with Conditional Columns
• Creating the FACT-Table
• Understanding Basic Mathematical Operations
• Performance Optimization
• Time to Practice - Query Editor
• Wrap Up
• Useful Resources & Links

Understanding the Data Model: Data & Relationship View

• Module Introduction
• Understanding Relationships
• Cardinality: Many-to-One & One-to-One
• Cross Filter Direction & Many-to-Many
• Understanding Active Properties
• M-Language vs DAX (Data Analysis Expressions)
• M vs DAX - A Practical Example
• Understanding the DAX Basics
• The DAX Syntax
• Supported DAX Data Types
• Diving Into Operators
• DAX Functions - An Overview
• Understanding the CALENDAR Function
• Applying the DAX Basics
• Understanding IF & RELATED
• Calculated Columns vs Measures
• Creating our First Measures
• Understanding CALCULATE & FILTER
• Applying CALCULATE & FILTER in Measures
• Creating Measures with Measures
• Understanding "Data Category"
• Time to Practice - Data Model & Relationships
• Wrap Up
• Useful Resources & Links

Creating Visuals in the Report View

• Module Introduction
• Understanding Basic Visual Concepts
• Getting Started with Visuals & Reports
• Creating our First Visuals
• Understanding Tooltips & Interactions
• Diving Intro Hierarchies & Drill Mode
• Data Colors & Conditional Formatting
• Formatting Report Pages
• Formatting Visuals
• Working with Report Themes
• Using the Slicer
• Understanding Default Summarization & Sorting
• Working with Treemaps & Tables
• Syncing Slicers
• Understanding Filter Types (Visual, Page & Report)
• Working with (Multi) Row Cards
• Creating Combined Visuals & Waterfalls
• Using Custom Visuals
• Time to Practice - Visualizations
• Wrap Up
• Useful Resources & Links

Taking the Project to the Cloud with Power BI Pro (Service)

• Module Introduction
• Why we Need Power BI Pro (Service)
• Power BI: Service vs Pro vs Premium
• No Business Email? An Alternative
• Exploring the Power BI Pro Interface
• Understanding Workspaces
• Connecting Power BI Pro & Power BI Desktop
• Understanding Datasets in Power BI Pro
• Working with Reports
• Creating Dashboards
• Exploring "My Workspace"
• Refreshing Data with Gateways
• Sharing Data From "My Workspace"
• Understanding Collaboration Workspaces
• Workspaces vs Apps vs Content Packs
• Publishing an App
• Workspace or App - Which one Should I Choose?
• Working with Power BI Mobile
• Wrap Up
• Useful Resources & Links

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-Date in the Power BI World?

• Module Introduction
• Helpful Resources
• Using Preview Features

Creating Custom Visuals (Power BI for Developers)

• Module Introduction
• Why Custom Visuals?
• The Required Tools
• Setting Up & Installing the Required Tools
• Creating a New Visual
• Analyzing the Project & the Code
• Rendering Content to the Screen
• Using d3.js & a First Shape
• Getting Started with the Bars
• Rendering a Chart for Dummy Data
• Binding Real Data
• Coloring the Bars
• Adding an Axis
• Package & Wrap Up
• Useful Resources & Links

Course Round Up

• Congratulations! What you Learned & How to Continue

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

[Old Course Material] - The "old" Power BI Interface

• [Please Read!] About the Following Modules

[Old Course] Getting Started

• Welcome to this Course
• Understanding the Power BI Tools
• Join our Online Learning Community
• Initial Project 1/3: Installing Power BI Desktop and Connecting to Data
• Important: The "Locale" Used in This Course
• Initial Project 2/3: Working in the Query Editor
• Initial Project 3/3: Working in the Data Model and Creating a Visualization
• Course Outline
• How to use the Attached Project Files

[Old Course] Exploring Power BI Desktop

• An Overview of the Workflow in Power BI Desktop
• Introducing the Different Views of the Data Model
• Taking a Closer Look at the Query Editor Interface
• Important! Before we Dive Deeper: Required Power BI Settings

[Old Course] An Introduction to the Query Editor

• Module Introduction
• Just to be Sure: What is the Query Editor?
• Before we Start - About the Attached Project Files
• Connecting Power BI Desktop to our Data Sources
• Editing Rows
• Understanding Append Queries
• Editing Columns
• Replacing Values
• Formatting Data
• Pivoting and Unpivoting Columns
• Splitting Columns
• Creating a New Group for our Queries
• What we Achieved until Now and How to Continue
• Introducing the Star Schema
• Duplicating and Referencing Queries
• Creating the DIM Region Table
• Entering Data Manually
• Merging Queries
• Finishing the DIM Region Table
• Introducing the DIM AgeGroup Table
• Creating an Index Column
• Duplicating Columns and Extracting Information
• Creating Conditional Columns
• Creating the FACT Population Table
• Performing Basic Mathematical Operations
• Improving Performance and Loading Data into the Data Model
• Wrap Up
• Time to Practice - Query Editor
• [Optional] Assignment Instructions
• [Optional] Assignment Solution

[Old Course] Working on our Data Model: Data & Relationship View

• Module Introduction
• Query Editor vs. Data Model
• Introducing and Understanding Relationships
• Editing Relationships
• Understanding Cardinality
• Cross Filter Selection and Many-To-Many Relationships
• Active Properties
• Understanding the differences between the M-Language and DAX
• M vs. DAX applied: Calculated Columns
• M vs. DAX: Conclusion
• DAX - Basic information
• DAX and Calculated Columns
• Calculated Columns vs. Measures
• Introducing DAX-Measures
• DAX-Measures Continued
• Categorizing Data
• Wrap Up
• Time to Practice - Data Model
• [Optional] Assignment Instructions
• [Optional] Assignment Solution

[Old Course] Working in the Report View to Visualize our Results

• Module Introduction
• Understanding the Interface of the Report View
• Creating our First Visualizations
• Editing Interactions and Adding Tooltips
• Adding Data Colors & Understanding Conditional Formatting
• Understanding Hierarchies and Adding Drill-Down
• Formatting Charts and Sorting
• About the Slicer
• Introducing Slicers
• Adding Treemaps and Tables
• Applying different Filter Types
• Creating (Multi-Row) Cards
• Understanding Combined Visualizations and Waterfalls
• Wrap Up
• [Optional] Assignment Instructions
• [Optional] Assignment Solution

[Old Course] Course Roundup

• Bonus: More Content!

Instructors

Mr Maximilian Schwarzmuller
Instructor
Udemy

Other Masters

Articles

Popular Articles

Trending Courses

Digital Marketing Courses Fashion Design Courses Data Science Courses Interior Design Courses Graphic Designing Courses Cyber Security Courses Nursing Courses Tally Courses Data Analysis Courses Web Designing Courses Artificial Intelligence Courses Ethical Hacking Courses Free Digital Marketing Courses And certifications Free Artificial Intelligence Courses And Certifications Free Data Analysis Courses And Certifications Free Cyber Security Courses And Certifications Free Data Science Courses And Certifications Free Cloud Computing Courses And Certifications Free Python Courses And Certifications Free Fashion And Textiles Courses And Certifications Free Graphic Designing Courses And Certifications Free Web Designing Courses And Certifications

Popular Courses

General Management Courses Teaching and Education Courses Financial Management Courses Public Health Courses Web Development Courses Programming Courses Cyber Security Courses Mathematics Courses Digital Marketing Courses Project Management Courses Data Science Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Edx Courses Swayam Courses Coursera Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses MSBM Courses IIT Kharagpur Courses Simpliv Learning Courses Emeritus Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Which udemy Power BI course is best?

Which is the best online course for Power BI?

Which Power BI course is best for beginners?

How Much Does Power BI training cost?