Product
Business Analytics Implementation
5 weeks part time / 2 weeks full time per module Online Synchronous Sessions by the Instructor & Mentor
Learn how to query data using SQL, perform analysis and visualize data using Power BI
What do I Get?
Acquire Power BI and SQL Skills
Learn how to visualize, analyse and report information using Microsoft Power BI along with basic concepts of Data Modellinga, analnd the various forms of Data Analysis
Acquire Operational Analytics Skills
Learn how to extract operations data of the enterprise from SQL or any other source and transform data and perform data modelling using Power BI desktop to create stunning visuals and perform the data analysis
Execute Analytics Implementation Project
Execute Analytics Implementation project using Power BI tool by identifying various data sources, extracting , cleaning and transforming data and create reports and dashboards as per the business requirement.
Audience and Certificates
Target Audience
- Entrepreneurs and relevant stakeholders responsible to analyse the data and generate reports for better decision making
- Leadership and management teams, mid-level managers of small and medium enterprises seeking business analytics solution to the organisation
Prerequisite
O level or ITE or A level with minimum 1 credits and with minimum 1 year of work experience in the relevant field.
Graduation Requirements
- Minimum attendance of 75% for all Sessions in each of the modules of the course
- Should be assessed Competent (C) in each of the modules 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
24 hours
Projects / Assignments
72 hours
Flipped Class/Mentoring
60 hours
Assessment
1.5 hours
Modules
NICF-Data Queries and Visualization Basics (SF) (Synch & Asynch 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
- 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
NICF-Operational Analytics (SF) (Synch & Asynch E-Learning)
Learners will learn how to implement Microsoft Power BI in their organization, Understand various data sources of operational application and building blocks of Power BI such as Visualizations, DataSets, Reports, Dashboards and Tiles, learn how to use Power BI Desktop and Power BI Service to extract, clean, transform, model, visualize and explore data from various sources
Session Plan
Learning Outcome
Knowledge
By the end of this module, the learner should be able to gain the following knowledge:
- Interpretation of data analysis and findings
- Types of information displays
- Suitability of different data representations and visual displays for different contexts
- Data visualisation tools and techniques
- Elements of data dashboards
- Data specifications and requirements
- Variety of data sources
- Relationship identification and mapping among different data sources and systems
- Range of tools to gather, process and optimise accuracy and functionality of data
- Methods and considerations to process multiple streams of data
- Data transformation techniques
- Trade offs between data access optimisation and loading or resource utilisationfactors
Skills
By the end of this module, the learner should be able to apply the following skills:
- Identify relevant data sources, processes and relationships in accordance to business requirements
- Propose methods and tools to gather data, process data, and minimiseconfounding variables and data limitations
- Apply data analysis and data profiling to improve the clarify, quality and integrity of valid data
- Process multiple streams of data using data systems
- Utilise data systems and platform capabilities to solve new data problems
- Transform data to meet specific business requirements
- Operate data warehouse systems to balance optimisation of data access with loading and resource utilisation factors
- Create supporting documentation with metadata and diagrams of entity relationships, business processes and process flow
- Map data between source systems, data warehouses and data marts
Other Information
Qualification Course Code: CRS-Q-0032185-ICT
Funding Validity Period: Until 2-Jan-2022
Course Developer : Lithan Academy
NICF-Analytics Implementation (SF) (Synch & Asynch 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
Qualification Course Code: CRS-Q-0032184-ICT
Funding Validity Period: Until 02-Jan-2022
Course Developer : Lithan Academy
