End-to-End Azure BI Project

Developed and deployed a BI solution on Azure (Data Factory, Data Lake, Databricks, Synapse), transforming an on-premise data warehouse into reliable and up-to-date datasets, and created secure Power BI dashboards (Key Vault, Active Directory).

Used tools : Azure Data Factory, Azure Data Lake Storage Gen2, Azure Databricks (Delta Lake), Azure Synapse Analytics, Power BI, Azure Key Vault, Azure Active Directory

Call Center Performance Analysis and Visualization

I analysed data from some CSV files, applied the cleaning and transformations needed, did some data modeling for more accuracy and built a 2-page dashboard: one for main KPIs and the second for agents' details.

Used tools: Power Query, PowerBI

BMW Sales Analysis and Visualization

I analysed a bunch of datasets to extract and transform required data in the business requirement, then I implemented a Star Schema model, and built a PowerBI dashboard.

Used tools : Power Query, DAX, PowerBI

Coffee shop sales Visualization

I have worked on a Kaggle dataset to extract and transform required data and to get the important KPIs then built a PowerBI dashboard.

Used tools : Power Query, PowerBI

Pizza Sales Visualization

I have worked on a Kaggle dataset to extract and transform required data and to get the important KPIs then built a PowerBI dashboard.

Used tools : Power Query, PowerBI

AdventureWorks Internet Sales Analysis and Visualization

I analysed a Microsoft DataWarehouse (AdventureWorks) to extract and transform required data in the business requirement, then I implemented a Star Schema model, and built a PowerBI dashboard.

Used tools : MS SQL Server, SSMS, PowerBI

Employees' experience analysis dashboard while using a DAM tool for decision making purposes

Created a form to collect evaluations and ratings of a newly introduced DAM tool in a hospital to know what to adjust later

Used tools : Google Forms, PowerBI

Data Visualization for Film Shootings

Built a dashboard for film shootings by visualising KPIs like the directors, time series trends ...

Used tools : PowerBI

ETL Pipeline implementation for OpenMeteo's API using Python

Extracted Data from the API to a JSON file, transformed temperature data using a fonction plus a manupation of calendar data, then loaded data to a postgres database

Used tools : API, Python (including Pandas, SQLAlchemy), PostgreSQL