From the course: SQL Hands-On Practice: Solve Business Problems
Unlock this course with a free trial
Join today to access over 25,000 courses taught by industry experts.
Summarizing customer data for leadership - SQL Tutorial
From the course: SQL Hands-On Practice: Solve Business Problems
Summarizing customer data for leadership
- [Instructor] Imagine it's a regular workday. You've just gone on a beautiful afternoon walk and made a cup of coffee. You're hoping for a quiet afternoon to finish a big project you've been working on. When all of this sudden you receive a message from your company's leadership team with an urgent request, they need some data on the number of registered users per customer. The data is for the board meeting the next day and the board members are super important to the company's success because they help plan, vote, and drive the company to success. So leadership really wants to be prepared and bring the best presentation possible to the meeting. They forgot to ask for the data sooner and they really need your help getting this together by tomorrow. This scenario might seem kind of silly and terrifying at the same time, but it's a pretty common situation in the real world. You immediately follow up and get more information…
Contents
-
-
-
(Locked)
Summarizing customer data for leadership2m 14s
-
(Locked)
Combining aggregate functions with CTEs6m 49s
-
(Locked)
Introduction to CTEs3m 36s
-
(Locked)
Solution: Pull descriptive statistics with a CTE7m 51s
-
(Locked)
Solution: Explore variable distributions with CTEs5m 20s
-
(Locked)
Solution: Payment funnel analysis with CTEs10m 56s
-
(Locked)
-
-
-
-
-