×
Phoenix TS

Data Analysis Level 1 Training

This course will introduce students to data analysis, modeling, and spreadsheet usage to make informed decisions.

BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!

Course Overview

This 3 -day instructor led course introduces the necessary core quantitative methods and the foundations for statistical methodologies used in data analytics. Statistical software and the use of spreadsheets are integrated throughout so that students better comprehend the importance of using technological tools for effective model building and decision-making. This course is data-oriented, exposing students to basic statistical methods, their conceptual underpinning, such as variability and uncertainty, and their use in the real world. Topics include data collection, descriptive statistics, elementary probability rules and distributions, statistical inferences, break-even analysis, regression analysis, and introduction to predictive modeling and optimization models.

There are no prerequsites for this course.

Course Objectives

At the end of this training course, participants will be able to do the following:

  • To improve analytical thinking and develop effective problem-solving strategies and validation techniques for different problem situations.
  • To familiarize students with useful, efficient, and proper methodologies for summarizing and communicating quantitative and qualitative data in Excel.
  • To build statistical models replicating the real-life situation as closely as possible and to formulate appropriate hypothesis given the context
  • To help students acquire effective modeling skills in designing and implementing readable and reliable spreadsheet models.
  • To teach students how to interpret the results of statistical tests and decision models, and to use them in making decisions.
  • To develop one’s ability and confidence in effectively communicate analytical, quantitative, and statistical concepts.

Schedule

Currently, there are no public classes scheduled. Please contact a Phoenix TS Training Consultant to discuss hosting a private class at 301-258-8200.

[image]

Not seeing a good fit?

Let us know. Our team of instructional designers, curriculum developers, and subject matter experts can create a custom course for you.

Contact Us

Learn more about custom training

Course Outline

Module 1: Introduction to The Course


• Introduction to Analytics
• Different Types of Analytics
• Why are There So Many Different Methods?
• Terminology and Notation
• Core Ideas in Data Analytics
• The Steps in Data Analytics Projects


Module 2: Data Exploration• Introduction to Statistics


• Variable Types
• Summarizing Data
• Descriptive Statistics: Measures of Central Tendency
• Descriptive Statistics: Measures of Variation
• Statistical Displays: Histograms and Boxplots


Module 3: Excel for Data Analysis


• Introduction to Excel
• Sort/Filter/Conditional Formatting
• Pivot Tables
• Data Visualization


Module 4: Breakeven Analysis


• Linear Functions
• Revenue and Cost Models
• Exponential Functions
• Curve Fitting
• What-If Analysis / Goal Seek


Module 5: Time Value of Money


• Basics of lending and borrowing.
• Interest
• Present and future value of investments
• Simple Interest
• Compound Interest


Module 6: Probability Models


• Basic Principles
• Conditional Probability
• Discrete Random Variables
• Continuous Random Variables
• Normal Distribution
• Z-score
• Outlier Detection Method


Module 7: Statistical Inferences

• Sampling Types / Survey Errors
• Confidence Intervals
• t-Distribution
• Introduction to Hypothesis Testing
• Single Sample t-Test
• Type I/II Errors

BONUS! Cyber Phoenix Subscription Included: All Phoenix TS students receive complimentary ninety (90) day access to the Cyber Phoenix learning platform, which hosts hundreds of expert asynchronous training courses in Cybersecurity, IT, Soft Skills, and Management and more!

Phoenix TS is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints re-garding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: www.nasbaregistry.org

Subscribe now

Get new class alerts, promotions, and blog posts

Phoenix TS needs the contact information you provide to us to contact you about our products and services. You may unsubscribe from these communications at anytime. For information on how to unsubscribe, as well as our privacy practices and commitment to protecting your privacy, check out our Privacy Policy.

Download Course Brochure

Enter your information below to download this brochure!

Name(Required)