Portrait of Sagar Shende, Data Analyst

Open to Data Analyst roles in Pune

Turning raw data into decisions people can act on.

I'm Sagar Shende, a Microsoft Certified Power BI Data Analyst Associate (PL-300) based in Wardha, Maharashtra. I clean, model and visualize business data — writing SQL queries, building Power BI dashboards, and running exploratory analysis in Python — to help teams make faster, evidence-based decisions.

View Projects Download Resume
0GitHub Projects
0Internships & Roles
0MS Certification

About

Business-first, not just tool-first.

Portrait of Sagar Shende
RoleJunior Data Analyst
CompanyDream With Data
LocationWardha, Maharashtra, IN
EducationBCCA, RTM Nagpur University
LanguagesEnglish, Hindi, Marathi

I turn messy, unstructured business data into reporting people actually trust and act on. As a Microsoft Certified Power BI Data Analyst Associate (PL-300), I work across the full analytics pipeline — cleaning and modeling data in SQL and Power Query, writing DAX measures that hold up under scrutiny, and building Power BI dashboards that answer the question a stakeholder actually asked, not just the one that was easiest to chart.

At Dream With Data, I write production SQL and build KPI-tracking dashboards that feed directly into management reporting and performance reviews — where accuracy isn't optional. That habit of validating every number before it reaches a dashboard carries through everything I build, reinforced by three AICTE-certified programs in Power BI, conversational analytics, and applied data science.

My GitHub is where I push that further: a 438K-row credit applicant segmentation model, a multi-source superstore sales dashboard tracking 15 KPIs, and attrition and churn analyses built to surface the pattern a business team would actually act on — not just describe the data.

Traveling Travel Photography Book Learning

Skills

Tools I use to get from raw data to a decision.

No inflated percentage bars — just the stack I actually work in day to day, organized the way I use it.

Programming

  • Python
  • Pandas
  • NumPy

Databases

  • SQL
  • MySQL
  • Data Modeling
  • ETL

BI Tools

  • Power BI
  • DAX
  • Power Query
  • Excel

Data Visualization

  • Power BI Dashboards
  • Matplotlib
  • Seaborn
  • Data Storytelling

Statistics

  • EDA
  • Statistical Analysis
  • Data Cleaning
  • Data Validation

Cloud & Tools

  • IBM Cloud
  • Jupyter Notebook
  • Git
  • GitHub

Experience

Internships & Traineeship

Dec 2025 — Present

Data Analyst Trainee

Dream With Data (DwD) · Wardha, India

  • Wrote 30+ SQL queries and built 5+ Power BI dashboards for business reporting and KPI tracking.
  • Cleaned, transformed and validated data using Excel, SQL and Power BI to improve reporting accuracy.
  • Built KPI-based reports that supported management decision-making and performance tracking.
  • Conducted exploratory data analysis (EDA) to identify trends, anomalies and business insights.
Jan 2026 — Feb 2026

Power BI Intern

Microsoft Elevate × AICTE · Remote

  • Completed a 4-week AICTE-certified internship on Power BI for Business Applications under Emerging Technologies.
  • Built dashboards and practiced data modeling and business reporting using Power BI.
Sep 2025 — Oct 2025

Conversational Data Analytics Intern

VOIS · AICTE-Certified, Edunet Foundation · Wardha (Remote)

  • Analyzed conversational datasets using LLMs to extract key insights across agriculture, business and science domains.
  • Applied NLP, data preprocessing and visualization techniques for pattern identification and performance evaluation.
  • Collaborated in a team-based project under expert mentorship, improving data-driven decision-making accuracy by 20%.
Jul 2025 — Aug 2025

Data Analytics Intern

IBM · AICTE-Certified, Edunet Foundation & IBM SkillsBuild · Wardha (Remote)

  • Completed a 4-week internship focused on Data Analytics, AI and IBM Cloud through the AICTE and Edunet Foundation program.
  • Conducted hands-on exploratory data analysis (EDA), built AI/ML models, and ran experiments using IBM Cloud tools.
  • Delivered a final project integrating data preprocessing, visualization and predictive analytics.

Education

Academic Background

2023 — 2026

BCCA — Bachelor of Commerce in Computer Applications

RTM Nagpur University · First Class, CGPA 6.63

2021 — 2023

Yashwant Mahavidyalay

Wardha · Second Class Distinction

Certifications & Achievements

Credentials that back the skill stack.

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Issuer
Microsoft
Issued
July 2026
Credential ID
6c78c21495ab725a
Verify Credential

IBM SkillsBuild — Data Analytics Fluency Pathway

Issuer
IBM SkillsBuild
Issued
2025
Credential ID
PLAN-E76CA96A8C45
Verify Credential

IBM SkillsBuild — Applied Data Science with Python

Issuer
IBM SkillsBuild
Issued
2025
Credential ID
PLAN-B6CBEFCA2BFD
Verify Credential

Kaggle — Advanced SQL

Issuer
Kaggle (Google)
Issued
June 2026
Learner ID
sagarshendeai
Verify Credential

Featured Projects

End-to-end analytics work — from raw data to a business decision.

Each project ships with a documented business problem, dataset, tools and measurable outcome. Expand any card for the full breakdown.

Superstore Sales Analytics

A multi-source Power BI dashboard unifying Orders, Returns and People data to track sales, profit and regional performance across 2011–2014.

