Analytics Boot Camp: Core Analytics

Overview

Develop a strong foundation in data analysis techniques to gain insight into sound business strategy, an insight critical to problem-solving and decision-making within your organization. You will learn numerous analytical techniques, including data validation and conditioning, probability distribution statistical analysis, and how to store data to maintain data integrity. Working collaboratively through real-world scenarios using Microsoft Excel, you’ll be prepared to perform the most relevant, mission-critical analyses.

Who Attends

This course is designed for professionals who seek formal training or a refresher course in foundational skills for data analytics.

Course Level: Basic
CLP: 24 | CPE: 24
Duration: 3 Days

Price: $ 2119.00 Course prices shown here do not include a credit card surcharge. Payments by ACH, EFT, or check do not include the surcharge and are offered at a lower price. At checkout, you may choose a payment method that avoids the credit card surcharge.
A 3% credit card surcharge will be applied.

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

Available Dates

Guaranteed to Run are designated with a

February 17 - February 19, 2027

Class ID: 274607001

Virtual

9 AM - 5 PM EST

April 19 - April 21, 2027

Class ID: 274607002

Virtual

9 AM - 5 PM EST

June 21 - June 23, 2027

Class ID: 274607003

Virtual

8 AM - 4 PM EST

August 9 - August 11, 2027

Class ID: 274607004

Virtual

9 AM - 5 PM EST

October 4 - October 6, 2027

Class ID: 274607005

Virtual

9 AM - 5 PM EST

December 1 - December 3, 2027

Class ID: 274607006

Virtual

9 AM - 5 PM EST

Learning Objectives

Use Excel's IF function
Check data sets for accuracy and quality and apply conditional formatting to allow for an alternate view of the data
Utilize Excel’s Get and Transform feature to import and transform data
Use descriptive statistics to describe or summarize a data set
Construct a frequency distribution to analyze data and translate it into relevant information
Predict the outcome of an event using probability
Demonstrate how probability distribution functions forecast how often an event will occur over time
Use sampling to accurately forecast the impact of an event
Investigate the relationship between values using correlation and linear regression
Review best practices for data retention and integrity

Additional Features

Learn More

Credits

CLP Credits: 24
CEU Credits: 1.9
PDUs: 21
NASBA Field(s) of Study and Credits: Statistics (24 CPEs)
NASBA Level: Basic
FM MyLearn Number: L3912

This course is part of the following Management Concepts Certificate Programs:

Core Courses

None

Elective Courses

Agile in Government Master Track
Project Management Master Track
Program Management Certificate Program

Prerequisites:

Mandatory

Participants should have a basic understanding of Excel.

Suggested

Introduction to Analytics

Course Activities

Course Topics

IF Functions

Excel's IF Function
VLOOKUP vs. IF

Data Validation and Conditional Formatting

Data Validation
Conditional Formatting

Get and Transform

What Is Get and Transform?
Getting Data
Transforming Data
Leveraging Power BI

Descriptive Statistics

Measures of Central Tendency
Measures of Variance
Measures of Shape
Descriptive Statistics Analysis
Rank and Percentile

Frequency Distribution

What Is a Frequency Distribution?
Showing the Frequency Distribution
Building a Frequency Distribution
Frequency Distributions as Histograms

Basic Probability

Probability Key Definitions
Probability Properties
Determining the Probability of an Event
Types of Probability for Multiple Events
Counting Techniques

Probability Distributions

The Binomial Distribution
The Normal Distribution

Overview of Statistical Sampling

Key Terms: Population vs. Sample
What Is Sampling?
Types of Sampling

Correlation and Regression

Correlation
Simple Linear Regression

Storing Data

Data Retention
Best Practices for Retaining Data
Course Wrap Up and Open Issues

Related Courses and Products

COURSE

Data Collection Techniques

Analyze and collect clean data, particularly in the context of your organization’s data management. Learn best practices to combat common obstacles in data collection. Gain strategies for identifying...

COURSE

Data Analysis and Modeling Techniques

Analyze data to help solve your organization’s most complex challenges and requirements. Learn the core techniques used to analyze and model complex data into understandable information. Gather the sk...

COURSE

Evaluating and Presenting Analysis Results

Capture the value of key data analyses and present them in a way that ensures decision-makers can interpret those results to make sound decisions. Learn how to capture, analyze, and determine relevanc...

COURSE

Data-Driven Decision-Making

Explore the General Decision Support Model, a framework that guides effective decision-making during the analytics process and helps ensure a sound business strategy based on facts. You will practice...

COURSE

Introduction to Data Visualization

Learn to select an appropriate visual format to communicate data and extract valuable information from your organization’s data by removing the barriers to understanding key information. Apply basic b...

Loading Course Details

Analytics Boot Camp: Core Analytics

Overview

Who Attends

For Groups

Available Dates

Learning Objectives

Additional Features

Credits

This course is part of the following Management Concepts Certificate Programs:

Core Courses

Elective Courses

Prerequisites:

Mandatory

Suggested

Course Activities

Course Topics

Leveraging Artificial Intelligence (SI) for Federal Decision-Making