Skip To Content
NICF – Data Appreciation to Extract Business Value (SF) is a Program

NICF – Data Appreciation to Extract Business Value (SF)

Self-paced

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

NICF – Data Appreciation to Extract Business Value (SF)

Course Overview

This powerful collection of software, apps, and services will help you analyse your organizations data and uncover insights and trends. This course will show you how to link and model data in Power BI 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.

Who Should Attend

This course is intended for students who are experienced with analyzing data with Excel and who wish to add BI techniques.

The course will likely be attended by SQL Server report creators who are interested in alternative methods of presenting data.

Course Duration

2 Days / 16 Hours (Including 2 hrs of assessment)

Course Outline

Lesson 1: Getting Started

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

Lesson 2: Working with Data

  • Transforming and Sanitizing Data
  • Using the Query Editor
  • Data Modeling
  • Managing Relationships 

Lesson 3: Working with Reports and Visualizations

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

Lesson 4: A Closer Look at Visualizations

  • TOPIC A: Matrixes, Tables, and Charts
  • TOPIC B: Maps
  • TOPIC C: Cards, Gauges, and KPIs
  • TOPIC D: Slicers 

Lesson 5: Introduction to the Power BI Web App

  • TOPIC A: Getting Started
  • TOPIC B: Connecting to Data Sources with the Power BI Web App
  • TOPIC C: Using Workspaces, Dashboards, and Reports
  • TOPIC D: Creating Custom Dashboards
  • TOPIC E: Power BI Web App Features

Mode of Assessment

You must complete a paper-based assessment during the class.

Certification Obtained and Conferred by

Statement of Attainment from SkillsFuture Singapore (SSG)

Upon meeting at least 75% attendance and passing the assessment(s), Statement of Attainment (SOAs) will be issued by SkillsFuture Singapore (SSG) to certify that the participant has achieved the following Competency Standard(s):

  • in Data Visualization (ICT-DIT-3006-1.1)

NTUC LearningHub reserves the right not to disclose any information on the assessment process.

Course Objectives

After completing this course, you will be able to:

  • Work with Data to transform and sanitize data, use the query editor, model data and manage relationships
  • Create interactive dashboard that allow stakeholder to filter information
  • Work with charts, such as maps, treemap etc for display of information
  • Presenting and sharing of finished dashboard using Power BI Web App

Pre-requisites

Before attending this course, you must have:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality
  • Working knowledge of relational databases
  • Extensive knowledge of Excel spreadsheets including formulas, charts, filtering, sorting, and sub-totals

You would need to download the following software before attending the VLC class:

* We will use ZOOM as the training platform and webcam and Mic are compulsory

Medium of Instruction & Trainer

Medium of Instruction: English

Trainer: Trainee ratio is 1: 20

Additional Note

Not Applicable

Price

This course is available only for company-sponsored candidates who are working for organisations that have enrolled in NTUCs Company Training Committee (CTC)

 

Company Sponsored

Non-SME

SME

w/o GST

w GST

w/o GST

w GST

Full Course Fee

$780.00

$834.60

$780.00

$834.60

Singapore Citizens & PRs aged 21 years and above

$234.00

$250.38

$234.00

$250.38

Singapore Citizens aged 40 years and above

$234.00

$250.38

$234.00

$250.38

Singapore Citizens aged 35 years and above who are not earning more than $2,000 per month (WTS Scheme)

$234.00

$250.38

$234.00

$250.38

 

Remarks:

  • Singaporeans / PRs sponsored by SMEs will be eligible to claim additional 20% funding ($156) via SkillsConnect
  • Singaporeans aged >= 40 years of age, regardless of sponsored by SME or Non-SME will be eligible to claim additional 20% funding ($156) via SkillsConnect
  • Singaporeans aged >=35 years & earning a salary <= $2,000 per month will be eligible to claim additional 25% funding ($195) via SkillsConnect.

Terms and conditions apply. NTUC LearningHub reserve 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.

CTCIT02