5X����

Course Overview

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. This course will give participants a basic understanding of how to analyze data in a business setting. Businesses look for candidates with an understanding of how to analyze the data they have been collecting; this course will help participants start on that journey.

Course Outcomes

• The participant will be able to distinguish between quantitative and qualitative data and give examples of a variety of sources of that data
• The participant will discover a number of different Statistical methods and identify methods of sorting, filtering and categorizing that data
• The participant will be able to compare and contrast the results of their analysis to “normal” results and be able to draw conclusions from those comparisons that are supported by the data
• The participant will be able to effectively summarize the results of their analysis and describe how these results are meaningful in a business context

Course Objectives

• Acquire the ability to identify potential sources of data and distinguish between quantitative and qualitative data
• Learn to identify and describe a variety of analysis tools that will assist in processing data
• Demonstrate basic data analysis techniques and show how this analysis can contribute to a business’ future growth
• Learn how to effectively communicate the results of your analysis

Agenda

Unit One – Understanding Data

• Identify sources of Data
• Discover methods of Collecting Data
• Examine Quantitative Data
• Examine Qualitative Data

Unit Two – Processing Data

• Introduction to Statistics
• Determine the Appropriate Statistical Method for use in various scenarios
• Identify methods of Sorting and Filtering Data
• Categorize Data

Unit Three – Analyzing Data

• Discuss Probability and the Normal Distribution
• Perform Trend Analysis
• Perform Breakeven Analysis
• Understand basic Statistical Modeling

Unit Four – Interpreting and Presenting Results

• Design Professional-looking Tables
• Generate Effective Charts
• Create Pivot Tables and Pivot Charts
• Compile a Dashboard for Management