Techehost
MICROSOFT POWER BI
Back to Dashboard

Hey there, great course, right? Do you like this course?

All of the most interesting lessons further. In order to continue you just need to purchase it

Get course

Course sections

Section 1
Introduction
1
Module introduction
2
Power BI desktop installation
3
The Power BI Desktop Workflow
4
Creating the Project Template & Recommended Settings
Section 2
Data preparation in Power Query Editor
1
Understanding Data Preparation / Cleaning / Cleansing
2
Connecting Power BI Desktop to Source Files
3
Understanding Basic Row Operations
4
Filtering Data
5
Working with Dates and handling date errors
6
Pivoting & Unpivoting
7
Extracting Data, Splitting Columns & Sorting Multiple Columns
8
Group By concept etc.,
Section 3
Data transformation in Power Query Editor
1
Data Warehouse, Data Model & Data Schema
2
Star schema – Introduction
3
Differences between References & Duplicates
4
Understanding the Merge Feature and handling Merge errors
5
Joins – different types
6
Conditional and Index Columns
7
DIM tables and Fact table concepts
8
Basic Mathematical Operations in Query Editor
Section 4
The Data Model - Working with Relationships & DAX
1
Understanding Relationships and Types
2
M-Language vs DAX (Data Analysis Expressions)
3
The DAX Basics
4
The Core DAX Syntax – Types, Operators, Functions
5
Calculated Column vs Measure
6
Combining CALCULATED & FILTER Functions
Section 5
Creating visuals in the Report view
1
The Power BI Workflow & Understanding Basics Visual Elements
2
Creating & Duplicating Pages
3
Organizing Visuals & creating new Visual
4
Different reports – Line, Bar etc.,
5
Understand Interactions, Hierarchies & Drill Down
6
Formatting reports
7
Slicers & Row cards
8
Importing visuals
Section 6
Power BI Pro & Mobile: Collaboration in Workspace
1
Power BI Pro Interface Tour
2
Publishing & My Workspace – Theory
3
Publishing / Importing Power BI Desktop Projects to Pro
4
Exploring Reports In Pro
5
Creating Reports & Dashboards
6
Gateways: Configuring Manual & Scheduled Refreshs
7
Sharing Links
8
Creating Colaboration Workspaces
9
Publishing & Unpublishing Apps
10
Workspaces vs Apps
11
Working with Power BI Mobile

Data preparation in Power Query Editor

Group By concept etc.,

Lesson is locked. Please Buy course to proceed.

Data preparation in Power Query Editor Extracting Data, Splitting Columns & Sorting Multiple Columns
Complete
Data transformation in Power Query Editor Data Warehouse, Data Model & Data Schema
w
Cart
Checkout - ₹0.00
  • 0
  • 1

Shopping Cart

Cart is empty!

Total
₹0.00
Apply Coupon
APPLY
Checkout View All Courses
0