Product
Business Analytics Implementation
4 weeks part time per module Online Synchronous Sessions by the Instructor & Mentor
Acquire Business Analytics Implementation Skills
What do I Get?
Understand Data Analytics & Explore Data Analytics Tools
Understand Data Analytics and its types, its application to the business and how it is beneficial to the management Explore data analytics tools for the implementation of the analytics to the business.
Perform Data extraction and Cleaning & Configure Data Model
Connect the data for analytics, learn to extract & clean data sources to develop data warehouse Configure data model with data tables, relationships & schema to perform the data analytics as per the requirement of the business
Develop Reports & Dashboards
Develop paginated reports with table, matrix & free-form layout from the analyzed data. Create visualizations dashboards to deliver business insights
Identify the Business Needs to Provide Business Analytics Solutions
Obtain the business requirements from your organization and identify the data points to perform the data analytics in Power BI
Perform the Data Cleansing and Data Transformation
Collect the data from different data source and perform the data cleansing and transform the data based on business requirements to create a data model using power BI
Implement the Business Analytics Solution
Create reports using the relevant Power BI visualization techniques and develop Power BI dashboards and get signoff from your organisation after User Acceptance testing
Audience and Certificates
Target Audience
- Candidates who are working in SMB or in Corporates and would like to attain digital skills or enhance the digital skills
Prerequisite
English Proficiency: Reading and writing proficiency in English
Academic Qualification: Minimum 1 credit in GCE O level or its equivalent: Matured candidates with relevant work experience (candidates will be selected on a case-to-case basis)
Experience: In general, not mandatory. But for some courses, relevant experience is preferable which will be analyzed on case-to-case basis
Graduation Requirements
- Minimum attendance of 75% for all sessions in each module of the course
- Should be assessed Competent (C) in each module of the 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
- Statement of Attainment by SSG, Singapore: ICT-DIT-2005-1.1 Data Engineering
Blended Learning Journey
E-Learning
15 hours
Flipped Class/Mentoring
22 hours
Projects / Assignments
83 hours
Assessment
1 hours
Modules
NICF-Data Queries and Visualization Basics (SF) (Synchronous and Asynchronous E-Learning)
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
By the end of this module, the Learner should be able to apply the following 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
Funding Validity Period: Until 2-March-2023
Course Developer: Lithan Academy
Course Code: TGS-2019503110
NICF-Analytics Implementation (SF) (Synchronous and Asynchronous E-Learning)
Learners will learn how to implement Microsoft Power BI in their organization, starting from identifying Various data sources, extracting, cleaning and transforming data, connecting Power BI to Data Sources, Using various tools available in Power BI and creating dashboards and reports, and present finding to business.
Session Plan
Learning Outcome
Knowledge
By the end of this module, the learner should be able to gain the following knowledge:
- Data Specification and requirement gathering
- Identifying Data Sources
- Data Extraction, Cleansing, Transformation and Loading
- Various types of Data Analysis
- Power BI functions and features
- Deployment of dashboard and reports created in Power BI
Skills
By the end of this module, the learner should be able to apply the following skills:
- Identify data and data sources required for Analytics Implementation
- Extract, Clean and Transform Data
- Create Data Models using the transformed data
- Visualize Data using maps, graphs, charts etc in Power BI
- Perform statistical analysis / correlation analysis of data to draw business insights
Other Information
Funding Validity Period: Until 02-Jan-2024
Course Developer : Lithan Academy
Course Code: TGS-2018500976
