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