Microsoft Power Bi Training
Microsoft Power Bi Training
HIGHEST RATED 4/5
Short Description :: Power BI may be a business analytics service by Microsoft. It aims to supply interactive visualizations associated business intelligence capabilities with an interface straightforward enough for finish users to make their own reports and dashboards.
Power BI Course Content
1. Introduction:
a) Downloads
b) Install POWERBI DESKTOP
c) Connect to POWERBI DESKTOP
2. Source Connections:
a) GET data from SQLSERVER
b) Get data from SSAS
c) Get data from Excel AND multiple Excel sheets
d) Get data from Text files
e) Load data from multiple data sources
3. Working with Transformations:
a) Change datatype
b) Combine multiple tables
c) Enter data
d) Format dates
e) Joins
f) Pivot table
g) Reorder and remove columns
h) Rename columns
i) Rename tables
j) Split columns
k) Unpivot table
4. Working with Visualizations:
a) Area chart
b) Bar chart
c) Card
d) Column chart
e) Donut chart
f) Pie chart
g) Line chart
h) Table
i) Matrix
j) Ribbon chart
k) Scatter chart
l) Map
m) Tree ma
n) Waterfall chart
o) Format charts (All types)
5. POWER BI Filters:
a) Slicer
b) Basic filters
c) Advanced filters
d) Top N filters
e) Filters on Measures
f) Page level, Report level filters
g) Drill through filters
6. POWER BI Calculated Fields:
a) Calculated Columns
b) Calculated Measures
c) Calculated Tables
d) Conditional Columns
e) Custom Columns
7. Dashboards:
a) Register to Pro Service
b) Dashboard Introduction
c) Connect Desktop with BI Service or Pro
d) Publish Desktop Reports
e) Create Workspace
f) Create Dashboard
8. Working with Dashboards:
a) Dashboard Functionalities
b) Dashboard Settings
c) Pin report to Dashboard
d) Delete a Dashboard
9. Sharing Work:
a) Share a Dashboard
b) Share a Report
c) Share Workspace
d) Publish App
10. Subscriptions:
a) Subscriber Dashboard
b) Subscribe Report
11. DAX:
a) Aggregate functions
b) Date functions
c) Logical functions
d) Math functions
e) String functions
f) Trigonometric functions
12. Practice Scenarios:
a) Drill-up and Drill-down Reports
b) Sort chart in ascending and descending order
c) Show empty record in Reports
13. Interview Questions:
14. FAQ’S
15. PRE-REQUISITES:
a) SQLSERVER KNOWLEDGE
b) SSRS KNOWLEDGE
