SQL Problem MOM Growth Analysis | How to Calculate Month On Month Growth In SQL Server
In this video we will see how to use window function in sql server to calculate month on month growth. In SQL Server we can use lag window function to get previous month sales for mom growth analysis. ========================================= This video solves below queries. ========================================= 1. SQL Server window function. 2. How to calculate month on month growth in sql server. 3. SQL Server mom growth analysis. 4. How to calculate mom growth analysis in sql server. 5. Data analyst SQL problems and answers. 6. SQL interview task for data analyst. 7. SQL server interview problems for data analyst. 8. Data analyst sql interview questions. 9. Data analyst sql problems. ========================================= Take a look, You may find below vides interesting. ========================================= Combine multiple row values into single row. https://youtu.be/g-bLekv2kjU?si=k2kRgdZRBZBOViFN Most asked SQL problem in data analyst interview. https://youtu.be/8T2MgbQxQcw?si=WHXXU1yJ4RmRtCOL Magical join in sql server. https://youtu.be/ObS6tayA0XY?si=9UPsysgd6ffGgVyU How to get list of all tables & their record count https://youtu.be/_jYmcaWOBZs?si=Qpt15qV8x5xX7G6A Get missing month name & sales value https://youtu.be/Y-d_5Yqi7I0?si=-qWl74jwVwBIclhn How to split text data into new rows in SQL Server https://youtu.be/EDfBR1d-E3Q?si=gJqCPp4awH7dtsJm ========================================= Table DDL & Insert statement for your practice ========================================= Create table dbo.sales_data ( Brand varchar(50) not null, Region varchar(50) not null, City varchar(50) not null, Sales_Date date not null, Sales Decimal(7,2) not null ); go Insert into dbo.sales_data(Brand,Region,City,sales_date,Sales) Values ('Apple','West','Akola','2012-01-19',8162), ('Apple','East','Akola','2012-01-20',6522), ('Apple','West','Delhi','2012-01-21',3012), ('Samsung','West','Delhi','2012-02-22',9969), ('Samsung','South','Mumbai','2012-02-23',7034), ('Samsung','West','Akola','2012-02-24',8162), ('Samsung','East','Mumbai','2012-03-25',9969), ('Apple','West','Chennai','2012-03-26',2913), ('Apple','East','Chennai','2012-04-27',9910), ('Samsung','East','Goa','2012-04-28',297), ('Apple','South','Chennai','2012-05-29',9506), ('Apple','South','Mumbai','2012-05-30',6385), ('Apple','South','Delhi','2012-05-31',9910), ('Samsung','East','Goa','2012-06-01',8793), ('Samsung','East','Goa','2012-06-02',9910), ('Samsung','East','Pune','2012-07-03',9557), ('Apple','South','Mumbai','2012-07-04',9910), ('Apple','North','Akola','2012-07-05',2162), ('Samsung','East','Goa','2012-08-06',9910), ('Samsung','South','Chennai','2012-08-07',7696), ('Samsung','West','Akola','2012-08-08',9890); go select * from dbo.sales_data; go ;with c_month_sales as ( select DATENAME(month,s.sales_date) as Month_Name, datepart(month,s.sales_date) as Month_Number, sum(s.Sales) as Total_Sale from dbo.Sales_Data s group by datename(month,s.sales_date),datepart(month,s.sales_date) ), c_prev_month as ( select Month_Name, Total_Sale, lag(Total_Sale,1,Total_Sale)over(order by month_number asc)as prv_sale from c_month_sales ) select *, total_sale-prv_sale as diff, cast(( Total_Sale - prv_sale) / prv_sale * 100 as decimal(7,2)) as growth from c_prev_month; #bitechlake #bizzintelligence
In this video we will see how to use window function in sql server to calculate month on month growth. In SQL Server we can use lag window function to get previous month sales for mom growth analysis. ========================================= This video solves below queries. ========================================= 1. SQL Server window function. 2. How to calculate month on month growth in sql server. 3. SQL Server mom growth analysis. 4. How to calculate mom growth analysis in sql server. 5. Data analyst SQL problems and answers. 6. SQL interview task for data analyst. 7. SQL server interview problems for data analyst. 8. Data analyst sql interview questions. 9. Data analyst sql problems. ========================================= Take a look, You may find below vides interesting. ========================================= Combine multiple row values into single row. https://youtu.be/g-bLekv2kjU?si=k2kRgdZRBZBOViFN Most asked SQL problem in data analyst interview. https://youtu.be/8T2MgbQxQcw?si=WHXXU1yJ4RmRtCOL Magical join in sql server. https://youtu.be/ObS6tayA0XY?si=9UPsysgd6ffGgVyU How to get list of all tables & their record count https://youtu.be/_jYmcaWOBZs?si=Qpt15qV8x5xX7G6A Get missing month name & sales value https://youtu.be/Y-d_5Yqi7I0?si=-qWl74jwVwBIclhn How to split text data into new rows in SQL Server https://youtu.be/EDfBR1d-E3Q?si=gJqCPp4awH7dtsJm ========================================= Table DDL & Insert statement for your practice ========================================= Create table dbo.sales_data ( Brand varchar(50) not null, Region varchar(50) not null, City varchar(50) not null, Sales_Date date not null, Sales Decimal(7,2) not null ); go Insert into dbo.sales_data(Brand,Region,City,sales_date,Sales) Values ('Apple','West','Akola','2012-01-19',8162), ('Apple','East','Akola','2012-01-20',6522), ('Apple','West','Delhi','2012-01-21',3012), ('Samsung','West','Delhi','2012-02-22',9969), ('Samsung','South','Mumbai','2012-02-23',7034), ('Samsung','West','Akola','2012-02-24',8162), ('Samsung','East','Mumbai','2012-03-25',9969), ('Apple','West','Chennai','2012-03-26',2913), ('Apple','East','Chennai','2012-04-27',9910), ('Samsung','East','Goa','2012-04-28',297), ('Apple','South','Chennai','2012-05-29',9506), ('Apple','South','Mumbai','2012-05-30',6385), ('Apple','South','Delhi','2012-05-31',9910), ('Samsung','East','Goa','2012-06-01',8793), ('Samsung','East','Goa','2012-06-02',9910), ('Samsung','East','Pune','2012-07-03',9557), ('Apple','South','Mumbai','2012-07-04',9910), ('Apple','North','Akola','2012-07-05',2162), ('Samsung','East','Goa','2012-08-06',9910), ('Samsung','South','Chennai','2012-08-07',7696), ('Samsung','West','Akola','2012-08-08',9890); go select * from dbo.sales_data; go ;with c_month_sales as ( select DATENAME(month,s.sales_date) as Month_Name, datepart(month,s.sales_date) as Month_Number, sum(s.Sales) as Total_Sale from dbo.Sales_Data s group by datename(month,s.sales_date),datepart(month,s.sales_date) ), c_prev_month as ( select Month_Name, Total_Sale, lag(Total_Sale,1,Total_Sale)over(order by month_number asc)as prv_sale from c_month_sales ) select *, total_sale-prv_sale as diff, cast(( Total_Sale - prv_sale) / prv_sale * 100 as decimal(7,2)) as growth from c_prev_month; #bitechlake #bizzintelligence