Disclaimer: The Client (Permier Engineering Group) has given permission for this github repo to be made public. Their employee's and client's names have been removed for privacy.
Microsoft Power Apps
Microsoft Dataverse
Microsoft PowerAutomate
Microsoft Teams PowerBI Integration
The Client wanted to move from Excel spreadsheets that tracked employee payroll to a more in-depth system where they could not only easily track payroll, but also track Project status, completion, and time-spent. This Dashboard provides the Client an easy way to have their employees enter time worked and view all relevant data from thoese punches. This dashboard offers a low-maintenance solution, low upkeep cost, and high customizability.
The MS PowerApps app connects to Microsoft Dataverse, a proprietary DBMS system that is integrated into the MS Power Suite. It is an SQL-like relational platform that allows for querrying, views, and security roles. The GUI run through PowerApps connects to custom relational tables hosted on Dataverse. Querries to Dataverse return dynamically updated results to the GUI in real-time and to any amount of users. This allows for multiple users to run the App through a seamless MS Teams interface, where Teams hosts the app run-time.
The home screen displays a list of scrollable Open Projects [Click each project to get to more project info] and a quick display of all of the user's input hours for the current week. Automatically calculates up to date Regular Time, Overtime, PTO, and Holiday time input.
The timesheet page is where users can enter the timepunches for the week. You can change the week in the top left, but will automatically land on the current week when you visit the page. You add a row for each project, with a dropdown of all currently open projects and standard time types. Users can enter time in the boxes shown in the row as a placeholder for total time per project per day. Users will then click the "clock" icon for the project to break-down their hours as seen below.
These hour breakdowns are required to be filled out. These hours are what the timesheet/payroll/project hour tracker is calculated off of. This feature was a client requested feature.
Users can add in reimbursement requests for miles traveled, tolls paid, parking paid, and other work-related expenses. The total is calculated per month for the user, and the weekly totals per employee are displayed to the payroll manager on the payroll page. When the amount has been paid, the payroll manager can mark the reimbursement paid which will show up to the user in a read-only format.
Users can review their weekly hours broken down by project, in the same manner the payroll manager would see their hours.
This is the main project information page. Lists of all projects are seperated by various categories to the left, which can be further filtered by Project Stage in the dropdown selector. A CSV of the filtered project list can be downloaded and opened by clicking the export buttons. Project information will show up on the right. Different fields are able to have different edit access roles based on user role, defined by the client. By clicking "Project Management for .....", a button only visible to administrators, admins can view and edit further project information which includes budget information and market segment information.
A condensed list of all projects maintained on the dashboard. Clicking on a project in the list will navigate to that project's Project Info sceen (referenced above).
This dynamic calendar will show project dates based on the input dates on the project's Project Info. Clicking on a project in the calendar will navigate to that project's Project Info sceen.
The admin panel is only accessible to administrators defined by the client. This page is where administrators enter a new project to be added to the dashboard, get to the Payroll section to view all employee's payroll (similar to a user's weekly summary but with the option to choose any user), and view project hour summaries. You can also adjust the hour breakdown types available to users from this panel.
