1. Course recap
Congratulations on finishing the course! You've learned quite a bit, so let's go over the course's contents to consolidate.
2. Course recap
In Chapter 1, you learned about revenue, cost, and profit, and how to use CTEs to combine the revenue and cost queries to calculate profit.
In Chapter 2, you learned about user-centric methods, namely the registrations and active users KPIs. You also used window functions to calculate the active users growth and retention rates.
In Chapter 3, you learned about unit economics, and understood how your data is distributed through histograms and percentiles.
In Chapter 4, you learned how to produce an executive report using pivoting.
3. To infinity, and beyond!
You can now use SQL to analyze real-world business data. I hope you've had fun analyzing Delivr's data!