💼 My Role

Data Analyst / Business Analyst

Responsibilities

• Data cleaning and transformation
• Data modeling
• DAX calculations
• Dashboard development
• KPI analysis
• Business insight generation
• Performance reporting

📌 Project Overview

Designed an interactive Power BI dashboard for City Hospital to analyze financial and operational performance using healthcare transaction data.

The dashboard provides leadership with a centralized view of hospital revenue, expenses, profit margins, patient activity, and doctor performance to support strategic decision-making.

🎯 Business Problem

City Hospital lacked a centralized reporting system for monitoring financial performance and operational efficiency.

This made it difficult to:

• Identify financial trends
• Optimize resource allocation
• Track doctor and patient activity
• Make data-driven operational decisions