Analytics Boot Camp

Overview

Gain insight into sound business strategy through data analysis, a key component to problem-solving and decision-making within a mission-critical organization. Develop a strong foundation in data analysis techniques, including analytical techniques, data preparation, integration, statistical analysis, and presentation skills. 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: 40 | CPE: 40
Duration: 5 Days

Price: $ 2789.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

July 20 - July 24, 2026

Class ID: 264650014

Virtual

9 AM - 5 PM EST

August 24 - August 28, 2026

Class ID: 264650016

Virtual

9 AM - 5 PM EST

September 21 - September 25, 2026

Class ID: 264650018

Washington, DC

8 AM - 4 PM EST

October 19 - October 23, 2026

Class ID: 264650020

Virtual

9 AM - 5 PM EST

November 16 - November 20, 2026

Class ID: 264650022

Virtual

9 AM - 5 PM EST

December 14 - December 18, 2026

Class ID: 264650024

Washington, DC

8 AM - 4 PM EST

Learning Objectives

Explain the importance of data analysis and data analysis tools to help organizations solve problems effectively
Review basic Excel components and functions
Use ranges, anchoring, and Excel tables to perform analysis tasks
Sort and filter data to identify relevant information
Create charts to clarify analysis results and make informed decisions
Use Excel LOOKUP and IF functions to search, evaluate, and analyze datasets
Check datasets for accuracy and quality and apply conditional formatting to allow for an alternative view of the data
Create PivotTables and PivotCharts to summarize data
Perform text manipulation functions to turn raw data into usable data
Utilize Excel’s Get and Transform feature to import and transform data
Use descriptive statistics to describe or summarize a dataset
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

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

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...

Loading Course Details

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

Introduction to Data Visualization

Leveraging Artificial Intelligence for Federal Decision-Making

Championing Data: Building a Data-Savvy Federal Workforce