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
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
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
