Skill UI

Automates pivot table creation in data analytics workflows, guiding SQL queries, visualization choices, statistical checks, and BI configurations whenever the user invokes pivot table creator support.

This skill provides advanced techniques for optimizing PostHog Cloud usage and reducing associated costs. It covers auditing event volume, implementing intelligent event sampling (e.g., sampling pageviews or autocapture events), filtering bot traffic, and tuning session recording rates. The goal is to maintain critical analytical value while staying within budget limits.

This guide provides minimal working examples demonstrating the three core PostHog functionalities: event capture, user identification, and feature flag evaluation. It covers both server-side (Node.js, Python) and client-side (JavaScript) SDK usage, as well as direct API calls, making it perfect for initial integration setup, testing, and learning basic product analytics patterns.

This comprehensive guide outlines the process of migrating analytics data from major platforms like Google Analytics, Mixpanel, Amplitude, or Segment to PostHog. It covers implementing a dual-write strategy, mapping historical event names and properties, and performing bulk historical data imports, ensuring a smooth transition and data continuity.

This skill guides you through integrating PostHog's Customer Data Platform (CDP) features. It covers setting up webhooks to trigger real-time actions (e.g., syncing to CRM, sending notifications) when specific user events occur. Furthermore, it demonstrates how to query event data using the Events API and perform complex funnel analysis using HogQL, allowing for deep, custom insights into user behavior.

A practical decision framework for determining whether to use regular expressions or Large Language Models (LLMs) when parsing structured text (e.g., forms, quizzes, invoices). It recommends starting with deterministic, low-cost regex for 95-98% of structured data, and only invoking expensive LLM calls for identifying and validating ambiguous edge cases, optimizing both cost and accuracy.

Automates ROC curve plotting tasks in ML training, guiding data prep, model training, tuning, tracking, and code generation for production-ready results.

A sophisticated tool for optimizing crypto trades across multiple Decentralized Exchanges (DEXs). It aggregates quotes from major aggregators (like 1inch, Paraswap, and 0x) to find the optimal multi-hop route, calculate split orders for large trades, and assess MEV risk, ensuring minimum slippage and gas costs.

An advanced workflow orchestrator designed to perform multi-phase, deep-dive schema optimization on large datasets (e.g., BigQuery exports). It systematically analyzes schema structure, identifies unused or redundant fields, assesses potential impact, and generates a comprehensive, actionable report with recommended optimization strategies and estimated savings.

This advanced tool simulates complex DeFi flash loan strategies across major protocols like Aave, dYdX, and Balancer. It calculates net profitability, estimates gas costs, and assesses comprehensive risks (MEV, liquidity, execution). Use it to evaluate arbitrage opportunities, analyze liquidation potential, or compare multiple lending providers before executing real transactions.

This guide provides advanced patterns and best practices for optimizing Apache Spark jobs. It covers critical areas like effective partitioning, memory tuning, minimizing data skew, and optimizing different types of joins (broadcast, bucket). Use this when troubleshooting slow, large-scale data processing workflows or needing to scale Spark pipelines efficiently and reliably.

A comprehensive foundation skill for monitoring cryptocurrency markets. It provides real-time quotes, 24-hour change metrics, and deep historical price data for over 10,000 coins. Users can track specific symbols, view predefined watchlists (e.g., DeFi, Top 10), or export detailed OHLCV data in CSV format. This skill serves as the foundational data layer for crypto portfolio management, tax calculation, and DeFi analysis applications.