Pricing Analytics using SQL | Data Analytics | Restaurant Business | DB Fiddle - Free SQL Playground

Pricing analytics are the metrics and associated tools used to understand how pricing activities affect the overall business, analyze the profitability of specific price points, and optimize a business’s pricing strategy for maximum revenue. [1] In this video, we will be learning: • How do restaurant and food delivery apps can share their pricing and discount information • Understand how to use different functions in SQL to calculate metrics in Pricing comparison Timeline: • Introduction to Restaurant business problem - 0:40 • Data in Excel - 1:40 • Questions and Introduction to DB FIDDLE - 3:08 • Question 1: What is the highest priced item in North Indian cuisine? - 5:14 • Question 2: In our Chinese dishes, what is the lower price in other restaurants? Which of restaurant are having these prices? - 7:34 • Question 3: What is the price competitiveness of our restaurant in each type of dish? - 13:30 • Question 4: How do we rate our prices for North India vs other restaurants? - 22:40 Restaurant Sample dataset: https://docs.google.com/spreadsheets/d/1kusfqw02i-PhiQi2ipty99Nkm9ME1Bfnm0Ph780Tcrk/edit?usp=drivesdk * The information on the videos and the resources available for download/viewing through this YouTube Channel are for educational and informational purposes only.​ Source: 1. https://www.paddle.com/resources/pricing-analytics