DIMPLE SHARMA

P

Papollo Healthcare Hospital Dashboard

Mar 2025

Excited to share my latest project: Papollo Hospitals Leads Flow Dashboard, built using PostgreSQL & Power BI to analyze hospital performance, patient trends, and financial insights! 🏥🔍 🚀 Future Scope: Implementing predictive modeling to optimize bed occupancy and improve patient care!

S

SQL PORTFOLIO PROJECT

Feb 2025

I’m excited to share my latest SQL Portfolio Project, where I worked extensively with real-world databases to extract meaningful insights. This project helped me strengthen my SQL skills and enhance my data analysis capabilities. Through this project, I explored SQL fundamentals like DDL, DML, DCL, and TCL commands, advanced filtering techniques, and real-time database management strategies. The hands-on experience has deepened my understanding of database operations and best practices, preparing me for real-world data analytics and database management tasks.

B

British Airways Reviews Dashboard

Feb 2025

This project has been a great learning experience in data visualization, dashboard design, and customer sentiment analysis. Understanding airline reviews through data helps in identifying key areas of improvement and enhancing the overall passenger experience.

Q

QUERY & VISUALIZE WITH POSTGRE-SQL

Feb 2025

🚀 Exploring Data Analysis with PostgreSQL! 🚀 Excited to share my latest project where I explored query execution and data visualization using PostgreSQL! 🔍📊 💡 What I Did? ✅ Created a database and structured tables for employee records ✅ Executed queries for data retrieval, updates, deletions, and modifications ✅ Applied SQL commands like SELECT, UPDATE, DELETE, ALTER, and more ✅ Visualized data using PgAdmin4 SQL Toolbar (Bar Charts, Pie Charts, Line Charts) 📊 Key Learnings: 🔹 How to efficiently manage and manipulate relational databases 🔹 The power of SQL in deriving meaningful insights from structured data 🔹 Visualizing data directly within PostgreSQL to identify trends and patterns This project enhanced my SQL querying skill

D

Data Analysis using MYSQL Server

Mar 2024

Introducing my new Project based on Data Analysis through MYSQL Server. Through this project I analyzed key indicators for our pizza sales data to gain our insights into our business performance. Specially, I calculated the following metrices: 💧 Total Revenue 💧 Average Order Value 💧 Total Pizzas sold 💧 Total Orders 💧 Average Pizzas Per Order 💧 Daily Trend for Total Orders 💧 Monthly Trend for Total Orders 💧 % of Sales by Pizza Category 💧 % of Sales by Pizza Size 💧 Total Pizzas Sold by Pizza category 💧 Top 5 pizzas by Revenue 💧 Bottom 5 pizzas by Revenue I also visualized pizza sales data to gain insights & understand key trends such as daily trend, monthly trend, yearly trend with the help of bar graphs and charts and DAX Expre

M

MYSQL Connected with Power BI

Dec 2023

MYSQL project connected with Power BI and the data analysis using MYSQL and data visualization using Power BI.

I

Impact of Car Features

Aug 2023

Project Description: This project aims to analyze a dataset titled "Car Features and MSRP" to gain insights into various aspects of the automotive industry. The purpose is to explore trends in car features and pricing, understand the relationship between car attributes and their popularity, identify the key factors influencing car prices, and examine how different manufacturers and market categories impact car prices. The dataset, containing information on over 11,000 car models, was collected and made available by Cooper Union on Kaggle. The data cleaning process involved identifying and addressing missing values, inconsistencies, and errors to ensure accurate analysis.

H

HR Analytics Dashboard using Power BI

Jul 2023

Power BI Project "HR ANALYTICS DASHBOARD". OBJECTIVE: Help an organization to improve employee performance and improve employee retention (reduce attrition) by creating a HR Analytics Dashboard. STEPS FOLLOWED:- ♦Data Extraction: The data is extracted and converted it into an excel file. ♦Data Transformation & Cleaning: The data is transformed into Power BI and cleaned the data using Power Query Editor. For data cleaning I remove null values, duplicates, replace some words, and add columns. ♦Data Loading: After proper cleaning the data is load into Power BI. ♦Data Visualization: After loading of the data perform certain visuals using different charts, graphs, slicer and makes a dashboard. ♦Data Analysis: After creating dashboard we pe

B

Bank Loan Case Study

Jul 2023

