Clickstream Case Study Through SQL

Learn the tips & tricks of measuring the performance of a website or an app, and perform funnel analysis of the user journey.

Learn the following SQL Concepts:

• How to get N rows of data in SQL
• How to use Aggregate Functions in SQL
  • Count, Count Distinct, Sum, Maximum, Minimum etc.
• How to Group data and aggregate in SQL
• How to combine Grouping and Sorting in SQL
• How to use Mathematical Functions on Aggregate Values in SQL
• How to do time-series analysis of a metric in SQL
• How to build a funnel analysis in SQL
• How to convert an aggregate column to percentage in SQL

Learn the following Concepts about Clickstream Analytics:

• Understand the user journey on an online platform through various clickstream metrics
• How to analyze the overall number of visits on a website or app
• What is Overall order conversion rate (most important online metric) and how to calculate it
• How to analyze the cart conversion rate for a website or app
• How to calculate the Bounce Rate for any online platform
• How to build your own funnel analysis for a specific user journey
• How to analyze the checkout abandonment rate for a website or app