Ankit Gupta

Ankit Gupta

Data Analyst
India
English, Hindi

About Me

Motivated and detail-oriented B.Tech (Computer Science & Engineering) graduate with a strong foundation in Data Analytics, Statistics, and Business Intelligence. Proficient in Microsoft Excel, SQL, Python, and Power BI, …

PROJECTS

Hospital emargency room

Duration : 03-Jul-2026 - 10-Jul-2026

<p>Hospital Emergency Room Dashboard (Power BI)</p><p></p><p>Developed an interactive Power BI dashboard to analyze hospital emergency room data and monitor key performance indicators (KPIs). The dashboard provides insights into patient visits, waiting time, admission status, age group, gender, department referrals, and patient satisfaction. Performed data cleaning and transformation using Power Query, created DAX measures for KPI calculations, and designed interactive visualizations with slicers and filters. This dashboard helps hospital management identify trends, optimize resource allocation, reduce patient waiting time, and improve overall emergency room operations.</p><p></p><p>Tools & Technologies: Power BI, Power Query, DAX, Excel</p>

Certifications

Code alpha ,microsoft excel, power BI, MySQL, python

madhu vachaspati institute of engineering and technology · Ballia , Uttar Pradesh , India · 2026

Skills

Python MySQL Microsoft Excel Power BI Pandas Matplotlib Seaborn MongoDB GitHub Visual Studio Code ChatGPT Claude Gemini Microsoft Copilot Data Cleaning Data Transformation Exploratory Data Analysis EDA Dashboard Development Reporting Analytical Thinking Problem Solving Communication Teamwork Time Management Attention to Detail
Report this Profile?