Sorry, JavaScript required!

Building and Optimizing Data Visualization with Power BI

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.

  • 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 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
    Sorry, JavaScript required!