HomePortfolioFormation

Formation en Business Intelligence (BI)

Formation exclusive

Training in Business Intelligence (BI)

Why the BI?

Having accurate information is essential to make well-informed sensitive decisions. Our Business Intelligence training course is designed to teach you how to apply Business Intelligence and Data Management best practices to capture, understand and analyze data that can provide critical insights into your organization, improve process decision-making and increase profitability and performance.

Registration fees:  2400,00Dhs 2000,00 Dhs (20% discount offered)

Next training session: April 17, 2021 in person or by videoconference

This training gives you access to:

  1. Certificate of technical aptitude from an international firm
  2. Reference or internship certificate : You have the possibility of participating in one of our projects as a technical internship in order to issue you a reference certificate.
  3. Technical support (PFE or PFA project) by our expert trainer for a period of 6 months
  4. Access to our e-learning platform for 6 months (Documentation, tools, video tutorials)
Please fill in all the information, in order to contact you as soon as possible and confirm your registration.

Formateur

Doctor in Business Intelligence and Big Data winner of ENSIAS

Business Intelligence is a set of theories and methodologies that deal with large amounts of data and information and helps managers in decision making. 

This training is designed for people who aspire to a career in Business Intelligence, Software or Analytics professionals. As well as for people wishing to perform data integration and management tasks having background/experience with any RDBMS, ETL, OLAP or reporting tools are the main beneficiaries of this training.

 

Objectifs de la formation

This Business Intelligence training aims to:

  • To understand the challenges of decision-making and the techniques implemented,
  • Master the advanced concepts of the Datawarehouse and thwart the pitfalls of Business Intelligence architecture,
  • To know the key stages of a Datawarehouse project,
  • Identify Business Intelligence tools.
  • The modeling of a decision-making information system aims to:
    1. To know how to create a data architecture adapted to the decision-making and Business Intelligence needs of users,
    2. Choose and harmonize relational stars and OLAP cubes.

Pré-requis

Basic computer skills required.

  • Knowledge of Java or another programming language.
  • Knowledge of SQL or general database concepts is helpful.
  • Mastery of the Windows environment.

Programme

Week end 1:

Introduction to Business Intelligence – Business intelligence

  • Areas of use of Business Intelligence
  • Why is Business Intelligence important?
  • Business Intelligence challenges
  • Business Intelligence Functions
  • Business Intelligence Challenges

The architecture of a decision-making system

  • Data collection
  • Data integration
  • The data warehouse
  • Restitution

Management of the Business Intelligence project

Data warehouses (Data warehousing)

  • What is Data Warehouse?
  • The warehouse approach
  • Data characteristics of a Data Warehouse

Multidimensional data

  • Notion of Data-mart

Modeling and Design of a Data Warehouse

  • Star pattern
  • Snowflake Model
  • Constellation Pattern

ETL 

  • Introduction to ETL – Extract-Transform – Loading
  • ETL Tool Overview: Talend Open Studio
    • Business Model
    • Metadata Manager
    • Job Designer
  • Presentation list of the most used components
    • Component Connections

multidimensional cube

  • OLAP 
  • OLTP 

Multidimensional modeling

WORKBENCH tool

Reporting 

  • How to succeed in your reporting?

JASPERSOFT  Tool

  • JasperSoft Pro

Résultats

This training gives you access to:

  1. Technical certificate from a firm specializing in the subject
  2. Reference or internship certificate: You have the possibility of participating in one of our projects as a technical internship in order to issue you a reference certificate
  3. Technical support by our expert trainer for a period of 6 months
  4. Access to our e-learning platform for 6 months (Documentation, tools, video tutorials)

Inscription et tarifs

The cost of training: Particular price 2400, 00 DHS TTC | Entreprise price : 3600,00 DHS TTC

Included: Coffee break, Training support.

Please fill in all the information, in order to contact you as soon as possible and confirm your registration.