Data / AICompleted

Database and Power BI dashboard

Design and optimization of a database for a fictional company, then analysis with Power BI.

Status

Completed

Period

January 2024 → March 2024

Context

School

Field

Data / AI

Technologies

SQLData modelingOptimizationPower BI

01The context

A Bachelor's degree project in which we played the role of a fictional company that had to manage and make use of its data.

02My approach

  1. Designing the database from a set of specifications
  2. Implementing it in SQL
  3. Optimizing the performance of the queries
  4. Analyzing with Power BI, to bring out useful indicators
  5. Oral presentation, justifying my choices with a Power BI dashboard

03What I take away from it

A well-designed database from the start makes everything else easier, from optimization to analysis.