Data Analyst Training Courses Icon

Data Analysis Boot Camp


3 Days
Classroom Session   |  
4 Days
Live Online

IIBA (CDU)

ASPE is an IIBA Endorsed Education Provider of business analysis training. Select Project Delivery courses offer IIBA continuing development units (CDU) in accordance with IIBA standards.

NASBA (CPE)

NASBA continuing professional education credits (CPE) assist Certified Public Accountants in reaching their continuing education requirements.

PMI (PDU)

Select courses offer Leadership (PDU-L), Strategic (PDU-S) and Technical PMI professional development units that vary according to certification. Technical PDUs are available in the following types: ACP, PBA, PfMP, PMP/PgMP, RMP, and SP.

NASBA
NASBA
24.00 CPEs
PMI
PMP/PgMP
21.00 T-PDUs

Expertise Level: Intermediate
Certification
Classroom Registration Fees
Individual:
$1995.00
Group Rate:
$1795.00
(per registrant, 2 or more)
GSA Individual:
$1456.35
Live Online Registration
Live Online:
$1995.00
Private Onsite Package

This course can be tailored to your needs for private, onsite delivery at your location.

Learn More About Enterprise Team Training

Overview

This course, organized into key topic areas, leverages straightforward business examples to explain practical techniques for understanding and reviewing data quality and how to translate data into analysis of business problems to begin making informed, intelligent decisions.Get an overview of data quality and data management, followed by foundational analysis and statistical techniques. Throughout the course, you will learn to communicate about data and findings to  stakeholders who need to quickly make the decisions that drive your organization forward. 

This data analysis training class is a lively blend of expert instruction combined with hands-on exercises so you can practice new skills. Leave prepared to start performing practical analysis techniques the moment you return to work.

InformsTechtown Training is proud to announce that we are an offical Registered Education provider (REP) with Informs® for the Certified Analytics Professional (CAP®) Exam.

Identify opportunities, manage change and develop deep visibility into your organization
Understand the terminology and jargon of analytics, business intelligence and statistics
Learn a wealth of practical applications for applying data analysis capability
Visualize both data and the results of your analysis for straightforward graphical presentation to stakeholders
Learn to estimate more accurately than ever, while accounting for variance, error, and Confidence Intervals
Practice creating a valuable array of plots and charts to reveal hidden trends and patterns in your data
Differentiate between "signal" and "noise" in your data
Understand and leverage different distribution models, and how each applies in the real world
Form and test hypotheses – use multiple methods to define and interpret useful predictions
Learn about statistical inference and drawing conclusions about the population
Upcoming Dates and Locations
Guaranteed To Run
May 15, 2017 – May 18, 2017    12:00pm – 4:30pm Live Online
12:00pm – 4:30pm
Register
May 22, 2017 – May 24, 2017    8:30am – 4:30pm San Francisco, California

Learn IT
33 New Montgomery St.
Suite 300
San Francisco, CA 94105
United States

Register
Jun 5, 2017 – Jun 7, 2017    8:30am – 4:30pm Chicago, Illinois

Microtek Chicago
230 W. Monroe
Suite 900
Chicago, IL 60606
United States

Register
Jun 5, 2017 – Jun 7, 2017    9:30am – 5:30pm Live Online
9:30am – 5:30pm
Register
Jun 19, 2017 – Jun 21, 2017    8:30am – 4:30pm Kansas City, Kansas

Centriq Training
8700 State Line Road
Suite 200
Leawood, KS 66206
United States

Register
Jul 10, 2017 – Jul 12, 2017    8:30am – 4:30pm Live Online
8:30am – 4:30pm
Register
Jul 10, 2017 – Jul 12, 2017    8:30am – 4:30pm Columbia, Maryland

Homewood Suites by Hilton
8320 Benson Drive

Columbia, MD 21045
United States

Register
Jul 24, 2017 – Jul 26, 2017    8:30am – 4:30pm San Jose, California

Doubletree Hotel San Jose
2050 Gateway Place

San Jose, CA 95110
United States

Register
Aug 7, 2017 – Aug 9, 2017    8:30am – 4:30pm Atlanta, Georgia

Microtek Atlanta
1000 Abernathy Rd. NE Ste 194
Northpark Bldg 400
Atlanta, GA 30328
United States

Register
Aug 14, 2017 – Aug 16, 2017    8:30am – 4:30pm Live Online
8:30am – 4:30pm
Register
Aug 21, 2017 – Aug 23, 2017    8:30am – 4:30pm Detroit, Michigan

Courtyard Detroit Livonia
17200 N Laurel Park Drive

Livonia, MI 48152
United States

Register
Sep 11, 2017 – Sep 13, 2017    8:30am – 4:30pm Baltimore, Maryland

Hilton Garden Inn BWI Airport
1516 Aero Drive

Linthicum Heights, MD 21090
United States

Register
Sep 25, 2017 – Sep 27, 2017    8:30am – 4:30pm Denver, Colorado

Microtek Denver
999 18th Street
Suite 300 South Tower
Denver, CO 80202
United States

Register
Sep 25, 2017 – Sep 27, 2017    10:30am – 6:30pm Live Online
10:30am – 6:30pm
Register
Oct 9, 2017 – Oct 11, 2017    8:30am – 4:30pm Minneapolis, Minnesota

