Five Year Audit Trend Analysis
Budget: $8 – $15 CAD
I will share a complete archive of audit observations spanning the past five years. Your task is to dig into that data, surface the key trends, and translate the insights into clear, finance-savvy visuals that fit neatly into a PowerPoint deck.
What I need from you
• Clean and structure the raw audit-observation data.
• Perform a trend analysis that highlights material changes, emerging risk areas, and recurring findings year-over-year.
• Create intuitive charts and graphs—bar, line, heat-map, or other formats that best tell the story.
• Assemble the visuals into a concise, well-ordered PowerPoint presentation with brief explanatory notes on each slide so executives can grasp the message at a glance.
Excel (or a similar analysis tool) may be used for data prep and calculations; PowerPoint is mandatory for the final deck. Familiarity with audit terminology and financial controls will help you pinpoint what matters most.
The deliverable is a ready-to-present PPT file plus the underlying workbook with formulas intact.
What I need from you
• Clean and structure the raw audit-observation data.
• Perform a trend analysis that highlights material changes, emerging risk areas, and recurring findings year-over-year.
• Create intuitive charts and graphs—bar, line, heat-map, or other formats that best tell the story.
• Assemble the visuals into a concise, well-ordered PowerPoint presentation with brief explanatory notes on each slide so executives can grasp the message at a glance.
Excel (or a similar analysis tool) may be used for data prep and calculations; PowerPoint is mandatory for the final deck. Familiarity with audit terminology and financial controls will help you pinpoint what matters most.
The deliverable is a ready-to-present PPT file plus the underlying workbook with formulas intact.