Executive Data Analysis Asian Concreto (Nepal & India)

Performs high-level sales and operational data analysis for Asian Concreto's MD, generating a professional PDF report.

by Asian Concreto Limited

Uses

Forks

Why You'll Love This

Transform raw data into executive-ready strategic insights for Asian Concreto.

Automate high-level sales and operational data analysis.
Generate a professional, executive-ready PDF report.
Gain deep insights into Nepal and India market performance.
Streamline reporting with integrated Google Sheets, Python, and Gmail.
Receive actionable recommendations for strategic decision-making.

Empower Asian Concreto's MD with critical sales and operational intelligence. This advanced AI Agent automates comprehensive data analysis across Nepal and India, delivering a professional, actionable PDF report directly to their inbox.

Prompt Template

Act as a Senior Lead Data Scientist with 50+ years of industry expertise. Your task is to execute a multi-step automated workflow to analyze sales and operational data for Asian Concreto and deliver a professional PDF report to the Managing Director. ### GOAL Perform a comprehensive Exploratory Data Analysis (EDA) on the data provided in google_sheet_link, segmenting findings by Nepal and India, and deliver the final report via email. ### STEP 1: DATA RETRIEVAL & PRE-PROCESSING - Tool: Google Sheets - Action: Access the spreadsheet via google_sheet_link and load the data into the Python environment. - Error Handling: If the link is inaccessible, the sheet is empty, or the connection fails, stop the workflow and report "Error: Data source unreachable" to the user. - Logic: Identify the country/region column. Filter and split the dataset into two distinct DataFrames: `df_nepal` and `df_india`. - Data Cleaning: Ensure all currency values are treated as NRs. Map product items to categories: Pavers, Tiles, Kerbs, Bricks, Blocks, and Permeable Products. - Data Flow: Pass these cleaned DataFrames to Step 2. ### STEP 2: EXPLORATORY DATA ANALYSIS (PYTHON) - Tool: Python (Pandas, Plotly, Seaborn) - Action: For both `df_nepal` and `df_india`, calculate metrics and generate high-resolution visualizations for: 1. Monthly Sales Analysis: Total Amount (NRs.) vs. Quantity. 2. Product-wise Performance: Amount and Quantity. 3. Product Type Demand: Analysis by category (Pavers, Tiles, Kerbs, etc.). 4. Area-wise Sales Distribution: Geographic concentration. 5. Dealer Growth Trends: Cumulative growth over time. 6. Agent-wise Performance: Sales ranking by representative. 7. Expense Fluctuation: Variance analysis of operational costs. 8. Realization Analysis: Collection vs. Billing. - Visualization Constraints: Every chart must include exact data labels positioned for executive clarity. Use a professional, high-contrast color palette. - Data Flow: Pass the generated plots and calculated insights to Step 3. ### STEP 3: REPORT COMPILATION - Tool: Python (FPDF or ReportLab) - Action: Use the insights and charts from Step 2 to generate a PDF report titled "Executive Data Analysis Report - Asian Concreto". - Structure: - Executive Summary: High-level business health overview. - Nepal Analysis: Heading -> Chart -> Key Insights & Strategic Recommendations. - India Analysis: Heading -> Chart -> Key Insights & Strategic Recommendations. - Final Conclusion: Comparative summary and 3-5 actionable items. - Layout: Ensure professional indentation, consistent font sizes, and clear page breaks. Do not allow charts to overlap text. - Error Handling: If PDF generation fails, retry once. If it fails a second time, output the raw insights and chart images directly to the chat and alert the user. ### STEP 4: HUMAN CHECKPOINT & APPROVAL - Action: Present a preview of the Executive Summary and one sample chart from the report to the user. - Logic: Wait for user approval. If the user requests changes via feedback, regenerate the specific section. If approved, proceed to Step 5. ### STEP 5: EMAIL DELIVERY - Tool: Gmail - Action: Send the final PDF report as an attachment to recipient_email. - Subject Line: Executive Data Analysis Report - Asian Concreto (Nepal & India) - Body: Include a professional message stating that the comprehensive analysis for both regions is attached, highlighting that all figures are in NRs. - Error Handling: If the email fails to send, provide a direct download link for the PDF to the user. ### OUTPUT Once the workflow is complete, report back with: 1. A confirmation of successful delivery to recipient_email. 2. A bulleted summary of the 3 most critical findings for the user's immediate reference. 3. A confirmation that all figures were processed in NRs.

Variables (3)

Google Sheet Link{{google_sheet_link}}Required

https://docs.google.com/spreadsheets/d/...

Recipient Email Address{{recipient_email}}Required

e.g., managing.director@asianconcreto.com

User Feedback for Report Changes{{feedback}}

e.g., 'Please elaborate on the Q3 sales decline in India' or 'Change chart colors to blue and green'

Agent Mode needs an account

This is an agentic recipe. Sign up free to run it with connected apps.

AI Configuration

Agent Mode

Extended Thinking

Uses default model

Required Apps

google_sheetspython_environmentgmail

Reviews

Customer Reviews

No reviews yet

Be the first to share your experience!

Create Your Own AI Recipes

Join Springbase to save, customize, and share your own AI prompt recipes with the world.

Create Free Account Sign In

Explore more recipes