More screenshots

    Works with the AI Agents you already use

    Claude CodeClaude CodeCursorCursorCodex CLICodex CLIMuseMuseDotsDots+21 more

    insightflow data intelligence

    1

    Turn CSV and Excel datasets into clear, quality-checked analytical insights and reports.

    Free

    2 uses5.0 (1 review)

    insightflow data intelligence

    Example session with this skill installed

    Analyze sales_q4.csv to find why margins are dipping in the Northeast region. Check for data quality issues first.

    • Read your context and instructions
    • Compiled the insightflow data intelligence
    • Generated the data export

    I have completed the initial profile and quality audit of sales_q4.csv. I identified 142 rows with missing discount codes and 12 duplicate transaction IDs that may be inflating volume metrics.

    Data Quality & Analysis Report: sales_q4.csv

    Dataset Overview

    • File Name: sales_q4.csv
    • Shape: 4,200 rows, 12 columns
    • Key Columns: transaction_date, region, category, revenue, cost, discount_pct

    Data Quality Findings

    IssueAffected ColumnsCountRecommendation
    Missing Valuesdiscount_pct142Review if NULL equals 0% or missing data.
    Duplicatestransaction_id12Remove exact duplicates to prevent double-counting.
    Out-of-Rangemargin_pct5Flagged values > 100% (likely data entry error).

    Regional Margin Analysis (Northeast)

    The Northeast region shows a mean margin of 18.4%, compared to the 24.1% average in other regions.

    • Finding 1: High correlation (r=0.82) between "Northeast" and "Expedited Shipping" costs.
    • Finding 2: 22% of Northeast entries have an applied discount_pct above the 15% threshold.
    • Finding 3: A significant spike in return processing fees was recorded in November.

    Limitations & Assumptions

    • Assumes cost includes variable logistics but not fixed warehouse overhead.
    • Correlation between shipping speed and margin does not prove the speed choice caused the dip.

    Next steps

    1. Approve the removal of 12 duplicate rows to normalize revenue.
    2. Decide if missing discount_pct values should be filled with 0.
    3. Provide the logistics_fees.csv to cross-reference shipping cost anomalies.

    sales_q4.csv

    CSV · data export

    Generated

    Example file from a real run - the skill writes it into your workspace.

    Connects securely to your tools. The creator never sees your data.

    About this skill

    Raw datasets often arrive messy, incomplete, or with hidden anomalies that skew results. This skill provides a systematic framework for profiling, auditing, and analyzing CSV and Excel files without making dangerous assumptions or silent modifications. ## What it does - **Comprehensive profiling** lists row/column counts, data types, and statistical summaries like mean, median, and quartiles. - **Data quality auditing** flags missing values, duplicate rows, inconsistent casing, and invalid date formats for review. - **Cleaning recommendations** generates a transparent plan for handling errors before any destructive changes occur. - **Pattern discovery** identifies correlations, time trends, and categorical distributions based on user objectives. - **Anomaly investigation** uses statistical rules to surface unusual values without assuming they are errors. ## How it works 1. **Inspection** starts by parsing the file, identifying sheets, and recording the basic shape of the data. 2. **Profiling** generates a deep dive into every column to identify distributions and distinct values. 3. **Audit and cleaning** presents a proposed transformation list for user approval to ensure data integrity. 4. **Analysis** applies descriptive statistics and grouped summaries to answer specific business questions. 5. **Reporting** delivers a structured analysis-report.md file documenting findings, limitations, and evidence. ## Frameworks & tools Works with standard tabular data formats including CSV and XLSX. Designed for environments with Python data science stacks like pandas, numpy, and matplotlib. ## Why this beats prompting it yourself Generic prompts often lead to "black box" cleaning where rows are deleted or values imputed without your knowledge. This skill enforces a strict verification workflow that requires approval for destructive changes and mandates evidence-based reporting over LLM guesswork. ## Use cases - Auditing a new customer dataset for quality issues before CRM import. - Summarizing sales trends and categorical performance from monthly Excel exports. - Identifying statistical outliers in financial logs for further manual investigation. - Preparing a clean, documented dataset for downstream machine learning or BI tools. ## Known limitations Does not support file execution if the agent environment lacks a runtime. Cannot interpret instructions embedded inside dataset cells or comments.

    Requires a runtime environment for file parsing. Does not support non-tabular formats. Cannot verify causation or perform automated external data enrichment.

    How to use

    1. 1

      Connect your agent to the Agensi MCP

      Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup

    2. 2

      Sign in to Agensi

      Your agent shows a sign-in link. Sign in and click Allow.

    3. 3

      Ask for what you need

      Your agent loads this skill and uses it on your task. It always asks before any payment.

    Reviews

    5.0
    1 review
    5
    1
    4
    0
    3
    0
    2
    0
    1
    0

    This skill has been used 2 times.

    Trust & safety

    Security scan

    Security scan passed 5 days ago

    • Free with an Agensi account

    Requires

    Microsoft Excel
    Python
    pandas

    Permissions

    Read Files
    Write Files

    File Scopes

    *.csv
    *.xlsx

    Read access is needed to inspect user-provided CSV and Excel datasets. Write access is needed only when creating approved analysis outputs or reports. The skill does not require network access or external account connections.

    Listed5 days ago

    What's inside

    Frequently Asked Questions

    Unlike generic prompts that might silently delete rows or impute values, this skill uses a structured 'audit-first' workflow that requires your approval for cleaning steps and provides an evidence-based report for every action taken.

    The skill is optimized for AI agents with access to a Python environment (supporting libraries like pandas and numpy) and is compatible with standard .csv and .xlsx file formats.

    You will receive the pre-configured skill instructions, the structured reporting templates, and the step-by-step logic framework designed to handle dataset profiling, auditing, and analysis.

    Yes, the skill is designed to handle multi-sheet Excel workbooks; during the initial inspection phase, it identifies all available sheets and allows you to target specific ones for profiling and analysis.

    While the skill excels at identifying anomalies, missing values, and formatting errors, it cannot interpret non-data instructions, such as macros or text comments, embedded within individual spreadsheet cells.

    No complex setup is required; once you add the skill to your compatible AI agent, you can immediately begin by uploading a dataset and asking the agent to start the 'Inspection' phase.

    New in Research & Analysis