Patient Demographics Excel Analysis
Budget: ₹600 – ₹1,500 INR
I have a dataset of patient records and need a focused Excel-based analysis that tells a clear story about who our patients are. The scope is limited to demographics: specifically age, gender, and geographical location.
What I expect from you is a clean, well-structured workbook that:
• Organises the raw data so every record is error-free and consistently formatted.
• Summarises age distribution, gender split, and location breakdown through pivot tables and descriptive statistics.
• Presents the key findings in easy-to-read charts or dashboards directly inside Excel, so any stakeholder can understand our patient mix at a glance.
If you typically rely on Power Query, PivotCharts, or simple VBA snippets to streamline repetitive steps, feel free to use them—just keep everything embedded in the final .xlsx file so it runs without add-ins.
I will provide the raw patient records once we start; please return the completed workbook and a short commentary sheet highlighting any notable trends you uncover.
What I expect from you is a clean, well-structured workbook that:
• Organises the raw data so every record is error-free and consistently formatted.
• Summarises age distribution, gender split, and location breakdown through pivot tables and descriptive statistics.
• Presents the key findings in easy-to-read charts or dashboards directly inside Excel, so any stakeholder can understand our patient mix at a glance.
If you typically rely on Power Query, PivotCharts, or simple VBA snippets to streamline repetitive steps, feel free to use them—just keep everything embedded in the final .xlsx file so it runs without add-ins.
I will provide the raw patient records once we start; please return the completed workbook and a short commentary sheet highlighting any notable trends you uncover.