Claude-skill-registry data-analytics-foundations

Core data analytics concepts, Excel/Google Sheets fundamentals, and data collection techniques

install
source · Clone the upstream repo
git clone https://github.com/majiayu000/claude-skill-registry
Claude Code · Install into ~/.claude/skills/
T=$(mktemp -d) && git clone --depth=1 https://github.com/majiayu000/claude-skill-registry "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/data/data-analytics-foundations" ~/.claude/skills/majiayu000-claude-skill-registry-data-analytics-foundations && rm -rf "$T"
manifest: skills/data/data-analytics-foundations/SKILL.md
source content

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 TypeCauseRecovery
Formula errorInvalid syntaxValidate formula structure
Data type mismatchWrong input formatConvert data types explicitly
Missing dataIncomplete datasetApply imputation or filtering
Performance issueLarge datasetUse data sampling or optimization

Related Skills

  • databases-sql (for advanced data querying)
  • statistics (for data analysis techniques)
  • visualization (for presenting insights)