Product
Professional Diploma in Business Intelligence
NICF - Diploma In IT Services (Database Management) Data Science
-
Brochures - Videos
Course Outcome
Get Trained
Implement and Administer SAP Net weaver Business Warehousing System, extract data from SAP source systems, manage delta data, create Simple Queries in BEx Query Designer and create Web Applications for SAP BW using Web Application designer to become a BI Consultant.
Get Experiential
With the guidance of Industry Experts, learners gain the hands-on skills in data modelling and transformation, creating queries & reports as per the business requirements in a simulated environment, as a part of the module project and capstone project.
Get Hired
After successfully completing the course, learners can be expected to take up entry level SAP BW consultant jobs.
Get Certified
Upon successful course completion, the learner will be eligible to appear for SAP Certified Application Associate - Business Intelligence with SAP BW 7.3 9. In addition, a learner will also receive the following:
- 11 NICF Statements of Attainment (SOA)
- NICF Diploma in IT Services (Database Management)
How You Learn
How You Learn?
Learning Duration (GLH*) - 264.5 Hours
| On Campus Hours 156.5 Hours | Off Campus Hours 108 Hours |
*Guided Learning Hours
Course Structure
Course Structure
NICF - Diploma In IT Services (Database Management)
This course provides the learner with knowledge, hands-on skills and development experience in SAP BW.
Learners will be able to analyze the functional specifications prepared by the SAP functional consultants and Extract and Modelling using BW.
Learners will acquire hands-on experience in Extraction tools (ETL), Modelling, Multidimensional design, Query designing, Web Application designing, Analysis, and Integrated Planning.
Learners will also apply the business intelligence concepts into different industrial applications such as Finance company, healthcare industry, telecommunication industry and service industry
The learner can use SAP Learning Hub & Lithan LMS for e-learning and SAP server Access for performing simulated Lab Exercises, Module Projects.
This course consists of following modules:
- Introduction to Business Intelligence
- Business Intelligence Applications
- Data Modelling & Transformation
- Strategic Usage of Business Intelligence
- Business Intelligence Queries & Reports
- Capstone Project – Business Intelligence
Course Modules :
Outline 
Schedule IBI - NICF - Introduction to Business Intelligence
| Module Name | NICF - Introduction to Business Intelligence |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus or go through a recording of the Orientation Session. After the Orientation, the Lecturer will introduce the module by conducting the lectures on
| |
Session 2: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU1 - IU4 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 3: Lab Exercises – On Campus (3 hrs) | The Student will PERFORM activities related to IU1, IU2, IU3 & IU4 in Server Lab environment | |
Session 4: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU5 & IU6 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 5: Lab Exercises – On Campus (3 hrs) | The student will perform activities related to IU 5 & IU 6 in server lab environment | |
Session 6: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs: IU 7: Intro to Embedded Analytics IU 8: Intro to Data warehouse | Before session: The Student will engage in e-learning to LEARN IU7 & IU8 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 7: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 7 & IU 8 in Server Lab environment | |
Session 8: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU9 & IU10 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 9: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 9 & IU 10 in Server Lab environment | |
Session 10: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU11 & IU12 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 11: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU11 & IU12 in Server Lab environment | |
Session 12: Tutoring - Live (3 hrs) |
| Before session:
|
Session 13: Project Implementation – Off campus (3 hrs) | Module Project – Implementation -2
| |
Session 14: Summative Assessment (4 hrs) | Students will attempt a Theory Test (1 hr) & Practical Test (2 hrs, 45 mins) | During session: Assessor will asses the student through oral questions (15 mins) and provide review and feedback |
| Module Name | NICF - Introduction to Business Intelligence |
|---|---|
| Competency Unit | IT-DM-401S-1 (IBI) : Build a database |
By end of this module, the learner should be able to gain the following knowledge:
- Introduction to SAP Business Warehouse systems
- Components of SAP BW Data Warehousing Workbench
- Knowledge of S4/Hana
- Introduction to SAP BOBI (SAP Business Objects Business Intelligence)
- Intro to SAP BW powered by SAP HANA
By end of this module, the learner should be able to perform the following activities:
- Define the outline of Business intelligence Star Schema
- Define the adoption of new SAP best practices
- Navigate in SAP Launch pad
- Navigate in SAP ABAP Planning Modeller
BIA - NICF - Business Intelligence Applications
| Module Name | NICF - Business Intelligence Applications |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus or go through a recording of the Orientation Session. After the Orientation, the Lecturer will introduce the module by conducting the lectures on:
| |
Session 2: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU1 - IU4 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 3: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU1, IU2, IU3 & IU4 in Server Lab environment | |
Session 4: Lecture (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU5 & IU6 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 5: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 5 & IU 6 in Server Lab environment | |
Session 6: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU7 & IU8 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 7: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 7 & IU 8 in Server Lab environment | |
Session 8: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU9 & IU10 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 9: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 9 & IU 10 in Server Lab environment | |
Session 10: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU11 & IU12 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 11: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities related to IU 11 & IU 12 in Server Lab environment | |
Session 12: Tutoring - Live (3 hrs) |
| Before session:
|
Session 13: Project Implementation – Off campus (3 hrs) | Module Project – Implementation -2
| |
Session 14: Summative Assessment (4 hrs) | Students will attempt a Theory Test (1 hr) & Practical Test (2 hrs, 45 mins) | During session: Assessor will asses the student through oral questions (15 mins) and provide review and feedback |
| Module Name | NICF - Business Intelligence Applications |
|---|---|
| Competency Unit | IT-DM-402S-1 (BIA) : Identify physical database requirements IT-AS-401S-1 (BIA) : Analyse and Troubleshoot application problem (3 Credit Values) IT-AS-402S-1 BIA : Generate and review application support report |
By end of this module, the learner should be able to gain the following knowledge:
- Components of Data Mining solutions
- Concepts of text mining, data mining
- Data mining Emerging trends
- Needs for BI in health care industries
- Key measures for BI retail
- BI application for Telecomm industry
By end of this module, the learner should be able to perform the following activities:
- Forecast the BI application in finance industries
- Draw a BI architecture for Health care, Finance industries
- Prepare a BI blue print for Telecomm industries
- Perform Gap & Conflict Analysis for Service Industries
- Discuss the BI best practices for Retail industry
- Prepare BI reports
- List the BI value chain for telecomm industry
DMT - NICF - Data Modelling & Transformation
| Module Name | NICF - Data Modelling & Transformation |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus or go through a recording of the Orientation Session. After the Orientation, the Lecturer will introduce the module by conducting the lectures on:
| |
Session 2: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU1 - IU4 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 3: Lab Exercises – On Campus (3 hrs) | The Student will PERFORM activities realted to IU1 – IU4 in Server Lab environment | |
Session 4: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU5 & IU6 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 5: Lab Exercises – On Campus (3 hrs) | The Student will PERFORM activities realted to IU5 & IU6 in Server Lab environment | |
Session 6: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU7 & IU8 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 7: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU7 & IU8 in Server Lab environment | |
Session 8: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU9 & IU10 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 9: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU9 & IU10 in Server Lab environment | |
Session 10: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU11 & IU12 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 11: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU11 & IU12 in Server Lab environment | |
Session 12: Tutoring - Live (3 hrs) |
| Before session:
|
Session 13: Project Implementation – Off campus (3 hrs) | Module Project – Implementation -2
| |
Session 14: Summative Assessment (4 hrs) | Students will attempt a Theory Test (1 hr) & Practical Test (2 hrs, 45 mins) | During session: Assessor will asses the student through oral questions (15 mins) and provide review and feedback |
| Module Name | NICF - Data Modelling & Transformation |
|---|---|
| Competency Unit | IT-DE-502S-1 : Design extract, transform and load (ETL) process (3 Credit Values) IT-DM-406S-1 : Determine that database functionality and scalability suit business requirements (2 Credit Values) |
By end of this module, the learner should be able to gain the following knowledge:
- Introduction to Data Warehouse systems and its LSA (Layered Scalable Architecture)
- Components of SAP BW Data Warehousing Workbench
- Overview of Multi Dimensional Modelling and Extended Star Schema in SAP BW
- Master Data Modelling in SAP BW
- Loading of Master Data and Transaction Data from SAP Data sources
- Loading data from Flat file Data sources
- Overview of Info Providers in SAP BW
By end of this module, the learner should be able to perform the following activities:
- Define the outline of Business intelligence Star Schema
- Define the Graphical Data Flow and Model the ETL (Extraction, Transformation and Loading)
- Extract Master Data and Transaction Data from SAP Data Sources
- Extract data from Flat file Source System
- Create Infoobjects in SAP BW using Data Warehousing Workbench
- Create Infoproviders such as DSO, Infocubes
- Modelling on Multiproviders, Infosets, Virtual Providers
SBI - NICF - Strategic Use of Business Intelligence
| Module Name | NICF - Strategic Use of Business Intelligence |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus or go through a recording of the Orientation Session. After the Orientation, the Lecturer will introduce the module by conducting the lectures on:
| |
Session 2: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU1 - IU4 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 3: Lab Exercises – On Campus (3 hrs) | The Student will PERFORM activities realted to IU1 – IU4 in Server Lab environment | |
Session 4: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU5 & IU6 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 5: Lab Exercises – On Campus (3 hrs) | The Student will PERFORM activities realted to IU5 & IU6 in Server Lab environment | |
Session 6: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU7 & IU8 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 7: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU7 & IU8 in Server Lab environment | |
Session 8: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU9 & IU10 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 9: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU9 & IU10 in Server Lab environment | |
Session 10: Lecture – Live (3 hrs) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs :
| Before session: The Student will engage in e-learning to LEARN IU11 & IU12 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 11: Lab Exercises - On Campus (3 hrs) | The Student will PERFORM activities realted to IU11 & IU12 in Server Lab environment | |
Session 12: Tutoring - Live (3 hrs) |
| Before session:
|
Session 13: Project Implementation – Off campus (3 hrs) | Module Project – Implementation -2
| |
Session 14: Summative Assessment (4 hrs) | Students will attempt a Theory Test (1 hr) & Practical Test (2 hrs, 45 mins) | During session: Assessor will asses the student through oral questions (15 mins) and provide review and feedback |
| Module Name | NICF - Strategic Use of Business Intelligence |
|---|---|
| Competency Unit | IT-RG-401S-1 (SUBI) : Determine business expectations and needs |
By end of this module, the learner should be able to gain the following knowledge:
- Introduction to Data Extraction using Delta management
- Different types of Source systems
- Overview of Delta extraction using many source system
- Defining and configuring Logistics Extraction
- Concepts of Data Extraction using SLT (System Landscape Transformation)
- Concepts of UD (Universal Data Connect) and DB connect
- Concepts of Web services
By end of this module, the learner should be able to perform the following activities:
- Extraction of Data using Delta management techniques
- Configure Logistics Extraction with Delta Mode
- Load Data directly without PSA (Persistent Staging Area)
- Replicate data from SAP Source systems
- Creating delta enables File data sources
- Design XML based extraction using WEB SERVICES
BIQ - NICF - Business Intelligence Queries & Reports
| Module Name | NICF - Business Intelligence Queries & Reports |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus or go through a recording of the Orientation Session. After the Orientation, the Lecturer will introduce the module by conducting the lectures on:
| |
Session 2: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU 1- IU 4 (3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 3: Lab exercises Off campus (3 Hours) | The Student will PERFORM activities related to IU 1 - IU 4 in Server Lab environment | |
Session 4: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU 5 & IU 6 (3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 5: Lab exercises Off campus (3 Hours) | The Student will PERFORM activities related to IU 5 & IU 6 in Server Lab environment | |
Session 6: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU7 & IU8 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 7: Lab exercises On campus (3 Hours) | The Student will PERFORM activities related to IU 7 & IU 8 in Server Lab environment | |
Session 8: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU9 & IU10 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 9: Lab exercises On Campus (3 Hours) | The Student will PERFORM activities related to IU 9 & IU 10 in Server Lab environment | |
Session 10: Lecture - Live (3 Hours) | The lecturer will deliver lectures & demo in the class room related to the topics of corresponding IUs:
| Before session: The Student will engage in e-learning to LEARN IU11 & IU12 (off campus - 3 hrs) The Student should complete self-assessments Student can approach Online Support for any queries or guidance |
Session 11: Lab exercises (3 Hours) | The Student will PERFORM activities related to IU 11 & IU 12 in Server Lab environment | |
Session 12: Tutoring - Live (3 hrs) |
| Before session:
|
Session 13: Project Implementation – Off campus (3 hrs) | Module Project – Implementation - 2
| |
Session 14: Summative Assessment (4 hrs) | Students will attempt a Theory Test (1 hr) & Practical Test (2 hrs, 45 mins) | During session: Assessor will asses the student through oral questions (15 mins) and provide review and feedback |
| Module Name | NICF - Business Intelligence Queries & Reports |
|---|---|
| Competency Unit | IT-RG-402S-1 (BI) : Gather data to identify business requirements (2 Credit Values) IT-IM-302S-1 : Analyse data and generate reports (2 Credit Values) |
By end of this module, the learner should be able to gain the following knowledge:
- Introduction to SAP Business Objects Business Intelligence Platform
- Concepts of BEx Queries and Analysis tools such as BEx(Business Explorer) Query designer, Analyzer
- Concepts of Variables , Exceptions, Conditions in Queries
- Concepts of Web Intelligence, Crystal Reports
- Overview of Business Objects Analysis , BO Explorer
- Introduction to Information Design tool , Data foundation and Business Layer
By end of this module, the learner should be able to perform the following activities:
- Execute Query using Bex Query Designer
- Create Simple Queries and configure Query properties
- Create a Web Intelligence document with advanced functions on an universe
- Create a new report in SAP Crystal Reports for Enterprise on an universe
- Create a workspace with Analysis, OLAP edition on a SAP BEx query
- Create a dashboard model with a Microsoft Excel data source using basic Dashboards functions
- Create a connection to the database and Create joins in the Data Foundation
- Create a Business Layer
BI -SG - NICF - Capstone Project - Business Intelligence
| Module Name | NICF - Capstone Project - Business Intelligence |
|---|
| Session | Outline | Activities |
|---|---|---|
Session 1: Orientation & Lecture - Live (3 hrs) | The student has to attend a Live Orientation Session conducted at LA campus The Tutor will explain the project brief, guidelines and expectations. | |
Session 2: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 1 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 1 of the project (off campus - 3 hrs) |
Session 3: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 2 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 2 of the project (off campus - 3 hrs) |
Session 4: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 3 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 3 of the project (off campus - 3 hrs) |
Session 5: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 4 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 4 of the project (3 hrs) |
Session 6: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 5 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 5 of the project (off campus - 3 hrs) |
Session 7: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 6 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 6 of the project (off campus - 3 hrs) |
Session 8: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 7 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 7 of the project (off campus - 3 hrs) |
Session 9: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 8 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 8 of the project (off campus - 3 hrs) |
Session 10: Tutoring - Live (3 hrs) | The Student will present the project what they have completed until Milestone 9 to the tutor and seek feedback & support | Before session:The student will IMPLEMENT tasks related to milestone 9 of the project (off campus - 3 hrs) |
Session 12: Summative Assessment (30 mins) | Assessor will review and provide feedback (15 minutes) | During session:The Student will make the final presentation (15 minutes) |
| Module Name | NICF - Capstone Project - Business Intelligence |
|---|---|
| Competency Unit | IT-DM-407S-1 (IBI) : Design a data warehouse |
By end of this module, the learner should be able to gain the following knowledge:
- Introduction to SAP Business Warehouse systems
- Components of SAP BW Data Warehousing Workbench
- Knowledge of S4/Hana
- Introduction to SAP BOBI (SAP Business Objects Business Intelligence)
- Intro to SAP BW powered by SAP HANA
- Introduction to SAP Business Warehouse systems
- Components of SAP BW Data Warehousing Workbench
- Knowledge of S4/Hana
- Introduction to SAP BOBI (SAP Business Objects Business Intelligence)
- Intro to SAP BW powered by SAP HANA
By end of this module, the learner should be able to perform the following activities:
- Define the outline of Business intelligence Star Schema
- Define the adoption of new SAP best practices
- Navigate in SAP Launch pad
- Navigate in SAP ABAP Planning Modeler
Who Should Attend
Ideal Candidates
Entry requirements
Minimum Age: 21 Years
Academic Level: "A" level with 2 years of working experience in the relevant fields
Language proficiency: IELTS 6.5 or its equivalent
Who Should Attend
-
IT or Non-IT Professionals who want to pursue a career in Designing, Configuring and Implementing Business Intelligence functionality
-
IT or Non-IT Professionals who want to pursue a career in Designing, Configuring and Implementing Business Intelligence functionality
Advance Your Career
Advance Your Career
SSG Funding Programme Options
SSG Professional Conversion Programme (Place & Train) (CAT A Funding)
Based on a pre-course assessment, you will get an opportunity to attend interviews with prospective employers. If you are selected by an employer who can avail the course fee grant from SSG, you can join the employer as a SAP BI Consultant during the course
Train & Place Programme with CAT A funding
After qualifying through a pre-course assessment, you can join the course, with a course free grant from SSG. After completing the course, you will get opportunities to attend interviews with prospective employers for SAP BI Consultant job role
Grad Requirements
Graduation Requirements
To graduate from this course, the learner should meet the following criteria:
- Minimum attendance of 75% for all Sessions in each of the modules of the qualification
- Should be assessed Competent (C) in each of the modules of the qualification
Certificates
Certificates
Following certifications will be awarded to the participant upon meeting the graduation requirements:
- Statement of Attainment by SSG, Singapore: IT-DM-401S-1 Build a database
- Statement of Attainment by SSG, Singapore: IT-AS-401S-1 Analyse and Troubleshoot application problem
- Statement of Attainment by SSG, Singapore: IT-DM-402S-1 Identify physical database requirements
- Statement of Attainment by SSG, Singapore: IT-AS-402S-1 Generate and review application support report
- Statement of Attainment by SSG, Singapore: IT-DE-502S-1 Design extract, transform and load (ETL)
- Statement of Attainment by SSG, Singapore: IT-DM-406S-1 Determine that database functionality and scalability suit business requirements
- Statement of Attainment by SSG, Singapore: IT-RG-401S-1 Determine business expectations and needs
- Statement of Attainment by SSG, Singapore: IT-IM-303S-1 Implement data management process
- Statement of Attainment by SSG, Singapore: IT-RG-402S-1 Gather data to identify business requirements
- Statement of Attainment by SSG, Singapore: IT-IM-302S-1 Analyse data and generate reports
- Statement of Attainment by SSG, Singapore: IT-DM-407S-1 Design a data warehouse
- NICF - Diploma in IT Services (Database Management)
Course Fees & Funding
Course Fees & Funding (All fees stated below, are in SGD)
For Self-sponsored Individuals
| Category of Individuals | |||
|---|---|---|---|
| Type | Singapore PR & Singapore Citizen Age >= 21 | Singapore Citizen Age >= 40 | Singapore Citizen Age >= 35 & earning <= 2000.00/month |
| Course Fee | 18000.0 | 18000.0 | 18000.0 |
| Less: SkillsFuture Funding | 12600.0 | 12600.0 | 12600.0 |
| Course Fee after SkillsFuture Funding | 5400.0 | 5400.0 | 5400.0 |
| Add: GST (7%) | 378.00000000000006 | 378.00000000000006 | 378.00000000000006 |
| Course Fee after GST | 5778.0 | 5778.0 | 5778.0 |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | 0.0 | 0.0 |
| Less: Workfare Training Scheme (WTS) | 0.0 | 0.0 | 4500.0 |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | 3600.0 | 0.0 |
| Total Fee Payable to Lithan | 5778.0 | 2178.0 | 1278.0 |
For Company sponsored
| Type of Companies | |||
|---|---|---|---|
| Type | Non-SME & Singapore PR & Singapore Citizen Age >= 21 | SME & Singapore PR & Singapore Citizen Age >= 21 | SME & Singapore Citizen Age >= 35 & earning <= 2000.00/month |
| Course Fee | 18000.0 | 18000.0 | 18000.0 |
| Less: SkillsFuture Funding | 12600.0 | 12600.0 | 12600.0 |
| Course Fee after SkillsFuture Funding | 5400.0 | 5400.0 | 5400.0 |
| Add: GST (7%) | 378.00000000000006 | 378.00000000000006 | 378.00000000000006 |
| Course Fee after GST | 5778.0 | 5778.0 | 5778.0 |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | 0.0 | 0.0 |
| Less: Workfare Training Scheme (WTS) | 0.0 | 0.0 | 0.0 |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | 0.0 | 4500.0 |
| Total Fee Payable to Lithan | 5778.0 | 5778.0 | 1278.0 |
| Note : SME can claim additional 20% of full gross fee under Enhanced Training Support Subsidy (ETSS) where applicable. | |||
Miscellaneous Fees
| Miscellaneous Fee (applicable to all individuals) | |
|---|---|
| Medical Insurance (option)* | 96.00 - Payable upon approval of request |
| Deferment Admin Fee* | 160.50 - Payable upon approval of request |
| Re-module Fee* | 0.00 - Refer to Modular course fee which is available on Lithan’s website |
| Re-sit Exam Fee* | 107.00 - Payable upon approval of request |
| Change of Assessment Date Fee* | 64.20 - Payable upon approval of request |
For Self-sponsored Individuals
| Category of Individuals | ||
|---|---|---|
| Singapore Citizen Age >= 35 & earning <= 2000.00/month | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 4500.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | |
| Total Fee Payable to Lithan | 1278.0 | |
| Singapore Citizen Age >= 40 | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 0.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 3600.0 | |
| Total Fee Payable to Lithan | 2178.0 | |
| Singapore PR & Singapore Citizen Age >= 21 | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 0.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | |
| Total Fee Payable to Lithan | 5778.0 | |
For Company sponsored
| Type of Companies | ||
|---|---|---|
| SME & Singapore Citizen Age >= 35 & earning <= 2000.00/month | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 0.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 4500.0 | |
| Total Fee Payable to Lithan | 1278.0 | |
| SME & Singapore PR & Singapore Citizen Age >= 21 | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 0.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | |
| Total Fee Payable to Lithan | 5778.0 | |
| Note : SME can claim additional 20% of full gross fee under Enhanced Training Support Subsidy (ETSS) where applicable. | ||
| Non-SME & Singapore PR & Singapore Citizen Age >= 21 | ||
| Course Fee | 18000.0 | |
| Less: SkillsFuture Funding | 12600.0 | |
| Course Fee after SkillsFuture Funding | 5400.0 | |
| Add: GST (7%) | 378.00000000000006 | |
| Course Fee after GST | 5778.0 | |
| Add: Fee Protection Scheme (inclusive of GST) | 0.0 | |
| Less: Workfare Training Scheme (WTS) | 0.0 | |
| Less: SkillsFuture Mid-Career Enhanced Subsidy (SFMCES) | 0.0 | |
| Total Fee Payable to Lithan | 5778.0 | |
Miscellaneous Fees
| Miscellaneous Fee (applicable to all individuals) | |
|---|---|
| Medical Insurance (option)* | 96.00 - Payable upon approval of request |
| Deferment Admin Fee* | 160.50 - Payable upon approval of request |
| Re-module Fee* | 0.00 - Refer to Modular course fee which is available on Lithan’s website |
| Re-sit Exam Fee* | 107.00 - Payable upon approval of request |
| Change of Assessment Date Fee* | 64.20 - Payable upon approval of request |