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

5
(60 reviews)
  • Live Online
  • At Your Company Location

Course Scheduling & Pricing

Home>Course Topic>Analytical Skills>Data Analysis Fundamentals: A Hands-On Workshop

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.

  •   Live Online2 Day(s)
    1.2 CEU, 12 CLP, 12 PDCs, 12 PHR, 12 PMU, 12 SPHR
 
 

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: MS Windows-based laptop with working browser to connect to the Internet via WiFi network; as well as a minimum of Excel 2019 or 365 for PC installed.

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

View a Sample of Our Reviews

5

60 reviews

 
The overall course and the instructor were very good. It was interactive and information.
5
Sangeeta M.
 
Communications & Recognition Manager
 
Industry: Business Services
I learned so much regarding both methods and Excel skills. It was a lot of new information that I am eager to implement in my role.
5
Jessica H.
 
Inventory Analyst
 
Industry: Media & Internet
I enjoyed this class very much! I have learned more than I thought I would. The instructor was very thorough and helpful throughout the entire class.
5
Christina B.
 
Operations Manager
 
Industry: Manufacturing
Learned a lot, facilitator was very approachable and knowledgeable
5
Adam G.
 
Business Analyst
 
Industry: Finance
The instructor was very knowledgeable about the topic of data analysis. He gave good practical examples of application. The pace and style was excellent. The discussions were well conducted. He followed up to make sure we were all on the same page through out the course.
5
Phyllis P.
 
Senior Human Resources Assistant
 
Industry: Finance

This course is valid for 12 PMUs.
2 Professional Effectiveness [PE]
10 Analytical Intelligence [AI]

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.

Live Online Schedule

5 Sessions Available

2595.00 $
Close