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
Unprocessed Meter Billing Tracker | R2.06M Revenue At Risk DashboardDescription:
Built for national managed print services / office automation — tracking meter billing capture across 4,468 machines and R2M+ in potential billing.
The Problem: Client couldn't see which customer meters weren't captured, couldn't bill. 4,459 uncaptured meters = R2.06M revenue at risk. No priority, no ownership. Finance was blind.
What I Built:Real-time Unprocessed Meters Progress Dashboard — the control room for contract billing.
Executive Header:2.06M Potential Revenue At Risk (the money shot)0.20% % Captured vs 4459 Uncaptured — urgency visible in red/orange/green
General Metrics: 4468 Total Meters | 2721 Black | 1552 Colour | 195 Other | 2722 Machines
Total Usage: 87.6K (Black 72.22K / Colour 15.38K)Deep Dive Modules I Built:Captured Progress by Customer — per customer: Meters, Captured, Uncaptured, %. Instant accountability. UNISA 1187 meters, 0.25% captured — immediate action.
Meter Breakdown Donut — 60.9% Black, 34.7% Colour — composition at a glance
Usage by MeterType — Black vs Colour usage — 72K vs 15K — shows billing impact
Top 10 Customers by Uncaptured Meters — where to focus collectors first
Top 10 Models by Uncaptured Meters — TASKalfa 4054, 358ci etc — identifies device/process issues
Variance Captured — Billing vs Usage variance detection — prevents under/over billing (R2,495 variance tracked)
Tech & Logic:Advanced SQL to join contracts, meters, readings, billing tablesComplex business rules: Reading Date filtering, Capture Status logic, Variance calc (Usage vs Billing)
6x slicers: Reading Date, Meter Type, Capture Status, Customer, Contract, Reading Comment
Handles large relational dataset: 4468 meters x readings history
Result: Billing team went from "we think we missed some" to "we have R2.06M at risk, here are top 10 customers, go collect". Moved capture rate tracking from weekly Excel to live.
Direct impact on cash flow.
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
Related posts
Hello all!
Assembling a few sample performance and analytics dashboards, using randomized dummy data to keep client info private, to refine how reporting gets presented to design and brand partners.
When working on brand, web, or UI/UX projects, what metrics or visual insights do you actually find valuable in a report? Are you looking to see how visual changes impact user engagement and conversion paths, or do you prefer high-level ROI summaries to show clients the impact of your work?
Always open to connecting with designers, agencies, and growth strategists looking to partner on the performance and reporting side of client accounts.
I Created Microsoft Power BI Dashboard By using many of the Tools
🚀 Data Modelling
🧠 Data Visualization
🚀 Group By
🧠 Data Cleaning
AutoML Forge is an end-to-end AutoML platform designed to simplify the machine learning workflow by automating key stages from data preparation to model evaluation.
The platform allows users to upload their datasets and build machine learning models without manually handling every step of the traditional ML pipeline.
Key Features
Automated data preprocessing and cleaning
Automatic feature handling and transformation
Classification and regression workflows
Anomaly detection
Model comparison and evaluation
Automated model selection
Hyperparameter optimization
Performance metrics and visualizations
Model prediction and inference
Easy-to-use interactive interface
Tech Stack
Python · PyCaret · FastAI · Scikit-learn · Pandas · NumPy · Streamlit
The project focuses on making machine learning more accessible while reducing repetitive experimentation and development time. It demonstrates practical experience in machine learning automation, model evaluation, data preprocessing, and building AI-powered applications.
Role: AI/ML Developer
Project Type: Machine Learning / AutoML / Data Science
Impressive to see automated data preprocessing and cleaning built into AutoML Forge - eliminating that tedious step speeds up experimentation dramatically. The integrated model comparison and evaluation visualizations make it easy to spot the best performer quickly.