Introduction to Analytics

Management Concepts

How long?

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

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.

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

Introduction to Analytics at Management Concepts

From  $1,109

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.