Microsoft PowerBI Course

Microsoft PowerBI Course

Overview:
Power BI may be a business analytics service by Microsoft. Microsoft Power BI may be a business intelligence platform that gives nontechnical business users with tools for aggregating, analyzing, visualizing and sharing data.
It aims to supply interactive visualizations and business intelligence capabilities with an interface simple enough for end users to make their own reports and dashboards.
Power BI provides Power BI Services and Power BI Desktop. It also offers data warehouse capabilities including data preparation, data discovery and interactive dashboards.
Microsoft Power BI is employed to seek out insights within an organization’s data. Power BI also can provide executive dashboards for administrators or managers, giving management more insight into how departments do . a standard flow of labor in Power BI begins by connecting to data sources and building a report in Power BI Desktop.
Key Components:

  • Power BI desktop
  • Power BI Service
  • Power BI Mobile Apps
  • Power BI Gateway
  • Power BI Embedded
  • Power BI Report Server
  • Power BI Visuals Marketplace

Introduction:
Downloads
Install POWERBI DESKTOP
Connect to POWERBI DESKTOP
Source Connections:
GET data from SQLSERVER
Get data from SSAS
Get data from Excel AND multiple Excel sheets
Get data from Text files
Load data from multiple data sources
Working with Transformations:
Change datatype
Combine multiple tables
Enter data
Format dates
Joins
Pivot table
Reorder and remove columns
Rename columns
Rename tables
Split columns
Unpivot table
Working with Visualizations:
Area chart
Bar chart
Card
Column chart
Donut chart
Pie chart
Line chart
Table
Matrix
Ribbon chart
Scatter chart
Map
Tree ma
Waterfall chart
Format charts (All types)
POWER BI Filters:
Slicer
Basic filters
Advanced filters
Top N filters
Filters on Measures
Page level, Report level filters
Drill through filters
POWER BI Calculated Fields:
Calculated Columns
Calculated Measures
Calculated Tables
Conditional Columns
Custom Columns
Dashboards:
Register to Pro Service
Dashboard Introduction
Connect Desktop with BI Service or Pro
Publish Desktop Reports
Create Workspace
Create Dashboard Working with Dashboards:
Dashboard Functionalities
Dashboard Settings
Pin report to Dashboard
Delete a Dashboard
Sharing Work:
Share a Dashboard
Share a Report
Share Workspace
Publish App
Subscriptions:
Subscriber Dashboard
Subscribe Report
DAX:
Aggregate functions
Date functions
Logical functions
Math functions
String functions
Trigonometric functions
Practice Scenarios:
Drill-up and Drill-down Reports
Sort chart in ascending and descending order
Show empty record in Reports


cours