Price:  $ 10.00 USD | Size: 10.9 GB  |  Duration :  16+ Hours  |198 Video Lessons | ⭐️⭐️⭐️⭐️⭐️ 4.9
BRAND : Expert TRAINING | ENGLISH |  Bonus : A bundle of Microsoft Power BI PDF Guides | INSTANT DOWNLOAD 
 
HOW TO DOWNLOAD THIS COURSE?
You can Instant Download a PDF file After successful payment, This PDF File Contains Course Download links
You can Download This Course immediately from the click that Links
 
Microsoft Power BI - A Complete Introduction  16+ Hours Course & PDF Guides
 
 
Table of contents
 
Chapter 1 : Getting Started
Welcome to This Course
Module Introduction
What Is Power BI?
Installing Power BI Desktop
Connecting Power BI Desktop to Source Files
Creating Our First Visuals
Comparing Excel and Power BI
Course Outline
How to Get the Most Out of This Course
Important: How to Access Course Resources, Project Files, and Slides
 
Chapter 2 : Understanding the Power BI Desktop Basics and Preparing the Course Project
Module Introduction
The Power BI Desktop Workflow
Interface Tour
Important! Creating the Project Template and Recommended Settings
 
Chapter 3 : 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 and Removing Blank Fields
Understanding and Using the Append Feature
Choosing and 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 and Unpivoting
Applying Pivoting and Unpivoting
Fixing a Sorting Problem
Extracting Data, Splitting Columns, and Sorting Multiple Columns
Introducing the "Group By" Feature
Improving the Project Structure
Wrap Up
 
Chapter 4 : Data Transformation in the Power Query Editor
Module Introduction
Data Warehouse, Data Model, and Data Schema
The Star Schema - Theory
Applying the Star Schema to Our Project
Understanding References
Comparing References and Duplicates
Importing Country and Region Codes
Using "Enter Data" to Create a Table
Understanding the Merge Feature
How to Join Tables
Understanding Outer, Inner, and 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
 
Chapter 5 : The Data Model: Working with Relationships and DAX (Data Analysis Expressions)
Module Introduction
Query Editor Versus Data Model
Understanding Relationships
Creating Our First Relationship
Understanding Cardinality and Difference Relationship Types
One to Many and 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 Versus DAX (Data Analysis Expressions)
Creating a Custom Column with the M-Language
Creating a Calculated Column with DAX
M Versus 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 and Dividing Columns
Working with IF Functions
Understanding Relationship Functions
Calculated Column Versus Measure
Understanding and Creating Measures
Working with FILTER and CALCULATE Functions - Theory
Combining CALCULATED and FILTER Functions
Adding the Filter Condition to CALCULATE
Using Measures in Measures
Changing the Measure's Home Table
Understanding the Data Category
Wrap Up
 
Chapter 6 : Creating Visuals in the Report View
Module Introduction
The Power BI Workflow and Understanding Basic Visual Elements
Creating and Duplicating Pages
Organizing Visuals
Creating a New Visual
Creating Line and Column Charts
How FILTER Affects the Visual
Understanding Interactions
Hierarchies and Drill Down
Formatting Chart Colors
The Canvas
Formatting the Page Background / Wallpaper
Formatting the Filter Pane and Filter Cards
Formatting Visuals: General Settings
Diving Deeper into Formatting Visuals
Working with Report Themes
Finishing the Report Theme
Understanding the Slicer
Default Summarization and Sorting Order
Creating Treemaps and Working with Multiple Slicers
Creating Tables
Syncing Slicers
Filter on Visual, Page, and Report Level
Creating Single and Multi-Row Cards
Adding a Secondary Y-Axis
Combining Column and Line Charts
The Waterfall Chart
Importing Visuals
Finishing Touches
Wrap Up
 
Chapter 7 : Power BI Pro and Mobile: Sharing and Collaborating with Workspaces and Apps
 
 
Chapter 8 : Other Data Sources
 
 
Chapter 9 : How to Stay Up-to-Date in the Power BI World
 
 
Chapter 10 : Course Round Up
 
 
Chapter 11 : Bonus - Selected Features by Example and Refresher Project