Welcome to my portfolio! I’m Mohit Kumar Ojha, a Data Analyst & MIS Executive with strong experience in data reporting, dashboard development, and business intelligence. I specialize in converting raw data into meaningful insights using tools like Excel, SQL, Power BI, Looker Studio, Tableau, and Python. My focus is on building automated reporting systems, improving data accuracy, and creating interactive dashboards that support smarter and faster decision-making.
Currently, I work as an MIS Executive at Smile Foundation, where I manage end-to-end reporting, visualization, and data validation processes. Previously, I gained hands-on experience as a Computer Trainer & MIS Executive and completed a Data Analyst Internship at Unified Mentor, working with real-time datasets and analytical problem-solving. I’m passionate about continuous learning and using modern analytics tools to help organizations optimize workflows and make data-driven decisions with confidence.
0 + Projects completed
Detail-oriented and result-driven Data Analyst | MIS Executive | MIS Analyst | Business Analyst with hands-on experience in Advanced Excel, Google Sheets, SQL, Python, Power BI, Tableau, Looker Studio, Business Intelligence and Data Reporting. Skilled in building dashboards, cleaning datasets, automating reports, and generating actionable insights that support data-driven decision-making by up to 40%.
Smile Foundation is a non-profit organization supporting underserved communities through education, healthcare, and livelihood programs.
Greet India Coaching Institute is a reputable educational center focused on providing quality training in computer applications and IT and technology .
Unified Mentors is a professional training and internship provider that helps individuals develop skills in fields like data analysis .
Analyzed Mobile Sales data using Excel and Power-Bi, visualizes mobile sales Data across cities, brands, payment methods, and time trends.
Showcases MS Dhoni's cricket performance, highlighting his runs, strike rate, dismissals, achievements by year, ground, and opponent.
presents Ecommerce sales insights, including profit, quantity, amount, customer and state-wise distribution, payment modes, and category performance.
This Power BI dashboard provides an overview of Maven Market's transactions, profit, returns, country-wise sales, product performance, and revenue trends.
sales performance insights, including regional and segment-wise sales, payment modes, sub-category sales, shipping methods, and year-over-year trends..
In this power-Bi project analysing ride trends, booking statuses, payment methods, and customer behaviour for data-driven insights.
Create Dashboard for data analysis on Zomato sales using Python to improve the customer experience.
A Power BI dashboard providing insights into credit card spending patterns, revenue distribution, and customer segmentation.
Analyzed music store data using advanced SQL queires to identify gaps and increase the business growth.