Capstone: a Price Monitoring Dashboard with Alerts, a Ranked Bar Chart and Conditional Formatting
This lesson is part of the course
In this lesson
You build Copperleaf Outdoor's weekly price dashboard: the price index per product, the share of products above an alert threshold, a sorted bar chart and red highlighting for the products that need attention.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Matching Products Across Shops: Normalised Match Keys and the Match Rate Locked
- The Price Index: Our Price ÷ Average Competitor Price × 100 Locked
- Price Position: Cheapest, Middle or Most Expensive with RANK.EQ Locked
- Detecting Price Changes: Day-over-Day %, Change Flags and Change Counts Locked
- Promotion Detection: Big Drops That Rebound Within N Days Locked
- Estimating Price Elasticity from Your Own Price Changes: Log-Log SLOPE Locked
- A Repricing Rule: Beat the Lowest Competitor by 1 %, Never Below the Margin Floor Locked
- Capstone: a Price Monitoring Dashboard with Alerts, a Ranked Bar Chart and Conditional Formatting Locked