Certificate in Power BI for Data Analytics - 生產力學院
Certificate in Power BI for Data Analytics
陳先生, 電話: 2788 5800


This course is designed to arm participants with knowledge on using the most highly rated Data Analytics and Business Intelligence Tool, Power BI to go from data to insights! We will cover:

  • Discover data analysis
  • Advance features of Power BI
  • Data Modelling
  • Visualization and Dashboards
  • Datasets management

Download Full Course Detail ▼ 

Course Objectives

  • Participants will be able to analyse data from different data sources and create their own datasets
  • Participants will be able to comfortably work with the different tools of the Power BI universe and know how the different tools work together
  • Participants will have the required knowledge to dive deeper into Power BI and find out more about its advanced features

Course Outline

Online Session*: Explore what Power BI can do for you (69 mins)

Topic 1: Discover data analysis 

  • Overview of data analysis
  • Roles in data
  • Tasks of a data analyst
  • Build up knowledge

Topic 2: Perform analytics in Power BI

  • Introduction to analytics
  • Advance data modelling
  • Explore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Use advanced analytics custom visuals
  • Review Quick insights
  • Apply AI Insights

Topic 3: Work with AI visuals in Power BI 

  • Introduction to working with AI visuals
  • Use the Q&A visual
  • Find important factors with the Key influencers visual
  • Use the Decomposition Tree visual to break down a measure
  • Exercise – Data analysis in Power BI Desktop

Topic 4: Data Model Design and Use DAX in Power BI Desktop 

  • Design a data model in Power BI
  • Working with tables
  • Work with dimensions
  • Star schema design
  • Analytic queries
  • Configure report visuals
  • Write DAX formulas
  • DAX data types
  • Work with DAX functions
  • Use DAX operators
  • Use DAX variables
  • Use DAX time intelligence functions
  • Additional time intelligence calculation

Topic 5: Data Visualization in Power BI  

  • Introduction to visuals in Power BI
  • Create and customize simple visualizations
  • Create slicers
  • Map visualizations
  • Matrices and tables
  • Create scatter, waterfall, and funnel charts
  • Modify colors in charts and visuals
  • Page layout and formatting

Topic 6: Manage workspaces in Power BI

  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection

Topic 7: Manage datasets in Power BI

  • Create dynamic reports with parameters
  • Create what-if parameters
  • Configure a dataset scheduled refresh
  • Manage and promote datasets
  • Troubleshoot service connectivity
  • Exercise on datasets

Topic 8: Extra Visuals and Integration with Power

  • Create Extra Visuals
  • Heatmap, Sankey Diagrams, Violin Chart etc.
  • Integration with Power Apps
  • Exercise on datasets

Date & Time

Date: 14-15 Dec 2023

Time: 09:30 – 17:00


Cantonese, supplemented with English terminology

Course Fee

HK$5,760* (May apply up to HK$3,840* RTTP subsidy)
*Maximum saving, with the final grant subjects to approval.


Complete Power BI for Business Users or experiences with Power BI Desktop

Award of Certificate of Accomplishment

Participants with full accomplishment and completion of online training hours will be awarded a Certificate of Accomplishment by the Hong Kong Productivity Council.*

Trainers Profile

Patrick TSOI, he is a trainer with over 25+ years hands-on data science, Big Data and programming experiences. He is a Doctor of Education graduate from the Hong Kong Baptist University, Master in IT Education graduate from the University of Hong Kong and B.Eng in System Engineering and Engineering Management from the Chinese University of Hong Kong.