Imagine you're a data analyst at a finance company that specializes in lending various types of loans to urban customers. Your company faces a challenge: some customers who don't have a sufficient credit history take advantage of this and default on their loans. Your task is to use Exploratory Data Analysis (EDA) to analyze patterns in the data and ensure that capable applicants are not rejected. The main aim of this project is to identify patterns that indicate if a customer will have difficulty paying their installments. This information can be used to make decisions such as denying the loan, reducing the amount of loan, or lending at a higher interest rate to risky applicants. The company wants to understand the key factors behind loan

I

Iris Flower Prediction

Jul 2023

This Project is completed through application of machine learning with python programming. It focuses on IRIS flower classification using Machine Learning with scikit tools. Here some of algorithm are used that are some types of machine learning subparts algorithms of supervised and Unsupervised learning. Algorithm used for predicting and getting accuracy are - (1) Decision tree classifier (20 K nearest classifier (3) SVM (4) Logistic Regression (5) Metrics (6) train_test_split We are making accuracy and prediction in Iris project through Iris Dataset. This is easy and understandable for machine learning staters( Naive ).

M

Movie Rating Prediction

Jul 2023

Build a model that predicts the rating of a movie based on features like genre, director, and actors. Use regression techniques, detecting data types, null values, duplicates, creation of new data frames, etc. to tackle this problem. The goal is to analyze historical movie data and develop a model that accurately estimates the rating given to a movie by users or critics. Movie Rating Prediction project enables me to explore data analysis, preprocessing, feature engineering, and machine learning modeling techniques. It provides insights into the factors that influence movie ratings and allows you to build a model that can estimate the ratings of movies accurately.

S

Sales Prediction Using Python

Jul 2023

Throughout the project leveraged Python's powerful data manipulation and visualization libraries to analyze historical sales data, identify trends, and build accurate forecasting models. Implemented state-of-the-art machine learning techniques, such as regression (linear regression, decision tree regression, random forest regression). Continually learning and pushing the boundaries of data science to deliver actionable insights and drive business growth.

H

HR Analytics Dashboard

Jun 2023

Created HR Analytics Dashboard using a report with the flat file i.e. excel file using Tableau. Having a tableau environment we can easily transform and clean our data then load it to the tableau environment for further analysis and build the dashboard.

S

Sales Dahboard

Jun 2023

Build an Awesome Excel Sales Dahboard. TOPICS COVERED📝: • Understanding the business problem • Data Cleaning & Preparation • Inserting Pivot Tables & Charts • Creating Dashboard • Useful Insights

E

Exploratory Data Analysis

Jun 2023

Objective: (1) Improve customer experience by analysing sales data. (2) Increase revenue

I

IMDB Movie Analysis

Jun 2023

We are providing you with a dataset having various columns of different IMDB Movies. You are required to Frame the problem. For this task, you will need to define a problem you want to shed some light on. Cleaning the data: This is one of the most important steps to perform before moving forward with the analysis. Use your knowledge learned till now to do this. (Dropping columns, removing null values, etc.) Once you have defined a problem, clean the data as necessary, and use your Data Analysis skills to explore the data set and derive insights. Once you have framed the problem and gathered initial insights from the data, you can ask the following questions as you dig deeper into your analysis. What do you see happening? What are the

H

Hiring Process Analytics Project-4

May 2023

Given a dataset of company with details about people who registered for a particular post in a deptt or a company. I was required to use my knowledge in statistics and use different formulas in excel and draw necessary conclusions about the company.

I

Instagram User Analytics Project-2

May 2023

The project is about User Analysis [the process by which we track how users engage and interact with our digital product (software or mobile application) in an attempt to derive business insights for marketing, product & development teams]. I handled the things with patience and excellent understanding about SQL. I am working with the product team of Instagram and the Instagram manager has asked me to provide insights on the questions asked by the management team.

S

Sales Forecasting Dashboard

May 2023

Objective- To contribute to the success of a business by utilizing Data Analysis techniques, specially focusing on time series analysis, to provide valuable insights and accurate sales forecasting.

O

Operation & Metric Analytics Project-3

May 2023

Operation Analytics is the analysis done for the complete end to end operations of a company. With the help of this, the company then finds the areas on which it must improve upon. Investigating metric spikes is also an important part of operation analytics as being a Data Analyst we must be able to understand or make other teams understand questions like- Why is there a dip in daily engagement? Why have sales taken a dip? Etc. Questions like these must be answered daily and for that it’s very important to investigate metric spikes.

DIMPLE SHARMA

About

Detail

Contact DIMPLE regarding:

Timeline

Résumé

Languages:

DIMPLE's behavioral traits
DIMPLE's likely patterns of behavior, thought, values, and emotion. Based on the HEXACO model, OCP instrument, and Torre’s own research.