Project Finance Data Manager
Jan 2024 - Jul 2024
Category: Work Project
Power Apps Used in 3 projects
Power Query Used in 7 projects
SharePoint Used in 9 projects
SQL Used in 5 projects
Description
The Project Finance Data Manager app was a Power App for managing various cost data for a project, tying together several data sources.
Pulled in timesheet data and financial information from various RLE International region sources such as Paycor, T-Sheet and Iplicit.
Users could also import Cost Model Translation Files to bring in planned finances and could version changes.
Pulled in timesheet data and financial information from various RLE International region sources such as Paycor, T-Sheet and Iplicit.
Users could also import Cost Model Translation Files to bring in planned finances and could version changes.
Lessons Learned
This project challenged our architecture skills mainly, ensuring we had a solid logic for how data flowed between the Cost Model files and could be pushed to the SQL backend whilst maintaining version control.
There were also various access roles we had to set up and implement to ensure the correct users could see the correct level of detail and correct projects.
There were also various access roles we had to set up and implement to ensure the correct users could see the correct level of detail and correct projects.
Developed For
RLE International
Project Links: