Profit is one of the first things people use to assess a company's success. In this chapter, you'll learn how to calculate revenue and cost, and then combine the two calculations using Common Table Expressions to calculate profit.

Revenue

Revenue per customer

Revenue per week

Cost and Common Table Expressions (CTEs)

Total cost

Top meals by cost

Using CTEs

Profit

Profit per eatery

Profit per month

Revenue, Cost, and Profit

Financial KPIs like profit are important, but they don't speak to user activity and engagement. In this chapter, you'll learn how to calculate the registrations and active users KPIs, and use window functions to calculate the user growth and retention rates.

Registrations and active users

Registrations by month

Monthly active users (MAU)

Window functions

Registrations running total

MAU monitor (I)

Growth

MAU monitor (II)

MAU monitor (III)

Order growth rate

Retention

New, retained, and resurrected users

Retention rate

User-Centric KPIs

Since a KPI is a single number, it can't describe how data is distributed. In this chapter, you'll learn about unit economics, histograms, bucketing, and percentiles, which you can use to spot the variance in user behaviors.

Unit economics

Average revenue per user

ARPU per week

Average orders per user

Histograms

Histogram of revenue

Histogram of orders

Bucketing

Bucketing users by revenue

Bucketing users by orders

Percentiles

Revenue quartiles

Interquartile range

ARPU, Histograms, and Percentiles

Executives often use the KPIs you've calculated in the three previous chapters to guide business decisions. In this chapter, you'll package the KPIs you've created into a readable report you can present to managers and executives.

Survey of useful functions

Formatting dates

Rank users by their count of orders

Pivoting

Pivoting user revenues by month

Costs

Producing executive reports

Report readability

Executive report

Course recap

Generating an Executive Report

Delivr Data (SQL)

Businesses track data on everything, from operations to marketing to HR. Leveraging this data enables businesses to better understand themselves and their customers, leading to higher profits and better performance. In this course, you’ll learn about the key metrics that businesses use to measure performance. You'll write SQL queries to calculate these metrics and produce report-ready results. Throughout the course, you'll study data from a fictional food delivery startup, modeled on data from real companies.

Data Manipulation in SQL

Learn to write SQL queries to calculate key metrics that businesses use to measure performance.

Analyzing Business Data in SQL

SQL for Business Analysts

New, retained, and resurrected users

Analyzing Business Data in SQL

Latihan interaktif praktis