What You’ll Learn
- Setting Up the Scenario & Hypothesis. Create the outline for an analysis of ACME Inc’s online advertising campaign (taken from a real AdWords campaign)
- Cleaning Up Raw Data. We’ll walk through some quick data clean-up tips!
- Filtering, Sorting, PivotTables. Play around with the data in Excel to discover the signal in the noise from Google Adwords campaign results.
- Creating Charts. Create some basic charts to show some trends in the data.
- Detecting Trends. Add value to the anlaysis by discovering the trends and story behind the numbers.
- Revisiting Original Hypothesis. Is our original hypothesis supported or rejected? Think about how to shape your findings to the CEO of ACME.
- Formatting. In terms of data visualization, there are a few tips to keep in mind when presenting charts to your audience.
- Presenting Findings. How do you succinctly present all your findings in one slide? Tell the story to help drive actionable business decisions for the CEO of ACME.