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

Course Details

FAQs Technology Requirements

For Groups

Volume Discounts (5+ Seats) Private Group Training Icon

Private Group Training

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

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

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 for Federal Decision-Making