Overview

CompTIA's Data+ Certification is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making.

The exam will certify the successful candidate has the knowledge and skills required to transform business requirements in support of data-driven decisions by:

  • Mining data

  • Manipulating data

  • Applying basic statistical methods

  • Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle

Read more +

Prerequisites

  • To ensure your success in this course, you should have 18–24 months of hands-on experience working in a business intelligence, report/data analyst job role.

  • You should have a working knowledge of Microsoft Excel or a spreadsheet program.

  • You should understand how to build basic math calculations, like add, subtract, divide, and multiply (basic arithmetic).

  • You should know how to build basic functions like Sums, Average, and Count.

  • You should understand the basics of sorting and filtering data sets in Excel or a similar spreadsheet program.

  • You should have a working knowledge of how to build very basic pivot tables.

  • You should have some understanding of databases and all knowledge toward understanding how databases designed will be helpful.

  • You should have a basic understanding of how to build simple charts in using data.

Read more +

Delegates will learn how to

This course can benefit you in two ways. If you intend to pass the CompTIA Data+(Exam DA0-001) certification examination, this course can be a significant part of your preparation. But certification is not the only key to professional success in the field of data analysis. Today's job market demands individuals with demonstrable skills, and the information and activities in this course can help you build your data skill set so that you can confidently perform your duties in any entry-level data analysis role.

On course completion, you will be able to do the following:

  • Identify basic concepts of data schemas

  • Understand different data systems

  • Understand types and characteristics of data

  • Compare and contrast different data structures, formats, and markup languages

  • Explain data integration and collection methods

  • Identify common reasons for cleansing and profiling data

  • Execute different data manipulation techniques

  • Explain common techniques for data manipulation and optimization

  • Apply descriptive statistical methods

  • Describe key analysis techniques

  • Understand the use of different statistical methods

  • Use the appropriate type of visualization

  • Express business requirements in a report format

  • Design components for reports and dashboards

  • Distinguish different report types

  • Summarize the importance of data governance

  • Apply quality control to data

  • Explain master data management concepts

  • Identify common data analytics tools

Read more +

Outline

Lesson 1: Identifying Basic Concepts of Data Schemas

Topic 1A: Identify Relational and Non-Relational Databases

Topic 1B: Understand the Way We Use Tables, Primary Keys, and Normalization

Lesson 2: Understanding Different Data Systems

Topic 2A: Describe Types of Data Processing and Storage Systems

Topic 2B: Explain How Data Changes

Lesson 3: Understanding Types and Characteristics of Data

Topic 3A: Understand Types of Data

Topic 3B: Break Down the Field Data Types

Lesson 4: Comparing and Contrasting Different Data Structures, Formats, and Markup Languages

Topic 4A: Differentiate Between Structured Data and Unstructured Data

Topic 4B: Recognize Different File Formats

Topic 4C: Understand the Different Code Languages Used for Data

Lesson 5: Explaining Data Integration and Collection Methods

Topic 5A: Understand the Processes of Extracting, Transforming and Loading Data

Topic 5B: Explain API/Web Scraping and Other Collection Methods

Topic 5C: Collect and Use Public and Publicly Available Data

Topic 5D: Use and Collect Survey Data

Lesson 6: Identifying Common Reasons for Cleansing and Profiling Data

Topic 6A: Learn to Profile Data

Topic 6B: Address Redundant, Duplicated, and Unnecessary Data

Topic 6C: Work with Missing Values

Topic 6D: Address Invalid Data

Topic 6E: Convert Data to Meet Specifications

Lesson 7: Executing Different Data Manipulation Techniques

Topic 7A: Manipulate Field Data and Create Variables

Topic 7B: Transpose and Append Data

Topic 7C: Query Data

Lesson 8: Explaining Common Techniques for Data Manipulation

and Optimization

Topic 8A: Use Functions to Manipulate Data

Topic 8B: Use Common Techniques for Query Optimization

Lesson 9: Applying Descriptive Statistical Methods

Topic 9A: Use Measures of Central Tendency

Topic 9B: Use Measures of Dispersion

Topic 9C: Use Frequency and Percentages

Lesson 10: Describing Key Analysis Techniques

Topic 10A: Get Started with Analysis

Topic 10B: Recognize Types of Analysis

Lesson 11: Understanding the Use of Different Statistical Methods

Topic 11A: Understand the Importance of Statistical Tests

