ליברו - שדרת הבשמים: ניתוח מכירות ורווח גולמי

Generated from prompt:

Act as an expert business data analyst and presentation designer. I have attached files containing sales and profit data for a business called "Libro" (ליברו - שדרת הבשמים). Note: The data represents a single physical retail store only (no online sales data is included) for the timeframe specified in the files. Please analyze the attached data and generate the content and structure for a highly visual, 5-slide business presentation. CRITICAL REQUIREMENT: The generated presentation content (titles, bullet points, and chart labels) MUST be completely in Hebrew. Presentation Guidelines: - Maximize data visualization: Suggest specific types of charts, graphs, or visual elements (e.g., Donut chart, Bar chart, KPI cards) for every single slide to best illustrate the numbers. - Keep the text concise and business-oriented. Required Slide Structure: Slide 1: Title Slide - Business name ("ליברו - שדרת הבשמים"), specific branch/store, and the exact data timeframe extracted from the files. Slide 2: Executive Summary / High-Level KPIs - Total sales revenue, total gross profit, and overall profit margin %. - Visual Recommendation: Large KPI cards/dashboards. Slide 3: Sales Distribution - Breakdown of total sales by top categories, departments, or brands. - Visual Recommendation: Pie chart or Donut chart with percentages. Slide 4: Profitability Analysis - Highlighting the most profitable categories/items vs. those with the highest sales volume. - Visual Recommendation: A combined Bar chart (Sales Volume vs. Profit Margin %). Slide 5: Key Insights & Conclusions - 3 to 4 actionable, data-driven insights extracted directly from the attached files (e.g., what is the main profit engine, what needs improvement). Please read the attached files carefully, extract the exact accurate numbers, and generate the presentation outline in Hebrew now.