Table of Content
 

 

Introduction
  • Evolution
  • Need and benefits
  • Technical terms
Integration
  • BI life cycle and management systems functions
  • ERP and BI
  • SCM and BI
  • E-commerce and BI
Data Management
  • Data Management
  • Reporting and Querying
  • BI and MDM
  • Knowledge Management
OLAP (Online analytical processing)
  • Evolution, Features and functions
  • Multidimensional analysis
  • Data drill-in and drill-up
  • OLAP Models (ROLAP and MOLAP) and applications
Dashboards
  • EIS
  • KPI
  • BI Dashboard
Data Warehousing
  • Dimensional modeling and metadata
  • ETL
Data Analytics
  • Concepts and terminologies
  • Techniques used (neural network, statistics, fuzzy logic, genetic algorithms
Value Proposition
  • Business intelligence economics
  • Cost Matrix, SLA and ROI
  • Risk Mitigation
Requirement Assessment
  • Business problem assessment
  • Focusing pertinent information
  • Desired outcome specification
Design
  • Data and architecture design
  • Hardware and Software Selection
  • Generate data warehouse matrix
  • Dimensional modeling and ETL
Implementation
  • Physical Design
  • Physical Storage (SAN, RAID, etc.)
  • Indexing (B-Tree, Clustered, etc.)
  • Data partitioning and clustering for performance
  • Analytics criteria selection
  • OLAP tools and data slicing or dicing
Post-Implementation
  • Security Policy, user privileges and security tools
  • Backup and Recovery
  • Monitoring and managing data growth
Performance Measurement
  • Observing dashboards
  • Assessing KPI and scorecard
Advanced BI
  • Future Trends
  • Case Studies

Apply for Certification
https://www.vskills.in/certification/Certified-Business-Intelligence-Professional