This project focused on transforming Pleora's Excel-based Return Map process into a centralized Power BI dashboard. The solution integrates multiple business data sources, including Return Map workbooks, Salesforce actual sales, Forecast data, BambooHR project hours, and Business Case assumptions, into a single reporting environment. The goal of the project was to reduce manual reporting effort, improve visibility into product performance, and create a scalable framework for future Return Map automation.
Jiayu Hilda Hu
Project Manager: client communication, Power BI development, deliverable coordination
Xinrui Wang
Data analysis, Power BI development, documentation, agenda preparation
Oliver Weng
ETL pipeline design, Power BI development, data integration
Yunsong Zhang
Meeting minutes, technical development, testing
Yunqi Zhao
Requirements analysis, UI design, testing
Client - Kerry Crouchman
Director of Operations, Pleora Technologies.
Kerry provides strategic direction, approves requirements, and facilitates access to internal systems.
Client - Aditya Dabbiru
Product Manager at Pleora
The subject matter expert for the Return Map.
Arya Rahgozar
Adjunct Professor
The School of Engineering Design and Teaching Innovation, University of Ottawa
Role in Project:Technical Advisor for the project. With expertise in artificial intelligence and software engineering, Professor Rahgozar's guidance support the team in addressing technical challenges and ensuring the soundness of our implementation strategy through critical feedback and domain-specific insight.