Skip to content

Pages

Courses

ALL COURSES

Resources

ALL RESOURCES

Blogs

ALL BLOGS
Use coupon code LEARN21 at checkout for 21% off any course. Valid through 6/30/21.
*Offer excludes Scaled Agile (SAFe®) courses and private team training.

Introduction to Data Analysis

For those with little or no experience analyzing and manipulating data, this course quickly equips you with fundamental techniques to use data for better decisions.

Data analysis and analytics are evolving disciplines. We constantly hear about big data, prediction, AI, and modeling techniques.

However, advanced techniques rest on fundamentals which can be applied in many job roles. This class quickly equips you with that foundation. Whether you're charting your overall business intelligence strategy or performing analysis yourself, these basic tools and techniques rapidly inform effective decision-making. In this fast-paced introductory workshop, we'll examine the history of business intelligence, its relationship to data analysis, and why the two are needed to help businesses deliver a complete assembly of the 'data puzzle'. We'll also address hurdles teams face when dealing with data overload and suggests some possible solutions.

Amid an ongoing explosion of data, there's also a greater need to understand who is qualified to correctly analyze data. We will explore the qualifications of data analysts as well as the analytic tools available for those people to use associated with the position.

Please note: Exercises in this course are not compatible with Excel in a web browser. Please make sure you have a version of Excel locally downloaded on your computer or access to Excel via Microsoft 365.

This course has been submitted, reviewed, and approved by the International Institute of Business Analysis (IIBA) to award CDUs for attendance.

Available formats for this course
In-Person
Live Online
Private Team Training
Duration
2 days/16 hours of instruction
Education Credits
14 PDUs
10 Strategy PDUs
4 Technical PDUs
14 PDUs
Public Classroom Pricing

Starting at: $1295(USD)

$1650(CAD)

GSA Price: $1185

Group Rate: $1195

Get the full details on this course. Download the .PDF Brochure below:

Part 1: Data and Information

  1. Data in the Real World
  2. Data vs. Information
  3. The Many “Vs” of Data
  4. Structured Data and Unstructured Data
  5. Types of Data

Part 2: Data Analysis Defined

  1. Why do we analyze data?
  2. Data Analysis Mindset
  3. Data Analysis Steps
  4. Data Analysis Defined
  5. Descriptive Statistics vs Inferential Statistics

Part 3: Types of Variables

  1. Categorical vs Numerical
  2. Nominal Variables
  3. Ordinal Variables
  4. Interval Variables
  5. Ratio Variables

Part 4: Central Tendency of Data

  1. (Arithmetic) Mean
  2. Median
  3. Mode

Part 5: Basic Probability

  1. Probability Uses In Business
  2. Ways We Can Calculate Probability
  3. Probability Terms
  4. Calculating Probability
  5. Calculating Probability from a Contingency Table
  6. Conditional Probability
  7. Frequency Distribution

Part 6: Distributions, Variance, and Standard Deviation

  1. Discrete Distributions
  2. Continuous Distributions
  3. Range
  4. Quartiles
  5. Variance
  6. Standard Deviation
  7. Population vs. Sample
  8. Application of the Standard Deviation
    • Standard Deviation and the Normal Distribution
    • Sigma (σ) Values (Standard Deviations)
  9. Bimodal distribution
  10. Skew and Summary
  11. Other Distributions
    • Poisson Distribution
    • Exponential Distribution
    • Pareto Distribution (“80/20”)
    • Log Normal Distribution
  12. Distributions in Excel
     

Part 7: Fitting Data

  1. Bivariate Data (Two Variables)
  2. Covariance and Correlation
  3. Simple Linear Regression
  4. Linear Regression
  5. Fitting Functions
    • Linear Fit
    • Polynomial Fit
    • Power-Law Fit

Part 8: Predictive Analytics Overview

  1. Monte Carlo Method

Anyone involved in operations, project management, business analysis, or management who needs an introduction to data analysis, would benefit from this class. Please note: Exercises in this course are not compatible with Excel in a web browser. Please make sure you have a version of Excel locally downloaded on your computer or access to Excel via Microsoft 365.

