Business Minutes Between Timestamps Calculation
Mar
2023
Problem / Purpose
Multiple reports required accurate calculations of business hours between two timestamps, but no consistent or scalable method existed across teams.
Solution
Developed a join-based approach to calculate business minutes by creating a minute-level reference table with associated lookup values. The solution joins to start and end timestamps, then calculates the difference between lookup values to derive business time. Adopted as the standard method and used for 4+ years.
Key Achievements / Impact
Created a durable and widely adopted solution for calculating business time across reports. Eliminated inconsistency and manual workarounds, becoming the go-to method for timestamp-based metrics across teams.
Key Technologies / Tools Used
SQL, Snowflake, Time Dimension Modeling, Reporting Infrastructure
Role
Data Scientist
ProService Hawaii