Cloud cost dashboard with tagging rules and budget alerts
Build a cost dashboard over an AWS billing export that finds untagged and idle spend, groups cost by team, and raises an alert before a budget is blown.
Industry project · for Brightwave Labs, a 60-person US analytics company whose monthly AWS bill grew from $18,000 to $47,000
Brightwave Labs runs its product on AWS. Over eight months the monthly bill went from $18,000 to $47,000, and nobody can say which team or feature caused the rise. Finance asks engineering, engineering shrugs, and the bill keeps climbing. Two things make it worse: about 30% of resources have no owner tag, and a few test databases were left running for weeks.
The finance lead wants three things she can act on. She wants the bill split by team and by service, so she knows who to talk to. She wants a list of waste, meaning untagged resources and resources that look idle. And she wants an alert when a team is on track to go over its monthly budget, not a surprise on the first of the month.
You will work from the AWS Cost and Usage Report format, using a synthetic export you generate to match its columns, because real billing data is sensitive. Your dashboard reads that export, applies a set of tagging rules to decide ownership, and computes cost by team, by service and by day. It flags untagged spend and idle-looking resources, and it runs a simple forecast that fires an alert when a team's projected month-end cost is over its budget. Done looks like a small web dashboard plus a nightly script, a waste report that names specific resources, and an alert that would have caught the test-database leak at least a week earlier. The finance lead signs off when she can answer "which team spent this" for at least 90% of the bill.
GitHub repo with the dashboard, the nightly script, a synthetic billing export and a waste report + README
Stack: Python or TypeScript, A SQL database or DuckDB, A charting library, The AWS Cost and Usage Report format
- Cost attribution30
The dashboard attributes at least 90% of spend to a team through tagging rules, and shows cost by team, service and day.
- Waste detection25
Untagged and idle-looking resources are listed by name with their cost, not just a total number.
- Budget alerting25
A forecast projects month-end cost per team and raises an alert that would catch overspend about a week early.
- Build quality20
The nightly script and dashboard run from the README, with config in one place and sensible charts.
Pass 60% · Merit 75% · Distinction 90%
Engineering Students
Diploma, B.Tech, B.E., BCA, MCA, or M.Tech students seeking practical experience.
Aspiring Developers
Developers who want to build proof-of-work capstone projects for tech resumes.
Job Seekers
Graduates looking for AI-evaluated code review & verified industry credentials.