Datawarehouse, Business Intelligence and Big Data Analytics Fundamentals

Data Warehouse, Business Intelligence and Big Data Analytics Fundamentals

Course Objectives

  • Define the terminology and explain the basic concepts of data warehousing and ETL processes
  • Identify B.I tools for accessing and analyzing warehouse data
  • Apply a series of powerful, cutting-edge analytical and data science techniques
  • Ensure the practical application of these techniques to optimize strategic business processes and decision making
  • Deploy, monitor, and optimally backtest analytical models.


  • Project and DSI Managers
  • Data Warehouse Developer and Analyst
  • Marketing/CRM managers
  • Fraud managers
  • Customer intelligence managers
  • Risk analysts
  • CRM analysts
  • Marketing analysts
  • Data analysts, and data miners

Course Topics

  • Data Warehouse Definition and Properties
  • Data Warehouses, Business Intelligence, Data Marts, and OLTP
  • Typical Data Warehouse Components
  • Warehouse Development Approaches
  • Extraction, Transformation, and Loading (ETL)
  • Filtering, Selecting and Grouping Data in Analysis
  • Creating and editing KPI dashboards
  • The Analytics Process Model
  • Techniques of the descriptive model
  • Techniques of the predictive model
  • Evaluating and Monitoring Analytical Models
  • Big Data Analytics principles and issues
  • Hadoop ecosystem, HDFS and Map/Reduce Paradigm
  • Structured and non-structured data with Apache HCatalog, Apache Hive
  • NoSQL database management, Apache HBase and Apache SQOOP and Apache Flume
  • Big Data Analytics with Apache Pig
  • Case Studies in Analytics for businesses and entreprises


  • French/English

Instructors :

  • Prof. Mohammed El Mohajir,  Datawarehouse Modeling and B.I expert
  • Prof. Mohamed El Far, Data and Analytics Process Modeling expert
  • Prof. Mohamed Chahhou, Big Data and Machine learning expert and Kaggle Data Science price winner

Duration, Venue & Date

  • 3 days
  • March – June, 2017
  • Rabat, Casablanca, Fez, Tetouan, Marrakesh, Agadir


  • Special rate for Maghrebiens (50% Reduction): 2.500 Dhs
  • Regular fees: 5.000 Dhs
  • Registration fees include: Course materials, coffee break and lunches
  • Places are limited, REGISTER NOW