Powered by
Codebasics DA Bootcamp

Yogita Salokhe

Data Aspirant

[email protected]

Hello, I am

Yogita Salokhe.

1

Excel
Project

About Me

Hi! I’m Yogita Salokhe, an aspiring data analyst who loves uncovering meaningful insights hidden in data.
I enjoy transforming raw datasets into clear, actionable insights that help businesses make smarter and faster decisions.

Whether I’m exploring complex datasets or building interactive dashboards, I’m passionate about solving real-world problems using data. I’ve worked on projects across healthcare, hospitality, and retail, where I analyzed trends, identified key business issues, and created data-driven solutions.

I’m also a continuous learner, constantly improving my skills in Power BI, SQL, Excel, and Python through certifications and hands-on projects. My goal is to not just analyze data, but to turn it into insights that drive better strategies and real impact.

If you're looking for someone who can transform data into meaningful business insights, let’s connect!

Key Skills

Power BI

SQL

Python

VBA

Microsoft Excel

Data Analysis

Azure

AWS

Microsoft Fabric

My Projects

Hospital Emergency Room Analysis

Hospital Emergency Room Analysis

Domain/Function: Healthcare

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Python: Beginner to Advanced For Data Professionals

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

LinkedIn

https://www.linkedin.com/in/yogita-salokhe-dataanalyst

GitHub

https://github.com/YogitaSalokhe

Excel Project

Hospital Emergency Room Analysis

Domain/Function: Healthcare

Analyzed emergency room data to monitor patient flow, wait times, and satisfaction metrics, enabling insights into operational efficiency and resource allocation. Built interactive dashboards to identify peak hours, demographic trends, and performance gaps, supporting data-driven decision-making.

View Project
on GitHUB

View Project
on NA

Hospital Emergency Room Analysis

The dashboard provides key insights that help hospital management improve patient experience and optimize emergency department operations.

Hospital Emergency Room Analysis

The dashboard provides key insights that help hospital management improve patient experience and optimize emergency department operations.

Project Details

Project Overview
This project analyzes Hospital Emergency Room data to help stakeholders monitor patient flow, waiting time, and hospital service efficiency.
The dashboard provides key insights that help hospital management improve patient experience and optimize emergency department operations.

Objectives:
1. Monitor number of patients visiting the emergency room
2. Track average waiting time
3. Analyze patient satisfaction score
4. Understand admission vs non-admission rates
5. Identify patient demographics
6. Track department referrals

Tools Used:
Excel
Power Query

Dashboard Features:
Interactive year filter
Monthly patient tracking
Age group analysis
Gender distribution
Department referral analysis
Admission status analysis

Business Impact
This dashboard helps hospital administrators:
1. Reduce patient waiting time
2. Monitor emergency room performance
3. Improve resource allocation
4. Increase patient satisfaction