Data Preparation and Analysis (Coursera)

Offered by Illinois Tech,
Data Preparation and Analysis (Coursera)

This course introduces the necessary concepts and common techniques for analyzing data. The primary emphasis is on the process of data analysis, including data preparation, descriptive analytics, model training, and result interpretation.

Class Deals by MOOC List - Click here and see Coursera's Active Discounts, Deals, and Promo Codes.

The process starts with removing distractions and anomalies, followed by discovering insights, formulating propositions, validating evidence, and finally building professional-grade solutions. Following the process properly, regularly, and transparently brings credibility and increases the impact of the results.
This course will cover topics including Exploratory Data Analysis, Feature Screening, Segmentation, Association Rules, Nearest Neighbors, Clustering, Decision Tree, Linear Regression, Logistic Regression, and Performance Evaluation. Besides, this course will review statistical theory, matrix algebra, and computational techniques as necessary.
This course prepares students ready for and capable of the data preparation and analysis process. Besides developing Python codes for carrying out the process, students will learn to tune the software tools for the most efficient implementation and optimal performance. At the end of this course, students will have built their inventory of data analysis codes and their confidence in advocating their propositions to the business stakeholders.
Required Textbook: This course does not mandate any textbooks because the lecture notes are self-contained.
Optional Materials: A Practitioner's Guide to Machine Learning (abbreviated PGML for Reading)
Software Requirements: Python version 3.11 or above with the latest compatible versions of NumPy, SciPy, Pandas, Scikit-learn, and Statsmodels libraries.

What you'll learn

  1. Apply appropriate techniques for generating insights from data.
  2. Present actionable solutions with confidence to the business stakeholders.

Syllabus

Module 1: Process of Preparing and Analyzing Data
Welcome to Data Preparation and Analysis! Module 1 guides students through the art of crafting informative and visually appealing histograms, a fundamental aspect of data visualization. Students will learn techniques for measuring the location and scale of data, understanding the origins and impacts of noise and missing values in datasets. This module also introduces the CRISP-DM Process, a structured approach to data mining, along with Gartner's Analytics Ascendancy Model for advanced data analysis. Additionally, students will explore the distinction between raw data and processed information, a key concept for effective data interpretation and decision-making.

Module 2: Measure and Visualize Correlation
Module 2 delves into the intricacies of statistical analysis, beginning with a thorough understanding of the p-value concept and its significance as a Type I Error indicator. Students will learn to apply statistical tests in Python to identify significantly correlated features, exploring various correlation metrics tailored for categorical, mixed-type, and continuous features. This module emphasizes practical application, equipping students with the skills to calculate and interpret these metrics using Python, thereby enhancing their ability to conduct sophisticated data analysis and draw meaningful conclusions from complex datasets.

Module 3: Market Basket Analysis
Module 3 offers a deep dive into the world of Association Rules, teaching students how to improvise these rules for identifying valuable feature combinations that generate specific label values. Learners will master setting appropriate thresholds for Support and Confidence and gain a comprehensive understanding of the Apriori Algorithm and the significance of Frequent Itemsets within it. This module covers the calculation of common metrics for Association Rules, familiarizing students with the relevant terminology. Additionally, learners will explore the practical application of Association Rules in Market Basket Analysis, including strategies for cross-selling, up-selling, and product bundling, equipping them with valuable skills for advanced data-driven decision making in business contexts.

Module 4: Partitioning, Segmenting, and Clustering of Observations
In Module 4, students will learn how to describe and interpret profiles of clusters, gaining proficiency in deploying the K-Means and K-Modes clustering algorithms. They will explore the application of Recency, Frequency, and Monetary (RFM) Analysis to identify the most valuable customers in retail business settings. The module also covers the technique of Simple Random Sampling with the option of incorporating stratification variables, enhancing the precision of data analysis. Furthermore, it emphasizes the importance of objectively validating models using a testing partition, ensuring the reliability and effectiveness of the analytical models in real-world scenarios.

Module 5: Linear Regression
This module delves into feature importance analysis in machine learning, covering Shapley Values, feature selection methods, statistical evaluation, feature interaction, aliasing, and the Least Squares Algorithm. Students will be able to master these concepts to build robust and interpretable models. included

Module 6: Binary Logistic Regression
In Module 6, students will master the art of feature selection in machine learning by exploring the Forward and Backward Selection Method, the All-Possible Subsets Method, and the concept of complete and quasi-complete separation. Students will also discover association rules for identifying separations, interpret model parameters and predicted probabilities, and delve into the concepts of maximum likelihood estimation, odds, and odds ratios.

Module 7: Decision Trees - The CART Algorithm
Module 7 will equip students wth the ability to harness the power of tree-based models to uncover hidden patterns in your data. Students will be able to describe clusters effectively, intelligently set algorithm parameters, construct business rules from tree results, and utilize variance metrics, entropy values, and Gini indices for optimal tree construction.

Module 8: Evaluating the Performance of Models
Module 8 delves into the realm of evaluation metrics for machine learning models. Students will master the concepts of precision and recall curves, lift curves, and receiver operating characteristics (ROC) curves. Additionally, students will obtain the ability to discover methods for calculating probability thresholds using Kolmogorov-Smirnov statistics and F1 scores. They will be able to explore metrics like misclassification rate, area under the curve (AUC), and root mean squared error (RMSE), along with techniques for computing RMSE and detecting severely misfitted observations using model-specific residuals.

Summative Course Assessment
This module contains the summative course assessment that has been designed to evaluate your understanding of the course material and assess your ability to apply the knowledge you have acquired throughout the course. Be sure to review the course material thoroughly before taking the assessment.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera) Coursera
Columbia University

