Academic/Independent Projects

---

1. Visualizing on-Time Performance Metrics of Delta Airlines, USA

2. Course Evaluation and Regression Models for Udemy Pricing Strategy

3. Social Media Marketing Strategy/Tweet Claasification for Chicago Based Hospital

4. Network and Security Data breach in Financial Sector

5. Product pricing Analysis and Logistic Regression for Brand Value and Origin

6. Channel Mix Evaluation and Marketing Strategy for Gestalt D

Description

• Utilized Bureau of Transportation Statistics airline data set to prepare delay metrics that describe Delta Airlines On-time Performance.
• Implemented Stories, Interactive Dashboards, Route Maps, LOD Expression for competitive analysis and operational insights.
• Created network maps and recommended profitable routes for Delta Airlines for its business expansion and opportunity identification.

Tech Used:

Tableau, Business Statistics, Advance Excel

Contributors:

Individual

Summary

Identify the dependent and independent variables for pricing a course at udemy and predict the price of courses for better profit forecasting.

Description

• Extracted, cleaned and transformed the unstructured course data to structured data, enabling a wider understanding of customer reviews on price of a course at Udemy.
• Performed univariate/bivariate analysis, Hypothesis testing and Linear Regression to obtain segmented results for each course category

Tech Used:

Advance Statistics, R and Regression Modelling, Tableau

GitHub Link:

Course Evaluation and Regression Models for Udemy Pricing Strategy

Contributors:

Individual

Summary

Predicting the category of tweets for healthcare industry and devising a market strategy for Chicago based hospital based on variable selection.

Description

• Scrapped, processed and analyzed social media data of top 10 Chicago area hospitals using R studio and Tableau.
• Developed digital reports based on the usage of social media handles and implemented regression and vector scale model to analyze the trends for hospital’s Social media marketing using various analysis metrics.
• Worked with the hospital to provided operational insights to enhance its social media strategy, based on the results obtained by analyzing and interpreting the data sets.

Tech Used:

R studio, Tableau, SPSS, Python, Machine Learning and Microsoft Excel

GitHub Link:

Social Media Marketing Strategy/Tweet Claasification for Chicago Based Hospital

Contributors:

Individual

Description

• Cleaned and analyzed 2 million data records for the types of security breaches in the financial sector and created dashboards for digital reporting.
• • Forecasted number of breaches in future years and used clustering to identify breaches which resulted in losses greater than 5M.
• Performed region, industry and company wise analysis, created time series visualizations and did forecasting using Tableau to understand the dynamics of breaches in the United States.

Tech Used:

Tableau, Tableau Prep, Tableau Server, MS Excel, SPSS

Contributors:

Individual

Description

• Scrapped and Extracted information from a UK based E commerce website for statistical analysis of the product prices and its specifications.
• Developed hypothesis for brand value and performed linear and logistic regression on product data, used PCA for factor analysis.

Tech Used:

R studio, Tableau, MS Excel, Dimensionality Reduction

GitHub Link:

Product pricing Analysis and Logistic Regression for Brand Value and Origin

Contributors:

Individual

Summary

Identify costumer buying behaviors and devise optimal marketing strategy, more specifically:o Customer buying patterns, sources and impact of online buying on interior design sourcingo Marketing strategy outlining Channel mix and value proposition.

Description

• Analyzed the volume and content on social media by competitors and recommended strategies, which increased engagement rate by 50%.
• Implemented strategies to understand the channel mix and improve the value proposition of Online Stores in designer industry.

Tech Used:

Tableau, Customer Segmentation, Catalogue Comparison

GitHub Link:

Channel Mix Evaluation and Marketing Strategy for Gestalt D

Contributors:

Group