IT10A13: DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI
DATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI
Course Duration
Mode of Assessment
Participants will be required to complete a paper-based assessment during class.
Who Should Attend
This course is intended for learners who are experienced with analysing data using Microsoft Excel and wish to expand on improving their BI techniques using Power BI. It is also for learners who are SQL Server report creators and are interested in using Power BI as an alternative tool of presenting data.
- Users with limited Microsoft Excel knowledge but require to work with IT and other departments within the organisation to conduct data analysis
- Business professionals requiring Microsoft Excel knowledge for data analysis
What's In It for Me
- Learn the fundamentals of data visualisation using Power BI
- Understand the job functions and roles of business analysts and data engineers
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 Schedule
Next available schedule
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:
Good-to-have:
Not recommended: |
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].
- Certificate of completion from NTUC LearningHub
Upon meeting at least 75% attendance and passing the assessment(s), participants will receive a Certificate of Completion from NTUC LearningHub.
Additional Details
Medium of Instruction: English
Trainer to trainee ratio: 1:20
Mode of Delivery: Mode of Delivery: <Virtual Live Class (VLC) via Zoom> or <Physical class>
Price
Course Fee and Government Subsidies |
||||||
|
Individual Sponsored |
Company Sponsored |
||||
|
Non-SME |
SME |
||||
Before GST |
After GST |
Before GST |
After GST |
Before GST |
After GST |
|
Full Course Fee |
$1,200.00 |
$1,308.00 |
$1,200.00 |
$1,308.00 |
$1,200.00 |
$1,308.00 |
For Singapore Citizens aged 39 years and below |
$360.00 |
$392.40 |
$360.00 |
$392.40 |
$120.00 |
$152.40 |
For Singapore Citizens aged 40 years and above |
$120.00 |
$152.40 |
$120.00 |
$152.40 |
$120.00 |
$152.40 |
Funding Eligibility Criteria
Individual Sponsored Trainee |
Company Sponsored Trainee |
|
|
Remarks
Individual Sponsored Trainee |
Company Sponsored Trainee |
SkillsFuture Credit:
UTAP:
PSEA:
|
Absentee Payroll (AP) Funding:
|
Terms & Conditions apply. NTUC LearningHub reserves the right to make changes or improvements to any of the products described in this document without prior notice.
Prices are subject to other LHUB miscellaneous fees.
Batch ID | Course Period | Course Title | Funding Available |
Duration (Hours) |
Session (Hours) |
Venue | Available Seats |
Online Payment |
---|
What Others Also Enrolled In
ANALYZING AND VISUALIZING DATA WITH POWER BI (SF) (SYNCHRONOUS E-LEARNING)
View detailDATA VISUALISATION FUNDAMENTALS USING MICROSOFT POWER BI
View detail