The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Back to feedPost
Built a Capacity & Bottleneck Analysis tool in Excel to help operations teams identify overloaded work centers, understand capacity gaps, and make better production planning decisions.
The analysis compares available capacity against required hours across each resource, highlights constraints before they impact output, and provides a clear view of where overtime, workload balancing, or schedule changes may be needed.
Key features:
Available vs. required capacity analysis
Work center utilization tracking
Capacity gap calculations
Bottleneck identification
Overtime requirement visibility
Capacity vs. demand trends
Utilization trend analysis
Risk-based alerts
Actionable planning recommendations
Management-ready summary dashboard
Designed to help planners quickly identify where capacity is constrained, understand the size of the gap, and determine where resources or schedules may need to be adjusted.
The network for creativity
Join 1.25M professional creatives like you
Connect with clients, get discovered, and run your business 100% commission-free
Creatives on Contra have earned over $150M and we are just getting started
Trending
retrofuturism
Share your favorite designs from the past exploring the distant future. Or your own take on the aesthetic 🚀
halftone
Dots. Texture. Grain. Let's see your designs using the halftone technique.
Midjourney
Creatives are showing off what they're making with Midjourney.
colorgrade
Video editors sound off: How do you enhance the mood of your video in color grading?
Related posts
Designing a dashboard that turns complex workforce data into clear, actionable insights.
Focused on making attendance, shifts, working hours, and key metrics easier to understand at a glance.
#ProductDesign #UXDesign #DashboardDesign #UIUX #SaaS #Figma
The multi-line shift chart earns its space by showing morning/evening/night as separate trends instead of one blended attendance number — that's the difference between "who's late today" and "which shift is actually understaffed." The KPI row above stays honest by not trying to say the same thing twice.
Checkout Research: Why Customers Abandon Cart, and What It Takes to Keep Them
Officeworks' desktop checkout converted above industry standard, but mobile conversion lagged and checkout took over 4x longer than the 1-minute benchmark customers expect. I led a mixed-methods research programme, an audit spanning 6 methods, 613 NPS responses, and 10 user interviews, to find out why.
The research surfaced three connected stories: customers need to feel confident before they can be efficient, cart abandonment has specific and fixable causes (hidden charges, security doubts, and slow load times ranked highest), and Officeworks' mobile checkout was underperforming its own desktop experience.
I translated these findings into 6 prioritized recommendations, including surfacing total cost upfront, making the mini cart editable, and redesigning for adaptive mobile checkout, directly shaping the roadmap for Officeworks' checkout redesign.
This sample demonstrates how I can take business data, organise and analyse it, and turn it into clear information that can support better business decisions.
The project includes data cleaning, spreadsheet analysis, KPI reporting, revenue and profit analysis, trend analysis and data visualisation.
The aim is to make business data easier to understand and highlight the areas that may require attention.
Work demonstrated:
Data cleaning and organisation
Spreadsheet analysis
KPI reporting
Revenue and profit analysis
Trend analysis
Data visualisation
Business insights
Note: All data used in this project is fictional and was created specifically for portfolio demonstration purposes. No client results are being claimed.
