iCompetent Logo
Classroom · Instructor-ledIT & SoftwareIntermediateCertificate

Data Analysis and Visualisation

Turning data into decisions. Covers framing the question, data types and quality, descriptive statistics and distributions, comparison and correlation, common statistical traps, chart selection and honest presentation, dashboards, and communicating findings so that they are acted on.

Modules
7
Max students
20
Language
EN

What it usually covers

  1. 1

    Orientation: How Analysis Creates Value

    • The Analysis Workflow from Question to Action
    • Roles, Tools and Data Sources in the Workplace
    • Metrics, Measures and Key Performance Indicators
    • Data Ethics, Privacy and Responsible Use
  2. 2

    Framing and Preparing

    • Starting from the Decision
    • Data Quality and Preparation
    • Cleaning and Transforming Data in Practice
    • Documenting Data: Dictionaries, Lineage and Assumptions
  3. 3

    Analysis and Statistical Care

    • Describing and Comparing
    • Correlation, Causation and Common Traps
    • Segmentation and Drill-Down Analysis
    • Sampling, Confidence Intervals and Margin of Error
    • Testing Changes: Before-and-After and A/B Comparisons
  4. 4

    Working with Analysis Tools

    • Spreadsheet Analysis: Formulas, Lookups and Pivot Tables
    • Querying Data with SQL
    • Time Series: Trends, Seasonality and Moving Averages
    • Simple Forecasting and Regression
  5. 5

    Visualisation and Communication

    • Choosing and Designing Charts
    • Dashboards and Communicating Findings
    • Building Effective Tables and Small Multiples
    • Accessible and Inclusive Visualisation
    • Writing the Analytical Report and Executive Summary
  6. 6

    Applying Analysis at Work

    • Case Study: Diagnosing a Rise in Operating Costs
    • Case Study: Customer Service Performance and Percentiles
    • Case Study: Workforce and Training Data
    • Building and Maintaining an Operational Dashboard
  7. 7

    Consolidation: Quality, Review and Professional Practice

    • Peer Review and Quality Checks for Analysis
    • Handling Challenge, Uncertainty and Conflicting Results
    • Making Recurring Analysis Repeatable
    • Capstone: An End-to-End Analysis Review

This page describes what the training usually covers. Each training provider may change the content, the length and the order to suit the group. Confirm the final content with the training provider before you book.

Code
Type
Classroom
Modules
7
Skill Level
Intermediate
Language
EN
Max Students
20
Certificate
Yes
Assessment
No

Prefer to learn at your own pace?

The same subject as an online course you can start today.

More in IT & Software

Other courses with a trainer in the same subject area.

Reviews

What learners say about Data Analysis and Visualisation.

No reviews yet

Be the first to say what Data Analysis and Visualisation was like.

Sign in to write one. We check every review before it is shown.

Book Now

Is it what you were looking for?

Contact our team to check the course and seat availability in your preferred location

Book Now
Image for the book now section

Get a quote