spend-analytics-engine
Procurement spend analysis skill with classification, consolidation, and savings identification
What this skill does
# Spend Analytics Engine
## Overview
The Spend Analytics Engine provides comprehensive procurement spend analysis capabilities. It cleanses and classifies spend data, identifies consolidation opportunities, detects maverick spending, and quantifies savings opportunities to drive procurement value.
## Capabilities
- **Spend Data Cleansing and Normalization**: Data quality improvement
- **UNSPSC/Commodity Classification**: Standard category assignment
- **Supplier Consolidation Analysis**: Fragmentation identification
- **Price Variance Identification**: Unit price analysis across transactions
- **Maverick Spend Detection**: Off-contract purchasing identification
- **Contract Compliance Analysis**: Spend vs. contract terms
- **Savings Opportunity Quantification**: Addressable spend and savings potential
- **Spend Trend Visualization**: Historical pattern analysis
## Input Schema
```yaml
spend_analysis_request:
spend_data:
transactions: array
- supplier: string
description: string
amount: float
quantity: float
date: date
business_unit: string
cost_center: string
period:
start_date: date
end_date: date
reference_data:
supplier_master: array
category_taxonomy: object
contracts: array
analysis_scope:
analysis_types: array # classification, consolidation, compliance
focus_categories: array
thresholds: object
```
## Output Schema
```yaml
spend_analysis_output:
spend_summary:
total_spend: float
supplier_count: integer
transaction_count: integer
by_category: object
by_supplier: object
by_business_unit: object
classification_results:
classified_spend: float
unclassified_spend: float
category_distribution: object
consolidation_opportunities:
fragmented_categories: array
supplier_rationalization: array
estimated_savings: float
price_variance_analysis:
variance_by_item: array
outliers: array
benchmark_comparisons: object
maverick_spend:
off_contract_spend: float
percentage: float
top_violations: array
contract_compliance:
compliant_spend: float
non_compliant_spend: float
compliance_issues: array
savings_opportunities:
total_addressable_spend: float
estimated_savings: float
initiatives: array
- initiative: string
category: string
addressable_spend: float
savings_potential: float
confidence: string
visualizations: object
```
## Usage
### Comprehensive Spend Analysis
```
Input: 12 months AP transaction data
Process: Cleanse, classify, analyze patterns
Output: Complete spend analysis with savings opportunities
```
### Supplier Consolidation Analysis
```
Input: Classified spend by category
Process: Identify fragmentation, model consolidation
Output: Consolidation recommendations with savings
```
### Contract Compliance Review
```
Input: Spend data, contract terms
Process: Match spend to contracts, identify leakage
Output: Compliance report with violation details
```
## Integration Points
- **Spend Analytics Platforms**: Coupa, SAP Ariba, Jaggaer
- **ERP Systems**: AP data extraction
- **Classification Services**: Automated categorization
- **Tools/Libraries**: Spend analytics, classification algorithms
## Process Dependencies
- Spend Analysis and Savings Identification
- Category Management
- Strategic Sourcing Initiative
## Best Practices
1. Establish regular data refresh cadence
2. Maintain category taxonomy consistency
3. Validate classification accuracy periodically
4. Focus on actionable savings opportunities
5. Track savings realization against projections
6. Communicate insights to stakeholders regularly
Related in Data & Analytics
clawarr-suite
IncludedComprehensive management for self-hosted media stacks (Sonarr, Radarr, Lidarr, Readarr, Prowlarr, Bazarr, Overseerr, Plex, Tautulli, SABnzbd, Recyclarr, Unpackerr, Notifiarr, Maintainerr, Kometa, FlareSolverr). Deep library exploration, analytics, dashboard generation, content management, request handling, subtitle management, indexer control, download monitoring, quality profile sync, library cleanup automation, notification routing, collection/overlay management, and media tracker integration (Trakt, Letterboxd, Simkl).
querying-soql
IncludedSOQL query generation, optimization, and analysis with 100-point scoring. Use this skill when the user needs SOQL/SOSL authoring or optimization: natural-language-to-query generation, relationship queries, aggregates, query-plan analysis, and performance or safety improvements for Salesforce queries. TRIGGER when: user writes, optimizes, or debugs SOQL/SOSL queries, touches .soql files, or asks about relationship queries, aggregates, or query performance. DO NOT TRIGGER when: bulk data operations (use handling-sf-data), Apex DML logic (use generating-apex), or report/dashboard queries.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
habit-flow
IncludedAI-powered atomic habit tracker with natural language logging, streak tracking, smart reminders, and coaching. Use for creating habits, logging completions naturally ("I meditated today"), viewing progress, and getting personalized coaching.
app-store-optimization
IncludedApp Store Optimization (ASO) toolkit for researching keywords, analyzing competitor rankings, generating metadata suggestions, and improving app visibility on Apple App Store and Google Play Store. Use when the user asks about ASO, app store rankings, app metadata, app titles and descriptions, app store listings, app visibility, or mobile app marketing on iOS or Android. Supports keyword research and scoring, competitor keyword analysis, metadata optimization, A/B test planning, launch checklists, and tracking ranking changes.
visualizing-data
IncludedBuilds dashboards, reports, and data-driven interfaces requiring charts, graphs, or visual analytics. Provides systematic framework for selecting appropriate visualizations based on data characteristics and analytical purpose. Includes 24+ visualization types organized by purpose (trends, comparisons, distributions, relationships, flows, hierarchies, geospatial), accessibility patterns (WCAG 2.1 AA compliance), colorblind-safe palettes, and performance optimization strategies. Use when creating visualizations, choosing chart types, displaying data graphically, or designing data interfaces.