Introduction to Data Analysis

Organizations need to make business decisions more quickly and accurately than ever before. Basing these decisions on data and best practice analysis techniques and less on gut feel or "the way we have always done things" is how today's corporate management is demanding information. A solid foundation of data analysis for business decision making is a critical skill you should have regardless of whether your motive is to obtain or sustain a competitive advantage or simply better steward your resources to serve customers. In this course, you will learn to use data analytics to create actionable recommendations, as well as identify and manage opportunities where data-based decisions can be used to change the way you do business.

This course provides many of the common data analysis tools used to gather, analyze and adapt your data to feed business decisions. You do not need heavy Excel or data analysis experience. This course includes introductory exercises on Excel add-ins, standard deviation, random sampling, and an introduction to pivot tables and charts. These exercises will show you how to effectively demonstrate basic data analysis functions and reporting in Excel or Google Spreadsheets. We will simplify math jargon and complex symbols and equations to concentrate on what your data can tell you and your organization. In addition, you will learn how to present to those executives, managers and subject matter experts who need to quickly make decisions that drive your organization.

Delegates will learn

·       Terms, jargon, and impact of business intelligence and data analytics

·       Scope and application of data analysis

·       Impact of analytics on gaining competitive advantage and decision support

·       Measure the performance of and improvement opportunities for business processes

·       Need for tracking and identifying the root causes of deviation or failure

·       Basic principles, properties, and application of probability theory and the normal distribution

·       Introduction to different methods for summarizing information and presenting results including charts

·       Statistical inference and drawing conclusions about the population

·       Sample sizes and confidence intervals, and how they influence the accuracy of your analysis

·       Forecasting and an introduction to simple linear regression analysis

·       Interpret your results and draw sound and relevant conclusions on business

·       Methods and algorithms for forecasting future results and to reduce current and future risk

·       Process improvement and analysis skills

·       Where powerful reference material exists and how to leverage to enhance your decision-making


Individuals involved in operations, project management, business analysis, or management, who need an introduction to data analysis

Course Introduction

Logistics, materials, and course expectations

Agile and integrated (A&I™) set of tools and best practices

References and resources

Introduction to Data Analysis and Analytics

Definition and history

Current technology, the growing availability of data, and increasing challenges

Applications for gaining competitive advantages

Rethinking the Value and Usage of Data

The impact of vast volumes of available data especially for decision making

Data difficulties and limitations: ROI vs. effort/expense, incomplete and inconclusive data

Dealing with data uncertainty

Getting real value out of your data: The data continuum

Effective and responsible data ownership

Advantages and disadvantages of qualitative and quantitative data types

Solutions and best practices to transform the way your organization accesses and uses data

Organizing the entire organization's data for maximum efficiency using easily available tools

Taking advantage of the expertise of the entire organization

Introduction to Data Mining and Data Warehousing

Data Mining concepts and application

Application benefits of data warehousing

Data Distribution and Variance

Decision making under uncertainty


Data distribution


Standard deviation

Information Needs

Operational and executive information classes

Key functional transactions and documents

Map information needs to underlying data

Executive information needs and the balanced scorecard

Role of the business analyst and data analyst

How to use simple pivot tables in Excel or Google Sheets to analyze and present your data

Tracking and managing business process performance

Learning from data

Data Exploration Concepts and Methods

Basic concepts

Descriptive measures of a sample


Statistical hypothesis and inference

Dependence and correlation

Moving beyond data and decision uncertainty - managing risk


Forecasting methods and models

Time series analysis

Linear regression

Establishing trends and business cycles (i.e., seasonality)

Selecting independent variables for predictive models including regression techniques

Review, Best Practices, and Next Steps

Data analysis and transformation

Best practices revisited

Next steps options

Program Details
Duration 3 Days
Capacity Max 12 Persons
Training Type Classroom / Virtual Classroom

Can't find what you're looking for? Let us know if you have a query or cannot find what you are looking for.