CompTIA Data+

Video training course for the new CompTIA Data+ exam. This is an early-career data analytics certification for professionals tasked with developing and promoting data-driven business decision-making.

The importance for data analytics continues to grow. As it does, more job roles are required to set context and better communicate vital business intelligence. The data analyst is responsible for collecting, analyzing, and reporting on data that can drive business priorities and lead to intelligent decision-making. CompTIA Data+ validates certified professionals have the skills required to facilitate data-driven business decisions, including:

• Mining data
• Manipulating data
• Applying basic statistical methods
• Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle

CompTIA recommends 18–24 months of experience in a report/business analyst job role, exposure to databases and analytical tools, a basic understanding of statistics, and data visualization experience before attempting this exam but for this course, we presume no previous experience.

Typical job roles you can apply for with this certification include:

• Data Analyst
• Reporting Analyst
• Marketing Analyst
• Business Intelligence Analyst

There is currently a huge shortfall of candidates with data analysis skills and a wide variation in available job titles and responsibilities. The shortfall is ~625K job postings to be filled. There is a lack of consistency in educational program offerings and credentials (until now) and a way to standardize around a set of skills.

• Exam Code – DA0-001

Consider this course if you are interested in learning how to confidently interpret data insights and communicate them in a way that drives the business forward. Job description would be any role that analyzes business-specific data. Individuals likely report data analytics to management on a regular basis on business functions, i.e. they analyze and monitor dashboards, results, and trends.

If you have, or want to develop strong logical and critical thinking skills, if you consider it important to think through things. If you find yourself often asking ‘why?' then you should consider this course. It's particularly suitable to tenacious problem solvers who want data driven solutions to problems.

The course includes full forum support where you can ask the expert your questions and get answers from industry experts and fellow students. It also includes full Excel training and the Microsoft Database Fundamentals course which are optional but recommended. Knowledge of Python is recommended but not necessary.

Reasons to take the CompTIA Data+ include:

• You want to be more efficient at analyzing and interpreting data
• You want to learn how to communicate insights more effectively
• You want to demonstrate my ability to translate data into business intel

This course covers the following areas in detail:

Data Concepts and Environments – identify data schemas and dimensions and understand the difference between common data structures and file formats

Data Mining – explain data acquisition concepts, why you would need to cleanse and profile datasets, execute data manipulation, and understand techniques for data manipulation

Data Analysis – apply the appropriate descriptive statistical methods and summarize types of analysis and critical analysis techniques

Visualization – translate business requirements to form the appropriate visualization in the form of a report or dashboard with the proper design components

Data Governance, Quality, & Controls – summarize important data governance concepts and apply data quality control concepts

