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
- Designing the database from a set of specifications
- Implementing it in SQL
- Optimizing the performance of the queries
- Analyzing with Power BI, to bring out useful indicators
- 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.