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:
Describe how to connect to data sources.
Perform Power BI desktop data transformation.
Design Power BI desktop data modelling.
Create a Power BI visualization for report and dashboard.
Explore the features of Power BI service.
Share and collaborate using workspace.
Course Outline :: Analysing Data with Power BI::
Module 1: Get Started with Microsoft Data Analytics
Data Analytics and Microsoft
Getting Started with Power BI
Module 2: Prepare Data in Power BI
Get data from various data sources
Resolve data errors
Module 3: Clean, Transform, and Load Data in Power BI
Data shaping
Enhance the data structure
Data Profiling
Module 4: Design a Data Model in Power BI
Introduction to data modeling
Working with tables
Dimensions and Hierarchies
Module 5: Create Measures using DAX in Power BI
Introduction to DAX
DAX context
Module 6: Create Reports
Design a report
Enhance the report
Module 7: Create Dashboards
Create a Dashboard
Real-time Dashboard
Enhance a Dashboard
Module 8: Create and Manage Workspaces
Creating Workspaces
Programme scope, delivery arrangements and suitability are confirmed during enquiry.