Excel Comparative Analysis: Patient Conditions
Budget: ₹600 – ₹1,500 INR
I have a raw spreadsheet of anonymised patient records and need a clear, insight-driven comparison of the different medical conditions represented in the file. Using Microsoft Excel (PivotTables, Power Query or formulas—whichever you prefer), please reorganise the data so it is tidy and normalised, then produce side-by-side summaries that highlight how each condition differs on the key variables already present in the sheet (admission counts, length of stay, readmission flags, cost, or any other fields you spot that strengthen the story).
When you hand the work back I’d like three concrete items:
• a cleaned, de-duplicated workbook with well-named tabs;
• a comparative dashboard or report tab that presents the findings with charts and concise commentary;
• a short note (can be on a separate sheet) explaining the steps you took so I can refresh the analysis when new records arrive.
Accuracy and clarity take priority—formulas should be traceable and any assumptions called out inside the workbook itself.
When you hand the work back I’d like three concrete items:
• a cleaned, de-duplicated workbook with well-named tabs;
• a comparative dashboard or report tab that presents the findings with charts and concise commentary;
• a short note (can be on a separate sheet) explaining the steps you took so I can refresh the analysis when new records arrive.
Accuracy and clarity take priority—formulas should be traceable and any assumptions called out inside the workbook itself.