Data Analysis Boot Camp

Course Code: 1579



This three day course uses straightforward business examples to help participants gain a thorough understanding of how to review, understand and analyze data, and make more informed, intelligent business decisions by analyzing data using Excel functions and the R programming language. The course provides an overview of data quality and data management, foundational analysis and statistical techniques. The course discusses how to communicate about data and findings to stakeholder who need to quickly make decisions that drive the organization forward.

Schedule Classes

Looking for more sessions of this class?

Course Delivery

This course is available in the following formats:

Live Classroom
Duration: 5 days

Live Virtual Classroom
Duration: 5 days

What You'll learn

  • Identify opportunities, manage change and develop deep visibility into the organization
  • Understand the terminology and jargon of analytics, business intelligence and statistics
  • Learn a wealth of practical applications for applying data analysis capability
  • Visualize both data and the results of analysis for straightforward graphical presentation to stakeholders
  • Learn to estimate more accurately than ever, while accounting for variance, error and confidence intervals
  • Practice creating a valuable array of plots and charts to reveal hidden trends and patterns in data
  • Differentiate between ‘signal’ and ‘noise’ in data
  • Understand and leverage different distribution models, and how each applies in the real world
  • Form and test hypotheses – use multiple methods to define and interpret useful predictions
  • Learn about statistical inference and drawing conclusions about the population


  • Objectives of the class
  • Expectations for the class
  • Unstructured vs. structured
  • Relationships
  • Outliers
  • Data growth
  • Flavors of data
  • Sources of data
  • Internal vs. external data
  • Time scope of data (Lagging, current, leading)
  • Common identified risk
  • Effect of process on results
  • Effect of usage on results
  • Opportunity costs, tool investments
  • Mitigation of risk
  • Cleansing
  • Duplicates
  • SSOT
  • Field standardization
  • Identify sparsely populated fields
  • How to fix common issues
  • Comparing programs and tools
  • Words in English vs. data
  • Concepts specific to data analysis
  • Domains of data analysis
  • Descriptive statistics
  • Inferential statistics
  • Analytical mindset
  • Describing and solving problems
  • Mean
  • Median
  • Mode
  • Range
  • Variance
  • Standard deviation
  • Sigma values
  • Percentiles
  • Use concepts for estimating
  • Probability distribution
  • Cumulative distribution
  • Bimodal distribution
  • Skewness of data
  • Pareto distribution
    • Correlation
  • Lab: Distributions
  • Predictive analysis
  • A discussion about patterns
  • Regression and time series for prediction
  • Lab: Hands-on – Linear regression
    • Simulation
  • Pseudo-random sequences
  • Monte Carlo analysis
  • Demo/Lab: Monte Carlo in Excel
  • Communication and narrative
  • Decision enablement
  • Critical characteristics
  • Users and stakeholders
  • Stakeholder cheat sheet
  • Common missteps
  • Alerting and trending
  • To self-serve or not
  • Formats and presentation tools
  • Design considerations
View More


Participants must have basic familiarity with Microsoft Excel. It would be beneficial to complete the Introduction to R course prior to taking up this boot camp.

Who Should Attend

The course is highly recommended for –

  • Business Analysts
  • Business Systems Analyst
  • CBAPs
  • CCBAs
  • Systems, Operations Research, Marketing, and other Analysts
  • Project Managers
  • Program Managers
  • Team Leaders
  • PMP and CAPM certified professionals
  • Data Modelers and Administrators, DBAs
  • IT Managers, Directors, VPs
  • Finance Managers, Directors, VPs
  • Operations Supervisors, Managers, Directors, VPs
  • Risk Managers, Operations Risk Professionals
  • Process Improvement, Audit, Internal Consultants and professionals
  • Executives exploring cost reduction and process improvement options
  • Job seekers and those who want to show dedication to process improvement
  • Senior professionals who make or recommend decisions to executives

Interested in this course? Let’s connect!