Fabric App · HR

Time off Tracker:
Planned, Approved and Visualized 

A leave request app that runs inside Microsoft Fabric. Employees request time off in seconds, managers approve with the whole team in view, and HR gets the numbers without a single spreadsheet.
Leave request and approval Team calendar Insights
PRODUCT
Leave Request App
FOR
Employees, team leads, HR
STACK
Microsoft Fabric
RUNS IN
Your own Fabric tenant

/01THE PROBLEM

Most teams track leave across emails, a shared calendar and a spreadsheet only HR understands. That works until two trainers book the same week as a client workshop.

Requests lost in email

Nobody is sure what was approved, by whom, or how many days someone has left.

No view of who's out

Managers approve one request at a time, without seeing the rest of the team's week.

Expensive or outdated SaaS

Missing values needed custom completion rules, using similarity checks across multiple attributes so the analytical integrity of the figures held.

/02THE IMPACT

What changes the day the app goes live:
leave requests stop being a side process in inboxes, Teams or expensive SaaS and become data the whole company can access & plan with. 

2 Clicks

to request
From Plan time off to a sent request, with working days counted for automatically.

Outlook

connection
Direct connection and time blocker in requester Outlook.

4 Views

one data source
Welcome, My time off, Team and Insights.

Live

team coverage
Managers see who else is off before they approve, not after.

/02THE APP

One app for the whole leave process: ask, approve, plan around it and report on it.
Built as a Fabric app, so requests, balances and approvals sit next to the rest of your data instead of in a separate HR tool or a shared Excel file.

/03THE APPROACH

We validated the model first, rebuilt the report around its two audiences, then handed the team something they could extend on their own.

01

Discover & assess

We reviewed the existing prototype and audited the calculation logic line by line, surfacing the gaps and inconsistencies in the applied methodology.

Logic audit
Gap analysis

02

Design & model

We defined a refined calculation framework and implemented multi-level logic so results stayed consistent across every entity and reporting period.

Calculation framework
Multi-level logic

03

Build & visualize

We rebuilt the report in Power BI, applying modern UX and UI principles to the clarity, navigation, and accessibility so both internal and external users could find their way around it.

Power BI
UX / UI
Accessibility

04

Adapt & rebuild

When the business changed its calculation methodology mid-project, we rewrote the key measures to align with the updated logic without breaking the rest of the model.

Measure rewrite
Change handling

05

Validate & test

We ran extensive validation sessions with business users to confirm the accuracy, completeness, and usability of every output. Those outputs now serve as the base other departments build their own analysis on.

User validation
Accuracy checks

06

Deploy & enable

We delivered the finished monitoring solution and ran knowledge-transfer sessions, so the internal analysts could maintain and iterate on it without waiting on us.

Handover
Enablement

07

Extend & scale

After the report was adopted, the airport extended the scope and we applied the same logic and design framework to a second operational area, keeping both consistent and easy to maintain.

Reusable framework
Second area

/04THE RESULTS

A compliance view the airport can stand behind, in front of regulators and on the ops floor.

External stakeholders read it unaided

Entity-specific views and a rebuilt experience mean regulators and partners get the detail they need without someone walking them through it.

Internal teams catch issues early

Daily-refreshed monitoring surfaces threshold pressure while there is still time to act, instead of after a breach shows up in a quarterly review.

One framework, now two areas

The validated logic and design system carried straight into a second operational area, so the airport scales reporting without rebuilding it each time.

Ready for reports your team actually uses?

Book a discovery call. We scope the work, tell you honestly whether we're the right fit, and you decide from there.