Module 1	Welcome
Unit 1	Welcome
Module 2	Database Fundamentals - Course Introduction
Unit 1	Welcome
Module 3	Database Fundamentals - Understanding Core Database Concepts
Unit 1	Understand How Data is stored in Tables
Unit 2	Understand Relational Database Concepts
Unit 3	Understand Data Manipulation Language (DML)
Unit 4	Understand Data Definition Language (DDL)
Module 4	Database Fundamentals - Creating Database Objects
Unit 1	Choose Data Types - Part 1
Unit 2	Choose Data Types - Part 2
Unit 3	Understand Tables and How to Create Them
Unit 4	Create Views
Unit 5	Create Stored Procedures and Functions
Module 5	Database Fundamentals - Manipulating Data
Unit 1	Select Data - Part 1
Unit 2	Select Data - Part 2
Unit 3	Insert and Update Data
Unit 4	Delete Data
Module 6	Database Fundamentals - Understanding Data Storage
Unit 1	Understand Normalization
Unit 2	Understand Primary, Foreign and Composite Keys
Unit 3	Understand Indexes
Module 7	Database Fundamentals - Administering a Database
Unit 1	Understand Database Security Concepts
Unit 2	Understand Database Backups and Restore
Module 8	Bonus Database Exams
Unit 1	Bonus Exam 1
Unit 2	Bonus Exam 2
Module 9	Data+ - Data Concepts and Environments
Unit 1	Data Schemas and Dimensions
Unit 2	Data Types, Structures and File Formats
Module 10	Data+ - Data Mining
Unit 1	Data Acquisition Concepts
Unit 2	Data Manipulation Techniques
Unit 3	Data Manipulation and Query Optimization
Module 11	Data+ - Data Analysis
Unit 1	Statistical Methods
Unit 2	Types of Analysis
Unit 3	Common Data Analytics Tools
Module 12	Data+ - Visualization
Unit 1	Design Components for Reports
Unit 2	Dashboard Development
Unit 3	Appropriate Type of Visualization
Unit 4	Compare and Contrast Types of Reports.
Module 13	Data+ - Data Governance, Quality, and Controls
Unit 1	Important Data Governance Concepts.
Unit 2	Data Quality Control Concepts
Unit 3	Master Data Management (MDM) Concepts.
Module 14	Excel - Create and Manage Worksheets and Workbooks
Unit 1	Introduction
Unit 2	Create Worksheets and Workbooks
Unit 3	Create Worksheets and Workbooks 2
Unit 4	Navigate through Worksheets and Workbooks
Unit 5	Navigate through Worksheets and Workbooks 2
Unit 6	Format Worksheets and Workbooks
Unit 7	Format Worksheets and Workbooks 2
Unit 8	Format Worksheets and Workbooks 3
Unit 9	Format Worksheets and Workbooks 4
Unit 10	Format Worksheets and Workbooks 5
Unit 11	Format Worksheets and Workbooks 6
Unit 12	Format Worksheets and Workbooks 7
Unit 13	Customize Options and Views for Worksheets and Workbooks
Unit 14	Customize Options and Views for Worksheets and Workbooks 2
Unit 15	Customize Options and Views for Worksheets and Workbooks 3
Unit 16	Customize Options and Views for Worksheets and Workbooks 4
Unit 17	Customize Options and Views for Worksheets and Workbooks 5
Unit 18	Configure Worksheets and Workbooks to Print or Save
Unit 19	Configure Worksheets and Workbooks to Print or Save 2
Module 15	Excel - Create Cells and Ranges
Unit 1	Insert Data in Cells and Ranges
Unit 2	Insert Data in Cells and Ranges 2
Unit 3	Insert Data in Cells and Ranges 3
Unit 4	Format Cells and Ranges
Unit 5	Format Cells and Ranges 2
Unit 6	Format Cells and Ranges 3
Unit 7	Format Cells and Ranges 4
Unit 8	Order and Group Cells and Ranges
Unit 9	Order and Group Cells and Ranges 2
Unit 10	Order and Group Cells and Ranges 3
Unit 11	Order and Group Cells and Ranges 4
Module 16	Excel - Create Tables
Unit 1	Create a Table
Unit 2	Modify a Table
Unit 3	Filter and Sort a Table
Module 17	Excel - Apply Formulas and Functions
Unit 1	Utilize Cell Ranges and References in Formulas and Functions
Unit 2	Summarize Data with Functions
Unit 3	Utilize Conditional Logic in Functions
Unit 4	Format and Modify Text with Functions
Module 18	Excel - Create Charts and Objects
Unit 1	Create a Chart
Unit 2	Format a Chart
Unit 3	Insert and Format an Object
Unit 4	Insert and Format an Object 2
Module 19	Excel - Case Study 3
Unit 1	Introduction
Unit 2	Part 1
Unit 3	Part 2
Unit 4	Part 3
Unit 5	Part 4
Unit 6	Part 5
Module 20	Excel - Case Study 4
Unit 1	Introduction
Unit 2	Part 1
Unit 3	Part 2
Unit 4	Part 3
Unit 5	Part 4
Unit 6	Part 5
Module 21	Excel - Case Study 5
Unit 1	Introduction
Unit 2	Part 1
Unit 3	Part 2
Unit 4	Part 3
Unit 5	Part 4
Unit 6	Part 5
Unit 7	Part 6