2014
Lynda
Ron Davis
1:28
English

You don't need to be a statistician to explore your own data. Learn how to use the software you already have, Excel, to perform basic data mining and analysis. Ron introduces core data-mining concepts like CRISP-DM (Cross Industry Standard Process for Data Mining), and then dives into the algorithms Microsoft offers for data mining right out of the box. Then learn about the data-mining structures and models in Excel SQL Server Analysis Services, and the new add-ins that make data mining in Excel both exceedingly powerful and incredibly easy.

Introduction
Welcome
What you should know before watching this course
Demonstration of the Excel data-mining tools built in this course
Building an environment
1. Data-Mining Concepts
Concepts and results
CRISP-DM (Cross-Industry Standard Process for Data Mining)
Business problems for data mining
Models, induction, and prediction
Key concepts
2. The Microsoft Data-Mining Algorithms
Types of data-mining algorithms
The Microsoft algorithms
3. Data Mining between Excel and SQL Server Analysis Services
Understanding mining structures
Understanding mining models
4. Using the Data-Mining Add-ins in Excel
The Data Preparation tab
The Model Usage group
The Accuracy and Validation group
The Data Modeling group
Analyzing key influencers
Detecting categories
Highlighting exceptions
Scenario analysis
Shopping Basket Analysis
Using the Prediction Calculator
Prediction with a model
Conclusion
Next steps

Download File Size:356.71 MB

---