Exploratory Data Analysis (EDA) Report Generator & Visualization Suggestor
Act as a senior data analyst specializing in business intelligence. Analyze the attached dataset snippet [insert: 5,000 e-commerce customer records, columns: Purchase_Date, Customer_Segment, Product_Category, Order_Value, Repeat_Purchase_Flag]. Generate a structured EDA report with: 1) Descriptive statistics (mean, median, std dev) for numerical columns, 2) Categorical distribution analysis, 3) 3 key correlation insights (e.g., Order_Value vs. Repeat_Purchase_Flag), 4) 5 tailored visualization suggestions (tool-agnostic: bar charts, heatmaps, etc.) with rationale, 5) 3 preliminary hypotheses for further testing.ADVERTISEMENT - IN-ARTICLE
Implementation Guide
This prompt streamlines EDA report creation, saving data analysts 8+ hours of manual analysis and report writing. By inputting a dataset snippet, ChatGPT/Claude generates a structured report with descriptive statistics, distribution analysis, correlation insights, and visualization suggestions tailored to the data’s unique characteristics. The output includes testable hypotheses to guide further analysis, eliminating the need for ad-hoc brainstorming. Ideal for initial dataset exploration, it works for e-commerce, healthcare, and SaaS data, and adapts to both structured and semi-structured data formats. The visualization suggestions are tool-agnostic, supporting Excel, Tableau, and Python libraries like Matplotlib.