COURSES LIST

INTRODUCTION TO BUSINESS INTELLIGENCE  (ONLINE AT YOUR PACE)

OBJECTIVES

This training will allow participants to understand what Business Intelligence is, and how it is implemented through tools such as SAP Business Objects, Qlikview. For educational purposes, the training ends with a practical case of business intelligence implementation under Microsoft Excel. At the end of this training you will be able to:

  • Understand the objectives of Business Intelligence
  • Understand the implementation of Business Intelligence through SAP Business Objects ® Qlikview ®
  • Understand the main components of Business Intelligence and be able to identify them in a professional environment
TEACHING PROGRAM

1. INTRODUCTION TO BUSINESS INTELLIGENCE

  • Definition of business intelligence.
  • Business Intelligence : from the data to the action/decision
  • Experience sharing.

    2. THE COMPONENTS OF A BUSINESS INTELLIGENCE SOLUTION

    • The different components of a Business Intelligence solution.
    • Data sources.
    • The analysis and restitution tools.

    3. SOME COMMON BUSINESS INTELLIGENCE CONCEPTS

    • Some main business intelligence concepts.

      Business Intelligence with Power BI (in person or remote sessions)

      OBJECTIVES

      This training will enable you to implement a simple Business Intelligence solution with Power BI Desktop tools. At the end of this training, you will also be able to create quality data connections, models, reports and visualizations.

      • Be able to implement a Business Intelligence solution
        simple with Power BI Desktop tools
      • Create quality data connections, templates, reports and visualizations
      • Learn how to format and combine data from different sources
      TEACHING PROGRAM

      1. INTRODUCTION TO BUSINESS INTELLIGENCE

      • Definition of Business Intelligence and concepts
      • The main tools and components of a Business Intelligence solution
      • Introduction to Data Analytics and Self-Service BI

      2. TAKING CHARGE OF THE ENVIRONMENT

      • Power BI Desktop and Power BI service
      • The query editor
      • The Relationships view
      • The Data view
      • The Report view

      3. DATA CONNECTION AND MODELING

      • The connectors
      • The ribbon
      • Present the main terms to remember and some main objects

      4. QUERY EDITING AND DATA TRANSFORMATION

      • Query editing
      • Data transformation
      • Data combination

      5. CREATE VISUALIZATIONS

      • The types of visualizations
      • The creation of visuals
      • Interactions

      6. ADVANCED TECHNIQUES AND DAX FORMULAS

      Duration of the course session : 2 days

      Initiation to Power BI : Visualize and analyze your data efficiently (online at your pace)

      OBJECTIVES

      At the end of this course, you will be able to:

      • Understand the fundamental concepts of Power BI.
      • Connect Power BI to different data sources (Excel files, databases, etc.).
      • Manipulate data (import, cleaning and transformation) via the Power Query editor.
      • Create interactive visualizations and dashboards.
      • Publish and share your reports with your teams or organization.
      TEACHING PROGRAM

      1. INTRODUCTION TO POWER BI

      • What is Power BI and why use it ?
      • Presentation of the Power BI Desktop interface: Ribbon, panels, views (report, data, model).
      • Power BI report examples to understand the potential of the tool

        2. CONNECTING TO DATA SOURCES

        • Import data from different sources (Excel, CSV, databases, online files).
        • The data types supported by Power BI and their importance.
        • Exploration of common connectors for external systems (cloud services, databases, etc.).

        3. PREPARATION AND TRANSFORMATION OF DATA WITH POWER QUERY

        • Using the Power Query editor to clean and transform data.
        • Rename, filter and sort columns.
        • Merge and add data tables.
        • Remove duplicates, change data types and manage missing values.

        4. CREATING VISUALIZATIONS

        • Create graphs and visualizations to analyze data.
        • Add segments (slicers) to allow dynamic exploration of reports.

        5. INTRODUCTION TO DAX (DATA ANALYSIS EXPRESSIONS)

        • Discovery of basic formulas in DAX to perform simple calculations.
        • Create basic measures (sum, average, account, etc.).
        • Understand the difference between calculated columns and measures.

        6. PUBLICATION AND SHARING OF REPORTS

        • Publish a report in the Power BI service
        • Share dashboards and reports with colleagues or teams.
        • Introduction to collaborative features in Power BI (comments, notifications).
        TESTIMONIES

        "An exceptional Power BI course ! Thanks to clear content, concrete exercises and effective pedagogy, I was able to transform my way of analyzing and visualizing data. This training is a real stepping stone for anyone wishing to excel in Power BI. I highly recommend it !"

        Ismaila DIANDA, Private sector employee in Ouagadougou

         

        "I attended the course titled power BI, it was very relevant, and the work environment was ideal. I had set myself the goal of understanding the importance of using power BI. As a beginner, I had some preconceptions, but I am very satisfied with the course schedule and the skills I was able to acquire."

        Claude-Michel NGANSO, Private sector employee in Paris

         

        "The course took place online in a pleasant atmosphere. The course is so interesting that I felt obliged to review it to not miss anything"

        Déovie KAMGANG, Private sector employee in Yaoundé

        Excel VBA Self-Learning Basics (in person or remote sessions)

        OBJECTIVES
        • Establish the fundamentals of programming
        • Understand the most common uses in VBA-Excel
        • Acquire the ability to progress self-taught in Excel-VBA
        TEACHING PROGRAM

        1. UTILITY OF EXCEL-VBA

        • Excel-VBA, for what?
        • Use cases in marketing
        • Use cases in management control
        • Use cases in the financial sector

        2. EXCEL-VBA OVERVIEW

        • Introducing VBA
        • Principles of language and programming and automation
        • Creating and running macros
        • Description of the environment: the project, the sheets, the modules, the libraries.

        3. CREATING AND USING OBJECTS

        • Creation and use of buttons
        • Using input data fields
        • Calling external objects
        • Demonstration of the use of forms
        • Automatic creation of sheets and workbooks
        1. RECURRING ROUTINES AND ALGORITHMS
        2. CONNECTING TO EXTERNAL SOURCES
        3. GOOD PRACTICES
        4. VBA SELF LEARNING PRINCIPLES AND TIPS

        Duration of the course session : 1 day

        POWER BI : ADVANCED ANALYSIS AND DATA VISUALIZATION (online at your pace)

        OBJECTIVES

        By the end of this course, you will be able to:

        • Use the advanced features of Power Query to transform and combine data from multiple sources.
        • Master advanced DAX (Data Analysis Expressions) concepts to create complex measurements and dynamic calculations.
        • Create more interactive and dynamic reports and dashboards using advanced features.
        • Set up relationships between tables for more efficient data models.
        • Publish, automate and share your reports on the Power BI service while optimizing collaboration and data management.
        TEACHING PROGRAM

        1. DEEP EXPLORATION OF DATA SOURCES

        • Connection to multiple and complex data sources (SQL databases, online services, APIs)
        • Advanced use of Power Query to transform, merge and combine data from different sources
        • Managing parameters and dynamic queries to automate data updates

          2. DATA MODELING AND RELATIONSHIP MANAGEMENT

          • Create and manage relationships between multiple tables to improve data modeling
          • Use of cardinalities and management of bidirectional relations
          • Using fact tables and dimension tables to build powerful data models

          3. ADVANCED DAX FUNCTIONS

          • Introduction to complex DAX functions for dynamic calculations (CALCULATE, FILTER, ALL, RELATED)
          • Creation of complex measures and calculated columns for advanced analyses
          • Mastering the line and filter context in DAX to refine analyses
          • Practical cases: creation of KPI, growth rate, temporal comparison, and cross-analysis

          4. INTERACTIVE VISUALIZATIONS AND ADVANCED REPORTS

          • Use of advanced visualizations (stacked histograms, combined charts, interactive maps)
          • Creation of interactive reports with elements such as slicers and visual filters
          • Using interaction tools between graphics to offer a more intuitive experience to users
          • Implementation of reactive and dynamic reports with parameters controlling the display

          5. PUBLISHING, UPDATING AND SHARING REPORTS

          • Publish reports in Power BI Service and manage automatic updates
          • Set up reports subscriptions for automatic email
          • Share and collaborate on dashboards in an organization via Power BI Workspaces
          • Using data security and permission management options

          Master the basics of Excel (online at your pace)

          OBJECTIVES

          By the end of this course, you will be able to:

          • Understand the Excel interface and its main features.
          • Create and organize simple tables.
          • Use basic formulas (sums, averages, etc.).
          • Manage data formats (text, number, dates).
          • Perform sorts and filters to organize your data.
          • Create simple graphs to visualize information.
          TEACHING PROGRAM

          1. DISCOVERY OF THE EXCEL INTERFACE

          • Introduction to the interface (ribbon, tabs, cells, spreadsheets).
          • Navigating in Excel: how to move efficiently through a workbook.

            2. WORKING WITH CELLS AND DATA

            • Enter, copy and paste data.
            • Change the size of columns and rows.
            • Introduction to cell formats: text, number, date, percentage.

            3. INTRODUCTION TO BASIC FORMULAS

            • Use simple formulas : addition, subtraction, multiplication, division.
            • Common functions: SUM, AVERAGE, MIN, MAX.
            • Copy formulas and use the copy handle.

            4. DATA ORGANIZATION

            • Sort the data in a table.
            • Filter data to display specific information.
            • Using tables and conditional formats.

            5. CREATE SIMPLE GRAPHICS

            • Introduction to chart types (histograms, curves, pie charts).
            • Create a chart from data.
            • Customize the appearance of a chart.

            AUTOMATE WITH EXCEL VBA (in person or remote sessions)

            AUDIENCE
            • Business leaders and department heads wishing to maximize their productivity in Excel thanks to VBA
            • Consultants, contractors, employees, project managers using Excel and wishing to perform automations
            OBJECTIVES
            • Understand how to use automation with VBA to increase productivity in Excel
            • Become familiar with the VBA Excel environment and be able to read a program
            • Mastering recurring automation routines
            • Acquire the ability to progress as an autodidact in VBA Excel
            TEACHING PROGRAM

            1. UTILITY OF VBA EXCEL

            • VBA Excel, for what purpose?
            • Use cases in marketing
            • Use cases in management control
            • Use cases in Finance

              2. PRESENTATION OF VBA EXCEL

              • Presentation of VBA
              • The macros and their utility
              • Create a first macro
              • Start from his need to open the Visual Basic editor
              • The editor interface
              • Description of the environment: the project, the sheets, the modules, the libraries

              3. FIRST AUTOMATION

              • Introduction
              • The macro recorder
              • First test macro
              • Review of the generated code
              • Code re-execution
              • Some techniques for improving the generated code

              4. PREREQUISITES FOR AUTOMATION IN VBA

              • The objects
              • The properties
              • The methods
              • The properties
              • The methods
              • Association of objects
              • Association of properties or methods
              • Coding of cells
              • Codification of cell ranges
              • Named cells
              • The affection of values

              5. THE BASICS OF AUTOMATION IN VBA

              • The variables
              • The conditions
                • The if statement
                • The SELECT CASE statement
              • The loops
              • The procedures and functions
              • The msgbox method
              • The most common types of variables
              • Examples of variable usage
              • The scope of variables
              • Examples of using loops

              6. THE PROCEDURES AND FUNCTIONS

              • Presentation of procedures and functions
              • Creation of a custom function with parameters
              • Call the custom function
              • Writing procedures
              • Procedure call
              • Procedures executed on events

              7. CREATION AND USE OF OBJECTS

              • Creation and use of buttons
              • Using input data fields
              • Call for external objects
              • Use of forms
              • Automatic creation of sheets

              8. USES OF SOME MOST COMMON FUNCTIONS

              • The operators
                • Arithmetic operators
                • Comparison operators
                • Logical operators
              • Character string functions
                • Operator &
                • The Left, Right and Len statements
                • The cutting of strings
              • Opening of files
              • The call of spreadsheet functions
              • Date and time functions
                • Know if a cell contains a date
                • Date formatting
                • The extraction functions on dates
                • Calculation of the difference between two dates

              9. TO GO FURTHER

              • Connection to external data sources
              • Comparison of Excel sheets and use cases
              • Comparison of Excel workbooks and use cases
              • Automation of pivot tables
              • Make the generation of graphics dynamic

              Duration of the course session : 2 days

              PERFECT YOUR SKILLS WITH EXCEL: INTERMEDIATE COURSE (online at your pace)

              OBJECTIVES

              À l'issue de cette formation, vous serez capable de :

              • Utiliser des formules et fonctions plus avancées (fonction SI, RECHERCHEV, etc.)
              • Structurer et gérer des données efficacement à l’aide de tableaux et de plages nommées
              • Créer et personnaliser des tableaux croisés dynamiques
              • Utiliser des graphiques pour illustrer des données complexes
              • Gérer les bases de données avec des tris et filtres avancés
              • Gagner en productivité avec des techniques de validation de données et de format conditionnel
              TEACHING PROGRAM

              1. RÉVISION DES BASES ET INTRODUCTION AUX FONCTIONS INTERMÉDIAIRES

              • Révision rapide des concepts de base : formules, mise en page, mise en forme
              • Utilisation de fonctions conditionnelles plus complexes : SI, SI.CONDITIONS
              • Fonctions logiques : ET, OU, NON pour des calculs conditionnels

              2. MANIPULATION DES DONNÉES AVEC RECHERCHEV, INDEX, EQUIV

              • Introduction aux fonctions de recherche : RECHERCHEV, RECHERCHEH
              • Utilisation combinée des fonctions INDEX et EQUIV pour des recherches plus flexibles
              • Comment utiliser les plages nommées pour faciliter la manipulation des données

              3. GESTION DES DONNÉES AVANCÉE (TRI, FILTRE, SOUS-TOTAUX)

              • Utilisation des filtres avancés pour gérer des bases de données complexes
              • Créer des sous-totaux automatiques dans des tableaux de données
              • Consolidation des données provenant de plusieurs feuilles

              4. INTRODUCTION AUX TABLEAUX CROISÉS DYNAMIQUES

              • Qu'est-ce qu'un tableau croisé dynamique et quand l'utiliser
              • Création et personnalisation d'un tableau croisé dynamique pour analyser les données
              • Regrouper les données par catégorie et par date
              • Utilisation des segments pour filtrer rapidement les données

              5. VISUALISATION DES DONNÉES AVEC DES GRAPHIQUES

              • Création de graphiques plus complexes : graphiques combinés, graphiques en cascade
              • Ajouter des éléments interactifs dans les graphiques (segments, filtres)
              • Introduction aux graphiques Sparklines pour représenter des tendances dans les tableaux

              6. AUTOMATISATION ET PRODUCTIVITÉ AVEC EXCEL

              • Validation des données pour créer des listes déroulantes et éviter les erreurs de saisie
              • Utiliser le format conditionnel pour mettre en évidence automatiquement des valeurs critiques
              • Création et utilisation des modèles Excel pour les tâches répétitives

              SAP BUSINESS OBJECTS WEB INTELLIGENCE (in person or remote sessions)

              OBJECTIVES

              This course will make you able to create simple or complex Web Intelligence documents by achieving the following objectives.

              • Understand the concepts of Business Intelligence and Business Objects Web Intelligence
              • Create simple or complex Web Intelligence documents, composed of one or more reports, combining one or more data sources
              TEACHING PROGRAM

              1. INTRODUCTION TO SAP BUSINESS OBJECTS

              • Business Intelligence tools and the SAP Business Objects software suite
              • The concepts of Business Objects

              2. BI LAUNCH PAD ENVIRONMENT

              • General reports and presentation of BI Launch Pad
              • General information on the use of Web Intelligence reports
              • Set user preferences

              3. DOCUMENT STRUCTURE AND ERGONOMICS

              • The modes of visualization
              • The requests and sub requests
              • The filters

              4. CREATING AND USING REPORTS

              • Create query, subquery, and combined queries
              • Creation and management of tables
              • Adding information, calculations and aggregates
              • Addition of decorative and informational elements
              • Use of jumps
              • Use of sections
              • Use of sorting
              • Report formatting
              1. DIAGRAM MANAGEMENT
              2. DATA ANALYSIS
              3. GOOD PRACTICES
              4. DOCUMENT SHARING

              Duration of the course session : 2 days

              Data Governance (in person or remote sessions)

              OBJECTIVES
              • Understand what data governance is
              • Be able to choose the right data governance model for your business
              • Be able to ensure reliable data from integration to restitution
              • Know the roles of data governance
              TEACHING PROGRAM

              1. DATA GOVERNANCE: DEFINITION AND NEED
              2. CHOOSING A DATA GOVERNANCE MODEL
              3. PROVIDE RELIABLE DATA
              4. DATA GOVERNANCE RECOMMENDATIONS
              5. ROLES IN DATA GOVERNANCE
              6. EXAMPLES OF SUCCESSFUL DATA GOVERNANCE
              7. TOWARDS DATA INTELLIGENCE, FROM INTEGRATION TO RESTITUTION

              Duration of the course session : 5 hours

              Data Quality (in person or remote sessions)

              OBJECTIVES
              • Understand what data quality is
              • Know the tools of data quality
              • Implement a continuous improvement approach to data quality
              TEACHING PROGRAM

              1. WHAT IS DATA QUALITY
              2. DATA QUALITY, DATA GOVERNANCE AND DATA MANAGEMENT
              3. DATA QUALITY TOOLS
              4. BISSONGENIOUS DATA QUALITY IMPROVEMENT METHODOLOGY
              5. STUDY CASE
              6. ARTIFICIAL INTELLIGENCE AND DATA QUALITY

              Duration of the course session : 5 hours

              Setting up a data warehouse (in person or remote sessions)

              OBJECTIVES
              • Understanding the need for a data warehouse
              • Know the components and management of a data warehouse
              • Be able to launch and manage a data warehouse project
              • Be able to conduct a requirements gathering document
              • Be able to make a dimensional modeling
              TEACHING PROGRAM

              1. Reminder of BI objectives and associated concepts
              2. The need for data warehouse
              3. Data warehouse components and management
              4. Starting and Managing a Data Warehouse Project
              5. Data warehouse and datamarts
              6. The requirements gathering document
              7. Conducting workshops
              8. Relational Modeling for Businesses
              9. Dimensional modelling

              Duration of the course session : 2 days

              Information Design Tool – Level 1 (in person or remote sessions)

              OBJECTIVES
              • Master the architecture and role of the universe designer
              • Create the structure and objects of a universe
              • Implement the functions and the optimal organization of a universe: value lists, aggregate tables, joins...
              TEACHING PROGRAM

              1. INTRODUCTION TO SAP BUSINESS OBJECTIS BI 4
              2. CREATING A UNIVERSE: THE PROJECT...
              3. CREATING A UNIVERSE: CONNECTIONS
              4. CREATING A UNIVERSE: THE DATA FOUNDATION
              5. CREATING A UNIVERSE: THE MANAGEMENT LAYER
              6. COMPLEMENTARY FUNCTIONS AND OPTIMIZATION

              Duration of the course session : 8 hours