Python Quest

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.

About 100 minAdvanced6 exercises

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.