Data Preparation and Analysis
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Preparation and Analysis
This course is part of multiple programs.
Instructors: Ming-Long Lam
2,778 already enrolled
Included with
Learn more
Ask Coursera
Recommended experience
Recommended experience
What you'll learn
1. Apply appropriate techniques for generating insights from data.
2. Present actionable solutions with confidence to the business stakeholders.
Skills you'll gain
- Data Presentation
- Data Visualization
- Machine Learning
- Data Preprocessing
- Applied Machine Learning
- Machine Learning Methods
- Decision Tree Learning
- Statistical Analysis
- Data Cleansing
- Correlation Analysis
- Probability & Statistics
- Exploratory Data Analysis
- Data Processing
- Model Training
- Analytics
- Data Analysis
- Statistical Methods
- Logistic Regression
- Model Evaluation
- Machine Learning Algorithms
Details to know
32 assignments
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- Learn new concepts from industry experts
- Gain a foundational understanding of a subject or tool
- Develop job-relevant skills with hands-on projects
- Earn a shareable career certificate
There are 9 modules in this course
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. 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. To succeed in this course, learners should possess a basic knowledge of linear algebra and statistics, basic set theory and probability theory, and have basic Python and SQL skills. A few courses that can help equip you with the database knowledge needed for this course are: Introduction to Relational Databases, Relational Database Design, and Relational Database Implementation and Applications.
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.
What's included
10 videos7 readings4 assignments1 discussion prompt1 ungraded lab
10 videosβ’Total 54 minutes
- Course Overviewβ’1 minute
- Instructor Introductionβ’1 minute
- Module 1 Introductionβ’1 minute
- Why Do We Analyze Dataβ’6 minutes
- The Process of Data Analysis - Part 1β’7 minutes
- The Process of Data Analysis - Part 2β’6 minutes
- The First Step of Knowing Your Data - Part 1β’8 minutes
- The First Step of Knowing Your Data - Part 2β’5 minutes
- The First Step of Knowing Your Data - Part 3β’9 minutes
- The First Step of Knowing Your Data - Part 4β’10 minutes
7 readingsβ’Total 290 minutes
- Syllabusβ’10 minutes
- Data Filesβ’60 minutes
- Module 1 Introductionβ’30 minutes
- Big Data and IEEE 754β’60 minutes
- CRISP-DM2β’60 minutes
- Selecting the Bin Size of a Time Histogramβ’60 minutes
- Module 1 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 1 Summative Assessmentβ’180 minutes
- Why Do We Analyze Data Quizβ’15 minutes
- The Process of Data Analysis Quizβ’15 minutes
- Knowing Your Data Quizβ’15 minutes
1 discussion promptβ’Total 60 minutes
- Meet and Greet Discussionβ’60 minutes
1 ungraded labβ’Total 60 minutes
- Module 1 Python Lab - VS Codeβ’60 minutes
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.
What's included
7 videos5 readings4 assignments1 ungraded lab
7 videosβ’Total 54 minutes
- Module 2 Introductionβ’2 minutes
- Discover and Measure Associations - Part 1β’10 minutes
- Discover and Measure Associations - Part 2β’10 minutes
- Measure Associations - Part 1β’8 minutes
- Measure Associations - Part 1 (Continued)β’7 minutes
- Measure Associations - Part 2β’9 minutes
- Measure Associations - Part 2 (Continued)β’9 minutes
5 readingsβ’Total 250 minutes
- Module 2 Introductionβ’60 minutes
- Chicago Taxi Trip Dataβ’60 minutes
- Correlation with Pythonβ’60 minutes
- Eta-squaredβ’60 minutes
- Module 2 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 2 Summative Assessmentβ’180 minutes
- Correlation of Continuous Features Quizβ’15 minutes
- Correlation of Mixed Types Featuresβ’15 minutes
- Means to an End for Feature Screening Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 2 Python Lab - VS Codeβ’60 minutes
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.
What's included
7 videos5 readings3 assignments1 ungraded lab
7 videosβ’Total 46 minutes
- Module 3 Introductionβ’1 minute
- What is in Your Basket - Part 1β’7 minutes
- What is in Your Basket - Part 2β’6 minutes
- How Are Association Rules Discovered - Part 1β’9 minutes
- How Are Association Rules Discovered - Part 2β’8 minutes
- What Can Association Rules Tell Me - Part 1β’8 minutes
- What Can Association Rules Tell Me - Part 2β’6 minutes
5 readingsβ’Total 200 minutes
- PGML Chapter 3β’60 minutes
- Cross-Sellingβ’60 minutes
- Apriori Algorithm and Association Rulesβ’60 minutes
- Module 3 Summaryβ’10 minutes
- Insights from an Industry Leader: Learn More About Our Programβ’10 minutes
3 assignmentsβ’Total 210 minutes
- Module 3 Summative Assessmentβ’180 minutes
- Market Basket Analysis Quizβ’15 minutes
- Association Rules Discovery Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 3 Python Lab - VS Codeβ’60 minutes
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.
What's included
8 videos5 readings4 assignments1 ungraded lab
8 videosβ’Total 70 minutes
- Module 4 Introductionβ’1 minute
- Partition Observations for Training Models - Part 1β’10 minutes
- Partition Observations for Training Models - Part 2β’12 minutes
- Create Segments of Observations for Business Reasons - Part 1β’10 minutes
- Create Segments of Observations for Business Reasons - Part 2β’10 minutes
- Put Observations with Similar Feature Values in Clusters - Part 1β’10 minutes
- Put Observations with Similar Feature Values in Clusters - Part 2β’11 minutes
- Put Observations with Similar Feature Values in Clusters - Part 3β’8 minutes
5 readingsβ’Total 220 minutes
- PGML Chapter 4 β’30 minutes
- Sampling Techniquesβ’60 minutes
- RFMβ’60 minutes
- Clusteringβ’60 minutes
- Module 4 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 4 Summative Assessmentβ’180 minutes
- Partition Observations for Training Models Quizβ’15 minutes
- Segments of Observations Quizβ’15 minutes
- Clustering Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 4 Python Lab - VS Codeβ’60 minutes
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.
What's included
8 videos5 readings4 assignments1 ungraded lab
8 videosβ’Total 53 minutes
- Module 5 Introductionβ’1 minute
- Linear Regression Modelβ - Part 1β’10 minutes
- Linear Regression Modelβ - Part 2β’5 minutes
- Forward Selection - Part 1β’8 minutes
- Forward Selection - Part 2β’4 minutes
- Feature Importance -β Part 1β’9 minutes
- Feature Importance -β Part 2β’8 minutes
- Feature Importance -β Part 3β’7 minutes
5 readingsβ’Total 250 minutes
- Linear Regression Analysis β’60 minutes
- Least Squares Regression β’60 minutes
- Forward and Backward Stepwise Regressionβ’60 minutes
- Shapley Valuesβ’60 minutes
- Module 5 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 5 Summative Assessmentβ’180 minutes
- Linear Regression Model Quizβ’15 minutes
- Feature Selection Quizβ’15 minutes
- Feature Importance Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 5 Python Lab - VS Codeβ’60 minutes
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.
What's included
6 videos5 readings4 assignments1 ungraded lab
6 videosβ’Total 34 minutes
- Module 6 Introductionβ’1 minute
- Logistic Regression -β Part 1β’6 minutes
- Logistic Regression -β Part 2β’7 minutes
- Forward Selectionβ’9 minutes
- Interpret Model and Assess Performance -β Part 1β’8 minutes
- Interpret Model and Assess Performance -β Part 2β’4 minutes
5 readingsβ’Total 220 minutes
- PGML Chapter 6β’30 minutes
- Predictive Analyticsβ’60 minutes
- Forward Selectionβ’60 minutes
- Best R-squared for Logistic Regressionβ’60 minutes
- Module 6 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 6 Summative Assessmentβ’180 minutes
- Logistic Regression Quizβ’15 minutes
- Forward Selection Quizβ’15 minutes
- Blessing and the Curse of Too Many Predictors Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 6 Python Lab - VS Codeβ’60 minutes
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.
What's included
7 videos5 readings4 assignments1 ungraded lab
7 videosβ’Total 37 minutes
- Module 7 Introductionβ’1 minute
- Motivation of Decision Trees -β Part 1β’6 minutes
- Motivation of Decision Trees -β Part 2β’5 minutes
- The CART Algorithm -β Part 1β’3 minutes
- The CART Algorithm -β Part 2β’9 minutes
- Cluster Profiling -β Part 1β’4 minutes
- Cluster Profilingβ - Part 2β’7 minutes
5 readingsβ’Total 220 minutes
- PGML Chapter 5β’30 minutes
- CARTβ’60 minutes
- CART as an Equationβ’60 minutes
- Decision Trees for Clusteringβ’60 minutes
- Module 7 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 7 Summative Assessmentβ’180 minutes
- Motivation of Decision Trees Quizβ’15 minutes
- The CART Algorithm Quizβ’15 minutes
- Cluster Profiling Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 7 Python Lab - VS Codeβ’60 minutes
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.
What's included
8 videos5 readings4 assignments1 ungraded lab
8 videosβ’Total 43 minutes
- Module 8 Introductionβ’1 minute
- Prediction Modelsβ’8 minutes
- Nominal Classification Modelsβ’6 minutes
- Binary Classification Models -β Part 1β’4 minutes
- Binary Classification Models -β Part 2β’6 minutes
- Binary Classification Models -β Part 3β’5 minutes
- Binary Classification Models -β Part 4β’6 minutes
- Binary Classification Models -β Part 5β’7 minutes
5 readingsβ’Total 235 minutes
- PGML Chapter 7, 8 β’45 minutes
- Outliersβ’60 minutes
- ROC Curveβ’60 minutes
- Using Life Analysisβ’60 minutes
- Module 8 Summaryβ’10 minutes
4 assignmentsβ’Total 225 minutes
- Module 8 Summative Assessmentβ’180 minutes
- Metrics for Prediction Models Quizβ’15 minutes
- Metrics for Classification Models Quizβ’15 minutes
- Charts for Classification Models Quizβ’15 minutes
1 ungraded labβ’Total 60 minutes
- Module 8 Python Lab - VS Codeβ’60 minutes
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.
What's included
1 assignment
1 assignmentβ’Total 180 minutes
- Summative Course Assessmentβ’180 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Build toward a degree
This course is part of the following degree program(s) offered by Illinois Tech. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.ΒΉ
Instructors
Offered by
Why people choose Coursera for their career
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. 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.
When you enroll in the course, you get access to all of the courses in the Specialization, 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.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you canβt afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, youβll find a link to apply on the description page.
More questions
Financial aid available,
