Certainly!
Here are the project descriptions for each of your courses:
SQL- New Wheels Case Study
Course: SQL
Description: Addressed the declining sales and customer retention issues at New-Wheels by
organizing and analyzing unstructured data using MySQL. Implemented fetching and filtering
techniques, aggregated data with aggregate and window functions, and utilized sub-queries and
Case When functions for quicker insights. Applied various join techniques, including inner, left,
and right joins, and created mathematical calculations using SQL queries. Translated the output
data into visualizations for the Quarterly Business Report, providing leadership with actionable
recommendations and insights.
Skills & Tools Covered:
Fetching and filtering techniques
Aggregate and window functions
Sub-queries and Case When functions
Joining multiple tables (inner, left, right)
Mathematical calculations in SQL
Visualization creation
Learnings: Successfully applied SQL skills to solve real-world business challenges, improving
data organization and providing valuable insights for decision-making.
Election Exit Poll Prediction and U.S.A Presidential Speech Analysis using
Machine Learning
Course: Machine Learning
Description: Conducted a comprehensive analysis of election exit polls and U.S.A. Presidential
speeches using machine learning. Implemented text mining analytics, support vector machines,
k-nearest neighbors, naive bayes, ensemble techniques, logistic regression, and linear
discriminant analysis. Predicted voting preferences based on survey responses and drew
inferences from the analysis of inaugural U.S.A. Presidential speeches.
Skills & Tools Covered:
Text mining analytics
Support Vector Machine, K Nearest Neighbour, Naive Bayes
Ensemble techniques
Logistic Regression, Linear Discriminant Analysis
Learnings: Developed proficiency in machine learning techniques, enhancing the ability to
make predictions and draw meaningful insights from textual data.
Gems & Holiday Package Prediction
Course: Predictive Modeling
Description: Executed predictive modeling on two case studies: Gems Price Prediction and
Holiday Package prediction. Employed linear regression for gem price prediction and logistic
regression along with linear discriminant analysis for holiday package prediction. Applied
statistical concepts to maximize profits and target the relevant customer base.
Skills & Tools Covered:
Linear Regression
Logistic Regression
Linear Discriminant Analysis
Learnings: Gained practical experience in applying predictive modeling techniques to solve
business problems, enhancing decision-making processes.
Segmentation using Clustering and PCA
Course: Data Mining
Description: Addressed the challenge of analyzing data with numerous variables through
segmentation using clustering and Principal Component Analysis (PCA). Conducted Exploratory
Data Analysis (EDA), performed clustering techniques for Digital Marketing Advertisement
Data Segmentation, and identified optimum principal components in Primary Census data.
Skills & Tools Covered:
EDA (Exploratory Data Analysis)
Clustering
PCA (Principal Component Analysis)
Data Mining
Silhouette Score
Learnings: Developed expertise in data mining techniques, enhancing the ability to uncover
patterns and insights in complex datasets.
Advance Statistics Graded Project DSBA New Structure
Course: Advanced Statistics
Description: Applied advanced statistical techniques, including probability, probability
distribution, hypothesis testing, and ANOVA, to solve problems in the DSBA New Structure
project. Demonstrated proficiency in statistical analysis and hypothesis testing.
Skills & Tools Covered:
Probability
Probability Distribution
Hypothesis Testing
ANOVA
Learnings: Enhanced statistical analysis skills through the application of advanced statistical
methods in solving real-world problems.
Analyse and Explore Data and reflect the insights - SMDM Project
Course: Statistical Methods for Decision Making
Description: Provided analytical solutions for the Austo Motor Company's marketing campaign
efficiency and framed an analytics problem on the Go Digit Dataset. Applied Python, descriptive
statistics, and exploratory data analysis techniques to address marketing concerns and formulate
analytics problems.
Skills & Tools Covered:
Python
Descriptive Statistics
EDA (Exploratory Data Analysis)
Framing an Analytics Problem
Learnings: Utilized statistical methods to derive actionable insights, improving decision-making
processes in real-world scenarios.
E-Commerce Revenue Management
Course: Python for Data Science
Description: Solved a business problem for an E-Commerce company by identifying regions
with maximum sales volume, analyzing product preferences, and determining overall revenue.
Utilized Python for data manipulation (numpy, pandas), visualization, and created user-defined
functions to extract meaningful insights.
Skills & Tools Covered:
numpy
pandas
Visualization
User-defined functions
Learnings: Applied Python for data science, gaining practical experience in extracting insights
from business data for effective revenue management.
