1.Normalizing Categorical Data Distributions
Time allocation analysis · 2026
Just as engineering teams must categorize components, this workflow illustrates how a freelance billing consultant analyzed time allocation across multiple clients. The dashboard highlights a portfolio logging 1,251.9h overall, split into 23.6% non-billable overhead and 76.4% delivery capacity. A normalization rule panel explains how multi-tag entries are split, defining overhead tags (comm*, misc/*, _chaos) versus billable tags (design, eng, data, research), with engineering absorbing 384.8h of billable time. A stacked horizontal bar chart visualizes ten anonymized clients, showing Client III with the highest total hours at 208.3h and the largest absolute overhead burden at 65.6h, while Client BBB has the highest overhead ratio at 41.0%.
What it shows:
How to use normalization rules to split multi-tag entries and visualize categorical distributions.




