Course Description
The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes perform data transform, develop data modelling, create the visualizations for report and dashboard, and implement the Power BI Service.
Audience
The primary audience for this course is for individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises. The secondary audiences for this course are technically proficient business users.
Prerequisites
Student enrolling in this course should understand the basics of Windows.
They should already have experience working with Microsoft Excel.
Learning Objectives
After completing this course, students will be able to:
Create a Power BI visualization for dashboard.
Apply and perform advanced report analytics.
Explore the features of Power BI service.
Share and collaborate using workspace.
Course Outline :: Power BI Advanced ::
Module 1: Create Dashboards in Power BI
Create a Dashboard
Real-time Dashboard
Enhance a Dashboard
After completing this module, students will be able to:
Create a Dashboard
Understand real-time Dashboards
Enhance Dashboard usability
Module 2: Identify Patterns and Trends in Power BI
Create animated scatter charts
Use the visual to forecast values
After completing this module, students will be able to:
Use the Analyze feature
Identify outliers in data
Use the AI visuals
Use the Advanced Analytics custom visual
Module 3: Create and Manage Workspaces in Power BI
Creating Workspaces
Sharing and Managing Assets
After completing this module, students will be able to:
Create and manage a workspace
Understand workspace collaboration
Monitor workspace usage and performance
Distribute an App
Module 4: Manage Files and Datasets in Power BI
Parameters
Datasets
After completing this module, students will be able to:
Manage datasets and parameters
Build dynamic reports with parameters
Course Outline :: Power BI Advanced ::
Schedule dataset refresh
Troubleshoot gateway service connectivity
Module 5: Row-level Security in Power BI
Security in Power BI
After completing this module, students will be able to:
Implement row-level security using both the Static and Dynamic methods
Programme scope, delivery arrangements and suitability are confirmed during enquiry.