MLC College – Business Intelligence using Data-warehousing

Course outline:

Business Analysis:

  • Enterprise Resource Planning
  • Material, Manufacturing Planning
  • Supply Chain Management
  • Supplier Relationship Management
  • Demand Plan/Supply Network Planning
  • Customer Relationship Mgmt
  • Human Capital Management
  • Business Intelligence
  • Strategic Enterprise Management
  • PLM, ALM, and PDM
  • Production planning PP and PP-PI
  • Enterprise Portals
  • Software Development Life Cycle
  • Business Areas in Sales
  • Enterprise Application Integration
  • Project Environments
  • Interface and Integrate
  • Business Process
  • Workflow
  • GRC—Government Risk and Compliance
  • Customer Service and Plant Maintenance

BW Data Warehousing

  • Data Warehousing Overview
  • BW Data Model
  • Extracting Data from SAP Components & External Systems
  • Business Content
  • Aggregates and Managing InfoCubes
  • Data Mart >Interface
  • Operational Data Store
  • Virtual InfoCubes and MultiProviders

BW Data Modeling

  • Extended BW Star Schema
  • Using Navigation Attributes
  • Time dependent data
  • Tracking History
  • ODS Scenarios
  • MultiProvider Data Marts

BW Reporting

  • Navigation within Reports
  • Working with Business Content Queries
  • BEx Query Designer
  • Calculated and Restricted Key Figures
  • Characteristic Attributes and Hierarchies Variables
  • Query Properties
  • Exceptions and Conditions
  • Ad hoc Query Designer on the Web
  • BEx Analyzer and Workbook Functions
  • InfoProvider
  • Reporting Management
  • Reporting Agent
  • Report To Report Interface
  • Currency and Unit Conversion
  • Personalization Features
  • Advanced Reporting Agent
  • BW Reporting Performance

BW Extraction

  • Service API
  • LO Extraction
  • Delta Management
  • CO PA Extraction
  • FI SL Extraction
  • Generic Extraction
  • CRM Extraction
  • Extraction Enhancements with User Exits
  • Business Content Extractors

BW Performance Tuning

  • Technical Basics
  • ODS
  • Transactional Data Targets
  • BW Statistics
  • Query and OLAP Basics
  • Partitioning , Aggregates
  • Query Tuning
  • Process Chains

The course also includes Delta course for Business Intelligence and Business Objects.

Project Work:

We will assign you projects from our consulting company which is a simulated exercise. The project will depict either best practices of the respective vendors or real life scenario. MLC does not assume responsibility for successful completions of projects


End of the training exams will be conducted by MLC College and certificates will be issued to successful candidates. In case a student fails, the re-examination fees will be applied as per college guidelines.

Vendor Certification:

MLC does not offer vendor certification but facilitates those under the VUE partnership. The certificate will be directly issued by the respective vendors.

Job Guidance

We provide resume customization, behavioral session and technical session during our placement assistance program. We also provide you 3 months on job complimentary support. There is an emphasis on “education for capability” which ensures that you will be attractive to a wide range of employers.

N. B:

The college is approved by Ministry of Training Education and Universities, Ontario, Canada and follows the PCC guidelines to register domestic and international students.

The course content is subject to change based on updates from time to time. For more details consult admissions coordinator at or contact the college.


Translate »