Introduction
I’m not a developer. I don’t write code for a living, and for years I believed that building apps was something reserved for engineers. My world revolved around Excel sheets, formulas, and endless manual checks.
But with the help of Copilot, I discovered that even someone non-technical like me could create powerful solutions that improve productivity, increase accuracy, and delight internal customers.
The first application I built? A fully interactive commission calculator that transformed how our Sales reps view their performance.
Challenges
Before this, our commission tracking was a maze of spreadsheets:
- Each rep had a different format.
- Business logic was buried in formulas.
- Manual errors were common.
- Reps had no visibility into their payout status or attainment progress.
It was time-consuming, error-prone, and lacked transparency.
Solution
With Microsoft Copilot guiding me step by step, I built a Streamlit-powered dashboard that:
- Reads a single Excel file of all opportunities.
- Lets me select any sales rep from a dropdown.
- Applies their unique commission rate and quota goal.
- Calculates attainment %, payout factor, and commission breakdown.
- Displays a clean, intuitive Rep Dashboard Summary.
Even more exciting — I’ve integrated the app with Dynamics 365 to automatically pull in won deals, making the workflow seamless and real-time.
Benefits
The impact was immediate and measurable:
- Time saved: No more manual reconciliation across sheets.
- Accuracy improved: Business logic is applied consistently across reps.
- Transparency unlocked: Reps see their progress, payout status, and commission breakdown instantly.
- Scalability achieved: The app works across all reps, all files, and all quarters.
- Internal delight: Reps feel empowered, managers feel informed, and I feel proud.
This isn’t just automation. It’s storytelling. It’s turning numbers into narratives, spreadsheets into stories, and commissions into confidence.
And the best part? If I can do this, anyone can.
If you have any questions or want to see how this solution can work for your team, don’t hesitate to contact us. We’re here to help!