HI-FIVE: Health Informatics For Innovation, Value & Enrichment (Administrative/IT Perspective) (Coursera)

HI-FIVE (Health Informatics For Innovation, Value & Enrichment) Training is an approximately 10-hour online course designed by Columbia University in 2016, with sponsorship from the Office of the National Coordinator for Health Information Technology (ONC). The training is role-based and uses case scenarios. No additional hardware or software are required for this course. Our nation’s healthcare system is changing at a rapid pace.

Sep 28th 2026
4 Weeks
Global Statistics - Composite Indices for International Comparisons (Coursera) Coursera
University of Geneva

Global Statistics - Composite Indices for International Comparisons (Coursera)

In this course on global statistics, offered by the University of Geneva jointly with the ETH Zürich KOF, you will learn the general approach of constructing composite indices and some of resulting problems. We will discuss the technical properties, the internal structure (like aggregation, weighting, stability of time series), the primary data used and the variable selection methods. These concepts will be illustrated using a sample of the most popular composite indices. We will try to address not only statistical questions but also focus on the distinction between policy-, media- and paradigm-driven indicators.

Sep 28th 2026
5-12 Weeks
Empathy, Data, and Risk (Coursera) Coursera
University of Illinois at Urbana-Champaign

Empathy, Data, and Risk (Coursera)

Risk Management and Innovation develops your ability to conduct empathy-driven and data-driven analysis in the domain of risk management. This course introduces empathy as a professional competency. It explains the psychological processes that inhibit empathy-building and the processes that determine how organizational stakeholders respond to risk.

Sep 28th 2026
4 Weeks
Functional Programming in Scala Capstone (Coursera) Coursera
École Polytechnique Fédérale de Lausanne

Functional Programming in Scala Capstone (Coursera)

In the final capstone project you will apply the skills you learned by building a large data-intensive application using real-world data. You will implement a complete application processing several gigabytes of data. This application will show interactive visualizations of the evolution of temperatures over time all over the world.

Oct 5th 2026
5-12 Weeks
Gender Foundations in Health Data: A Data for Health Course (Coursera) Coursera
Johns Hopkins University

Gender Foundations in Health Data: A Data for Health Course (Coursera)

Welcome to Gender Foundations in Health Data: A Data for Health course. This course was developed from an online seminar series of the same name, that was hosted by Johns Hopkins University Bloomberg School of Health in 2021-22. The course instructors are Drs. Michelle Kaufman and Tahilin Sanchez Karver. This course will raise learners' awareness of the necessity of utilizing a gender lens in global public health data, policy, and practice, feature how-tos and key examples of integration of gender in data collection, analysis, and use from Data for Health partners.

Sep 28th 2026
1 Week
Introducción a la Minería de Datos (Coursera) Coursera
Pontificia Universidad Católica de Chile

Introducción a la Minería de Datos (Coursera)

En este curso, aprenderás de manera gradual y práctica los conceptos básicos de Minería de Datos, junto a los algoritmos más utilizados hoy en día. Al finalizar el curso, serás capaz de entender la importancia de manejar la información y de explorar por ti mismo distintas bases de datos reales. Este curso es el primer paso para convertirte en un/a profesional con habilidades básicas de un científico de datos o Data Scientist, de manera tal que puedas abrirle la puerta al futuro.

Oct 5th 2026
5-12 Weeks
Data intelligence for businesses and managers (Coursera) Coursera
Institut Mines-Telecom

Data intelligence for businesses and managers (Coursera)

With the proliferation of connected objects (computers, tablets, watches, etc.), huge masses of data are generated every second. This Big Data has led to the emergence of a data economy, where data is the main source of competitive advantage for companies. In this sense, data and its processing tools have become a strategic priority for companies, and the main gas pedal of their digital transformation.

Oct 5th 2026
5-12 Weeks
Business Intelligence and Competitive Analysis (Coursera) Coursera
Rutgers University

Business Intelligence and Competitive Analysis (Coursera)

By the end of 2019, it is clear that American Airlines (AAL), the world’s largest airline group, is in trouble. With the growth rate of its stock price ranked at the bottom of all major US airlines and going in the opposite direction from the SP500 index, AAL needs to find out what is going on, and how to turn the company and its stock price around.

Sep 28th 2026
4 Weeks
Construção de Relacionamentos em Vendas Orientada a Dados (Coursera) Coursera
FIA Business School

Construção de Relacionamentos em Vendas Orientada a Dados (Coursera)

Nossas boas-vindas ao Curso Construção de Relacionamento em Vendas Orientada a Dados. Neste curso, você aprenderá métodos sobre data analytics para o ambiente dos profissionais de vendas. Ao final deste curso, você será capaz de avaliar relacionamentos entre o desempenho de vendas e os gastos relacionados; agrupar por semelhança itens, produtos ou serviços e, por fim, realizar recomendações de produtos para clientes sob características preestabelecidas.

Sep 28th 2026
4 Weeks
Introduction to Accounting Data Analytics and Visualization (Coursera) Coursera
University of Illinois at Urbana-Champaign

Introduction to Accounting Data Analytics and Visualization (Coursera)

Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions. The skillset that accountants have needed to perform math and to keep order has evolved from pencil and paper, to typewriters and calculators, then to spreadsheets and accounting software. A new skillset that is becoming more important for nearly every aspect of business is that of big data analytics: analyzing large amounts of data to find actionable insights. This course is designed to help accounting students develop an analytical mindset and prepare them to use data analytic programming languages like Python and R.

Oct 5th 2026
5-12 Weeks
Analyzing and Visualizing Data in Looker (Coursera) Coursera
Google Cloud

Analyzing and Visualizing Data in Looker (Coursera)

In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.

Sep 28th 2026
2 Weeks