.
Code | Available Dates | Places & Fees | Registeration | ||||||
| Register | ||||||||
| Register | ||||||||
| Register | ||||||||
| Register | ||||||||
| Register | ||||||||
| Register |
1- Online Training...with international accreditation. The value of participation per person is €1,450
2-Requirement : specifying the course, number of participants
implementation date, and joint coordination.
Group contracting ... 20% Discount For Each Participant In Any Group Of Five Person Or More
Other Places To Hold The Course :
KualaLumpur.. Istanbul.. Dubai.. Cairo.. Riyadh.. Jeddah.. Abu Dhabi.. Doha.. Muscat.. Sharm El Sheikh.. Kuwait.. Tripoli.. Amman.. Beirut.. Damascus.. Tunisia.. Casablanca.. London.. Paris.. Barcelona.. Amsterdam.. Brussels
Data Analysis Techniques
Introduction :
The Data Analysis Techniques training course shows delegates how to use Microsoft Excel to perform a wide range of powerful analysis and interpretations, using real data. This is possible because, although most people are familiar with Microsoft Excel, they generally only use a small fraction of its true capability. This training course will show delegates how to make the most of Excel by explaining and demonstrating many of the very powerful analytical, visualization and interpretation capabilities that it is capable of.
Course Objectives :
At the end of this course, the participants will be able to :
- A good understanding and extensive practical experience of a range of common analytical techniques and interpretation methods for numerical data
- The ability to recognize which types of analysis are best suited to particular types of problems
- The ability to judge when an applied technique will likely lead to incorrect conclusions
- A good understanding of a wide range of common statistical methods and approaches
- The ability to use Microsoft Excel 2016, 2019 or 365 to analyze and interpret a wide range of real data types
- Experience of how to transform numerical data into evidence and hence how to make informed business decisions
Targeted Audience :
- Performance assessment and monitoring
- Planning
- Data analysis
- Management and leadership
- Finance
- Human resources
- Quality control
- Engineering and technology
- …in fact, any job function which uses data to make decisions.
Course Outlines :
Day 1 : Logical and Reliable Data Analysis, Descriptive Statistics, and Pivot Tables
- Importing data into Excel
- Best practice when analyzing data
- Analyzing and representing coded data
- Descriptive statistics and their real meanings
- Performing a frequency analysis
- The use of pivot tables and pivot charts
- Noisy and incomplete data, statistical significance and dealing with outliers
Day 2 : Data Mode Shape Analysis
- Plotting data against time
- Generating data mode shapes
- Fitting curves to data
- Correlating mode shape to time-based events
- Interpreting time series analyses
- Moving average calculations
Day 3 : Scenario Analysis and Interactive Spreadsheets
- Representing analytical problems as multi-input, single-output (MISO) systems
- Deterministic systems analysis
- What if and visual scenario analysis
- Dynamic / interactive spreadsheets and the use of forms control
- Moving window, conditional and adaptive calculations
- Measuring the sensitivity of calculated variables
Day 4 : Regression Analysis and Correlation
- Equations of curves
- The prediction of future behavior using data shape – regression analysis
- Linear, polynomial, exponential and power curve fits
- The dangers of over-fitting
- Data end effects
- Goodness of fit (sum of square error – SSE) and R2
- Evaluating equations, solving equations, and using Solver
- Correlation and causality
Day 5 : Data Driven Methods and Analysis of Variance
- Non-deterministic system
- Data driven methods
- One step ahead future prediction using data science (multivariate correlation)
- Single factor analysis of variance (ANOVA)
- Two factor analysis of variance
- A demonstration of artificial intelligence – the travelling salesman problem
European Business Center Training Methodology :
Our training work is presented in a professional and attractive manner.. Interspersed with interceptive information to renew attention throughout the training period… We aim with this method to train the listener and interact… In addition to practical applications that target the direct skills and knowledge required to be achieved.. It is presented to the trainees in more than one way.. Practical exercises and applications.. Surveys and questions.. A training strategy has been adopted based on pairing between the theoretical and the professional and between the local and the global.
What Does The Participant Get From The Course?
Each participant obtains an internationally accredited training certificate from the European Business Center for Training and Development … which has the ISO certificate in quality No. 900/2015 from the English international company UCAS .. and receives a training bag containing the scientific material via an electronic flash … in addition to an enjoyable and useful training that is reflected Positive and developmental for individuals and the institution
Note :
We can implement the training course in any of the cities referred to in this course..at the appropriate and required time for the trainees..through joint coordination with the training department at the center..the training is implemented in a distinctive manner according to the best quality standards so that we meet all training requirements and needs.
International Accreditations
European Business Center for Training and Development has obtained international and official accreditations with the highest and best international levels scientifically and technically, which reflect the level of outstanding performance in our training work.. so that it achieves what each participant aspires to by obtaining the best certificates with officially approved scientific and technical standards.