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, and create the visualizations for report and dashboard.
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.
Course Outline :: Power BI Basic ::
Module 1: Get Started with Microsoft Data Analytics
Data Analytics and Microsoft
Getting Started with Power BI
After completing this module, students will be able to:
Explore the different roles in data
Identify the tasks that are performed by a data analyst
Describe the Power BI landscape of products and services
Use the Power BI service
Module 2: Prepare Data in Power BI
Get Data from Various Data Sources
Resolve Data Errors
After completing this module, students will be able to:
Identify and retrieve data from different data sources
Understand the connection methods and their performance implications
Use Microsoft Dataverse
Connect to a data flow
Module 3: Clean, Transform, and Load Data in Power BI
Data Shaping
Enhance the Data Structure
Data Profiling
After completing this module, students will be able to:
Apply data shape transformations
Enhance the structure of the data
Profile and examine the data
Module 4: Design a Data Model in Power BI
Introduction to Data Modeling
Working with tables
Dimensions and Hierarchies
After completing this module, students will be able to:
Understand the basics of data modeling
Course Outline :: Power BI Basic ::
Define relationships and their cardinality
Implement Dimensions and Hierarchies
Create histograms and rankings
Programme scope, delivery arrangements and suitability are confirmed during enquiry.