CompTIA Data Analysis Essentials V1

Price
$99.00 USD

Duration
1 Day

Delivery Methods
Virtual Instructor Led
Private Group

Request More Information

Download Course Details

Course Details Only
Course Details & Schedule

Skip to Class Dates

Course Overview

CompTIA Data Analysis Essentials is a focused course that guides learners through a practical data-analysis workflow, from defining a business objective and structuring source data to cleaning, combining, analyzing, visualizing, validating, and sharing results. Learners practice with common metrics, data types, formulas, pivot tables, charts, slicers, dashboards, and data-protection techniques.

The course uses practice activities and an applied case study to help learners translate business questions into data definitions, identify trends, create reusable calculations, and package analysis for handoff.

Course Objectives

Define an analysis objective and translate business questions into data definitions.
Identify needed datasets, sources, metrics, data types, and formats.
Import, structure, clean, reshape, join, and stack data.
Apply aggregate calculations, descriptive formulas, conditional logic, dynamic formulas, and named ranges.
Summarize data using pivot tables and communicate findings using appropriate charts.
Build interactive dashboards using pivots, charts, and slicers.
Validate data, identify errors, and mask sensitive information.
Document, package, export, permission, and hand off analysis results.

Who Should Attend?

Professionals who work with business data and spreadsheets
Business analysts, operations professionals, and project team members
Marketing, sales, finance, and administrative professionals responsible for reporting
Early-career data professionals seeking a practical workflow foundation
Anyone who needs to clean, analyze, visualize, and share data effectively

Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Learning Credits: Learning Credits can be purchased well in advance of your training date to avoid having to commit to specific courses or dates. Learning Credits allow you to secure your training budget for an entire year while eliminating the administrative headache of paying for individual classes. They can also be redeemed for a full year from the date of purchase. If you have previously purchased a Learning Credit agreement with New Horizons, you may use a portion of your agreement to pay for this class.

If you have questions about Learning Credits, please contact your Account Manager.

Corporate Tech Pass: Our Corporate Tech Pass includes unlimited attendance for a single person, in the following Virtual Instructor Led course types: Microsoft Office, Microsoft Technical, CompTIA, Project Management, SharePoint, ITIL, Certified Ethical Hacker, Certified Hacking Forensics Investigator, Java, Professional Development Courses and more. The full list of eligible course titles can be found at https://www.newhorizons.com/eligible.

If you have questions about our Corporate Tech Pass, please contact your Account Manager.

Course Prerequisites

No advanced data-analysis experience is required. Basic familiarity with spreadsheets, tables, formulas, and common workplace data will help learners complete the activities.

Agenda

Course Introduction

Getting Started
Course Introduction
How to Use This Course
Activity: Pre-Assessment

Setting Up Your Data Project

Defining the Analysis Objective
Why Defining Your Objective is Critical...and Hard
Turning Business Questions Into Data Definitions
Practice: Translating Two Business Questions
Identifying Needed Datasets and Sources
Common Metrics and Data Sources
Identify Key Metrics and Sources
Case Study Introduction
Case Study: Defining a Data Project
Importing and Structuring Data
Importing Data
Converting Raw Data into Tables and Ranges
Understanding Different Data Types
Set Correct Data Types and Formats
Case Study: Import Data
Module 2 Review

Cleaning and Combining Data

Cleaning Data
Introduction to Cleaning Data
Common Data Issues
Practice Cleaning Data
Case Study: Cleaning the Dataset
Reshaping Your Data to be Useful
Introduction to Reshaping Data
Common Scenarios for Reshaping Columns
Activity: When to Reshape Columns
Practice: Reshaping Data
Case Study: Reshaping the Data
Combining Datasets
Introduction to Combining Data Sets
Practice: Joining Data
Common Joining Errors
Stacking Data
Case Study: Join Datasets
Module 3 Review

Core Analyses and Calculations

Aggregate and Descriptive Calculations
Introduction to Aggregate and Descriptive Calculations
Common Aggregate and Descriptive Formulas
Using Aggregate and Descriptive Calculations
Case Study: Find Key Metrics and Trends
Conditional Logic
Introduction to Conditional Logic
Common Logic Scenarios
Activity: Common Logic Scenarios
Practice: Using Conditional Logic
Case Study: Applying Conditional Logic
Dynamic Formulas and Named Ranges
Introduction to Dynamic Formulas
Reference Guide
Creating Reusable Formulas
Case Study: Build Reusable Calc Set
Module 4 Review

Summarizing and Visualizing Data

Pivot Tables
Introduction to Pivot Tables
When to Use Pivots vs. Simple Totals
Activity: Building a Pivot Table
Practice: Using Pivot Tables
Case Study: Explore Data with Pivots and Charts
Standard Charts and Customization
Introduction to Charts
Chart Selection and Design Checklist
Activity: Explore Different Types of Charts
Practice Creating Charts
Case Study: Building Charts
Interactive Dashboards with Slicers
Introduction to Interactive Dashboards
Dashboard and Slicer Best Practices
Combine Pivots, Charts, and Slicers
Case Study: Build an Interactive Dashboard
Module 5 Review

Data Integrity, Ethics and Sharing Results

Validate and Safeguard Data
Introduction to Validating and Protecting Data
Practice: Validation Rules and Quick Masking
Case Study: Spot and Fix Errors
Practice: Identify and Mask Sensitive Data
Document, Package and Share Results
Documenting and Sharing Your Analysis
Export Dashboard, Set Permissions
Practice: Package and Hand-Off Analysis
Module 6 Review

Get in touch to schedule training for your team
We can enroll multiple students in an upcoming class or schedule a dedicated private training event designed to meet your organization’s needs.

CourseID: 3607031E