Data Strategy for Short-Term Rental Operations

Paper Instructions 1. Scenario & Goal Describe the project goal: using Excel to track guest data to improve experience, increase repeat bookings, and maximize rental income. List the five stakeholder roles (who inputs what). 2. Data Fields List the requested fields in four groups: personal details, preferences, stay details, post-stay feedback (including survey ratings and guest issues). 3. Data Collection Procedure Explain manual entry into a shared OneDrive Excel file. State who enters pre-stay data and who enters post-stay data. Note backup roles. 4. The Five Knows (Governance) Value – Why the data matters (personalization, pricing, trends, segmentation) Consequences – Risks of ignoring data challenges (lost revenue, bad reviews) Contingency – Five examples of repurposing data (e.g., feedback + room type to improve listings) 5. Access State storage location (OneDrive, five users). List concerns (unauthorized access, data loss, no audit trail). List recommendations (version history, restricted editing, 2FA, backups, training). 6. Security List who is responsible. Identify PII, financial data, and high-risk items (credit card info, guest comments). Name external threats (hackers, competitors, marketers). List protection steps (no full credit cards, masking, 2FA, auditing, training). 7. Protection State current measures (encryption, restricted access). Note legally required fields and 3-year retention rule. Describe archiving and secure deletion. Mention data quality (Excel validation) and error responsibility (audits). 8. Risk List key risks (unauthorized access, data loss, inaccurate entry, non-compliance, legal action). State how to identify risks (missing records, complaints, version conflicts, unauthorized logins). Note factors endangering goals (loss of trust, miscommunication, non-compliance, bad reviews). 9. Recommendations List five steps: secure access, prevent data loss, standardize entry, comply with retention laws, securely delete after retention period.