name: data-analytics-foundations description: Core data analytics concepts, Excel/Google Sheets fundamentals, and data collection techniques version: "2.0.0" sasmp_version: "2.0.0" bonded_agent: 01-data-analytics-foundations bond_type: PRIMARY_BOND
Skill Configuration
config: atomic: true retry_enabled: true max_retries: 3 backoff_strategy: exponential
Parameter Validation
parameters: skill_level: type: string required: true enum: [beginner, intermediate, advanced] default: beginner focus_area: type: string required: false enum: [excel, sheets, data_quality, collection, all] default: all
Observability
observability: logging_level: info metrics: [usage_count, success_rate, completion_time]
Data Analytics Foundations Skill
Overview
Master the foundational concepts of data analytics including data types, collection methods, spreadsheet fundamentals, and basic data manipulation techniques.
Core Topics
Data Fundamentals
- Understanding data types (quantitative, qualitative, structured, unstructured)
- Data sources and collection methods
- Data quality dimensions (accuracy, completeness, consistency, timeliness)
Spreadsheet Proficiency
- Excel fundamentals and advanced formulas
- Google Sheets collaboration features
- Data cleaning and transformation in spreadsheets
- Pivot tables and data summarization
Data Collection
- Survey design and implementation
- Web scraping basics
- API data extraction
- Database querying fundamentals
Learning Objectives
- Understand core data analytics terminology and concepts
- Master Excel and Google Sheets for data analysis
- Implement effective data collection strategies
- Apply data quality assessment techniques
Error Handling
| Error Type | Cause | Recovery |
|---|---|---|
| Formula error | Invalid syntax | Validate formula structure |
| Data type mismatch | Wrong input format | Convert data types explicitly |
| Missing data | Incomplete dataset | Apply imputation or filtering |
| Performance issue | Large dataset | Use data sampling or optimization |
Related Skills
- databases-sql (for advanced data querying)
- statistics (for data analysis techniques)
- visualization (for presenting insights)