Data Analysis with Excel and Python Course
Introduction
Everyone agrees that evidence-based decision making is the key to corporate high performance. In a world where everything is now measured and recorded, the data that companies hold can be a very rich and powerful source of evidence, but only if it can be analyzed and interpreted accurately and reliably. This Data Analysis and information course shows participants, by example, how to analyze and interpret data and hence how to make robust and defensible evidence-based business decisions.
The Data Analysis training course shows participants 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. The course will show participants how to make the most of Excel by explaining and demonstrating many of the very powerful analytical, visualization and interpretation capabilities.
Duration
5 Days
Who Should Attend
Professionals working in the following fields:
- Performance assessment and monitoring
- Planning
- Data analysis
- Management and leadership
- Finance
- Human resources
- Quality control
- Engineering and technology
Course Objectives
At the end of this IRES training course, participants will learn:
- 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
Course Outline
Module 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
Module 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
Module 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
Module 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
Module 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
Enroll for this Course
We are proud to offer this course in a variety of training formats to suit your needs.
Benefits of Taking a Course at IRES
LEARN
Our courses are carefully curated to keep you abreast of latest industry trends, technological advancements, and best practices. We employ a variety of teaching methodologies, including hands-on workshops, case studies, and interactive sessions, all aimed at fostering an engaging and effective learning environment. Our expert instructors bring a wealth of knowledge and real-world experience, providing our clients with insights that can be immediately applied in their professional lives.
NETWORK
Our courses serve as a vibrant platform for professionals to connect and engage with a diverse community of peers, industry leaders, and experts. By participating in our programs, you gain access to an invaluable network that spans across various sectors and geographical boundaries. This networking aspect is not just about forming professional relationships; it's about creating a supportive ecosystem where ideas, opportunities, and collaborations can flourish.
GROW
Our courses are designed to challenge and inspire professionals to step out of their comfort zones and explore new horizons. Through a combination of theoretical knowledge and practical application, our programs help professionals refine their existing skills and acquire new ones, making them more versatile and competitive.