skills.rest
htlin222
htlin222COMMUNITY
Explore all skills by this author →
Website𝕏@htlin222GitHub

data-science

Analyze data with SQL queries and BigQuery operations using Python libraries.

77|4|Updated Jun 20, 2022
Search Tags:#python#insights#data analysis#sql#statistics#bigquery
One-click install
npx skills add https://github.com/htlin222/dotfiles --skill data-science-htlin222
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-science
Source: https://github.com/htlin222/dotfiles/tree/main/claude.symlink/skills/data-science
Command: npx skills add https://github.com/htlin222/dotfiles --skill data-science-htlin222

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines data analysis, SQL querying, and BigQuery operations to help you derive meaningful insights from your data efficiently.

Core Features & Use Cases

  • SQL Querying: Write and optimize SQL queries, including complex aggregations and window functions.
  • BigQuery Operations: Execute BigQuery-specific queries for large-scale data analysis.
  • Python Analysis: Perform data manipulation, statistical analysis, and visualization using pandas and scikit-learn.
  • Use Case: Analyze customer behavior by querying a large dataset in BigQuery, identifying key trends, and summarizing findings in a clear report.

Quick Start

Use the data-science skill to write a SQL query that calculates the monthly revenue growth rate from the orders table.

Frequently Asked Questions about data-science

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write a SQL query to calculate monthly revenue growth in BigQuery?▼

To calculate monthly revenue growth using SQL in BigQuery, you can aggregate order totals by month and utilize window functions to compare current period totals against previous periods for growth rate calculation.

Can I use Python pandas and scikit-learn for statistical analysis on large datasets?▼

Yes, you can use Python pandas for data manipulation and scikit-learn for statistical analysis and visualization, enabling efficient processing and modeling of large datasets to extract meaningful insights.

What is the best way to optimize SQL queries with aggregations and window functions?▼

The best way to optimize SQL queries with aggregations and window functions involves structuring complex queries efficiently to minimize computation overhead, specifically when executing large-scale data analysis operations in BigQuery.

Do I need BigQuery expertise to build ETL pipelines with Python?▼

Yes, BigQuery expertise is required for efficient data manipulation and executing large-scale queries within ETL pipeline development, while Python libraries like pandas handle the data transformation and loading phases.

How does data visualization work with Python for customer behavior analysis?▼

Data visualization for customer behavior analysis works by using Python to query large datasets, identify key trends through statistical analysis, and summarize the findings into a clear, visual report for insights.

Related Skills

Explore More Data & Analytics Skills→
BfdCamposBfdCampos

bigquery

Query BigQuery INFORMATION_SCHEMA tables and columns for metadata without exposing data.

Community
Intermediate
ShubhamsabooShubhamsaboo
131.7k

data-analyst

Analyze datasets using SQL and pandas for extraction and reporting.

Community
Intermediate
PetriLahdelmaPetriLahdelma
2

data-science

Guide analytics, data processing, and ML modeling with pandas and scikit-learn.

Community
Advanced
TurnaboutHeroTurnaboutHero
12

scientist-low

Load and inspect datasets with pandas and matplotlib in a Python REPL.

Community
Intermediate