- Implemented a user-centric BI solution to monitor strategic KPIs and support data-driven decision-making.
- Analyzed RFQ data to improve business decisions and identify new customer opportunities.
- Developed a Python application to automate Excel data import, processing, and dashboard generation.
- Added new modules to meet business needs and improve analysis.
- Result: Reduced dashboard generation time from 2 weeks to an average of 30 seconds.
I implemented an ETL pipeline through SSIS, automated it through SSMS by creating a scheduled job and created a Power BI dashboard with all the KPIs communicated during business requirements' gathering reunion
I analysed data from a JSON file using PowerBI, learnt how to make visual filter using charts and how to make conditional columns based on another column’s values
I Transformed data based on the business requirements, then I built a dashboard plus a storytelling via an explanatory video.
I Developed a web application for scholar internship application called Concentresi between ESI students and Concentrix