Track 17 · Lesson 8 of 12
Project: sales dashboard with pandas and matplotlib
Turn a year of order lines into a sales dashboard: monthly revenue, top products, regional comparison, two charts and a KPI summary, all built as small tested functions.
You will be able to
- Load a CSV with pandas, parse dates and derive a revenue column
- Group and pivot order data to answer specific business questions
- Rank results deterministically, including ties
- Build charts in functions that return their Axes so they can be checked automatically
- Combine the analysis into a KPI summary and handle empty or one-month data
Included with a Formula Quest membership
It has 6 graded exercises with feedback, hints and solutions. Python Quest is included in Formula Quest memberships that cover Python; membership and billing are managed on Formula Quest.
View Formula Quest memberships
Tracks 1 and 2, the first lesson of every track, the playground and the dataset library are free.