skills.rest
take566
take566COMMUNITY
Explore all skills by this author →
GitHub

data-analysis

Analyze data with pandas, SQL, and BigQuery to generate charts and reports.

Updated Dec 23, 2025
Search Tags:#SQL#reporting#data analysis#visualization#pandas#BigQuery
One-click install
npx skills add https://github.com/take566/skills --skill data-analysis-take566
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/take566/skills/tree/main/data-analysis
Command: npx skills add https://github.com/take566/skills --skill data-analysis-take566

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill streamlines the process of analyzing, visualizing, and reporting on data, transforming raw information into actionable insights.

Core Features & Use Cases

  • Data Manipulation: Perform complex operations using pandas for cleaning, transforming, and aggregating data.
  • Database Querying: Execute SQL and BigQuery queries to retrieve and analyze data from various sources.
  • Visualization & Reporting: Create insightful charts and generate comprehensive reports to communicate findings.
  • Use Case: Analyze monthly sales data from BigQuery, identify top-performing products, and generate a visual report with key trends and recommendations.

Quick Start

Use the data-analysis skill to analyze the provided CSV file 'sales_data.csv' and generate a summary report.

Frequently Asked Questions about data-analysis

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

FAQPage Schema
How do I analyze CSV files and generate a summary report with pandas?▼

To analyze CSV files and generate a summary report, this skill uses pandas for data manipulation, statistical analysis, and aggregation. It transforms raw data into actionable insights and creates a comprehensive report of your findings.

Can I use BigQuery and SQL to retrieve data for visualization?▼

Yes, you can use BigQuery and SQL to retrieve data for visualization. This skill executes database queries to extract information, performs data analysis, and generates charts to facilitate business intelligence and decision-making.

What's the best way to aggregate raw data for business intelligence reporting?▼

The best way to aggregate raw data for business intelligence reporting is by using pandas for complex transformations and SQL for database querying. This approach enables statistical analysis and chart generation to communicate key trends.

Do I need to know SQL to use this data analysis and reporting skill?▼

Yes, proficiency in SQL and database query languages is required to use this data analysis skill effectively. You also need familiarity with data manipulation libraries like pandas to execute queries and perform aggregations.

How do I create charts from monthly sales data to identify top-performing products?▼

To create charts from monthly sales data and identify top-performing products, this skill performs data aggregation and visualization. It uses pandas and BigQuery to analyze trends and generate visual reports with recommendations.

What are the limitations of using pandas for complex statistical analysis?▼

While pandas facilitates complex statistical analysis and data aggregation, limitations arise when handling extremely large datasets outside of BigQuery. Proficiency in data manipulation libraries is required to avoid performance bottlenecks during reporting.

Related Skills

Explore More Data & Analytics Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
yangqiongyangqiong

Report Generator Skill

Generate HTML data reports from pandas DataFrames with summaries and analyses.

Community
Intermediate
alter123-zzalter123-zz
18

analytics-dashboard

Generate interactive KPI dashboards from business data with Python.

Community
Intermediate
tapanshahtapanshah

senior-data-scientist

Design A/B tests and build predictive models using Python, R, and SQL.

Community
Advanced