Katelle Allin

🔹 Development and optimization of 19 Power BI reports tailored to the needs of 5 business areas (operations, controlling/asset management, executive management, maintenance, data engineering).🔹 Design of KPIs and visuals adapted to each user profile, with standardized layouts through 2 JSON theme files (Valemo & Valorem).🔹 Implementation of interactive documentation and best practice guidelines directly integrated into the reports.🔹Connection and modeling of data from various sources (SQL, Databricks, Power BI dataflows, JSON files).🔹Contribution to data governance through the development of monitoring reports for the data engineering team.🔹Integration of all reports into Azure DevOps (pbip format) to ensure version control, collaboration, and deployment via Microsoft Fabric.

- Created a master data sheet consolidating over 20 datasets related to recycling and waste data for the University of Ottawa.- Analyzing data by building to compare recycling and waste generation across faculties.- Developing an interactive Power BI dashboard to visualize key insights and trends in waste diversion.

🔹 Development of Power BI Dashboards:Designed and implemented intuitive, high-performance dashboards for the "Enterprise and Cloud" sector, adopted by the sales team to drive data-driven decisions in the Energy and Fixed Data markets.🔹 Support for Primary Market Research Projects:Managed the scope design, vendor coordination, and organization of research data, providing detailed analysis for decision-making.🔹 Database Management and Data Preparation:Led data cleaning, structuring, and organization tasks, ensuring the integrity and usability of datasets. Supported the creation and updates of key databases.🔹 Preparation and Presentation of Market Reports:Developed and presented comprehensive market reports, including a one-hour presentation on market trends for sales kick-off events in Asia and Africa.