Data Analysis Through SQL

Cohort analysis is a method used to track and analyze the behavior and performance of a specific group (called cohort) over time . It enables businesses to understand how different cohorts behave differently from one another or from a general population.  Typically, cohorts share common characteristics or experiences within a defined timeframe , such as customers who signed up during a particular month or users who joined a platform in a specific year.  For example, a subscription-based company (like Netflix) might use cohort analysis to compare the retention rates of customers who signed up in different months. This could reveal insights into whether newer cohorts exhibit different retention behaviors compared to older ones, helping the company adjust its retention strategies accordingly to improve customer lifetime value (CLTV). Cohort analysis deals with retention , survivorship , returnship and cumulative .  Retention is concerned with whether the cohort member has ...

    Time series analysis helps in profiling and understanding a dataset. The result set of the analysis is a series of dates or timestamps and a numerical value. When graphing a time series, the dates or timestamps are plotted on the x-axis, and the numerical value becomes the y-axis.      In this article, the time series analysis of the monthly US retail sales dataset using SQL on MySQL Workbench is presented. The data is used as an economic indicator to understand trends in US consumer spending patterns.      Our dataset contains records of monthly retail sales in US from 1992 till 2020 and has been taken (in .XLS format originally) from the Census.gov website. The dataset has been converted into a format that can be easily interpreted and used for querying in MySQL Workbench. Its .CSV version was pulled as the retail_sales table in MySQL Workbench using Workbench's 'Table Data Import Wizard' utility.  The retail_sales table has 22026 rec...