rachitchikara Goto Github PK

exploratory-data-analysis-for-ed-tech-users

This repository contains Python pandas code to perform exploratory data analysis (EDA) on a dataset of users who churned and then rejoined the platform. The report includes the number of win-back users in each week, the average number of days it took for users to rejoin the platform.

rachitchikara.github.io

retention-rate-calculation

This repository contains SQL queries to calculate the retention rate for an application called Kolo. The queries are written in standard SQL and can be used with any database that supports SQL.The queries are well-documented and easy to follow. They can be used as a starting point for anyone who wants to calculate the retention rate for an app.

sql-danny-s-diner-case-study

Danny wants to use the data to answer a few simple questions about his customers, especially about their visiting patterns, how much money they’ve spent and also which menu items are their favourite. Having this deeper connection with his customers will help him deliver a better and more personalised experience for his loyal customers.

sql-data-analysis-for-application-users

This repository contains SQL queries for an application. The queries are used to perform a variety of tasks, such as: Retrieve the current lifecycle stage of users and the duration in days that took for them to be in the current lifecycle stage. Identify users who have been in the same lifecycle stage for a long period of time.

sql-data-challange-datalemur-

This repository contains SQL queries for solving different SQL problems available on datalemur(fpr practicing SQL and Data Science Interview questions). The problems are divided into four categories: Basic SQL, Intermediate SQL, Advanced SQL, Data Analysis.