Professionals who may benefit include:

  • Business Analyst, Business Systems Analyst, Staff Analyst
  • Those interested in CBAP®, CCBA®®, or other business analysis certifications
  • Systems, Operations Research, Marketing, and other Analysts
  • Project Manager, Team Leads, Project Leads, Project Assistants, Project Coordinators
  • Those interested in PMP®, CAPM®, or other project management certifications
  • Program Managers, Portfolio Managers, Project Management Office (PMO) staff
  • Data Modelers and Administrators, DBAs
  • Technical & other Subject Matter Experts (SMEs)
  • IT Staff, Manager, VPs
  • Finance Staff, Manager
  • Operations Analyst, Supervisor
  • External and Internal Consultants
  • Risk Managers, Operations Risk Professionals
  • Operations Managers, Line Managers, Operations Staff
  • Process Improvement, Compliance, Audit, & other Governance Staff
  • Thought Leaders, Transformation & Change Champions, Change Manager
  • Executives, Directors, & other senior staff exploring cost reduction and process improvement options
  • Executive and Administrative Assistants and Coordinators
  • Job seekers and those who want to show dedication to data analysis and process improvement
  • Leaders at all levels who wish to increase their Data Analysis capabilities

  • Measure business performance.
  • Identify improvement opportunities for business processes.
  • Describe the need for tracking and identifying the root causes of deviation or failure.
  • Use the principles, properties, and application of Probability Theory.
  • Discuss data distribution including central tendency, variance, normal distribution, and non-normal distributions.
  • Draw conclusions about a data population using statistical inference.
  • Forecast trends using simple linear regression analysis.
  • Perform accurate analysis after learning about sample sizes and confidence intervals and limits, and how they influence the accuracy of your analysis.
  • Explore different methods and easy algorithms for forecasting future results and to reduce current and future risk.

Introduction to Data Analysis Schedule

Location
Date
Register
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNV1ZQAX', 'startDate' => '2021-05-18', 'startTime' => '8:30 AM', 'endDate' => '2021-05-19', 'endTime' => '4:30 PM', 'name' => '290004VCL02', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
May 18th - 19th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNV3MQAX', 'startDate' => '2021-06-01', 'startTime' => '8:30 AM', 'endDate' => '2021-06-02', 'endTime' => '4:30 PM', 'name' => '290004VCL03', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Jun 1st - 2nd 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNV5KQAX', 'startDate' => '2021-07-08', 'startTime' => '8:30 AM', 'endDate' => '2021-07-09', 'endTime' => '4:30 PM', 'name' => '290005VCL02', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Jul 8th - 9th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNV64QAH', 'startDate' => '2021-08-23', 'startTime' => '8:30 AM', 'endDate' => '2021-08-24', 'endTime' => '4:30 PM', 'name' => '290005VCL03', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Aug 23rd - 24th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNTstQAH', 'startDate' => '2021-09-13', 'startTime' => '8:30 AM', 'endDate' => '2021-09-14', 'endTime' => '4:30 PM', 'name' => '290005VCL', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Sep 13th - 14th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNTtyQAH', 'startDate' => '2021-10-04', 'startTime' => '8:30 AM', 'endDate' => '2021-10-05', 'endTime' => '4:30 PM', 'name' => '290006VCL', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Oct 4th - 5th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNTuxQAH', 'startDate' => '2021-11-15', 'startTime' => '8:30 AM', 'endDate' => '2021-11-16', 'endTime' => '4:30 PM', 'name' => '290006VCL02', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Nov 15th - 16th 8:30 AM - 4:30 PM ET
$1295(usd)
CPSFDC\Entity\Session::__set_state(array( 'entitySanitizer' => 'CPSFDC\\Utils\\Sanitizers\\SessionSanitizer', 'sfId' => 'a011G00000VNTw4QAH', 'startDate' => '2021-12-07', 'startTime' => '8:30 AM', 'endDate' => '2021-12-08', 'endTime' => '4:30 PM', 'name' => '290006VCL03', 'standardCourseFee' => '1295', 'standardCourseFeeCAD' => '1650', 'courseId' => 'DATALYTICS', 'course' => 'a00370000029ukmAAA', 'courseSfId' => 'a00370000029ukmAAA', 'courseName' => 'Introduction to Data Analysis', 'instructorId' => '85388', 'instructorSfId' => 'a0237000001Y4RDAA0', 'instructorDisplayName' => 'TBD', 'instructorName' => 'TBD', 'locationCode' => 'VCL', 'sessionStatus' => 'O', 'city' => 'Live Online Training', 'state' => '', 'cityState' => 'Live, Online Training', 'locationSfId' => 'a0637000000tn2hAAA', 'subjectSfId' => 'a051G00000Jso3oQAB', 'subjectName' => 'Data & Analytics', 'specialitySfId' => 'a051G00000Jso3yQAB', 'specialityName' => 'Analytics & Data Science', 'expertiseSfId' => 'a051G00000JsoCGQAZ', 'expertiseName' => NULL, 'certificationSfId' => NULL, 'certificationBody' => '', 'certificationName' => '', 'pdus' => '14', 'deliveryModalities' => 'In-Person;Live Online', 'fullFacilityAddress' => 'Live Instructor-Led Online Training
Please call Cprime for location details
at 1-877-800-5221
, LOL', 'gtr' => '', ))
Live, Online Training
Dec 7th - 8th 8:30 AM - 4:30 PM ET
$1295(usd)

Request Private Team Training