Facebook Business Analytics Implementation - Products - Lithan Skip to Content

SPActivityHub SPActivityHub

Enquire Now

Hi there!

How would you like to engage with us?

Email

Product 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

(157.5 Hours)

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

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 

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

More Details

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

More Details

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

Pricing and Funding

SGD 9000.00

Pricing

Fee Description

Detailed Breakdown

SHARE THIS PAGE

Share This