Compare courses
Register
Management Concepts

Introduction to Analytics

Add course to comparison

Next dates

Jun 17—19
3 days
Washington, District of Columbia, United States
USD 1059
USD 353 per day
Aug 26—28
3 days
Denver, Colorado, United States
USD 1059
USD 353 per day
Sep 9—11
3 days
Washington, District of Columbia, United States
USD 1059
USD 353 per day
+11 more options

Description

Improve upon the success of your organization by developing the analytical skills needed to evaluate and solve problems. After an introduction to a structured 6-Step Analytics Process Model, you will learn to apply these steps through collaborative scenarios and conduct analysis projects using Microsoft Excel. This experiential approach provides you with a foundational understanding of analytics, with an emphasis on collecting, interpreting, and presenting data.

Learning Objectives

  • Define Analytics Process Model
  • Identify each phase of the Analytics Process Model and its purpose
  • Apply basic Excel functions to filter data, sort data, create ranges, and to anchor
  • Define effective objectives for analysis
  • Translate an organizational problem into an accomplishable analysis project
  • Apply basic quantitative analysis techniques
  • Write a problem statement
  • Begin formulating a study plan
  • Develop and administer a brief survey
  • Develop interview questions and conduct short interviews
  • Analyze data using descriptive statistics (e.g., mean, median, mode, range, variance, standard deviation, and frequencies)
  • Develop an outline for an executive summary in an analytical report
  • Give a short briefing to present analysis results

Course Topics

Introduction to Analytics

  • What Is Analytics?
  • Excel For Analytics

Defining Effective Objectives for Analysis

  • Defining Organizational Objectives
  • Developing a Hypothesis
  • Problem Statements
  • Creating Analytical Objectives
  • Stakeholder Analysis

Basic Quantitative Analysis Techniques

  • Qualitative vs. Quantitative Data
  • Levels of Measurement
  • What Is Central Tendency?
  • What Is Variation?
  • Descriptive Statistics and Excel's Data Analysis ToolPak

Visual Analysis Techniques

  • Data Visualization
  • Exploring Data
  • Preparing Chart Data
  • Creating Graphs in Excel
  • Best Practices for Formatting Charts in Excel
  • Sample of Pivot Table in Excel

Data Collection

  • Primary Data vs. Secondary Data
  • Primary Data: Surveys
  • Primary Data: Interviews

Presenting Your Results

  • Presentation Goals
  • Organizing the Presentation
  • Assessing Your Audience
  • Crafting the Message of the Presentation

Who should attend

This course is designed for individuals who need to develop a foundational understanding of how to use data analysis to solve problems in their organization.

Show more