Overview
This course provides a practical understanding and framework for basic analytics tasks, including data extraction, cleaning, manipulation, and analysis. It introduces the OSEMN cycle for managing analytics projects and you’ll examine real-world examples of how companies use data insights to improve decision-making.
By the end of this course you will be able to:
• Formulate business goals, KPIs and associated metrics
• Apply a data analysis process using the OSEMN framework
• Identify and define the relevant data to be collected for marketing
• Compare and contrast various data formats and their applications across different scenarios
• Identify data gaps and articulate the strengths and weaknesses of collected data
You don’t need marketing or data analysis experience, but should have basic internet navigation skills and be eager to participate. Ideally you have already completed course 1: Marketing Analytics Foundation in this program.
Syllabus
- Working with Data
- This week, you will learn what data analytics are and what a data analyst does. You’ll be introduced to the OSEMN framework as well as important business metrics, KPIs and their value to a business.
- Obtaining and Scrubbing Data
- In the second week you will learn how to discover different sources of data and how to evaluate their validity. You will also explore different data formats. You’ll begin to apply the OSEMN framework by learning the steps in the data cleaning process as well as how to handle missing or incorrect data in your datasets.
- Exploring and Modeling Data
- This week moves onto the Exploring and Modeling phases of OSEMN. You will learn how to inspect and summarize your data as well as evaluate data relationships. You will discover the purpose of data modeling and common types of data models and data visualizations.
- Interpreting Data
- This week you will learn how to interpret the data you have working with and relate the results of your analysis back to a specific business goal. You will also learn how to create a story for a presentation of your data in order to explain and engage an audience.