Excel/Sheets Expert Needed for Medical KPI Dashboard Development
Summary
Overview:We are seeking an experienced Excel (or Google Sheets) dashboard designer to help us transform medical production data into a visually clean, intuitive, and easily updateable dashboard. The dashboard will be used by physicians and management to track key performance metrics such as new patients, follow-ups, procedures, and revenue, broken down by provider and month.📌 Scope of Work:Design an aesthetically pleasing and interactive Excel or Google Sheets dashboardPull from existing data (provided in structured Excel files) across multiple service types:New patient visitsFollow-up visitsEEGs, EMGs, NCVsInjections, Botox, infusionsHospital encountersEnable filtering and drill-down views by:ProviderMonthProcedure typeCreate a clean summary view with trend graphs, KPIs, and data visualsBuild in a simple monthly update process (e.g., drop new data into a table)🎨 What We're Looking For:Advanced Excel or Google Sheets skills (Power Query, Pivot Tables, Slicers, Charts, Named Ranges, etc.)Strong eye for design and data visualizationExperience working with medical or operational data (bonus)Ability to design for clarity and usability for non-technical users (doctors, office staff)💼 Deliverables:Fully functional and styled dashboard file (Excel preferred)Documentation or video walkthrough on how to update it monthlyOptional: design mockup in Figma or another UI tool before building📂 We Will Provide:Raw production files across several servicesHistorical data sets for at least 12 months