Autoplay
Autocomplete
Previous Lesson
Complete and Continue
CompTIA Data+ (DA0-001) Certification Prep Course A-Z™
Identify Basic Concepts of Data Schemas and Dimensions
Data Schemas (3:53)
Relational Databases Schemas (7:35)
Non-Relational Databases (6:25)
Comparing Databases (5:07)
Data Processing(OLTP & OLAP) (6:33)
Data Warehouse (6:45)
Data Mart (3:37)
Schema Concepts(Snowflake & Star) (7:40)
Data Lake (7:44)
Slowly changing dimensions (5:34)
Quiz
Compare and contrast different data types
Qualitative Data (6:17)
Quantitative Data (3:57)
Data Types (5:21)
Can we convert data types? (2:31)
Quiz
Compare and contrast common data structures and file formats
Data Structures (6:59)
Data File Formats-Text/Flat File (4:05)
Review Data Languages: Lesson 1 (7:48)
Review Data Languages: Lesson 2 (6:37)
Quiz
Explain Data Acquisition Concepts
Extracting Data (4:28)
Explain data acquisition concepts (5:06)
Transforming Data (5:39)
Loading Data(Full Load & Delta Load) (6:13)
Application programming interfaces (APIs) (5:49)
Web Scraping (5:38)
Machine Data (3:09)
Public Data (5:38)
Survey Data (7:00)
Sampling & Observation (6:48)
Quiz
Cleansing and Profiling Datasets
Data Profiling Steps (4:24)
Cleansing and Profiling Datasets (4:15)
Tools that Simplify The Data Profiling Process (3:31)
Redundant Data (3:06)
Dublicate Data (3:44)
Missing Values (9:07)
Invalid Data (4:55)
Non-parametric Data (3:24)
Data Outliers (6:51)
Specification mismatch (4:19)
Quiz
Data Manipulation Techniques.
Data Manipulation Techniques. (3:23)
Recording Data (10:24)
Derived Variables (4:01)
Data Merge (2:20)
Data Blending (2:14)
Concatenation (3:02)
Data Append (1:39)
Value İmputation (5:07)
Reduction/Aggregation (4:04)
Quiz
Common Techniques for Data Manipulation
Filtering (2:49)
Data Sorting (2:30)
Date Functions (2:43)
Logical functions (10:05)
Aggregate Functions (6:53)
System Functions (1:05)
Query Optimization (4:00)
Parameterization (4:37)
Indexing (4:47)
Temporary table in the query set (4:03)
Subset of records (4:59)
Execution Plan (4:06)
Quiz
Summarize types of analysis and key analysis techniques.
Data Analysis (7:49)
Exploratory Data Analysis(EDA) (4:29)
Sentiment Analysis (3:34)
Perfomance Analysis (4:10)
Diagnostic Analysis (4:34)
Gap Analysis (3:30)
Trend Analysis (3:28)
Link Anlysis (3:18)
Quiz
Descriptive Statistical Methods
Measures of Central Tendency(Mean, Median, Mode) (5:39)
Descriptive Statistical Methods (4:36)
Why is Central Tendency Important? (6:19)
Measures of dispersion (10:58)
Frequencies/Percentages (3:38)
Percent change / Percent Difference (2:25)
Confidence intervals (2:54)
Quiz
Inferential Statistical Methods
Inferential Statistical Methods (4:03)
T-tests (7:48)
Z-Score (3:16)
P-Values (3:57)
Chi-squared (2:49)
Hypothesis Testing (5:30)
Linear Regression (3:17)
Correlation (3:39)
Quiz
Data Analytics Tools
Data Analytics Tools (1:26)
Data Transformation Tools(Excel-Tableau) (8:36)
Data Transformation Tools(Power BI ve Rapid Miner) (5:06)
Data Visualization Tools(Tableau, Power BI) (9:11)
Data Visualization Tools(Qlik, AWS QuickSight, ArcGIS) (8:32)
Statistical Tools (3:47)
Statistical Tools(SAS, IBMSPSS) (6:16)
Statistical Tools(Stata, Minitab) (4:33)
Reporting Tools (3:11)
Reporting Tools(SSRS, Crystal Reports ve Power BI) (8:40)
Platform Tools (2:52)
Platform Tools(Business Objects, MicroStrategy) (7:15)
Platform Tools(Oracles Apex, Dataroma) (4:50)
Platform Tools(IBM Cognos, Rapid Miner) (5:19)
Platform Tools(Oracle Analytics, Domo ve Microsoft Power platform) (6:18)
Quiz
Translate business requirements to form a report
Creating Reports (4:21)
Data Content (3:08)
Data Filtering (12:32)
Data Sorting (10:55)
Views (2:44)
Data Range (2:44)
Frequency (3:15)
Audience for Report (5:38)
Quiz
Use Appropriate Design Components For Feports And Dashboards
Creating Dashboards (2:27)
Report cover page (3:09)
Design Elements: Lesson 1 (3:49)
Design Elements: Lesson 2 (7:24)
Documentation Elements (7:53)
Quiz
Use Appropriate Methods For Dashboard Development
Data Sources And Attributes (3:14)
Dashboard Considerations (2:23)
Continuous/live Data Feed vs. Static Data (3:40)
Development Process (2:34)
Mockup/wireframe (4:53)
Approval granted (3:01)
Develop Dashboard (2:32)
Deploy to production (3:04)
Subscription and Scheduled delivery (6:05)
Interactive (6:26)
Static & Web interface (3:02)
Dashboard optimization & Access permissions (3:29)
Quiz
Apply The Appropriate Type of Visualization.
Visualization Type (2:59)
Line Chart (2:30)
Pie Chart – Bubble Chart (3:26)
Scatter Plot-Bar Chart (3:41)
Histogram-Waterfall (3:27)
Heat map - Geographic map (3:50)
Tree map - Stacked chart (4:14)
Infographic - Word cloud (4:54)
Quiz
Compare and contrast types of reports
Compare and contrast types of reports. (3:58)
Static vs. dynamic reports (3:33)
Ad-hoc/one-time report (3:30)
Self-service/on demand (3:22)
Recurring Reports (3:24)
Tactical/Research report (3:02)
Quiz
Data Governance, Quality, and Controls
Data Governance, Quality, and Controls (2:54)
Data Lifecycle (3:34)
Data Roles (3:27)
Quiz
Summarize important data governance concepts.
Access Requirements (6:18)
Security Requirements (7:15)
Storage environment requirements (4:41)
Use Requirements (4:50)
Data Process (3:04)
Data Retention (2:10)
Entity Relationship Requirements (5:55)
Data Classification (11:38)
Jurisdiction Requirements (6:07)
Data Breach Reporting (5:50)
Quiz
Apply data quality control concepts.
Data Quality Control Concepts (4:37)
Circumstances to check for quality: Lesson 2 (4:06)
Circumstances to check for quality: Lesson 1 (7:25)
Circumstances to check for quality: Lesson 3 (6:20)
Automated Validation (7:03)
Data Quality Dimensions (6:49)
Data quality rule and metrics (9:59)
Cross validation & Sample/Spot Check (6:15)
Reasonable expectations & Data profiling (5:53)
Data audits & Peer Review (5:38)
Quiz
Explain master data management (MDM) concepts.
Explain master data management (MDM) concepts. (3:46)
Processes (11:35)
Circumstances for MDM (9:10)
Quiz
Data Visualization Tools(Qlik, AWS QuickSight, ArcGIS)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock