Data Analysis Projects

Following are the examples of Data analysis projects to showcase the experience with different analytical tools.

Project 1: Data Exploration with SQL

Using SQL server to explore data for an insurance company customer database. The analysis gave a clearer picture of the company’s customer base and how to target that segment.

Check the project at SQL Customer Segment

Project 2: Data Exploration using R with sql packages

The R packages for SQL i.e ‘sqldf’ and ‘SQLite’ were used to explore the employee database for an apparel company. The analysis helped get a better understanding of the employees of the company and how to increase their productivity.

You can view the projects at SQL projects in R

Project 3: Customer Analysis using BTYD package and CLVTools package in R

To gauge the customer lifetime value of a snacks company and an apparel company, CLVTools and BTYD package. CLVTools enables us to get accurate the lifetime value of a customer, whereas BTYD predicts the cunsomer behaviour. These packages in the analysis helped in making the customer acquisition process more efficient and increasing the retention rate.

The projects can be viewed at CLV Analysis

Project 3: A/B Testing using R

Using R, performance of two different email campaigns was checked by running an A/B test and determined which email campaign had better result.

View the project at A/B Testing

Project 4: Linear Regression using R

Linear Regression was run on the dataset of marketing department for a cosmetic company, to determine which marketing platform is significant for spreading their message and what platform to remove to reduce cost.

View the project at Linear Regression Analysis

Project 4: Logistic Regression using R

TO predict the future orders for a bakery, Logistic regression was run to create a model with good accuracy that will help in the prediction.

View the project at Logistic Regression Analysis

Project 5: SQL Murder Case

An interesting project by Joon Park and Cathy He of Knight Lab to sharpen SQL skills. By using queries involving functions such as JOIN, WHERE, ORDER BY the killer is found hidden in the dataset. The dataset is built in SQLite as “sqlite_master”. You can check the mystery here

You can view my solutions at Murder Mystery Solution

You can reach out to me at

Email address: Farwabatool569@gmail.com

LinkedIn: Farwa Batool