Laureal
Back to the catalogue
Data & Business Intelligence

Data Analytics & Engineering

This training begins with the foundations of data and a method for framing an analytics project. You will then explore the use of Python and the Pandas library to manipulate and analyze your datasets. The program covers applied statistics, with a focus on descriptive analysis, correlations, and regressions. You will also study star schema modeling, ETL/ELT processes, and the medallion architecture. In addition, the session presents the different Azure data services across relational, non-relational, and analytical environments. Finally, you will learn to present your results with Power BI, while completing a capstone project and preparing for the DP-900 mock exam.

Duration
45h
Level
Intermediate
Format
Hybrid
Lessons
10

What you will learn

  1. 01Understand the foundations of data and how to frame an analytics project methodically.
  2. 02Use Python and the Pandas library to manipulate, clean, and analyze datasets.
  3. 03Apply descriptive statistics, correlation analysis, and regression models to real data.
  4. 04Design a star schema data model and implement ETL/ELT pipelines.
  5. 05Understand and apply the medallion architecture (Bronze, Silver, Gold).
  6. 06Identify and use Azure data services across relational, non-relational, and analytical workloads.
  7. 07Restitute analytical results effectively with Power BI.
  8. 08Prepare for the DP-900 certification exam through a corrected mock exam.
Who it is for

Aspiring and practicing data analysts, data engineers, and BI professionals looking to master the end-to-end data pipeline — from ingestion and transformation to modeling and reporting.

Prerequisites

Basic knowledge of spreadsheets and information systems recommended. No prior programming experience strictly required, but familiarity with Python is a plus.

Certification

DP-900 — Microsoft Azure Data Fundamentals.

Instructors

Original Name

Updated bio.

Terms

  • Courses run online or in person, in three-hour sessions, on a dedicated hands-on environment (Linux VM, lab FortiGate, a running dataset depending on the path).
  • Every certification path includes at least one marked mock exam under real conditions, with an individual remediation plan.
  • Registration and sitting fees for the official exams (LPI, Fortinet, Microsoft) are not included in the course price.
  • A tailored quote is drawn up based on the number of participants, the schedule you want and the format, open enrolment or in-house.