| Title | Building and Optimizing Data Visualization with Power BI |
| Course code | CM635-07-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. |
| Content |
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 | 24 Full |
| 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 | 10:00-13:00, from Jul 9, 2023 to Aug 27, 2023 every Sunday. |
| 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: 2304190218-0 |