Business Intelligence using Microsoft Power BI

OVERVIEWCOURSE OUTLINEWHEN & WHEREREQUEST IN-HOUSE

About the Course 

Microsoft Power BI is a business intelligence technology from Microsoft that gathers and processes your data, analyzes and provides data driven insights that enables managers, business analysts and key decision makers to make informed decisions real time. It allows one to ask questions and get answers about their data. Users of Power BI are able to create interactive dashboards and insights by self-interacting with the technology.

Target Participants 

This course is aimed at professionals who need to analyze and visualize data utilizing Microsoft Power BI.

What you will learn  

By the end of this training the participants will be able to: 

  • Connect, import, shape, and transform data for business intelligence (BI)
  • Model data with Power BI desktop
  • Custom create data visualizations and style reports for lucid data representation
  • Visualize data, author reports, and schedule automated refresh of your reports
  • Create and share dashboards based on reports in Power BI desktop
  • Share and collaborate with data with Power BI
  • Understand Power BI Data Analysis Expression(DAX), and its functions
Introduction to Power BI

Components of Power BI
Features of Power BI
Power BI workflow
Self Service ETL (Extract Transform Load)
Setup and Configuration of Power BI
Connecting to Data Sources

Excel
Online sources
SQL
Data Transformation: Data Management and Data Cleaning in Power BI (Power Query)

Using first rows as headers
Rename fields & replacing data values in cells, rows
Changing data types & change order of columns
Un-pivoting columns
Grouping and splitting column into multiple
extract feature (before /after delimiter)
Adding new columns
Filters and parameters
View native queries vs unfold queries
Modeling

Table relationship (one to one, one to many, many to many)
Data Analysis Expression (DAX)
Measures and calculated Columns
Mastering DAX using quick measures
Visualization and Charts (Power View)

Stacked bar chart and stacked column chart
Clustered bar chart and clustered column chart
Line chart & area chart
Line and clustered column chart
Line and stacked column chart
Ribbon & waterfall chart
Funnel & tree map visuals
Pie-chart and doughnut chart
Table chart and matrix chart
Slicer, gauge, card visuals
Map and filled map
ArcGIS maps for Power BI
KPI
Q & A visual
Fine tune your visualization using parameters and slicers
Deciding on when to use a particular visual
Building and Sharing a Dashboard

Workspace
Datasets
Reports
Create Dashboard
Modify and update Dashboard
Share your Dashboard
Power Q&A and Insights
Data Security in Power BI

Configuring row level security
Setting up user roles
Configuring Data Refresh

Types of data refresh (Package Refresh, Model/Data refresh, Tile Refresh, Visual/Container Refresh)
Understand & configure data management gateways
Configuring & scheduling data refresh
Power BI for Mobile

Configuring Power BI for Mobile
Visualize dashboards and report on Power BI Mobile
Commenting on eports and dashboards in Power BI Mobile
Excel Power BI

Power Query and Power Pivot on Excel
Visualize and Edit Power BI reports using excel analyzer
Building reports on Excel and Publishing to Power BI service
In person, or online, with live instructor

Course Information

Estimated Time: 5 DAYS

Categories:

Course Instructor

Owi_ghola Owi_ghola Author
This course does not have any sections.

Also see:

×

Hello!

Click one of our contacts below to chat on WhatsApp

× Chat with us