Mihir Jadhav | Data Analyst

Turning Data Into Business Decisions.

Hi, I'm Mihir Jadhav.

I analyze complex datasets and transform them into clear, actionable insights using SQL, Power BI, Python and Excel. My work spans data cleaning, exploratory analysis, interactive dashboards, KPI reporting and predictive analytics.

SQL Power BI Python Excel Tableau Machine Learning

More than dashboards — I focus on the story behind the data.

I'm a Data Analyst with an engineering background and a strong interest in transforming complex datasets into clear and meaningful business insights.

My work combines SQL, Power BI, Python, Excel, Tableau and statistical analysis to clean data, investigate performance, develop dashboards and build predictive solutions.

I focus on understanding the business question behind the data, selecting the right analytical approach and communicating findings in a way that supports informed decision-making.

What happened? Why did it happen? What does the data tell us — and what should we do next?

Tools I use to solve data problems.

My toolkit covers data preparation, querying, business intelligence, visualization, statistical analysis and machine learning.

Data Analysis

SQL • Excel • Python • Pandas • NumPy • Data Cleaning • Data Validation • Exploratory Data Analysis

Business Intelligence

Power BI • DAX • Power Query • Tableau • KPI Reporting • Dashboard Development • Data Visualization

Machine Learning

Scikit-learn • Linear Regression • Decision Trees • Random Forest • K-Means • Model Evaluation

Statistics & Analytics

Statistical Analysis • Hypothesis Testing • Correlation • Outlier Analysis • Trend Analysis • Business Insights

Featured Projects

Selected analytical work.

Projects demonstrating how I approach business intelligence, machine learning and database analytics.

Add Your Power BI Dashboard Screenshot

Project 01 • Business Intelligence

Fundraising Analytics & Sustainability Dashboard

Power BI DAX Power Query Excel

Developed an interactive analytics solution to evaluate fundraising performance, donor behaviour, campaign effectiveness and marketing efficiency.

Designed KPI-driven dashboards for campaign and fundraising performance.

Analyzed donor behaviour, campaign trends and marketing channels.

Translated analytical findings into clear business insights.

View Project

Add ML Model / Results Visualization

Project 02 • Machine Learning

Air Quality Prediction Using Machine Learning

Python Pandas Scikit-learn Regression

Developed an end-to-end regression workflow to analyze environmental sensor measurements and predict Relative Humidity.

Performed EDA, missing-value treatment, feature analysis and preprocessing.

Applied IQR-based outlier analysis, Winsorization and feature scaling.

Compared regression models using MAE, MSE and R².

View Project

Add ER Diagram / SQL Project Screenshot

Project 03 • SQL & Database Analytics

Aerox Aviation Database & Analytics

SQL DBMS 3NF Data Modeling

Designed a structured aviation database covering passengers, flights, bookings, aircraft, routes, payments and operational data.

Designed relational tables using primary and foreign key relationships.

Applied database normalization through Third Normal Form.

Used joins, views, subqueries, procedures and indexing concepts.

View Project

From business question to actionable insight.

I follow a structured workflow to ensure that the final analysis addresses the underlying business problem.

Understand

Define the business problem, objectives and key performance indicators.

Prepare

Clean, validate and transform raw datasets for analysis.

Analyze

Explore trends, relationships, patterns and performance drivers.

Visualize

Communicate findings through dashboards and visual reports.

Recommend

Translate analytical findings into actionable recommendations.

Academic Background

My engineering background developed my analytical, technical and problem-solving foundation.

2021 – 2024

B.E. Electronics & Telecommunication

Sant Gadge Baba Amravati University

2018 – 2021

Diploma

Government Polytechnic, Amravati

Technical Focus

Data & Analytics

SQL • Power BI • Python • Excel • Tableau • Statistics • Machine Learning

Let's turn data into meaningful business insights.

I'm interested in Data Analyst opportunities where I can apply data analysis, business intelligence and analytical problem-solving skills to real-world business challenges.