About Skills Projects Experience Education Activities Contact

Hey, I'm

Sakshi Gangawane.

Data Analytics Associate

Turning complex datasets into actionable insights through Python, SQL, Power BI, and data storytelling. Currently open to new opportunities.

Sakshi Gangawane

About Me

Hi! I'm Sakshi Gangawane, a Data Analytics Associate from Pune, Maharashtra. I specialize in transforming complex datasets into actionable business insights through dashboards, visualizations, and BI reporting.

I'm pursuing my B.Tech in Computer Science & Engineering at Dr. Babasaheb Ambedkar Technological University (DBATU) (2022โ€“2026), and I'm passionate about data storytelling, process optimization, and leveraging analytics to drive business growth.

2 Projects
180K+ Records Analyzed
2 Certifications
Download Resume
Data-driven decisions start with clean insights ๐Ÿ“ˆ

Skills & Tools

Technologies I work with

๐Ÿ Python
๐Ÿ—„๏ธ SQL / MySQL
๐Ÿ“Š Power BI
๐Ÿ“— Microsoft Excel
๐Ÿ”ข DAX
๐Ÿผ Pandas & NumPy
๐Ÿ“‰ Matplotlib & Seaborn
๐Ÿงน Data Cleaning & ETL
๐Ÿ“‹ EDA & Statistics
โ˜๏ธ AWS (Basics)
๐Ÿ™ Git & GitHub
๐Ÿค– Generative AI
๐Ÿ

Programming & Data Analysis

Python SQL
๐Ÿ“Š

Data Visualization & BI

Power BI Microsoft Excel DAX Power Query KPI Reporting Data Storytelling
๐Ÿ—„๏ธ

Database Technologies

MySQL SQL Server DBMS
๐Ÿ“Š

Statistical Analysis

A/B Testing Hypothesis Testing Statistical Analysis Descriptive Statistics Inferential Statistics Probability Confidence Intervals P-Value Interpretation Statistical Significance Z-Test T-Test Chi-Square Test ANOVA Correlation Analysis Regression Analysis Experimental Design Sampling Techniques Data-Driven Decision Making
๐Ÿ”ฌ

Data Analytics & Engineering

Data Cleaning Data Validation Data Transformation Data Collection Data Modelling ETL Processes Data Querying EDA Statistical Analysis
๐Ÿ“‹

SQL Concepts

Joins Subqueries Views Aggregations Window Functions CTEs
๐Ÿ› ๏ธ

Tools & Platforms

GitHub Jupyter Notebook VS Code MySQL Workbench Jira AWS (Basics)
๐Ÿค–

Emerging Technologies

Generative AI (GenAI) AI-Assisted Data Analysis Prompt Engineering

My Projects

Data projects I've built

๐Ÿšš
Python Pandas Matplotlib Seaborn

Supply Chain BI & Risk Analysis

Analyzed 180K+ supply chain records across 53 business variables. Uncovered a 54.71% late delivery rate, estimated $2.1M in losses, and delivered logistics optimization recommendations.

๐Ÿฆ
Power BI SQL DAX Excel

Bank Loan Analysis Dashboard

Built interactive Power BI dashboards to monitor loan applications, repayments, and KPIs. Classified loans into Good/Bad categories and implemented MTD & YoY metrics using advanced DAX.

๐Ÿ“Š
Python Pandas NumPy Matplotlib Seaborn Jupyter Notebook

Retail Sales Business Intelligence Analysis

Conducted retail sales analysis using SQL, Python, and Power BI to uncover revenue trends, product performance, and customer insights, enabling data-driven business recommendations. ๐Ÿš€

๐ŸŽ“
Python Pandas NumPy Matplotlib Seaborn Jupyter Notebook

Degree vs Skills job market analysis

Degree vs Skills: Workforce Intelligence Analysis Conducted an end-to-end analysis of the Indian job market to evaluate the impact of degrees, skills, experience, and location on hiring trends. Discovered that 76% of jobs did not explicitly require a degree, highlighting the increasing importance of practical skills and problem-solving abilities.

๐Ÿ…ฐ๏ธ๐Ÿ…ฑ๏ธ๐Ÿงช
Python Pandas NumPy Matplotlib Statsmodels Hypothesis Testing A/B Testing Jupyter Notebook

E-commerce A/B Testing Statistical Analysis

Conducted an end-to-end statistical analysis of an e-commerce A/B testing experiment to evaluate whether a new landing page improved customer conversion rates. Cleaned and validated over 294K user records, performed exploratory data analysis, applied a Two-Proportion Z-Test,interpreted confidence intervals and p-values, and translated statistical findings into actionable business recommendations. The analysis concluded that the observed difference in conversion rates was not statistically significant (p = 0.1899), demonstrating data-driven decision making.

Experience

Where I've worked

Data Analyst Intern

Feb 2026 โ€“ May 2026

Greateway Software Pvt. Ltd., Pune

  • Collected, cleaned, and analyzed retail and financial datasets using Python, SQL, and Power BI.
  • Analyzed 1,000+ transaction records using EDA to identify trends and customer behavior patterns.
  • Designed interactive Power BI dashboards to visualize KPIs, loan performance, and sales insights.
  • Applied advanced DAX calculations and data modeling to enhance reporting efficiency.
  • Supported data-driven decision-making through effective data storytelling and BI reporting.

Education

Where I've learned

B.Tech โ€” Computer Science & Engineering

2022 โ€“ 2026

Dr. Babasaheb Ambedkar Technological University (DBATU), Lonere

  • Specializing in data analytics, database management, and software engineering.
  • Completed hands-on projects in Python, SQL, Power BI, and statistical analysis.

Certifications

๐Ÿ…

Data Analyst Internship Completion Certificate

Greateway Software Pvt. Ltd., Pune

View Certificate โ†’
๐Ÿ…

Data Analytics Professional Certification

Fusion Software Institute, Pune

View Certificate โ†’

Extra Curricular

Job Simulations & Online Programs

๐Ÿข
Job Simulation Data Analysis

Data Analytics Job Simulation

Deloitte ยท March 2026

๐Ÿ” Completed practical tasks in Data Analytics as part of Deloitte's official Job Simulation program on Forage, leveraging data analysis and visualization techniques to solve real-world business challenges and deliver actionable insights.

View Certificate โ†’
๐Ÿ“ˆ
Job Simulation Data Analysis

Data VisualiZation job simulation

TATA ยท April 2026

๐Ÿ“ˆ Completed hands-on Data Visualization tasks as part of Tata Group's official Job Simulation program on Forage, transforming business data into actionable insights through effective visual storytelling and dashboard designation as part of TATA's official Job Simulation program on Forage.

View Certificate โ†’
๐Ÿค–๐Ÿ“Š
Job Simulation Data Analysis

GenAI Powered Data Analytics Job Simulation

GenAI ยท April 2026

๐Ÿ“Š Successfully completed a Generative AI Data Analytics Job Simulation, gaining practical experience in data analysis, prompt engineering, AI-assisted reporting, and transforming complex datasets into meaningful business insights.

View Certificate โ†’

Get In Touch

I'm always open to new opportunities and collaborations.

๐Ÿ“ž
๐Ÿ“

Location

Pune, Maharashtra 411041, India

๐Ÿ’ผ