HOME / ENSEIGNEMENT /

TP for 4 th year Engineer AI

 

Home Assignment 

Please organize yourselves into groups of 3 to 5 members to prepare a PowerPoint presentation (maximum 20 to 25 slides) on one of the following Business Intelligence tools:

  • JasperReports

  • BIRT

  • Pentaho

  • SpagoBI

  • Palo

  • JavaEye Reporting Tool (JERT)

  • OpenRPT

  • OpenReports

  • StimulSoft

  • ClickView

Your presentation should include:

  • An introduction to the selected tool (publisher, license type, technologies used)

  • Its main features and advantages

  • A possible comparison with other similar tools

  • A use case or practical application scenario

A live demonstration of the selected tool will also be required on the presentation day, to showcase its main functionalities in action.

 

Good luck!

 

Business Intelligence Lab – Sales Analysis of a Company

 Learning Objectives

  • Understand the ETL (Extract, Transform, Load) process.
  • Manipulate a data warehouse.
  • Create and query OLAP cubes.
  • Build dashboards and interactive visualizations.

Scenario

An e-commerce company wants to analyze its sales in order to:

  • Identify the best-selling products.
  • Analyze sales by region, time period, and product category.
  • Understand the behavior of loyal customers.

The company has CSV files extracted from its transactional system:

  1. Customers.csv (customer_id, name, city, country, segment).
  2. Products.csv (product_id, product_name, category, price).
  3. Sales.csv (sale_id, customer_id, product_id, date, quantity, amount).

Part 1 – Extraction and Transformation

  1. Import the three CSV files into a BI tool (e.g., Power BI, Talend, Pentaho, or SQL Server Integration Services).
  2. Clean the data:
    • Remove null values.
    • Standardize country names.
    • Check for duplicates.

Part 2 – Building the Data Warehouse

  1. Create a Star Schema:
    • Fact table: Sales.
    • Dimension tables: Customers, Products, Time.
  2. Load the cleaned data into the warehouse.

 Part 3 – OLAP Analysis

  1. Build an OLAP cube with the following dimensions:
    • Time (year, quarter, month).
    • Products (category, product).
    • Customers (city, country, segment).
  2. Main measures:
    • Total Sales (sum of amounts).
    • Quantity sold.
    • Average price per product.

Part 4 – Dashboard

  1. Create an interactive dashboard showing:
    • Sales by region and time period.
    • Best-selling products.
    • Sales distribution by customer category.
    • A Top 5 Customers indicator.
  2. Add interactive filters (year, country, product category).

Expected Deliverables

  • Data model (Star Schema).
  • OLAP cube definition.
  • Final dashboard.
  • A short report (2-3 pages) explaining the steps and interpretation of the results.

 

To facilitate students' familiarization with the field, I propose the following chapters:

Chapter 1 : Introduction to BI

Chapter 1 : Introduction to BI FR 

Chaptre 2 Data Warehousing and ETL Process : Corporate Governance and Business Intelligence

Chapitre 3 Feeding Data Warehouses and ETL: Enablers of Corporate Governance

Chaptre 2 &3 Data Warehousing and ETL Process : Corporate Governance and Business Intelligence FR 

 

 

Offered: 

2025