IT10A13 - DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI (SYNCHRONOUS E-LEARNING)

Course Overview

Power BI’s powerful collection of functions and features will help you to analyse your organisation’s data, uncover insights and trends. With this course, you will learn how to model data and create visual reports that reveal data insights. Although the Power BI desktop client will be the primary focus, an introduction to the Power BI web app will also be provided.

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.

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.