Analytics Boot Camp

Management Concepts

How long?

  • 5 days
  • online, in person

What are the topics?

Management Concepts

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Reviews

Make sure this course is right for you.

Get unbiased reviews and personalized recommendations.

Who should attend

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

About the course

Insight into sound business strategy is critical to problem-solving and decision-making within a mission-critical organization. Developing a strong foundation in data analysis techniques helps lead to this gained insight. You will learn numerous analytical techniques, including 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.

Learning Objectives

  • Explain the importance of data analysis and how to use Excel to analyze data for effective decision-making
  • Use ranges, reference anchors, and data tables to increase efficiency when performing data analysis
  • Demonstrate how to sort and filter data in order to identify the relevant information for problem-solving
  • Use pivot tables to summarize data to quickly gain a better understanding of it
  • Import data into Excel from a variety of sources
  • Use data retention and integration functions to effectively manage your data
  • Use text manipulation functions to turn raw data into usable data
  • Visualize data through analysis software
  • Identify real-world applications for statistical data analysis
  • Use Excel to generate descriptive statistics and interpret the data
  • Construct a frequency distribution to analyze data and translate it into relevant information
  • Calculate the likelihood that an event will occur using probability
  • Use probability distribution functions to forecast how often an outcome will occur over a period of time
  • Use sampling to avoid the potential for hidden bias in expressing statistical findings
  • Calculate the correlation between two variables and make predictions using simple linear regression
  • Use the data analysis features of Excel to assist in complex problem-solving

Course Topics

Introduction to Data Analysis

  • The Importance of Data Analysis
  • Using Excel for Data Analysis

Ranges, Anchoring, and Data Tables

  • Range References
  • Anchoring References
  • Named Ranges
  • Data Tables

Sorting and Filtering

  • Sorting Data
  • Filtering Data

Pivot Tables

  • Overview of the Pivot Table Tool
  • Creating a Pivot Table Report

Importing Data for Analysis

  • Importing Text Files for Analysis
  • Importing Data from a Database
  • Refreshing the Data

Data Retention and Integration

  • Curating and Retaining Data Sets
  • Data Integration
  • Linking Data Between Sets
  • Data Integration Functions

Text Manipulation

  • Overview of Text Manipulation Functions
  • Using Text Manipulation Functions

Charting Data

  • Levels of Measurement
  • Introduction to Charting Data
  • Formatting Charts
  • Chart Types and Applications

Introduction to Statistics

  • Statistics Overview

Descriptive Statistics

  • Measures Central Tendency
  • Measures of Variation
  • Analysis ToolPak Descriptive Statistics

Frequency Distribution

  • What Is a Frequency Distribution?
  • Creating Histograms

Probability

  • Probability in Practice
  • Counting Outcomes

Probability Distributions

  • Binomial Distribution
  • Normal Distribution

Statistical Sampling and Confidence Intervals

  • Overview of Statistical Sampling
  • Methods of Statistical Sampling
  • Statistical Error and Sample Size
  • Sampling Distribution of the Mean
  • Confidence Intervals

Correlation and Regression

  • Correlation Analysis and Applications
  • Linear Regression Analysis and Applications

Course Capstone

  • Capstone Exercise

Analytics Boot Camp at Management Concepts

From  $1,829

Something went wrong. We're trying to fix this error.

Thank you for your application

We will contact the provider to ensure that seats are available and, if there is an admissions process, that you satisfy any requirements or prerequisites.

We may ask you for additional information.

To finalize your enrollment we will be in touch shortly.

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with any business school or university.

Full disclaimer.

Because of COVID-19, many providers are cancelling or postponing in-person programs or providing online participation options.

We are happy to help you find a suitable online alternative.