How This Workflow Works
This workflow brings together timesheet, employee, and project data to calculate actual project expenses and revenues, determine profitability for each project, and present the results in an interactive dashboard for further analysis.
Key Features:
- Calculate task duration, project costs and revenues based on timesheet data.
- Assess profitability for each project and across all projects.
- Visualize overall project performance and details in an interactive dashboard.
Step-by-step:
1. Aggregate and Enrich Timesheet Data:
The workflow combines timesheet entries with employee and project information, calculates the duration of each task, and determines the corresponding salary expenses and billable prices. This step ensures that all relevant data points are merged and ready for analysis.
2. Calculate Project Costs, Revenues, and Profitability:
For each project, the workflow sums up the total expenses and revenues, compares actuals to budgeted figures, and computes gross profit. It also distinguishes between internal and external projects to provide a clear view of where value is being generated.
3. Summarize Overall Financial Performance:
The workflow aggregates total revenues and expenses across all projects, applying business rules such as setting internal task revenues to zero. It rounds key metrics for clarity and prepares the data for reporting.
4. Visualize and Share Insights:
Results are presented in an interactive dashboard, featuring bar charts and project overviews. Users can explore project-level details, add manual notes, making it easier to communicate findings with stakeholders.