Sorry, JavaScript required!

Building and Optimizing Data Visualization with Power BI

Title Building and Optimizing Data Visualization with Power BI
Course code CM635-11-2023-C
Objective This course teaches how to build and optimize data visualization with Power BI. Students will learn how to connect and transform raw data, build a relational data model, and add calculated fields using DAX. In addition, students will learn how to use Power BI visualization and interaction features, including basic charts, matrices, slicers, maps, and what-if parameters. Through detailed examples, students will be able to create customer behavior and consumption trend prediction dashboards, retail sales performance interactive dashboards, and human resources and cost analysis dashboards.

  • Connect and Transform Raw Data
  • Build Relational Data Model
  • Add Calculated Fields with DAX
  • Data Visualization and Interaction
  • Detailed Examples:
Customer behavior and consumption trend prediction dashboard
Retail sales performance interactive dashboard
Human resources and cost analysis dashboard

Assessment In-class performance and exercises
Target audience Anyone who interested in Data analysis and generating better report
Prerequisite Have basic knowledge of data analysis, such as data transform and data cleaning.
Familiar with relational database design and SQL language.
Understand basic statistics and data visualization principles.
Class size 20
Instructor Microsoft certified Trainer(MCT), Oracle Certifited Professional (OCP), a result-driven IT professional experienced in hardware & network troubleshooting. Certified in MCITP,CCNA, Oracle OCP and ITIL v3 qualification. Has been teaching for CPTTM since 2004.
Instruction language Handouts in Chinese (supplemented with English terminology)
Handout language Handouts in Chinese (traditional)
Duration 24 hours in 8 sessions
Schedule 18:45-21:45, from Nov 27, 2023 to Dec 28, 2023 every Monday, Thursday, excluding Dec 18, 2023(Monday), Dec 25, 2023(Monday).
Fee MOP1,600
Venue Cyber-Lab (Rua Comandante Mata Oliveira, Ed. Associacao Industrial, 3-andar Macau)
Certificate Certificate of Completion issued by CPTTM (at least 80% attendance and completing in-class exercises)
PDAC code Approved Course under the SAR Government "Continuing Education Development Program", Code: 2307200251-0
Sorry, JavaScript required!