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

One month course; John Rutledge, instructor

Agenda

Unit 1
Understanding Data

Identify sources of Data

Discover methods of Collecting Data

Examine Quantitative Data

Examine Qualitative Data

Unit 2
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 3
Analyzing Data

Discuss Probability and the Normal Distribution

Perform Trend Analysis

Perform Breakeven Analysis

Understand basic Statistical Modelling

Unit 4

Interpreting and Presenting Results

Design Professional-looking Tables

Generate Effective Charts

Create Pivot Tables and Pivot Charts

Compile a Dashboard for Management

About online learning

Online learning is a fun, enjoyable and very productive way to learn. Millions of people are learning online each year. You will engage with the instructor and other participants. You will get to know your instructor and other participants. You may make friends. It’s easy. It’s fun.

How the Course Works

It is easy to participate in your online course. After you register, you will be given a web address to go to get into your online classroom. You will have a password and use your email address and password to gain access.

Once inside the online classroom, here’s what you can expect.

Participate when you want

You can participate any time of day or evening. The online classroom is open 24 hours a day, 7 days a week.
There are no live real-time requirements or meetings. You decide when you participate.
For the best learning, participants should log into the course on 2-3 different days of the week.

What you will do

For each Unit, you will:

Read the print readings (about 20 pages a week)

Have the option of accessing the online readings

Listen to the audio presentation for the Unit and view the slides

Have the option of taking a self-quiz to see how much you have learned

Engage in written online discussion with your instructor and other participants

For best learning, you should make one or more comments at 2-3 different times each week.
The content (readings, audio lectures, slides) and self-quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience.

Discussion

The Discussion for each Unit lasts one week. All comments are made in writing and can be made at any time of the day or night.

Your instructor will log into the Discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants.

We encourage you to make 2-3 comments each week to maximize your learning and enjoyment of the course.

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.

What some students say:

“It was challenging and informative. I learned a great deal in the course that can be immediately applied in my job. Thank you”-Brenda Kohl, Cincinnati, OH

"The ability to log on at odd hours was incredibly valuable to me! This course was just what I had hoped for. Thank you, John." -James Martin, Dallas, TX

"This was a terrific course. I found myself excited to start studying each day. It explained all aspects of the course clearly." -Brenda Green, Durham, NC

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.

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