Methodology Memo -- Baan Suan Hotels Property Analysis

1. Data Sources

List each data source, its shape (rows and columns), what it contains, and any quality issues discovered during profiling.

2. Join Strategy

Document the join approach: which keys were used, what matching logic was applied, how many records matched and how many did not, and how discrepancies (date formats, naming inconsistencies) were resolved.

3. Analytical Questions

State the specific questions this analysis answers and classify each by type (descriptive, inferential, predictive). Connect each question to Somchai's requirements.

4. Methods

For each analytical question, document the method used and why it was chosen. Note any alternatives considered and why they were not selected.

5. Assumptions Checked

For each statistical test, document which assumptions were checked, the results of those checks, and what action was taken if an assumption was violated.

6. Limitations

State what this analysis cannot support. Note any caveats about the data, the methods, or the scope that affect how confidently the findings should be interpreted.

7. Key Findings

Summarize the results in language Somchai can present to the board. Lead with what the board needs to know, not with how it was calculated.