Course Objectives
CompTIA Data+ validates that you have the skills required to facilitate data-driven business decisions, including:
- Mining data Manipulating data Visualizing and reporting data Applying basic statistical methods Analyzing complex datasets while adhering to governance and quality standards throughout the entire data life cycle
Agenda
- Identify Relational and NonRelational Databases
- Understand the Way We Use Tables ,Primary Keys, and Normalization
- Describe Types of Data Processing and Storage Systems
- Explain How Data Changes
- Understand Types of Data
- Break Down the Field Data Types
- Differentiate between Structured Data and Unstructured Data
- Recognize Different File Formats
- Understand the Different Code Languages Used for Data
- Understand the Processes of Extracting, Transforming, and Loading Data
- Explain API/Web Scraping and Other Collection Methods
- Collect and Use Public and Publicly Available Data
- Use and Collect Survey Data
- Learn to Profile Data
- Address Redundant, Duplicated, and Unnecessary Data
- Work with Missing Values
- Address Invalid Data
- Convert Data to Meet Specifications
- Manipulate Field Data and Create Variables
- Transpose and Append Data
- Query Data
- Use Functions to Manipulate Data
- Use Common Techniques for Query Optimization
- Use Measures of Central Tendency
- Use Measures of Dispersion
- Use Frequency and Percentages
- Get Started with Analysis
- Recognize Types of Analysis
- Understand the Importance of Statistical Tests
- Break Down the Hypothesis Test
- Understand Tests and Methods to Determine Relationships Between Variables
- Use Basic Visuals
- Build Advanced Visuals
- Build Maps with Geographical Data
- Use Visuals to Tell a Story
- Consider Audience Needs When Developing a Report
- Describe Data Source Considerations For Reporting
- Describe Considerations for Delivering Reports and Dashboards
- Develop Reports or Dashboards
- Understand Ways to Sort and Filter Data
- Design Elements for Reports and Dashboards
- Utilize Standard Elements
- Creating a Narrative and Other Written Elements
- Understand Deployment Considerations
- Understand How Updates and Timing Affect Reporting
- Differentiate Between Types of Reports
- Define Data Governance
- Understand Access Requirements and Policies
- Understand Security Requirements
- Understand Entity Relationship Requirements
- Describe Characteristics, Rules, and Metrics of Data Quality
- Identify Reasons to Quality Check Data and Methods of Data Validation
- Explain the Basics of Master Data Management
- Describe Master Data Management Processes
FREE
Interested in course?
Course Type: Instructor Led