Course Overview
High-level description: The CompTIA Data+ and Data Analyst Bundle is designed to provide comprehensive training for individuals aiming to excel in data analytics. This blended bundle includes custom self-paced online instructor-led training (ILT) courses for CompTIA Data+ and Data Analyst certifications, combined with engaging video lessons, text lessons, section quizzes, performance-based lab simulations, and comprehensive exam practice. The bundle also includes an exam voucher and an exam pass guarantee for Data+: if you don’t pass the Data+ exam on the first try, we will provide another 12 months of access to our custom online self-paced ILT.
Recommended Study Sequence: We recommend you start with ITI’s Custom Online Self-Paced ILT for Data Analyst, followed by the integrated CompTIA CertMaster Learn and Labs for Data+.
CTI Custom Data Analyst Online Self-Paced ILT Description: Embark on the Data Analyst Career Path with our comprehensive Online Self-Paced ILT bundle of mini-courses, designed for aspiring data analysts. This course covers a wide range of topics, including data collection, analysis, visualization, and advanced techniques using tools like Microsoft Power BI, Excel, and SQL Server. This course offers 42 hours of content delivered through 278 on-demand videos and includes 100 prep questions. Once purchased, you have 12 months’ access to the course.
Topics Areas Included:
- Data Collection and Management
- Data Analysis and Interpretation
- Database Management and Querying
- Data Visualization and Reporting
- Excel Proficiency
- Big Data Technologies
- Advanced Analysis Techniques
Once purchased, you have 12 months’ access to the course.
Course Highlights:
- Duration: 56+ hours
- Content: 350+ On-demand Videos
- Exam Prep: 400+ Prep Questions
- Certification: Certificate of Completion for Data Analyst
Topics Areas Included:
- Data Visualization
- Data Cleaning
- Data Analysis Techniques
- Data Interpretation
Courses Included:
- Course 1 Microsoft SQL Server – Introduction to Data Analysis
- Course 2 Microsoft SQL Server – Querying SQL Server
- Course 3 Introduction to Microsoft Power BI
- Course 4 Microsoft Excel for Data Analysis
- Course 5 Microsoft SQL Server – Big Data
- Course 6 Microsoft SQL Service Analysis Services (SSAS)
CTI Custom Data+ Online Self-Paced ILT Description: This course prepares participants to manage and analyze data effectively, covering topics like data mining, visualization, statistical analysis, and governance. Learners gain practical experience using tools such as AWS Redshift and Google Cloud SQL, with a focus on creating dashboards and ensuring data quality. The course is ideal for aspiring data analysts, business intelligence professionals, and database managers, providing both theoretical knowledge and hands-on labs to prepare for the CompTIA Data+ certification exam. This course offers 5 hours of content delivered through 70+ on-demand videos and includes 90+ prep questions. Once purchased, you have 12 months’ access to the course.
Topics Areas Included:
Introduction to CompTIA Data+
- Course Welcome
- Module Overview
- Instructor Introduction
- What is the CompTIA Data+ Exam
- Roles that Should Consider the Exam
- Exam Objectives
- Discussion – The Importance of Data
- US DOD Member Data Directives and 8570
Module 1 – Data Concepts and Environments
- Understanding Data Schemes
- Databases
- Demonstration – Google Cloud SQL
- Data Warehouses and Data Lakes
- Comparing OLTP and OLAP Processing
- Demonstration – AWS Redshift
- Demonstration – Deploy SQL DemoBench
- What is Column Database
- Data Structures, Files, and Types
- Module Summary Review
- Module Review Questions
Module 2 – Data Mining
- Data Acquisition and Integration
- Demonstration – Data Integration Techniques
- API Fundamentals
- Demonstration – Google Vision API
- Data Profiling and Cleansing
- Data Collection Method Options
- Data Outliers
- Understanding ETL and ELT
- Query Optimization
- Understanding Data Manipulation Techniques
- Module Summary Review
- Module Review Questions
Module 3 – Data Analysis
- Descriptive Statistical Methods
- Measures of Tendency and Dispersion
- Understanding Percentages
- Inferential Statistical Methods
- Hypothesis Testing with Excel
- Whiteboard – Linear Regression and Correlation
- Whiteboard – Analysis Testing
- Module Summary Review
- Module Review Questions
Module 4 – Data Visualization
- Translate Business Requirements to Reports
- Whiteboard – Translate Business Requirements
- Dashboard Fundamentals
- Demonstration – Dashboard Components
- Data Sources and Attributes
- Understanding Charts and Graphs
- Report Types and Elements
- Module Summary Review
- Module Review Questions
Module 5 – Data Governance, Quality, and Controls
- Introduction to Data Governance
- The Data Lifecycle
- Determining Data Classification
- Data Ownership
- Data Storage Access
- Data Privacy and Frameworks
- Information Rights Management (IRM) and Data Loss Prevention (DLP)
- Setting Data Quality Control
- Methods to Validate Quality
- Data Transformation Tools
- Data Security Fundamentals
- Master Data Management (MDM)
- Module Summary Review
- Module Review Questions
Module 6 – Exam Preparation and Practice Exams
- Course Summary Review
- Data Plus Exam Experience
- Certification CEU Requirements
- Practice Exams – Additional Resources
- Course Closeout
CompTIA Data+ CertMaster Learn and Labs Description: CertMaster Learn is a comprehensive eLearning experience that helps learners gain the knowledge and practical skills necessary to be successful on CompTIA certification exams and in their IT career. A Learning Plan helps learners stay on track with their studies, while robust analytics bring awareness of strengths and weaknesses.
CertMaster Labs make it easy for learners to practice and apply their skills in real workplace scenarios in preparation for the certification exam. All lab activities use real equipment and software, offer feedback and hints, and provide a score based on learner inputs, ultimately guiding learners to the most correct and efficient path through job tasks.
In the integrated experience, CertMaster Labs are integrated as Study Tasks within the CertMaster Learn Learning Plan, accessible through a single login and seamless workflow.
Lessons cover all exam objectives with integrated videos:
- Hundreds of practice questions test your knowledge
- Performance-based questions apply what you’ve learned in a scenario
- Assisted Labs guide you step-by-step through tasks
- Applied Labs present goal-oriented scenarios and require critical thinking and analysis
- Flashcards ensure you know the terminology and acronyms required for the exam
- The Learning Plan keeps you on track with your studies
Topics Covered:
- Identifying Basic Concepts of Data Schemas
- Understanding Different Data Systems
- Understanding Types and Characteristics of Data
- Comparing and Contrasting Different Data Structures, Formats, and Markup Languages
- Explaining Data Integration and Collection Methods
- Identifying Common Reasons for Cleansing and Profiling Data
- Executing Different Data Manipulation Techniques
- Explaining Common Techniques for Data Manipulation and Optimization
- Applying Descriptive Statistical Methods
- Describing Key Analysis Techniques
- Understanding the Use of Different Statistical Methods
- Using the Appropriate Type of Visualization
- Expressing Business Requirements in a Report Format
- Designing Components for Reports and Dashboards
- Distinguishing Different Report Types
- Summarizing the Importance of Data Governance
- Applying Quality Control to Data
- Explaining Master Data Management Concepts
Labs Available:
- Assisted Lab: Navigating and Understanding Database Design
- Assisted Lab: Understanding Data Types and Conversion
- Assisted Lab: Working with Different File Formats
- APPLIED LAB: Understanding Data Structure and Types and Using Basic Statements
- Assisted Lab: Using Public Data
- Assisted Lab: Profiling Data Sets
- Assisted Lab: Addressing Redundant and Duplicated Data
- Assisted Lab: Addressing Missing Values
- APPLIED LAB: Preparing Data for Use
- Assisted Lab: Recoding Data
- Assisted Lab: Working with Queries and Join Types
- APPLIED LAB: Building Queries and Transforming Data
- Assisted Lab: Using the Measures of Central Tendency
- Assisted Lab: Using the Measures of Variability
- APPLIED LAB: Analyzing Data
- Assisted Lab: Building Basic Visuals to Make Visual Impact
- Assisted Lab: Building Maps with Geographical Data
- Assisted Lab: Using Visuals to Tell a Story
- Assisted Lab: Filtering Data
- Assisted Lab: Designing Elements for Dashboards
- Assisted Lab: Building an Ad Hoc Report
- APPLIED LAB: Visualizing Data
- Assisted Lab: De-Identifying Records
Product and License Information:
- One license provides access to CertMaster Learn for Data+ (DA0-001) with CertMaster Labs integrated throughout the course
- Access keys must be redeemed within 12 months of purchase
- Once redeemed, Learn for Data+ (DA0-001) with CertMaster Labs integrated will be valid for 12 months
How to Access CertMaster Learn integrated with CertMaster Labs: An access key and instructions will be sent via email after your purchase is complete.
Exam Voucher and Exam Pass Guarantee (Data+ only): This bundle includes an exam voucher and an exam pass guarantee for Data+: if you don’t pass the Data+ exam on the first try, we will provide another 12 months of access to our custom online self-paced ILT. To qualify for the exam pass guarantee, you must show proof of completing all training materials, including course content, labs, and practice prep questions, before taking your exam.