data-analysis

Name: data-analysis
Availability: InStock
Author: take566

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

Ready to run

npx skills add https://github.com/take566/skills --skill data-analysis-take566

💬 Prompt for ChatGPT / Claude Chat▼

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.