Mohit Kumar Ojha

About Me

Learn more about my journey and expertise

📊 Turning Data Into Decisions

I'm a passionate Data Analyst with hands-on experience transforming raw business data into clear, actionable insights. Currently working as an MIS Executive at Smile Foundation, I specialize in building interactive Power BI dashboards that reduced report generation time by 0%, automating SQL-based ETL pipelines that cut data delivery time by 0%, and delivering compelling KPI reports that drive strategic decision-making.

With expertise in Power BI, DAX, SQL, Python, Excel, Tableau, and Looker Studio, I'm dedicated to solving real-world business challenges through data exploration, visualization, and intelligent automation. My goal is to turn complex datasets into intuitive dashboards that tell a story and empower teams to make data-driven decisions.

I'm a problem solver at heart who believes that great data analysis goes beyond numbers — it's about understanding the business context and delivering insights that actually matter.

Skills

A quick overview of my profile, tools, and expertise

Profile : Data Analyst & Business Analyst, MIS Executive & MIS Analyst
Education : Bachelor of Arts (History), 2021 - 2024
Experience : MIS Executive
2 Years+ experience in data reporting, data analysis, and dashboard management.

Excel / Sheets 95%

BI Tools 90%

SQL 90%

Python 85%

Data Cleaning 90%

Data Analysis 92%

Data Visualization 95%

Dashboard Automation 92%

My Data Analysis Process

Collect

Clean

Analyze

Visualize

Report

Tools

Skills

Software

Soft Skills

Language

Currently Learning

Currently exploring: Advanced Python, Machine Learning, Deep Learning & AI for Data Science.

Power BI

SQL

Python

Tableau

Excel

DAX

Looker Studio

Google Sheets

Professional Experience

My career journey and professional accomplishments

MIS Executive | Data Analyst

🏛️ Smile Foundation

Sep 2025 - Present

Excel SQL Power BI Google Sheets

Analyzed large-scale datasets using Excel, SQL, and Power BI to drive KPI-driven MIS reporting
Designed and deployed interactive Power BI dashboards, reducing report generation time by 40%
Built and automated ETL pipelines using Python and SQL, cutting data delivery time by 30%

MIS Executive

🏛️ Greet India Foundation

Apr 2024 - Aug 2025

Excel Power BI Google Sheets MS Office

Optimized MIS dashboards using Excel and Power BI, reducing manual reporting time by 25%
Developed MIS templates and data verification techniques, improving reporting accuracy by 25%
Trained 300+ students in Excel, MS Office, Power BI, and Google Sheets for practical data skills

Data Analyst (Internship)

🏛️ Unified Mentor

Sep 2024 - Oct 2024

SQL Python Power BI

View Certificate

Executed EDA and cleaned 1,000+ records using SQL and Python, enabling faster Power BI visualizations
Built KPI tracking dashboards and reports, enhancing decision-making efficiency by 25%
Increased data accuracy and integrity by 20% through systematic validation and reporting techniques

Featured Projects

A selection of my recent work and achievements

Mobile Sales Power BI Dashboard - Data Analyst Portfolio Project by Mohit Ojha

Mobile Sales Dashboard

Analyzed mobile sales data using Excel and Power BI to track sales trends, city and brand wise performance.

Power BI Excel Dax

Credit Card Financial Power BI Dashboard - Data Analyst Portfolio Project by Mohit Ojha

Credit Card Dashboard

Built a Power BI dashboard to analyze credit card transactions, customer segments, and revenue distribution.

Power BI SQl DAX

E-Commerce Market Analysis

Developed a Power BI dashboard to analyze e-commerce sales, profit, returns, and product performance.

Power BI Dax Data modeling

Super Store Sales Power BI Dashboard - Data Analyst Portfolio Project by Mohit Ojha

Super Store Data Analysis

Created a dashboard to analyze regional sales, product categories, payment modes, and growth trends.

Power BI Dax Power Query

Ola Ride Booking Analysis

Designed a Power BI dashboard to analyze ride bookings, cancellations, payment methods, and customer behavior.

Power BI SQl Power Query Dax

Blinkit Sales Power BI Dashboard - Data Analyst Portfolio Project by Mohit Ojha

Blinkit Sales Dashboard

Built an interactive Power BI dashboard analyzing Blinkit sales, item type revenue, outlet establishment trends, and outlet size or location performance.

Power BI Dax Power Query

HR Analyst Power BI Dashboard - Employee Attrition Analysis Project by Mohit Ojha

HR Analyst Dashboard

Designed an HR analytics dashboard to track employee attrition by age, education, salary, job role, and gender, across departments.

SQL Power-BI Dax

E-Commerce Sales Power BI Dashboard - Data Analyst Portfolio Project by Mohit Ojha

E-Commerce Sale Dashboard

Created a sales dashboard analyzing quantity, profit, and amount by state, category, payment mode, and month to uncover key sales trends.

Excel Power-BI Dax

Zomato Sales Data Analysis

Analyzed Zomato sales data using Python to identify order trends, customer behavior, and revenue patterns.

Python Pandas Data Analysis

Hi, I'm Mohit Ojha

📊 Turning Data Into Decisions

Mohit Kumar Ojha

Tools

Skills

Software

Soft Skills

Language

Currently Learning

Bachelor of Arts (B.A)

Data Analytics

MIS Executive | Data Analyst

MIS Executive

Data Analyst (Internship)

Advanced Excel

Power-BI

SQL Certificate

Data Analyst

Data Analyst

Power-BI

SQL Basic

SQL Intermediate

SQL Advanced

Data Analyst

Data Science

Advanced Excel

Mobile Sales Dashboard

Credit Card Dashboard

E-Commerce Market Analysis

Super Store Data Analysis

Ola Ride Booking Analysis

Blinkit Sales Dashboard

HR Analyst Dashboard

E-Commerce Sale Dashboard

Zomato Sales Data Analysis

Location

Phone

Email

Resume

Follow Me

Ask about Mohit