1
Define the objectives before opening the template
Write down two to four specific questions the analysis must answer and the decision they will inform. Paste these directly into the Objectives section before adding any data.
π‘ If you cannot state the objective in one sentence, the scope is too broad β split it into two separate reports.
2
Document your data sources and cleaning steps
Record the name, version, date range, and record count of every dataset used. Note any rows removed, fields imputed, or known quality issues before analysis began.
π‘ Save the raw, uncleaned dataset separately so you can always trace a finding back to the original data.
3
Run the analysis and capture outputs
Apply your analytical techniques β descriptive statistics, trend analysis, segmentation, or regression β and export the results into the Key Findings section organized by research question.
π‘ Label every output with the date it was generated and the tool version used, especially if the report will be updated over time.
4
Build visualizations with interpretive captions
Create one chart or table per major finding. Number each figure, add a descriptive title and data source note, and write a one-to-two sentence caption stating what the visual shows.
π‘ Use the same color scheme and axis scale across similar chart types β inconsistency forces readers to re-orient with every chart.
5
Write the analysis and interpretation section
For each key finding, explain why the pattern exists, compare it to a prior period or external benchmark, and state what it implies for the business β not just what the number is.
π‘ For every data point you cite, ask 'so what?' at least twice before writing the interpretation β the second answer is usually more useful than the first.
6
Draft specific, assignable recommendations
For each significant finding, write one recommendation with a named owner (role or team), a target completion date, and a measurable expected outcome.
π‘ Recommendations without owners are wishes. If you don't know who should own an action, resolve that before finalizing the report.
7
Write the executive summary last
Pull the top two or three findings and their corresponding recommendations into a single page. State the purpose of the analysis in one sentence, summarize the findings, and close with the priority action.
π‘ Read the executive summary aloud β if it takes more than 90 seconds, cut it. Busy executives read this section first and often exclusively.
8
Move supporting detail to appendices and add cross-references
Relocate raw tables, full methodology notes, and extended outputs to appendices. Add '(see Appendix A)' callouts in the body so readers can verify the evidence without wading through it inline.
π‘ Ask a colleague who was not involved in the analysis to read only the body β if they ask for something that's buried in an appendix without a callout, add the reference.