Events

Data Mining - Value data and build decision aids (Excel stat)

495 €

at 1.8 KM
House of Training Follow

Training
Business
Innovation
Strategy
Statistics
Technology
Data
Digital
IT
Office

tue. 12 Nov.

Description
This Data Mining course allows you to acquire the essentials of the keys to structure the data for analytical purposes and to appropriate the main methods of data analysis.
These methods will be grouped into 4 categories:
Descriptive methods of simple highlighting of information
The methods of multidimensional analysis of the variables (on quantitative variables, on qualitative variables, and mixing the two types of variables).
Decision-making methods
The forecasting methods
goals
As part of this training, it is not only about understanding the methods but also practicing them, that is to say learning to deploy them at the same time as part of the internship but also on the return, in his own universe working.
At the end of the training, the participant will be able to:
define the term Data Mining and to know the different fields of application to know and use The different types of variables to know and use the statistical functions and data representations In Excel to know and use certain features of the XLSTAT data analysis software to perform with XLSTAT a linear regression and establish a correlation matrix perform with XLSTAT a principal component analysis (PCA) perform with XLSTAT a factorial analysis of correspondence (AFC) perform with XLSTAT a discriminant analysis to transfer The methodologies learned In its professional environment
program
Quick overview of the concept of Data Mining (definitions) and some applicationsApplied statistical tutorial In ExcelTutorial representation of dataIn ExcelInstallation of the XLSTAT software on participants' laptops Tutorial XLSTATThe linear regression model and matrix of correlationsThe principal component analysis (PCA) Factorial Correspondence Analysis (CFA) Discriminant AnalysisQuestions Answers

Good to know

Asset of the training
In addition to the course, and practical applications, learners will have a license of the XLSTAT software, for one year.

Target audience
All functions in companies with large amounts of data, applicable to all sectors of the economy

Prerequisites
Good knowledge of the Excel tool
Coming with his laptop

Pedagogy
Training in the practical use of a Data Mining software. Each participant will leave with the software used and will have a license of one year of use.

To help implement these methods in the workplace, a follow-up and support will be provided by the teacher for 4 weeks in order to respond to the learners' requests and to accompany them in a company: it is "learning in the flow of work ".

Certificate
At the end of the training participants will receive a certificate of participation issued by the House of Training

Course materials
Upgrade videos to consult before the face-to-face course
A synthetic course on Powerpoint serving as a framework for the course and made available to the learners after the training
Software taught during the internship, made available and for a period of one year thereafter. This software will put into practice and build skills immediately and tangibly
Rather short video sequences (of the order of 10 mns), each illustrating and serving to interpret a method. These videos will be valuable, especially once in the workplace to refresh your knowledge: it is "micro-learning"