Excel Data-Mining Fundamentals Год выпуска: 2014 Производитель: Lynda Сайт производителя: lynda.com Автор: Ron Davis Продолжительность: 1:28 Тип раздаваемого материала: Видеоклипы Язык: Английский Описание: 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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You can download files in this forum