Facebook NICF-Data Queries and Visualization Basics(SF) - Products - Lithan Skip to Content

SPActivityHub SPActivityHub

Enquire Now

Hi there!

How would you like to engage with us?

Email

Product Product

NICF-Data Queries and Visualization Basics(SF)

2 weeks full time / 1 month part time Instructor-led Live & Mentor-led Blended Learning NICF-Data Queries and Visualization Basics(SF)

Learn how to Query data using Transact-SQL and Visualize data using Power BI.

What do I Get?

Acquire Power BI and SQL Skills

Learn the  skills and knowledge to analyze, visualize and report information using Microsoft Power BI along with basic concepts of Data Modelling , SQL Transformations, Statistical foundations and the various forms of Data Analysis

Mentor-Led Blended Learning Delivery

We deliver blended learning through a combination of self-paced e-learning, instructor-led flipped classes and personalised mentoring  with industry practitioners to greatly increase your efficiency and effectiveness in acquiring knowledge and skills

Up to 90% Funding

Singapore Citizens / Permanent Residents can receive up to 90% funding* from SkillsFuture Singapore and further subsidies using your SkillsFuture credit and Post-Secondary Education Account.

*Terms and Conditions apply

Audience and Certificates

Target Audience

  • Higher Learning students who want to gain skills in Data Exploration, Visualization, Cleaning and Transformation

Prerequisite

Minimum O Level or its equivalent with 1 year IT or Business related experience 

Graduation Requirements

  • Minimum attendance of 75% for all sessions in the modular course
  • Should be assessed Competent (C) in the modular course

Certificate(s)

  • Statement of Attainment by SSG, Singapore: ICT-DES-4001-1.1 Data Design

  • Statement of Attainment by SSG, Singapore: ICT-DIT-4006-1.1 Data Visualisation

Blended Learning Journey

(60.5 Hours)

E-Learning

15 hours

Flipped Class/Mentoring

15 hours

Projects / Assignments

30 hours

Assessment

0.5 hours

Modules

NICF-Data Queries and Visualization Basics (SF)

You will get started on your Analytical journey by learning how to write queries and modify data using Transact-SQL as well as visualise data using Power BI. Learn the  skills and knowledge to analyze, visualize and report information using Microsoft Power BI along with basic concepts of Data Modelling , SQL Transformations, Statistical foundations and the various forms of Data Analysis

Session Plan

More Details

Learning Outcome

Knowledge

By the end of this module, the learner should be able to gain the following knowledge:

  • Foundational statistics that can be used to analyze data
  • Learn Syntax of Transact-SQL, working with data types, tables and manipulating data using T-SQL
  • Understand how to program using Transact-SQL
  • Learn how to perform visual analysis to gather insights using Power BI
  • Learn different types of data visualisation techniques using Power BI
  • Working with different types of data sources connecting Power BI

Skills

  • Assess the data to be visualised based on the volume, velocity and variety
  • Create reports using the relevant Power BI visualisation techniques
  • Develop a data visualisation model that conveys the insights to the audience
  • Develop PowerBI dashboards 
  • Write programs using T-SQL
  • Implement error handling and transactions using T-SQL

Other Information

Course Code: CRS-Q-0037588-ICT  

Funding Validity Period: Until 03-Feb-2021     

Course Developer: Lithan Academy 

Pricing and Funding

SGD 3000.00

Pricing

Fee Description

Detailed Breakdown

SHARE THIS PAGE

Share This