Topic 11B: Break Down the Hypothesis Test

Topic 11C: Understand Tests and Methods to Determine Relationships Between Variables

Lesson 12: Using the Appropriate Type of Visualization

Topic 12A: Use Basic Visuals

Topic 12B: Build Advanced Visuals

Topic 12C: Build Maps with Geographical Data

Topic 12D: Use Visuals to Tell a Story

Lesson 13: Expressing Business Requirements in a Report Format

Topic 13A: Consider Audience Needs When Developing a Report

Topic 13B: Describe Data Source Considerations for Reporting

Topic 13C: Describe Considerations for Delivering Reports and Dashboards

Topic 13D: Develop Reports or Dashboards

Topic 13E: Understand Ways to Sort and Filter Data

Lesson 14: Designing Components for Reports and Dashboards

Topic 14A: Choose Design Elements for Reports/Dashboards

Topic 14B: Utilize Standard Elements for Reports/Dashboards

Topic 14C: Create a Narrative and Other Written Elements

Topic 14D: Understand Deployment Considerations

Lesson 15: Distinguishing Different Report Types

Topic 15A: Understand How Updates and Timing Affect Reporting

Topic 15B: Differentiate Between Types of Reports

Lesson 16: Summarizing the Importance of Data Governance

Topic 16A: Define Data Governance

Topic 16B: Understand Access Requirements and Policies

Topic 16C: Understand Security Requirements

Topic 16D: Understand Entity Relationship Requirements

Lesson 17: Applying Quality Control to Data

Topic 17A: Describe Characteristics, Rules, and Metrics of Data Quality

Topic 17B: Identify Reasons to Quality Check Data and Methods of Data Validation

Lesson 18: Explaining Master Data Management Concepts

Topic 18A: Explain the Basics of Master Data Management

Topic 18B: Describe Master Data Management Processes

Appendix A: Identifying Common Data Analytics Tools

Appendix B: Mapping Course Content to CompTIA Data+ Certification (DA0-001)

Read more +

Why choose QA

CompTIA Data Career Pathway

= Required
= Certification
CompTIA Data Career Pathway
CompTIA Data Career Pathway
Need to know

Frequently asked questions

How can I create an account on myQA.com?

There are a number of ways to create an account. If you are a self-funder, simply select the "Create account" option on the login page.

If you have been booked onto a course by your company, you will receive a confirmation email. From this email, select "Sign into myQA" and you will be taken to the "Create account" page. Complete all of the details and select "Create account".

If you have the booking number you can also go here and select the "I have a booking number" option. Enter the booking reference and your surname. If the details match, you will be taken to the "Create account" page from where you can enter your details and confirm your account.

Find more answers to frequently asked questions in our FAQs: Bookings & Cancellations page.

How do QA’s virtual classroom courses work?

Our virtual classroom courses allow you to access award-winning classroom training, without leaving your home or office. Our learning professionals are specially trained on how to interact with remote attendees and our remote labs ensure all participants can take part in hands-on exercises wherever they are.

We use the WebEx video conferencing platform by Cisco. Before you book, check that you meet the WebEx system requirements and run a test meeting (more details in the link below) to ensure the software is compatible with your firewall settings. If it doesn’t work, try adjusting your settings or contact your IT department about permitting the website.

How do QA’s online courses work?

QA online courses, also commonly known as distance learning courses or elearning courses, take the form of interactive software designed for individual learning, but you will also have access to full support from our subject-matter experts for the duration of your course. When you book a QA online learning course you will receive immediate access to it through our e-learning platform and you can start to learn straight away, from any compatible device. Access to the online learning platform is valid for one year from the booking date.

All courses are built around case studies and presented in an engaging format, which includes storytelling elements, video, audio and humour. Every case study is supported by sample documents and a collection of Knowledge Nuggets that provide more in-depth detail on the wider processes.

When will I receive my joining instructions?

Joining instructions for QA courses are sent two weeks prior to the course start date, or immediately if the booking is confirmed within this timeframe. For course bookings made via QA but delivered by a third-party supplier, joining instructions are sent to attendees prior to the training course, but timescales vary depending on each supplier’s terms. Read more FAQs.

When will I receive my certificate?

Certificates of Achievement are issued at the end the course, either as a hard copy or via email. Read more here.

Let's talk

By submitting this form, you agree to QA processing your data in accordance with our Privacy Policy and Terms & Conditions. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.