Skilled in SQL, Power BI, Excel, and Python. I focus on turning raw data into clear business insights and interactive dashboards that support strategic decision-making.
Name: Bhavesh Kshirsagar
Job Role: Aspiring Data Analyst
Experience: 3+ Months (Internship)
Address: Pune, Maharashtra
I chose data analytics because I’ve always been fascinated by how numbers can tell a story and solve complex business problems. During my 3+ month internship at Unified Mentor, I transitioned from learning tools to applying them on real-world datasets, focusing on sales and healthcare. My approach is simple: I don't just look at data; I look for the "why" behind the trends to help businesses make better choices.
Business Problem: Executive management lacked visibility into real-time patient waiting times across departments, leading to resource allocation inefficiencies.
Tools Used: SQL, Power BI, DAX
Key Analysis: Row-Level Security (RLS), KPI cards, and drill-through departmental deep-dives.
Insights & Impact: Increased stakeholder engagement by 40% and reduced reporting time by 15 hours/month.
View Case Study
Business Problem: Raw sales data was unorganized, making it difficult to identify regional performance trends and top-selling products.
Tools Used: Excel, Power Query, SQL
Key Analysis: Pivot Tables, Slicers, and automated data refresh via Power Query.
Insights & Impact: Identified 3 low-revenue regions for strategic focus and optimized inventory distribution.
View Case Study
Business Problem: Unpredictable delivery delays were causing supply chain bottlenecks and customer dissatisfaction.
Tools Used: Python (Pandas, Matplotlib, Seaborn)
Key Analysis: Lead time distribution visualization and carrier performance correlation.
Insights & Impact: Identified root causes of delays, leading to a strategy that reduced late deliveries by 15%.
View Case Study
Business Problem: Vehicle theft and unauthorized access are major concerns for vehicle owners.
Tools Used: Embedded C, Microcontrollers
Key Analysis: Biometric authentication and GSM module integration for remote alerts.
Insights & Impact: Designed a robust security system that enhances vehicle protection and user peace of mind.
View Documentation
Business Problem: Manual market research across e-commerce platforms is slow, inefficient, and prone to human error, hindering competitive analysis.
Tools Used: Python, Playwright, PostgreSQL, Pandas
Key Analysis: Dynamic web scraping handling pagination and popups, and real-time structured data storage into PostgreSQL.
Insights & Impact: Automated extraction of product details across multiple categories, saving up to 90% of manual data entry time and enabling rapid market trend analysis.
View Case Study
Business Problem: Fragmented academic data made it difficult for educators and administrators to track student performance, attendance trends, and attrition risks.
Tools Used: Python, Streamlit, Plotly, PostgreSQL
Key Analysis: Secure role-based access, interactive KPI dashboards, heatmaps, and a composite risk scoring system for students.
Insights & Impact: Centralized data management, allowing proactive identification of at-risk students and reducing administrative reporting overhead by standardizing performance tracking.
View Case Studybhaveshkshirsagar50@gmail.com
+91 9325369612
Pune, Maharashtra
Feel free to connect with me on LinkedIn or reach out via email.