LRN0060 - Introduction to Data Analysis

Course Description

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies produce vast amounts of data, but it is rare to have someone with the ability to analyze that data, see trends, and make predictions. This course will give you 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 you start on that journey.

Note: This course is part of a Digital Badge for those who wish to earn a credential. You may register for this individual class, but if If you would like to earn the Digital Badge, register for LRN0059 - Online Self-Paced Data Analysis Digital Badge.

Students need to have Microsoft Excel to complete this certificate. 

Course Outline

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

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

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

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

About Your Instructor:

 

With over 25 years’ experience in transforming data, John Rutledge has worked with a variety of companies to analyze their data and help make business decisions.  From implementing systems that perform data collection to scrubbing existing data and performing analysis, John has been involved in all levels of data management.  Currently the owner of a Consultancy firm, John works regularly with businesses of all sizes assisting them in understanding and managing their data.  He is familiar with many analysis and reporting tools that are used to distill complex amounts of data down to a level that can be used to make decisions at an Executive or Business Unit level.

Learner Outcomes

• The student will be able to distinguish between quantitative and qualitative data and give examples of a variety of sources of that data.
• The student will discover a number of different Statistical methods and identify methods of sorting, filtering and categorizing that data.
• The student 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 student will be able to effectively summarize the results of their analysis and describe how these results are meaningful in a business context.

Notes

Students need to have Microsoft Excel to complete this certificate.

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.

Testimonials

Applies Towards the Following Digital Badges

• Data Analysis Digital Badge- Online : Required Courses