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 :: Procurement Data Analyst using 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: Create Measures using DAX in Power BI
- Introduction to DAX
- DAX context
Module 5: Create Reports
- Design a report
- Enhance the report
Module 6: Create Dashboards
- Create a Dashboard
- Real-time Dashboard
- Enhance a Dashboard
Module 7: Create and Manage Workspaces
- Creating Workspaces
Programme scope, delivery arrangements and suitability are confirmed during enquiry.