📈 Data Analysis Prompts

SQL queries, data cleaning, visualization, insights

← All Categories
1 prompts in Data Analysis

Analyze Sales Data and Find Insights

data Data Analysis Intermediate
Act as a data analyst. I have sales data with columns: Date, Product, Category, Region, Units Sold, Revenue, Cost. Perform analysis: 1) Summary statistics (total revenue, average order value, top products), 2) Trend analysis (monthly revenue trend, seasonality), 3) Pareto analysis (which 20% of products generate 80% of revenue), 4) Regional comparison, 5) Profit margin by category, 6) Anomaly detection (unusual spikes or drops). Provide both the analysis approach and the specific Excel formulas or SQL queries to run.
💡 Start with the big picture, then drill down. Executives want insights, not just numbers.