Call Us Today! 03-22871829

PL 300 Power BI Data Analyst

Course Duration
3 Days

Training Mode

Accredited By

Course Overview

The Power BI Data Analyst certification course teaches professionals to create data visualizations and dashboards using Microsoft Power BI. It covers accessing and processing data from relational and non-relational sources, implementing security standards, managing and deploying reports and dashboards, and building paginated reports within Power BI. 

Corporate Benefits

Upskilling your employees in this certification offers several advantages, including: 

  • Increasing the productivity and efficiency of the company’s data analysis and reporting 
  • Improving decision-making in the company through accurate and insightful data analysis 
  • Improving business data visualisation and storytelling skills to effectively communicate insights 
  • Lowering organisational costs by reducing reliance on outside consultants or vendors 
  • Increasing a company’s competitive advantage by rapidly adapting to changing business needs and trends

Course ratings

Nurul Azwina Rudi
Data Analyst
Read More
"The Power BI data analyst course was a great help for our company. Our team can now analyse data more efficiently and effectively than ever before, and we've seen measurable improvements in our decision-making processes."
Rajesh Kumar Selvam
Business Intelligence Analyst
Read More
"I highly recommend the Power BI data analyst course. It's helped me to better understand and utilize our company's data, which has led to more informed marketing strategies and better ROI."
Wong Yee Ling
Data Analytics Manager
Read More
"The Power BI data analyst course provided us with the tools and knowledge we needed to optimize our sales processes. We've been able to identify key areas for improvement and make data-driven decisions that have had a significant impact on our bottom line."
Muhammad Azrul Bakri
Senior Business Analyst
Read More
"The Power BI data analyst course was incredibly valuable for our team. We now have a deeper understanding of our data and are able to quickly identify trends and insights that we can act on. It's helped us to become more agile and responsive in our decision-making processes."
John Raj
Data Scientist
Read More
"I can't recommend the Power BI data analyst course enough. The skills and knowledge we gained have been invaluable to our business, and we're now able to analyze data in a more meaningful and impactful way."
Dariah Daril
Business Intelligence Manager
Read More
"The Power BI data analyst course was well-structured and easy to follow, and the instructors were knowledgeable and engaging. It's definitely a must for any company looking to improve their data analysis capabilities."
Lee Ming Wei
Data Analyst
Read More
"Since taking the Power BI data analyst course, our team has been able to streamline our reporting processes and make data-driven decisions that have had a positive impact on our business. I would highly recommend this course to any company looking to improve their data analysis capabilities."
Khairunnisa Rashid
Business Intelligence Analyst
Read More
"The Power BI data analyst course has helped our team to better understand and communicate data insights to our clients. It's improved our overall client relationships and has helped us to deliver better results for their businesses."

Why Choose Us ?

  • Reputable training facility with over 20 years of experience.
  • Experienced and knowledgeable instructors
  • High-quality, relevant, and up-to-date training materials
  • Convenient training that fits your hectic schedule
  • Good value for money that is worth the investment

Course Objectives

  • Ingest, clean, and transform data 
  • Model data for performance and scalability 
  • Design and create reports for data analysis 
  • Apply and perform advanced report analytics 
  • Manage and share report assets 
  • Create paginated reports in Power BI
Show more

Who Should Get Certified

  • Data Analysts 
  • Business Intelligence Developers 
  • Business Analysts 
  • IT Professionals 
  • Project Managers 
  • Anyone interested in a career in data analytics or business intelligence
Show more


  • Have a good understanding of data analysis concepts and proficient in using Microsoft Excel 
  • Have experience working with data from a variety of sources and familiar with database concepts 
  • Have a basic understanding of SQL and data modeling concepts 
  • Familiar with Power BI Desktop and have access to a Power BI tenant to complete the labs and exercises 
Show more

Course Curriculum

Module 1: Get Started with Microsoft Data Analytics 

  • Data analytics and Microsoft 
  • Getting started with Power BI 
  • Lab: getting started in Power BI desktop 
  • Getting started 

