Data-Analysis-Portfolio

Sparsh Gupta - Data Analysis Portfolio

About

Hi, I’m Sparsh Gupta. I am MBA graduate with expertise in data analysis. Proficient in spreadsheets for data manipulation, SQL for database querying, R for statistical analysis, and Tableau for data visualization. Proven ability to derive insights and make data-driven decisions. Strong analytical skills combined with business acumen.

My CV in pdf.

This is a repository to showcase skills, share projects and track my progress in Data Analytics related topics.

Table of Contents

• About
• Portfolio Projects
  • Python
  • R
    • How does a bike-share navigate speedy success?
  • SQL
  • Spreadsheets
  • Tableau [Link]
  • Power BI
  • Power Point
  • Google Slides
  • Canva
• Education
• Certificates
• Experience
• Contact

  Portfolio Projects

  In this section I will list data analytics projects briefly describing the technology stack used to solve cases.

Project 1- How does a bike-share navigate speedy success?

Kaggle Notebook- Link

Goal

Design marketing strategies aimed at converting casual riders into annual members.

Description

Cyclistic, a bike-share company in Chicago, seeks to maximize the number of annual memberships. The company aims to understand the different usage patterns of casual riders and annual members to design effective marketing strategies that convert casual riders into annual members. The analysis follows the steps of the data analysis process—Ask, Prepare, Process, Analyze, Share, and Act—to derive insights and recommendations.

Skills

• Data Analysis
• Statistical Analysis
• Data Visualization
• Marketing Strategy Design
• Customer Behavior Analysis

Technology

• Tidyverse (R package for data manipulation and visualization)
• ggplot2 (R package for creating complex plots from data)
• Tableau (for creating interactive visualizations and dashboards)
  • Link of Dashboard

Results

The analysis revealed that annual members use Cyclistic bikes for regular commuting during peak hours on weekdays, with shorter and more frequent trips, while casual riders predominantly use bikes for leisure on weekends and holidays, resulting in longer but fewer trips. Both groups prefer classic bikes, with casual riders showing a notable preference for docked bikes leading to the longest ride durations. Revenue from annual members is more stable and predictable, contributing significantly to profitability. Popular stations like Streeter Dr & Grand Ave are favored by casual riders, and both groups peak in usage during summer months. The data highlights a substantial opportunity to convert engaged casual riders into annual members through targeted marketing strategies utilizing digital media.

Education

• MBA (2021 - 2023)

  USMS, GGSIPU

  Sector 16 C, Dwarka, New Delhi- 110078

• BBA (2018 - 2021)

  Tecnia Institute of Advance Studies, GGSIPU

  3, Bhagwan Mahavir Marg, Sector 14, Rohini, Delhi- 85

• 12th (2018)

  S.D. Public School

  Subject: Commerce

  Balraj Khanna Marg, Delhi Patel Nagar, Delhi- 110008

Certificates

• Google data analytics certifications
• Financial Accounting (NPTEL)

Experience

• Research Analyst (Nov 2023 - Jan 2024)

  SMC Global Securities Ltd. · Internship · On-site

  • Accomplished a 20% improvement in financial analysis accuracy, as measured by the precision of evaluations, by analyzing Dabur’s annual and quarterly reports and using spreadsheets for financial statements.
  • Achieved a 30% increase in stakeholder understanding by creating visualizations to present financial data more effectively.

• Market Research Analyst (May 2022 - Jul 2022)

  ICICI BANK · Internship · On-site

  • Accomplished a comprehensive analysis of the micro-market dynamics of Mayur Vihar, Delhi, resulting in a 15% increase in market penetration for targeted financial products within the locality.

• Marketing (Mar 2020)

  Lenskart.com · Freelance · On-site

  • Effectively increased brand visibility and foot traffic by 30% through strategic pamphlet distribution in targeted local areas. By reaching an average of 50 households per day, I achieved a 20% rise in new customer acquisitions. This experience honed my skills in data- driven marketing and campaign analysis, providing valuable insights for future roles in data analysis.

Contact

• Linkedin: @sparshgupta
• Email: sparshgupta2109@gmail.com