skills.rest
eosphoros-ai
eosphoros-aiOFFICIAL
Explore all skills by this author →
WebsiteGitHub

walmart-sales-analyzer

Analyze Walmart sales data and generate an HTML report with visualizations.

19.7k|2.9k|Updated Apr 13, 2023
Search Tags:#data visualization#retail analytics#sales analysis#html report#unemployment rate#economic trends
One-click install
npx skills add https://github.com/eosphoros-ai/DB-GPT --skill walmart-sales-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: walmart-sales-analyzer
Source: https://github.com/eosphoros-ai/DB-GPT/tree/main/skills/walmart-sales-analyzer
Command: npx skills add https://github.com/eosphoros-ai/DB-GPT --skill walmart-sales-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, matplotlib, seaborn, and includes scripts (resource) and templates (resource) components.

What problem does it solve?

This Skill helps users analyze Walmart sales data to understand the relationship between store performance and macroeconomic factors like unemployment rates, generating insightful visualizations and reports.

Core Features & Use Cases

  • Data Correlation Heatmap: Visualize correlations between all numerical variables.
  • Sales vs. Unemployment Scatter Plot: Explore the relationship between sales and unemployment with a regression line.
  • Time Series Trends: Track sales and unemployment over time for specific stores.
  • Store Performance Comparison: Compare average sales and unemployment across different stores.
  • HTML Deep Analysis Report: Generate a comprehensive, visually appealing HTML report with detailed analysis and recommendations.
  • Use Case: A regional manager can use this skill to quickly understand how local unemployment trends might be impacting sales in different store locations and identify areas needing strategic adjustments.

Quick Start

Use the walmart-sales-analyzer skill to generate an HTML report from the file '/mnt/data/Walmart_Sales.csv'.

Frequently Asked Questions about walmart-sales-analyzer

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

FAQPage Schema
How do I analyze the relationship between retail sales and the unemployment rate?▼

To analyze retail sales and the unemployment rate, you need a tool that generates scatter plots with regression lines and correlation heatmaps. This allows you to visually explore how macroeconomic factors impact store performance.

Can I generate an HTML report for Walmart sales data using pandas and seaborn?▼

Yes, you can generate a comprehensive HTML report from Walmart sales data using pandas for manipulation and seaborn for visualizations. The output includes time series trends and store performance comparisons.

What is the best way to compare store performance and economic trends in retail analytics?▼

The best way to compare store performance against economic trends is by generating visualizations like correlation heatmaps and time series plots. This reveals how unemployment rates impact sales across different locations.

Does this sales analysis workflow require a specific CSV file format?▼

The sales analysis workflow requires a CSV file containing numerical variables for sales and unemployment data. It processes this input to generate visualizations and an HTML report detailing macroeconomic impacts on sales.

What visualizations are included when exploring sales data and macroeconomic factors?▼

Visualizations for exploring sales data and macroeconomic factors include correlation heatmaps, scatter plots with regression lines, and time series trend charts. These charts help identify patterns between unemployment rates and store sales.

Related Skills

Explore More Data & Analytics Skills→
hico-mrmgnhico-mrmgn

data-analysis

Analyze and visualize CSV and Excel data with Python, Pandas, and Matplotlib/Seaborn.

Community
Intermediate
yuma588yuma588
2

data-analysis

Analyze Excel datasets and generate structured Markdown reports using Python scripts.

Community
Advanced
h4vzzh4vzz
33

data-visualization

Generate static and interactive charts from structured data using matplotlib, seaborn, and plotly.

Community
Intermediate
ZJU-REALZJU-REAL
195

data-analysis-report-generator

Analyze Excel and CSV files and generate interactive HTML reports with ECharts.

Official
Advanced