Overview

From Nov 13 to Nov 20
Register by Nov 08
15 hours
French
Certificate of achievement
100% online

Choose your session

Start: Nov 13 End: Nov 20
Register by Nov 08
Language: French
99 €

Course information

During the online sessions, you will be able to learn about the principles, opportunities and constraints related to the launch of a Business Intelligence project, follow the different key steps, and implement them easily and immediately during the workshops by using Business Intelligence tools available on the Excel spreadsheet.

The use of the Excel spreadsheet will allow you to immediately put into practice the concepts discussed during the sessions, using computer tools already available on your computer.

You will also be able to use the various documents provided as well as the videos of the application exercises, in preparation for the workshop or at the end of the online sessions. You will create a personal dashboard project based on a sample database and challenge your know-how with the other participants.

  • Live sessions: two sessions of 3 hours (Saturdays)
  • Autonomous work (with interaction): around 9 hours
  • Who is this course for?

    These workshops are intended for anyone, student or professional, interested in the design and implementation of a business intelligence project: use the data in your organisation to create, format and share information analysis documents.

    To follow the course, an intermediate level of proficiency in Excel is required and you must have a computer with Excel (versions 2016 to 365).

    Whether you are a student, young professional or more experienced, you will enjoy this course if you wish to:

    – Improve a specific skill related to a topic or theme.

    – Interact with experts who will help you to address challenges and identify opportunities for your future, giving you constructive feedback.

    – Deepen your knowledge and apply it to your professional life.

    – Discover and practice new skills and receive a certificate of achievement at the end of the course after evaluating your knowledge.

  • What is the content of this program?

    You will follow various exercises as you prepare individually for the two 3-hour workshops with your professor. These live sessions will be based on French time (Paris). You will participate to a total of 6 hours of classes with your professor.
    This programme encourages you to work for 6 other hours independently by following different exercises on our platform: videos, quizzes and other content.

    Workshop 1

    The first workshop is dedicated to Business Intelligence data:

    – Identifying the project path and data sources to be exploited;

    – Issues related to connecting to data sources and extracting information;

    – Transformation of data for use in a Business Intelligence system;

    – Design of a decision-making dashboard and use of performance indicators.

    The workshop is divided into 4 short integrated sections, a presentation of the concepts, and a practical application carried out simultaneously by the workshop leader and the participants. The Excel Power Query module and pivot tables will be used.

    Workshop 2

    The second workshop is dedicated to the exploitation of data from the BI project:

    – Data modelling using the Excel Power Pivot module;

    – Data visualisation issues and graphic design of a dashboard;

    – Exploiting the data visualisation features available in Excel in a dashboard;

    – Discovering the Power BI software and comparing its possibilities with those of Excel.

    The workshop is also divided into 4 short sections integrating theoretical presentation and a maximum of practice.

    Project

    You will be asked to carry out a personal project to create a dashboard, based on a sample database provided. This project will allow you to evaluate your understanding of the concepts and to assess your ability to implement them in practice. The project will be peer-reviewed, and the best projects will be published.

  • How will this program benefit my career?

    At the end of the course, you will:

    Acquire knowledge of the basic concepts of Business Intelligence and learn to integrate them into the construction of an operational project.

    Identify the different stages of project design and consider the risks and constraints during operational implementation.

    Develop the ability to build a professional project independently.