There are currently no items in your shopping cart.

User Panel

Forgot your password?.

Data Reduction Techniques Using Excel and R: Business Analytics Deep Dive


What you should know before watching this course
Exercise files

1. Problems Raised by Massive Amounts of Data

Observation overkill
Rationale for clustering
Rationale for PCA

2. An Overview of Principal Components Analysis

Using Excel to extract principal components
Rotating factors
Using R to extract principal components

3. An Overview of Cluster Analysis

ANOVA and MANOVA reviewed
Causation and probability
Multivariate nature of clustering
Using R for cluster analysis
Using Excel for cluster analysis
Setting up confusion tables in Excel

4. Putting It Together: Using Cluster Anaysis and Factor Analysis in Concert

Clusters and factors
Pivot table analysis


Next steps