Skip to content
OrionStats
Log inStart learning
← Project Lab
PROJECT 34Advanced

Commission Management in Streamlit

Business scenario

Sales commissions are calculated in a fragile spreadsheet. Disputes take days to resolve.

Problem statement

Build a Streamlit app where finance uploads monthly sales performance, configures commission rules, reviews calculated commissions per rep and exports an approved payout file.

Learning objectives

  • Implement configurable commission rules
  • Build a multi-page Streamlit app with validation
  • Provide audit trail and export

Instructions

Rules (configurable): base commission % on actual sales; accelerator above 100% of plan; cap; clawback flag. Validate uploads (columns, types, duplicates). Store approved runs (SQLite) with who/when.

Tasks

  1. Rule engine with unit tests.
  2. Upload & validation page.
  3. Review page with filters and charts.
  4. Approval + export + history.
  5. README and deployment notes.

Deliverables

  • App repository
  • Tests
  • Demo screenshots/video

Evaluation rubric

CriterionWeightExcellentProficientDevelopingInsufficient
Calculation correctness25%Rules exact, tested at boundaries.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
App functionality25%Upload, review, approve, export all work.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Validation & audit20%Bad input rejected; history kept.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Code structure15%Modular, readable.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.
Presentation15%Concise, well-labelled outputs a manager can act on without explanation.Correct and complete with minor gaps in rigour or presentation.Partly correct; important steps missing, unvalidated or unclear.Missing, incorrect, or not supported by the data.