Meta Data Analyst

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.

This course takes a deep dive into the statistical foundation upon which marketing analytics is built. The first part of this course will help you to thoroughly understand your dataset and what the data actually means. Then, it will go into sampling including how to ask specific questions about your data and how to conduct analysis to answer those questions. Many of the mistakes made by Marketing Analysts today are due to a lack of understanding the concepts behind the tests they run, leading to incorrect tests or misinterpreting the results. This course is tailored to provide you with the necessary background knowledge to comprehend the "what" and "why" of your actions in a practical sense. By the end of this course you will be able to: • Understand the concept of dependent and independent variables • Identify variables to test • Understand the Null Hypothesis, P-Values, and their role in testing hypotheses • Formulate a hypothesis and align it to business goals • Identify actions based on hypothesis validation/invalidation • Explain Descriptive Statistics (mean, median, standard deviation, distribution) and their use cases • Understand basic concepts from Inferential Statistics • Explain the different levels of analytics (descriptive, predictive, prescriptive) in the context of marketing • Create basic statistical models for regression using data • Create time-series forecasts using historical data and basic statistical models • Understand the basic assumptions, use cases, and limitations of Linear Regression • Fit a linear regression model to a dataset and interpret the output using Tableau and statsmodels • Explain the difference between linear and multivariate regression • Run a segmentation (cluster) analysis • Describe the difference between observational methods and experiments This course is designed for people who want to learn the basics of descriptive and inferential statistics and analytics in marketing.

This course introduces you to how to use spreadsheets and SQL queries to analyze and extract data. You will learn how to practically apply the OSEMN data analysis framework and spreadsheet functions to clean data, calculate summary statistics, evaluate correlations, and more. You’ll also dive into common data visualization techniques and learn how to use dashboards to tell a story with your data. By the end of this course you will be able to: • Clean data with spreadsheets • Use common spreadsheet formulas to calculate summary statistics • Identify data trends and patterns • Write foundational SQL statements and queries to extract data in spreadsheets • Create charts in Google Sheets and use Tableau to visualize data • Use dashboards to create data visualizations 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 and course 2: Introduction to Data Analytics in this program.

This course introduces the use of the Python programming language to manipulate datasets as an alternative to spreadsheets. You will follow the OSEMN framework of data analysis to pull, clean, manipulate, and interpret data all while learning foundational programming principles and basic Python functions. You will be introduced to the Python library, Pandas, and how you can use it to obtain, scrub, explore, and visualize data. By the end of this course you will be able to: • Use Python to construct loops and basic data structures • Sort, query, and structure data in Pandas, the Python library • Create data visualizations with Python libraries • Model and interpret data using Python This course is designed for people who want to learn the basics of using Python to sort and structure data for data analysis. You don't need marketing or data analysis experience, but should have basic internet navigation skills and be eager to participate.