The following is a summary of the blog posts grouped by topics.
Build Predictive Models
- How to build predictive models that win competitions.
- Build Predictive Models Using PL/SQL
- Oracle On The Fly Model- Clustering
- Build Best Direct Marketing Predictive Models
- Zip Code and Predictive Models
- More On Zip Code and Predictive Models - Variable of High Cardinality
Predictive Models vs Business Rules
- Predictive Modeling vs Intuitive Business Rules
- Comparison of Business Rules and Predictive Models
- A Real World Case Study: Business Rule vs Predictive Model
Predictive Model Variables
- Find the Most Important Variables In Predictive Models
- How to build predictive models that win competitions. (continued)
- Abraham Lincoln and Predictive Modeling Project
- Build Best Direct Marketing Predictive Models
- Recency, Frequency, Monetary (RFM) Analysis: Part 1
- Recency, Frequency, Monetary (RFM) Analysis: Part 2
- Recency, Frequency, Monetary (RFM) Analysis: Part 3
- Recency, Frequency, Monetary (RFM) Analysis: Part 4
- Recency, Frequency, Monetary (RFM) Analysis: Part 5. RFM Code
Import Text File Into Oracle
- Five Ways of Loading Text Files Into Oracle Database
- A Quick Way to Import Spreadsheet Into a Relational Database
- "Fix" a Text File that Is in Unix Format
- Add Line Number to Text File
- How to Change Delimiters of Text File
- Analyze Text Files in Real Time Using SQL Without Loading Them into Database
- Why Sometime It Is Not a Good Idea to Export Database Tables as Text Files?
- Calculate Histogram for a Text File
- How to Query a Text File In Oracle
- More On Oracle External Table
Unique Identifiers in Oracle
- Five Ways of Creating Unique Record Identifier For Oracle Tables
- How to Generate Globally Unique Identifier on the Fly
Recency Frequency Monetary
- Recency, Frequency, Monetary (RFM) Analysis: Part 1
- Recency, Frequency, Monetary (RFM) Analysis: Part 2
- Recency, Frequency, Monetary (RFM) Analysis: Part 3
- Recency, Frequency, Monetary (RFM) Analysis: Part 4
- Recency, Frequency, Monetary (RFM) Analysis: Part 5. RFM Code
Oracle Materialized View
- Take Advantage of Materialized View
- More On Oracle External Table
- Get the source code for Oracle database views and materialized view
- Refresh an Oracle Materialized View
Database Link to Oracle on Amazon
- Create Database Link to DB on Amazon EC2 Instance
- Compare Oracle Tables in Different Databases: Find an ETL Issue
- Why Sometime It Is Not a Good Idea to Export Database Tables as Text Files?
Calculate Percent Using SQL
- Three Ways of Calculating Percentage of Counts Using Oracle SQL
- Three Ways of Calculating Percentage of Quantity Using Oracle SQL
Calculate Cumulative Percent Using SQL
Find Score Cutoff Value Using SQL
Remove Duplicates Using SQL
Calculate Correlation Coefficients Using SQL
- Calculate correlation coefficient between two variables using SQL
- Calculate the Correlation Coefficient Using SQL
- Calculate correlation matrix using SQL
- Calculate correlation matrix using SQL (continued)
Oracle vs SQL Server
NULL Value
- Calculate Average Value - Watch Out NULL Values
- NULL Value and Logical Comparison
- NULL Value and Order By
- NULL Value and Arithmetic Operations
Logistic Regression
- Data preparation for building logistic regression models
- More on Data Preparation for Logistic Regression Models
- Categorical Variables in Logistic Regression
Random Sampling
- A random sampling method for medical claim audit
- Random Sampling using SQL
- More on random sampling in Oracle
Table Insert
- Insert Records Into an Oracle Table and Rollback
- Oracle Multiple Table Insert
- Oracle Direct Path Insert
Read Only Table
Clustering
- Build K-Means Clustering Models Using PL/SQL
- Oracle On The Fly Model- Clustering
- Impute Missing Values Using Clustering Algorithms
Ranking
Find Most Frequent
Median Value
Oracle Source Code
- More on Get Source Code for Oracle Database Objects
- Get the source code for Oracle database views and materialized view
3 comments:
i found this is the best site 2017 Printable Calendar because it provides calendar first
some sites always hep us in our trip Oklahoma Map
hello! you can the best Blank Calendar templates here.
Post a Comment