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
I designed and built a dynamic Excel procurement dashboard using 720 synthetic purchase records. Users can filter the report by date, region, category, and supplier, while all KPIs, charts, and transaction details update automatically.
The dashboard tracks total spend, budget savings, purchase-order volume, on-time delivery, quality performance, and average lead time. It also includes a dynamically filtered transaction view, supplier and product master data, performance comparisons, and formula-driven analysis tables.
This project demonstrates my ability to transform complex business data into a clear, interactive, and reusable Excel management system for faster procurement decisions.
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
Challenges
View all
Related posts
Same website. Two completely different vibes.
Which one are you shipping? 👀
3 voted
100%
0 voted
0%
3 votes
Closed
Currently exploring a book design focused on making complex information easier to understand through visual language. Playing with typography, data visualization, and graphic systems to give the subject a more editorial feel.
This is a trully elegant and impressive design concept.
I love it.
This project tackles a real small-business pain point: inventory silently running out because no one's tracking stock in real time.
Order processing (webhook-triggered): Incoming orders (supporting multiple items per order) are received via webhook, split into individual line items, and logged — each order simply appends a new entry to an order log rather than directly overwriting stock numbers.
Live stock calculation: Current stock for each item is computed on the fly, using a formula that subtracts all logged order quantities from the starting count.
Daily stock monitoring (schedule-triggered): A separate scheduled trigger runs once a day, checks every item's live stock against its own custom reorder threshold, and sends a Slack alert for anything running low — so restocking happens before customers ever notice a shortage.
The daily trigger that checks each item's live stock against its own reorder threshold and then pushes a Slack alert seems like a practical way to stay ahead of stockouts.