Microsoft Power BI Online Course Training - Rizetrainings.com

Microsoft Power BI Training:-

Introduction to Power BI and Power BI Products. Also, pricing of Power BI
Installing Power BI desktop and sign-in to Power BI app service from Desktop

Desktop
1. Explore the Power BI Desktop panels
i. Options window (left to Home Menu) ii. Top Ribbon with different data sources
ii. Left side vertical panel iv.Right side vertical panels (Visualizations, Fields)
Data Cleansing
2. Explore all the data sources and connecting to excel file, text file, folder source, sql server database
3. What is Load and edit? Can we do edit after loading to the model?
4. HOME ribbon
I) Choose & Remove columns ii) Keep & remove rows iii) Remove duplicates & Error rows
iv) Sorting v) Split column (by delimiter / by no. of characters) vi) Group by vi) data type change
vii) First row as headers viii) Replace values ix) Merge queries & Append Quires
Transform ribbon
i) Transpose, Reverse and Count Rows ii) Fill iii) Pivot and Un-pivot iv) Format
v) Merge columns and Extract vi) statistics / standard/ Scientific / Trigonometry / Round/ Information
vi) Date/ Time / Duration
Add Column ribbonlumns / Index column
View ribbon
i) Query settings ii) Advanced editor iii) Formula bar (M-Query)
iv) Mono spaced v) Show whitespace
Left / RightPanels
i) Left side vertical panel (Queries)
ii) Left side vertical panel (Query settings)
5. How to load the cleansed and transformed data to the data model (Close and Apply option)?

Data Modelling
6. What is relationship window and Data window from Left side vertical panel
7. Relationship window
& manage relationships from ribbon
Data windoweld properties from the right side vertical panel (Fields)
Difference between new measure & New columns
8. Create multiple measures and columns with DAX functions
Reports
9. What is reports windows from Left side vertical panel and explore the options of reports window
i. Top ribbon with report options e view
ii. Right side panel(Fields options)
(Visualizations)
10. Different report styles and apply formatting options
i. Table, Matrix, Card, Multi row card,
ii. Bar charts, Line charts
iii. Dual style charts (Line and bar)
iv. Pie charts, Donut charts, Tree maps and geographical maps (Globe and Filled Map)
App Service
v. Scatter plot, Funnel, Gauge, KPI and Slickers.
vi. R based charts
11. After adding 4 visuals to page, explore the below options
i. Ribbon (Home)
ii. Ribbon (Format) backward
iii. Visual options
12. How to create drilldown charts?
13. How to publish the files Power BI App service and what are the options while publishing?
14. Explore Power BI App service window with top ribbon and panels
i. Top black ribbon
1. Full focus mode with print option while in focus mode option
2. Gear icon
3. Downloads, support, feedback and account info
ii. white ribbon under black ribbon
1. Add widget (Web content, image, video and Textbox)
2. Share
3. … dashboard
iii. question bar below white ribbon
iv. Left side ribbon (from bottom)
1. Datasets: Explore data set options

Gateways
Types of gateways and what are those?
refresh the data from on-premise to Cloud App service

Email Us:- contact@rizetrainings.com
Call US:- + 91 970 39 767 53
For More Details:- https://goo.gl/wwQIVV