5,009 orders · 15+ derived columns · 3 merged datasets
Power BIDAXMySQLPythonExcel
$2MTotal sales
$286KTotal profit
15KPIs tracked
View full breakdown
Business problem
Sales, logistics and product teams had no single view of order performance across products, customers, shipping and regions — reporting was manual and spreadsheet-driven.
Approach & tools
Integrated Orders, Returns and People datasets into one master table in Excel and MySQL, engineered 15+ derived columns in Python, then built a Power BI model with DAX measures (Profit Margin %, YoY Growth, Avg Delivery Days) answering 27 EDA questions across 15 tracked KPIs.
Key insight
The Consumer segment drove 50.55% of total sales and Technology led category profit at $0.15M, while Furniture showed high volume but the thinnest margins — flagging it for a pricing review.
Business impact
Replaced fragmented spreadsheet reporting with one interactive dashboard, giving stakeholders a self-serve view by region, segment and year instead of a manual monthly pull.
GitHub Live Demo

Credit Card Customer Analytics

Customer segmentation dashboard analyzing income, family structure and asset ownership across 438,000+ credit card applicants.

438,000+ applicant records
ExcelMySQLPythonPower BI
438K+Applicants
10KPIs & slicers
1Interactive dashboard
View full breakdown
Business problem
Understand demographic, income, family and asset trends across a large applicant pool to support customer segmentation and more consistent, risk-aware credit decisions.
Approach & tools
Cleaned and engineered features across income, family structure and asset ownership using Excel, MySQL and Python, then built an interactive Power BI dashboard with 10 KPIs and cross-filtering slicers.
Key insight
Segmenting by income band, family size and asset ownership surfaced distinct applicant clusters — useful for tailoring credit offers and flagging income-to-asset mismatches for review.
Business impact
Gives a credit team a repeatable, filterable segmentation view across 438K+ applicants instead of ad-hoc manual review.
GitHub Live Demo

HR Analytics — Attrition & Workforce Insights

A SQL-driven investigation into attrition, salary distribution and departmental performance, visualized in a Power BI dashboard for workforce planning.

1,500 employee records
MySQLSQLPower BI
1,500Employee rows
50+SQL queries
3Focus areas
View full breakdown
Business problem
HR had no consolidated view of why employees were leaving or how pay and performance varied across departments — decisions on retention and workforce planning relied on manual, ad-hoc dataset review.
Approach & tools
Wrote 50+ SQL queries — joins, CTEs, subqueries and window functions — against a 1,500-row HR dataset in MySQL to investigate attrition, salary distribution and departmental performance, then visualized the findings in a Power BI dashboard.
Key insight
Surfaced workforce and demographic patterns — attrition concentration by department and tenure, and salary-to-performance mismatches — that flag where retention risk is highest.
Business impact
Gives HR a repeatable, query-driven view of attrition and compensation patterns to support retention strategy and workforce planning, instead of a one-off manual pull.
GitHub Live Demo

IBM Telecom Customer Churn Analysis

Exploratory analysis of the IBM Telco Customer Churn dataset in Python, examining contract type, tenure and billing patterns to identify where churn concentrates.

7,043 customer records · 21 attributes
PythonPandasEDA
7,043Customers
21Attributes analyzed
1Notebook end-to-end
View full breakdown
Business problem
Telecom providers lose recurring revenue when customers churn. Understanding which contract types, tenure bands and billing patterns correlate with churn helps a retention team target the right customers.
Approach & tools
Loaded and cleaned the IBM Telco Customer Churn dataset (7,043 customers, 21 attributes) in Python and Pandas, then ran exploratory analysis across contract type, tenure, payment method and monthly/total charges to profile churned vs. retained customers.
Key insight
Churn concentrates among customers on month-to-month contracts with shorter tenure — the classic signal a retention team would use to prioritize proactive outreach.
Business impact
Gives a retention team a data-backed starting point for who to target first, instead of treating all customers as equally likely to churn.
GitHub Live Demo

Excel Analytics Portfolio

Real-world Excel analysis on IMDB, Loan, E-Commerce & Titanic datasets using pivot tables, VLOOKUP and dashboards.

GitHub →

Power BI Dashboards Collection

A collection of Power BI dashboards covering ecommerce sales, HR analytics, IMDB, Spotify and unicorn companies.

GitHub →

Netflix Data Analysis

Exploratory data analysis of Netflix's catalog using Python, Pandas, Seaborn and Matplotlib — built during the VOIS × AICTE internship.

GitHub →

MySQL Sakila Practice

SQL fundamentals through advanced practice on the Sakila dataset — SELECT, JOINs, subqueries and CTEs in MySQL Workbench.

GitHub →

GitHub Activity

Live stats, pulled straight from GitHub.

Sagar Shende's GitHub stats: repositories, stars and contributions Sagar Shende's GitHub contribution streak
0Public projects
0Certifications
0SQL queries written
0Power BI dashboards

Want the one-page version?

Download my resume for a quick summary of experience, tools and education — or connect on LinkedIn.

Download Resume Connect on LinkedIn

Contact

Let's talk about your data.

Open to Data Analyst roles and freelance dashboard work in and around Pune.

Address

Wardha, Maharashtra, India

This opens your email app with the message pre-filled — sent directly to sagarshende0608@gmail.com.