This course equips you with a practical understanding and a framework to guide the execution of basic analytics tasks such as pulling, cleaning, manipulating and analyzing data by introducing you to the OSEMN cycle for analytics projects. You’ll learn to perform data analytics tasks using spreadsheet and SQL queries. You will also be introduced to using the Python programming language to manipulate datasets as an alternative to spreadsheets. You will learn foundational programming concepts and how they apply to marketing. You will also learn how to use Tableau to create data visualizations and dashboards. By the end of this course, you will be able to: • State business goals, KPIs and associated metrics • Apply a Data Analysis Process: OSEMN • Identify and define the relevant data to be collected for different marketing related questions • Compare and contrast the different formats and use cases of different kinds of data • Identify gaps in data collected and describe the strengths and weaknesses in the available data • Demonstrate basic proficiency in Python with variables, control flow, loops, and basic data structures • Sort, query and structure data in spreadsheets and with Python libraries • Write basic SQL statements to select, group and filter data • Visualize data patterns and trends with spreadsheets • Utilize Tableau to visualize data patterns and trends This course is designed for people who want to learn the basics of data analytics including using spreadsheets and Python to sort and structure data and using Tableau to visualize data patterns. Learners don't need marketing or data analysis experience, but should have basic internet navigation skills and be eager to participate. Learners also need access to a computer with strong internet connection. Ideally learners have already completed course 1 (Marketing Analytics Foundation) in this program.