Youness Mostefaoui

Data quality monitoring – SNCF Project (Power BI & Power Platform)

Tools: Power BI, Power Automate, Power Apps, SQL Server

Responsibilities:

Creation of Power BI dashboards for operational data monitoring (delays, logistics flows, security).

Automation of alerts and processes via Power Automate (e.g., notifications in case of anomalies).

Participation in the implementation of data quality rules in Power Apps, with validation of business processes.

Facilitation of user workshops and creation of reports for business teams.

Creation of a Python simulation to visualize future silo levels based on a sales plan. => Creation of an executable allowing users to modify certain data (quantity, granulometry...). Development of process and energy Dashboards on Grafana, SQL queries based on display needs, use of different data sources. Automation of real-time energy data updates on Power BI via an API call (data import, M code, Power BI Services, personal mode Gateway, scheduled refresh...). Development of a Python script that, through an API call, allows periodic saving of specific data to PostgreSQL every minute.