workers-collab

Data Analysis Fundamentals: A Hands-on Workshop

Make smarter business decisions using these powerful data analysis methods.

Are you tired of being under constant pressure to make the right number-based decisions for your organization? Are you too often overwhelmed by an out-of-control flood of data, much of it conflicting and confusing? Designed for those who have a basic familiarity with MS Excel and want to develop their ability to solve problems effectively and efficiently, this course goes beyond the qualitative side of data analysis to explore proven quantitative tools and methods for analyzing, interpreting, and utilizing data, so that more informed and reliable business decisions can be made. Take this chance to add value to your organization by increasing your productivity in handling all the information and reports that pile up in the inbox every day—and lose the angst that goes with it!

Seminar Number: 01112

  • In a Classroom
  • Your Company Location

Course Scheduling & Pricing

Who Should Attend

Business professionals who need the basic tools to quantitatively and accurately analyze the mountains of data that come across their desk each minute of every day to help make data-driven decisions.

  •   Classroom2 Day(s)
    1.2 CEU, 12 CPU, 12 PDCs
 

Are you tired of being under constant pressure to make the right number-based decisions for your organization? Are you too often overwhelmed by an out-of-control flood of data, much of it conflicting and confusing?

Designed for those who have a basic familiarity with MS Excel and want to develop their ability to solve problems effectively and efficiently, this course goes beyond the qualitative side of data analysis to explore proven quantitative tools and methods for analyzing, interpreting, and utilizing data, so that more informed and reliable business decisions can be made. Take this chance to add value to your organization by increasing your productivity in handling all the information and reports that pile up in the inbox every day—and lose the angst that goes with it!

  • Learn the best practices for organizing, summarizing and interpreting quantitative data
  • Create a repeatable process for analyzing your data
  • Bring out patterns in data that were not apparent at first glance
  • Identify and apply tools for data analysis
  • Shorten the time between analysis and action to avoid “analysis paralysis”
  • Recognize the value of using data to address business questions and inform decision-making
  • Recognizing the context and the need for information
  • Using the Data as a Strategic Model (DASA) as a framing tool when approaching data analysis
  • Framing the right questions to ensure the best results
  • Collecting and organizing the “right” data for the questions being posed
  • Selecting the right tools and techniques to analyze the data
  • Identifying the relevancy of the data you can access
  • Interpreting and translating data into actionable insights
  • Applying analytical tools to your business questions

Special Feature

Course Requirements: A laptop equipped with a mouse and Excel 2010. Your laptop must have the ability to load external files and add-in applications.

Introduction

  • Recognize the Value of Using Data to Answer Questions and Address Business Issues
  • Explain How Data Has Become the Strategic Business Asset It Is Today
  • Describe the Data as a Strategic Asset (DASA) Model and How to Apply It

Framing Questions

  • Describe the Value of Using Data to Answer Business Questions and to Address Business Issues
  • Explain How to Identify Relevant Business Questions and Issues

Finding Data

  • Discover Usable Data: Its Source, Type, Value, Quality, Location, and Relationships
  • Profile the Data to Determine What Is Important or Relevant
  • Organize and Manage Data Appropriately
  • Acquire Data from Any Source

Shaping the Data Table

  • Identify and Resolve Problems Associated with Data Collection
  • Articulate the Pros and Cons of Data Manipulation
  • Determine If Data Samples Are Adequate
  • Create a Table That Is Ready to Be Analyzed

Analyzing the Data

  • Understand Which Data-Analysis Tools Best Answer Common Analytical Business Questions
  • Articulate How the Microsoft® Excel Analysis ToolPak and Other Programs Can Be Used for Advanced Data Analysis
  • Choose the Appropriate Tool and Technique to Analyze Your Data
  • Apply Analytical Tools to Answer Business Questions You Are Facing at Work

Applying the Results

  • Create Appropriate Business Rules to Take Advantage of Your Data-Driven Insights

This program is valid for 12 PDCs for the SHRM-CPSM or SHRM-SCPSM.

This course qualifies 12 CPUs towards your recertification as a CAP® (Certified Analytics Professionals).

American Management Association is accredited by the International Association for Continuing Education and Training (IACET) and is accredited to issue the IACET CEU.

Classroom Schedule

5 Sessions Available

  • $2,345.00 Non Members
  • $2,095.00 AMA Members
  • $1,889.00 GSA
Date Duration State City Zip
  2019-09-12 2019-09-13 Sep 12, 2019 - Sep 13, 2019 2 Days IL Chicago 60601 Chicago Register Now

  2019-11-04 2019-11-05 Nov 4, 2019 - Nov 5, 2019 2 Days NY New York 10019 New York Register Now

  2019-12-18 2019-12-19 Dec 18, 2019 - Dec 19, 2019 2 Days DC Arlington/Washington 22202-4807 Arlington/Washington Register Now

  2020-04-06 2020-04-07 Apr 6, 2020 - Apr 7, 2020 2 Days GA Atlanta 30309-7705 Atlanta Register Now

  2020-05-07 2020-05-08 May 7, 2020 - May 8, 2020 2 Days NY New York 10019 New York Register Now

2345.00 $
Close