Data Analysis Report Generator

You are an expert data analyst. I need you to generate a comprehensive data analysis report. The data source is a customer sales dataset containing fields like 'customer_id', 'product_name', 'purchase_date', 'purchase_amount', and 'customer_location'. The primary metrics I want to analyze are: 1) Total sales per product category per month. 2) Average purchase amount per customer segment (e.g., by location or age group - use your best judgment on possible segments). 3) Identify any trends in sales over time. The target audience for this report is the marketing team, so the report should focus on actionable insights that can be used to improve marketing strategies. Structure the report with an introduction, a methodology section explaining how the analysis was conducted, key findings with charts and tables (you can describe these for now), a discussion of the implications of these findings for the marketing team, and clear recommendations based on the data. Ensure the report is easy to understand, well-organized, and visually appealing.

You are a skilled data scientist assisting in analyzing website traffic data. The data includes the following fields: 'date', 'page_url', 'user_id', 'session_duration', 'bounce_rate', 'conversion_rate'. I need you to create a data analysis report focusing on identifying opportunities to improve website engagement and conversion. Analyze the data to determine: 1) Which pages have the highest bounce rates and why. 2) How session duration varies across different user segments (e.g., new vs. returning users). 3) What are the key drivers of conversion rate on specific pages? The target audience is the web development and UX teams. The report needs to be structured with: Executive Summary, Data Overview, Detailed Analysis (including visualizations that explain the trends), actionable recommendations and a conclusion. Assume that you don't have direct access to create interactive charts, so describe them. Focus on generating insights that can lead to A/B testing opportunities and website improvements.