Module 2: Prepare Data in Power BI  

  • Get data from various data sources 
  • Lab: preparing data in Power BI desktop 
  • Prepare Data 

Module 3: Clean, Transform, and Load Data in Power BI 

  • Data shaping 
  • Enhance the data structure 
  • Data profiling 
  • Lab: transforming and loading data in Power BI desktop 
  • Loading data 

Module 4: Design a Data Model in Power BI 

  • Introduction to data modelling 
  • Working with tables 
  • Dimensions and hierarchies 
  • Lab: data modeling in Power BI desktop 
  • Create model relationships 
  • Configure tables 
  • Review the model interface 
  • Create quick measures 
  • Lab: advanced data modeling in Power BI desktop 
  • Configure many-to-many relationships 
  • Enforce row-level security 

Module 5: Create Model Calculations using DAX in Power BI 

  • Introduction to DAX 
  • DAX context 
  • Advanced DAX 
  • Lab: advanced DAX in Power BI desktop 
  • Use the CALCULATE() function to manipulate filter context 
  • Use Time Intelligence functions 
  • Lab: introduction to DAX in Power BI Desktop 
  • Create calculated tables 
  • Create calculated columns 
  • Create measures 

Module 6: Optimize Model Performance in Power BI 

  • Optimize the model for performance 
  • Optimize Direct Query models 
  • Create and manage aggregations 

Module 7: Create Reports in Power BI  

  • Design a report 
  • Enhance the report 
  • Lab: designing a report in Power BI desktop 
  • Create a live connection in Power BI desktop 
  • Design a report 
  • Configure visual fields and format properties 
  • Lab: enhancing reports with interaction and formatting in Power BI 
  • desktop 
  • Create and configure Sync Slicers 
  • Create a drill through page 
  • Apply conditional formatting 
  • Create and use Bookmarks 

Module 8: Create Dashboards in Power BI 

  • Create a dashboard 
  • Real-time dashboards 
  • Enhance a dashboard 
  • Lab: creating a dashboard in Power BI service 
  • Create a dashboard 
  • Pin visuals to a dashboard 
  • Configure a dashboard tile alert 
  • Use Q&A to create a dashboard tile 

Module 9: Enhance Reports for Usability and Storytelling in Power BI 

  • Paginated report overview 
  • Create paginated reports 
  • Lab: creating a paginated report in Power BI desktop 
  • Use Power BI report builder 
  • Design a multi-page report layout 
  • Define a data course 
  • Define a dataset 
  • Create a report parameter 
  • Export a report to PDF 

Module 10: Perform Advanced Analytics in Power BI 

  • Advanced analytics 
  • Data insights through AI visuals 
  • Lab: Data analysis in Power BI desktop 
  • Create animated scatter charts 
  • Use the visual to forecast values 
  • Work with Decomposition Tree visual 
  • Work with the Key Influencers visual 

Module 11: Manage Datasets in Power BI 

  • Parameters 
  • Datasets 
  • Security in Power BI 

Module 12: Create and Manage Workspaces in Power BI 

  • Creating Workspaces 
  • Sharing and managing assets 
  • Lab: publishing and sharing Power BI content 
  • Map security principals to dataset roles 
  • Share a dashboard 
  • Publish an App
Show more

Claim with HRD-Corp

We are an authorized training provider of HRD Corp (Human Resources Development Corporation). Our certification training programs are eligible for funding under SBL-Khas Scheme. 

HRD Corp provides training and upskilling opportunities for Malaysian employees who are: 

  • Malaysian citizens or permanent residents
  • Employed in a company that contributes to HRD Corp (employer with 10 or more Malaysian employees, or employers from specific sectors)
  • Registered with the HRD Corp portal and have an activated account
  • Have not attended the same training program within the last 12 months
  • Meet the specific requirements for the training program, such as qualifications, skills, or job-specific criteria

Invest in your employees’ professional growth and development by claiming your training with HRD-Corp today!