Detecting Machine Failure from IoT Sensors with a SQL Pipeline

Replacing big industrial machines are expensive. Routine maintenance is so important, it can help prevent critical damage to the machine and extend its useful life. That's why learning to predict when a machine needs maintenance is highly valuable!

Buy $99.00

Course curriculum

1. Kickoff
2. Client Conversation 1: Johnny and the Sensors
1. Client Conversation 2: Our Data is in a Database
2. Overview of Project
3. Installing Sqlite
4. Connect to SQL Database
5. Check what tables are available
6. Check What Fields are Available
7. Get a Few Columns from the DB
8. Get All the Data
9. Convert SQL Result into a DataFrame
1. Split Data into Train and Testing to Prevent Data Snooping Bias
1. Bird's Eye Overview
2. Take a look at Distributions
3. Calculating Pearsons Correlation
4. Is the target balanced?
1. Split Features and Targets
2. Rebalance Data using Imblearn and SMOTE
1. Client Conversation 3: How can you handle so much data?
2. Training a PCA Model
3. Evaluating Components using a Scree Plot
1. Client Conversation 4: Where does PCA come into the ML process?
2. Import Dependencies
3. Create Sklearn Pipelines and Grids
4. Train PCA Factored Models
1. Calculate Classification Metrics
2. Review Confusion Matrix
1. Client Conversation 5: We need the data in the database!
2. Save the PCA Pipeline
3. Reloading the PCA Model and Pipeline
4. Call New Data to be Scored from the Database
5. Make Predictions on Scoring Data
6. Check if Predictions Table Exists, If Not Create It!
7. Push back into Database using an INSERT
8. View Loaded Results
9. Wrap Up

About this course

$99.00
36 lessons
2.5 hours of video content

Discover your potential, starting today

Enroll today

Detecting Machine Failure from IoT Sensors with a SQL Pipeline

Course curriculum

Kickoff

Working with Data from a SQL Database

Split Data into Train and Testing to Prevent Data Snooping Bias

Exploring Sensor Data

Preprocessing for IoT

Reducing Dimensionality with PCA

Modelling with a PCA Pipeline Step

Machine Failure Evaluation

Deployment Back into the Database

About this course

Discover your potential, starting today