This training will enable candidates to:
- Work with Power BI Desktop
- Import Data into Power BI
- Perform Data Cleaning with Power Query
- Create the Data Model
- Create Interactive Dashboard with Power BI Desktop
Theory; Demonstration; Hands on session
We will conduct per and post test to evaluate the participant learning curve. The report will be submitted to the Learning & Development Department.
Training Venue and Facilities
In house training at client premises. Client to provide the training lab with computers that is installed with Microsoft Excel version 2016 above and Power BI desktop
Class date : To be discussed
Class time : 9:00 am to 5:00 pm
Microsoft Excel Power BI
No. Of Days:
2 Days
Language:
English
Prerequisite
Participants with knowledge of Excel Formulas and functions will be an advantage.
Training materials
Printed Notes and exercises file will be shared one day before the class start
Software version
Power BI Desktop
No of Participants
25 participants per batch.
Training Fee
RM6,000 per day x 2 days = RM12,000.00
Certification
Certification of Completion ( PDF) will be sent via email.
Training Course Outline
INTRODUCTION TO POWER BI
- Load data
- Perform basic data cleaning
- Edit rows and columns
- Change data types
- Replace values
- Challenge Exercise 1
BEGINNER LEVEL DATA PREPARATION AND DATA MODEL
- Load data
- Basic cleaning
- Edit rows and columns
- Change data types
- Replace values
- Create table visual
- Create pie chart
- Challenge Exercise 2
INTERMEDIATE DATA PREP & VISUALISATION
- Append query
- Merge query
- Visual drilldown and drill up
- Create line chart
- Challenge Exercise 3
INTERMEDIATE DATA TRANSFORMATION
- Grouping data
- Unpivoting Data
- Basic Filtering Visuals (Panel)
- Advanced Filtering Visuals (Panel)
- Editing the canvas
- Challenge Exercise 4
INTERMEDIATE DATA INTERACTIVE VISULALISATION
- Top N filtering method
- Synchronizing the slicers
- Editing visual interaction
- Creating drill through
- Creating Custom columns
- Columns from examples
- Challenge Exercise 5
INTERMEDIATE DATA ADVANCE VISUALISATION
- Creating Map visuals
- Creating filled map visuals
- Creating page navigation
- Capturing bookmarks and assigning to buttons
- Creating card visual and multi row card visuals
- Creating tooltip page
- Challenge Exercise 6
FINAL DASHBOARD WORKSHOP
- Participants will be given a set of dataset and are required to create a dashboard based on a set of requirements.