Management Concepts

Introduction to Analytics

Available dates

Feb 24—26, 2020
3 days
Washington, District of Columbia, United States
USD 1059
USD 353 per day
Mar 11—13, 2020
3 days
Washington, District of Columbia, United States
USD 1059
USD 353 per day
Apr 27—29, 2020
3 days
San Diego, California, United States
USD 1059
USD 353 per day
+5 more options

Disclaimer

Coursalytics is an independent platform to find, compare, and book executive courses. Coursalytics is not endorsed by, sponsored by, or otherwise affiliated with Management Concepts.

Full disclaimer.

About the course

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.

Course reviews