Data Analyst | Data Engineer
Projects
​​
These days, customers are hard earned as they are spoiled for choices due to increased competition.
It has therefore become imperative for organizations to track churn rate so as to be able to develop strategies for customer satisfaction and ultimately, customer retention.
​
Objective
To highlight churn rate and customer retention trends in a Telecoms company.
​
These KPIs include:
-
Customer retention rate
-
Charges Lost
-
Churn rate by gender, product, contract type etc.
​
Skills and Tools
Power BI, Visualization.
​​
​
​​
Objective
To highlight Key Performance Indicators and metrics in a Call Centre's data that can be used as a basis for discussing ways for improvement
​
These KPIs include:
-
Overall customer satisfaction
-
Overall calls answered/abandoned
-
Calls by time
-
Average speed of answer
​
Skills and Tools
Power BI, Visualization.
Danny owns a little Japanese restaurant that sells Sushi, Ramen and Curry.
He wants to use the data to answer a few simple questions about his customers.
​
Danny has shared 3 key datasets for this case study:
-
sales
-
menu
-
members
​
Objective
To answer questions and generate insights to help Danny improve his business.
​
Skills and Tools
SQL, Microsoft SQL Server, EDA
​
#8weeksSQLChallenge
​
​
Objective
To analyze different aspects of Diabetes in the Pima Indians tribe.
​
Skills and Tools
Descriptive Statistics, Data Visualization, EDA, Python.
New York City taxi rides form the core of the traffic in the city of New York. The many rides taken every day by New Yorkers in the busy city can give us a great idea of traffic times, road blockages, and so on.
The data set contains various information regarding the taxi trips, its duration in New York City. I applied different techniques to get insights into the data and determine how different variables are dependent on the Trip Duration.
Objective
To build a predictive model, which will help in predicting the duration of a taxi trip in NYC.
​
Skills and Tools
Predictive modeling, Feature Engineering, Regression, EDA, Python.
Social and economic factors, such as income, infant mortality, GDP and other Human Development Indices(HDI) can significantly affect how well and how long people live.
These factors are what show the improvements or decline brought about by the impact of governments on the lives of their citizens. This project seeks to use the Kmeans and Bisecting Kmeans clustering algorithms to create groups of countries with similar socio economic performances
​
Objective:
To cluster countries into groups based on similarity in their socio economic perfromance.
​
Tools and Skills:
Unsupervised Machine Learning, Python.
Online streaming platforms like Netflix have plenty of movies in their repositories and if we can build a recommendation system to recommend relevant movies to users based on their historical interactions, this would improve customer satisfaction and hence improve revenue
Objective
The objective of this project is to build a recommendation system to recommend movies to users based on the ratings given to different movies by the users.
Skills and Tools
Collaborative filtering, Matrix factorization, Recommendation systems
Sentiment analysis is frequently used on textual data to assist organizations in tracking brand and product sentiment in consumer feedback and better understanding customer demands.
​
Reviews provided by customers for various businesses on Google and Trust pilot were extracted and analyzed using the vaderSentiment library in Python.
​
The reviews were extracted using the Octoparse web scraping tool, cleaned, and combined in Microsoft excel before importing into Python for the analysis.
​
Tools and Skills
Python, NLP
This project is an analysis of course revenue data for the e-learning platform- Udemy.
​
Traditional methods of education have experienced drastic changes within the last couple of years. As a result of the effects of the COVID-19 pandemic and huge strides being made in terms of technological advancement, more and more people are embracing online education.
​
The analysis of past data on courses was done to understand where opportunities to increase revenue may lie, and also to track the performance of these courses.
​
Tools and Skills
Excel, Tableau, EDA, Visualization.
.png)