I am a Data Analyst, Power BI Developer, and SQL Developer with expertise in data transformation, automation, and visualization. I specialize in converting complex datasets into meaningful insights, enabling data-driven decision-making. Passionate about streamlining processes, I aim to enhance business efficiency through innovative solutions. My skills in Power BI, SQL, and data management empower companies to optimize operations, improve performance, and achieve sustainable growth.
Mohit Bhatia
Jaipur, Rajasthan
+91 6375467286
mohitbhatia.py@gmail.com
Completed a comprehensive program focusing on machine learning, data analysis, and big data technologies. Gained practical experience in Python, SQL, and advanced data visualization. Developed strong skills in predictive modeling and database management through hands-on projects and coursework.
Skilled in data analysis, database management, and automated data pipelines with proficiency in Python, SQL, and Power BI. Experienced in developing insightful dashboards and transforming unstructured data into actionable insights. Adept at optimizing data processes and enhancing data integrity.
Issued: August 2024
View Certificate
Issued: May 2023
View Certificate
Issued: June 2023
View Certificate
The Best Seller Book Sales Analysis project involves examining sales data to identify top-selling books based on various criteria such as genre, author, time period, and region. The analysis helps uncover trends in customer preferences, seasonal sales patterns, and factors driving book sales. By leveraging tools like Python for data processing and visualization, the project offers actionable insights for publishers and retailers to optimize inventory, marketing strategies, and sales performance.
The Company's Historical Data Analysis Report is a comprehensive Power BI dashboard that provides valuable insights into sales trends, product performance, customer behavior, and market dynamics. By utilizing SQL for data extraction and Power BI for interactive visualizations, the report enables data-driven decision-making to optimize business strategies, identify growth opportunities, and improve overall sales performance.
Created an interactive HR analytics dashboard to effectively analyze employee attrition and provide actionable insights. This dashboard visualizes critical metrics including attrition rates, salary distributions, job roles, age groups, and satisfaction levels. By leveraging these insights, it supports strategic decision-making for improving employee retention and optimizing workforce management.
The E-Commerce Sales Dashboard provides a comprehensive overview of sales performance, customer behavior, and product profitability. It tracks key metrics like total sales, profit, and quantities sold while offering insights into top-selling categories, customer preferences, and payment modes. With this interactive dashboard, businesses can easily monitor trends, identify high-performing products, and optimize strategies to boost revenue and customer satisfaction.
Developed a Loan Eligibility Checker App that determines an applicant's loan eligibility using Naive Bayes classification. The app evaluates key parameters such as income, credit score, loan amount, and repayment history to predict loan approval likelihood. Built with Python, it applies Naive Bayes for risk assessment, ensuring efficient and accurate predictions. The app features a user-friendly interface for easy input, providing real-time feedback on eligibility status. This tool aids financial institutions in streamlining loan approval processes with data-driven decision-making.
Created a basic Resume Screening App using Python that analyzes resumes for key details like skills and experience, helping to automatically match candidates with job requirements. A simple personal project to practice Python and NLP concepts.
Developed a Python project that generates poetic texts using a Recurrent Neural Network (RNN) trained on the textual works of Shakespeare. The model learns the structure, style, and vocabulary from Shakespeare's poems and plays, enabling it to generate creative, Shakespearean-style poetic lines. This project demonstrates the application of deep learning for natural language generation.
Designed and implemented a simple voice based assistant leveraging Python for scripting and voice recognition. The assistant accepts voice commands and performs various tasks such as opening applications, fetching online information, and providing reminders. Integrated Python libraries like SpeechRecognition and pyttsx3 to enable voice input and output functionalities. The project demonstrates a practical use of automation, showcasing how voice-driven tasks can enhance user convenience.