Microsoft Excel Data Analysis Boot Camp

3 Day Course

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

In this course, you will gain practical and useful data analysis skills! You will learn to communicate efficiently regarding data and findings to stakeholders who need to make decisions quickly. An overview of data quality and data management will be provided, followed by foundational analysis and statistical techniques. This course provides straightforward business examples, and hands on exercises, to gain a good understanding of practical techniques for understanding and reviewing data quality.

COURSE CONTENT

DATA FUNDAMENTALS

• Course Overview

• Understanding “Real-World” Data

          ▪ Unstructured vs. Structured

          ▪ Relationships

          ▪ Outliers

          ▪ Data growth

• Types of Data

          ▪ Types of Data

          ▪ Sources of Data

          ▪ Internal vs. External Data

          ▪ Time Scope of Data (Lagging, Current, Leading)

• Data-Related Risk

          ▪ Common Identified Risks

          ▪ Effect of Process on Results

          ▪ Effect of Usage on Results

          ▪ Opportunity Costs, Tool Investment

          ▪ Mitigation of Risk

• Data Quality

          ▪ Cleansing

          ▪ Duplicates

          ▪ SSOT

          ▪ Field standardization

          ▪ Identify sparsely populated fields

          ▪ How to fix common issues

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

ANALYZING DATA

• Averages in Data

          ▪ Mean

          ▪ Median

          ▪ Mode

          ▪ Range

• Central Tendency

          ▪ Variance

          ▪ Standard Deviation

          ▪ Sigma Values

          ▪ Percentiles

          ▪ Use Concepts for Estimating

• Analytical Graphics for Data

• Categorical

          ▪ Bar Charts

• Continuous

          ▪ Histograms

• Time Series

          ▪ Line Charts

• Bivariate Data

          ▪ Scatter Plots

• Distribution

          ▪ Box Plot

ANALYTICS & MODELING

• Overview of Commonly Useful Distributions

          ▪ Probability Distribution

          ▪ Cumulative Distribution

          ▪ Bimodal Distributions

          ▪ Skewness of Data

          ▪ Pareto Distribution

          ▪ Correlation

• Understanding Clustering

• Segmentation

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

Register
Price
Quantity
Total
  • 4 or more Course Participants
    $897
    +$116.61 HST
    $897
    +$116.61 HST
    0
    $0
  • 2 - 3 Course Participants
    $1,197
    +$155.61 HST
    $1,197
    +$155.61 HST
    0
    $0
  • Course Calendar Date Pricing
    $897
    +$116.61 HST
    $897
    +$116.61 HST
    0
    $0
  • 1 on 1 Training
    $1,497
    +$194.61 HST
    $1,497
    +$194.61 HST
    0
    $0
Total$0

Share This Event