NTUC LearningHub

Course Objectives

 

  • Perform data analysis in Power BI
  • Identify data types and explain how they are interpreted as visualisations
  • Design and create visualisations, based on user-centred workflows, for others to use
  • Discuss concepts of data visualisation and how they are implemented in Power BI
  • Identify best practices for Power BI visualisation design
  • Share insights with Power BI

 

Pre-requisites

 

The admission requirements are:

  • Basic working knowledge of Microsoft Excel
  • Working knowledge of relational databases
  • Extensive knowledge on the use Microsoft Excel’s worksheets features and functions such as formulas, charts, filtering, sorting, and sub-total etc.
  • Read, write, and speak English at WPL Level 4
  • Manipulate numbers at WPN Level 4
  • Hardware & Software
    • This course will be conducted as a Virtual Live Class (VLC) via Zoom platform
    • Participants must own a Zoom account and have a laptop or a desktop with “Zoom Client for Meetings” installed. Download from zoom.us/download.

System Requirement

Must-have:
Please ensure that your computer or laptop meets the following requirements.

  • Operating system: Windows 10 or MacOS (64 bit or above)
  • Processor/CPU: 1.8 GHz, 2-core Intel Core i3 or higher
  • Minimum 20 GB hard disk space
  • Minimum 8 GB RAM
  • Webcam (camera must be turned on for the duration of the class)
  • Microphone
  • Internet Connection: Wired or Wireless broadband
  • Latest version of Zoom software to be installed on computer or laptop prior to the class.

Good-to-have:

  • Wired internet connection
    Wired internet will provide you with stable and reliable connection.
  • Dual monitors
    Using a dual monitor setup will undoubtedly improve your training experience, enabling you to simultaneously participate in hands-on exercises and maintain engagement with your instructor.

Not recommended:
Using tablets are not recommended due to their smaller screen size, which could cause eye strain and discomfort over the course of the program's duration.

 

Course Outline

 

Module 1: Get Started with Power BI

    • Introduction to Power BI
    • Working with Power BI Desktop Files
    • Connecting to Data Sources with Power BI Desktop
    • Creating a Report with Visualisations
    • Doing More with Visualisations

 

Module 2: Working with Data

    • Transforming and Sanitising Data
    • Using the Query Editor
    • Data Modelling
    • Managing Relationships

 

Module 3: Working with Reports and Visualisations

    • Managing Report Pages
    • Changing Report View Options
    • Working with Visualisations
    • Adding Static Objects to a Report

 

Module 4: A closer look at Visualisations

    • Matrixes, Tables, and Charts
    • Maps
    • Cards, Gauges, and KPIs
    • Slicers

 

Module 5: Getting started with Power BI Web App

    • Connecting to Data Sources with the Power BI Web App
    • Using Workspaces, Dashboards, and Reports
    • Creating Custom Dashboards
    • Power BI Web App Features

 

Certificate Obtained and Conferred by

 

  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Statement of Attainment (SOA), accredited by SkillsFuture Singapore. SOA will be reflected as [ICT-DIT-3006-1.1 Data Visualisation].
  • Upon meeting 75% attendance and passing the assessment, participants will be awarded with a digital Certificate of Completion from NTUC LearningHub.
Categories
More Information
  • NTUC LearningHub
  • No comments yet.
  • Add a review
    error: Content is protected !!