|Title||Building and Optimizing Data Visualization with Power BI|
|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.|
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.
|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).|
|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|