Embassy Suites Airport
7901 34th Avenue South

Bloomington, MN 55425
United States

Register
Oct 30, 2017 – Nov 1, 2017    8:30am – 4:30pm Live Online
8:30am – 4:30pm
Register
Oct 30, 2017 – Nov 1, 2017    8:30am – 4:30pm Raleigh, North Carolina

ASPE Training
114 Edinburgh South Dr
Suite 200
Cary, NC 27511
United States

Register
Nov 6, 2017 – Nov 8, 2017    8:30am – 4:30pm Phoenix, Arizona

Dynamic Worldwide
4500 S. Lakeshore Dr
Suite 600
Tempe, AZ 85282
United States

Register
Nov 6, 2017 – Nov 8, 2017    10:30am – 6:30pm Live Online
10:30am – 6:30pm
Register
Nov 27, 2017 – Nov 29, 2017    8:30am – 4:30pm Saint Louis, Missouri

Saint Louis University - Workforce Ctr
3545 Lindell Blvd.
2nd Floor Wool Center
Saint Louis, MO 63103
United States

Register
Course Outline

1. Data Fundamentals

Course Overview and Level Set

  • Objectives of the class
  • Expectations for the class

Understanding "real-world" data

  • Unstructured vs. structured
  • Relationships
  • Outliers
  • Data growth

Types of Data

  • Flavors of data
  • Sources of data
  • Internal vs. external data
  • Time scope of data (lagging, current, leading)

LAB: Getting started with our classroom data 

Data-related Risk

  • Common identified risks
  • Effect of process on results
  • Effect of usage on results
  • Opportunity costs, Tool investment
  • Mitigating common risks

Data Quality

  • Cleansing
  • Duplicates
  • SSOT
  • Field standardization
  • Identifying sparsely populated fields
  • How to fix some common issues

LAB: Data Quality

Relationships

  • Finding common attributes
  • 1:N, N:N, 1:1

LAB: Relationships in a dataset
 

2. Analysis Foundations

Statistical Practices: Overview

  • Comparing programs and tools
  • Words in English vs. data
  • Concepts specific to data analysis

Domains of data analysis

  • Descriptive statistics
  • Inferential statistics
  • Analytical mindset
  • Describing and solving problems

3. Analyzing Data

Averages in data

  • Mean
  • Median
  • Mode
  • Range

Central Tendency

  • Variance
  • Standard deviation
  • Sigma values
  • Percentiles
  • Using these concepts to estimate things

LAB: Hands-On – Central Tendency

LAB: Hands-On – Linear Regression

Overview of commonly useful distributions

  • Probability distribution
  • Cumulative distribution
  • Bimodal distributions
  • Skewness of data
  • Pareto distribution

Correlation

LAB: Distributions

Analytical Graphics for Data

  • Categorical – bar charts
  • Continuous – histograms
  • Time series – line charts
  • Bivariate data – scatter plots
  • Distribution – box plot

4. Analytics & Modeling

ROI & Financial Decisions

Common uses of financial data

  • Earned Value
  • Actual Cost, BAC and EAC
  • Expected Monetary Value
  • Cost Performance/Schedule Performance Index

Common uses for random numbers

  • Sampling
  • Simulation
  • Monte Carlo analysis
  • Pseudo-random sequences

Demo / Lab – Random numbers in Excel

An introduction to Predictive Analytics

  • A discussion about patterns
  • Regression and time series for prediction
  • Machine learning basics
  • Tools for predictive analytics

Demo / Lab – Getting started with R

Understanding Clustering

  • Segmentation
  • Common algorithms
  • K-MEANS
  • PAM

Fundamentals of Data Modeling

  • Architecture and analysis
  • Stages of a data model
  • Data warehousing
  • Top-down vs. Bottom-up

Understanding Data Warehousing

  • Context tables
  • Facts
  • Dimensions
  • Star vs. Snowflake Schema

 

5. Visualizing & Presenting Data

Goals of Visualization

  • Communication and Narrative
  • Decision enablement
  • Critical characteristics

Visualization Essentials

  • Users and stakeholders
  • Stakeholder cheat sheet
  • Common missteps

Communicating Data-Driven Knowledge

  • Alerting and trending
  • To self-serve or not
  • Formats & presentation tools
  • Design considerations

 

Who should attend
  • Business Analyst, Business Systems Analyst, CBAP, CCBA
  • Systems, Operations Research, Marketing, and other Analysts
  • Project Manager, Program Manager, Team Leader, PMP, CAPM
  • Data Modelers and Administrators, DBAs
  • IT Manager, Director, VP
  • Finance Manager, Director, VP
  • Operations Supervisor, Manager, Director, VP
  • Risk Managers, Operations Risk Professionals
  • Process Improvement, Audit, Internal Consultants and Staff
  • Executives exploring cost reduction and process improvement options
  • Job seekers and those who want to show dedication to process improvement
  • Senior staff who make or recommend decisions to executives
Pre-Requisites

If you have basic familiarity with Excel, this three-day course can teach you practical applied analysis techniques to leverage data for relatively common decision making methods.

Yes, this course looks perfect for my needs!

Download the brochure