Javith L

Microsoft Certified Power BI Data Analyst (PL-300) with 4+ years of experience in data analysis, MIS reporting, and business intelligence. Skilled in Power BI, DAX, Power Query, and data modeling (Star Schema) to build interactive dashboards and reports. Experienced in Excel VBA automation to improve reporting efficiency and support business decision-making.

Healthcare Operations Dashboard – Power BI

• Developed an interactive Power BI dashboard to monitor hospital operations including patient admissions, discharge rates, and department-wise performance  
• Created DAX measures to calculate KPIs such as average length of stay, bed occupancy rate, and patient turnaround time  
• Used Power Query to clean and transform raw healthcare data from multiple sources  
• Designed data model with relationships to analyze patient flow across departments  
• Implemented slicers for dynamic filtering by department, doctor, and time period.

Patient & Inventory Management Dashboard – Power BI

• Built a Power BI dashboard to track medical inventory, medicine usage, and stock availability  
• Used Power Query to transform and standardize data from inventory systems  
• Created DAX measures to identify fast-moving and slow-moving medicines  
• Developed alerts for low stock levels to prevent shortages  
• Provided insights to optimize inventory planning and reduce wastage