Introduction to Data Analytics

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 marketing • 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 • Demonstrate 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.

• How to apply the data analysis process OSEMN to marketing data

• How to use spreadsheets, SQL and basic Python to sort, query, and structure data

• How to use spreadsheets and Tableau to visualize data patterns and trends

Syllabus

Syllabus - What you will learn from this course
Week 1
Working with Data
Week 2
Python for Data Analysis
Week 3
Data Cleaning and Processing
Week 4
Introduction to Data Visualization
Week 5
Structuring Real-World Analytics Projects

FAQ

When will I have access to the lectures and assignments?

Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:

The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.

The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

Reviews

Every concept was very understandable, just with a few videos I have a good understanding of how to use python, SQL, and spreadsheets for marketing analysis. Now it's time to practice more.

My last assignment is under review that's why i don't get certificate

Amazing course, I'm enjoying it so much! Best teachers ever!!

This course has really been helpfull in the area of decision making making with data