Skill UI

This guide provides comprehensive patterns and best practices for designing high-impact Key Performance Indicator (KPI) dashboards. It covers everything from establishing a KPI framework (Strategic, Tactical, Operational) to defining departmental metrics (Sales, Marketing, Finance) and implementing best-practice layouts for executive summaries and SaaS metrics. Use this skill to translate raw data into actionable business insights.

High-performance Rust toolkit with Python bindings for genomic interval analysis, covering overlap detection, coverage track generation, ML tokenization, reference sequence handling, fragment processing, and scoring workflows for sequencing datasets.

Vaex is a high-performance Python library for lazy out-of-core DataFrames that process billions of rows without RAM. Use it to analyze massive CSV/HDF5/Arrow/Parquet tables, compute fast statistics, visualize big data, and build scikit-learn pipelines.

A comprehensive toolkit designed to track and analyze content performance, engagement metrics, and Return on Investment (ROI) across major social media platforms. By utilizing specialized Apify Actors, this skill extracts deep insights from Instagram, Facebook, YouTube, TikTok, and more, helping users identify high-performing content, monitor growth, and measure marketing campaign effectiveness.

A comprehensive expert prompt for evaluating Power BI data models. It guides the assessment of model architecture (Star Schema, relationships), storage optimization (Import, DirectQuery, Dual), data quality, performance scalability, and governance best practices. Use this when reviewing an existing BI model to ensure it is robust, maintainable, and highly performant.

Polars is a lightning-fast DataFrame library built for Python and Rust, leveraging Apache Arrow. It provides an expression-based API and lazy evaluation framework for highly efficient data manipulation. It is ideal for complex data pipelines, large-scale ETL tasks, and migrating from Pandas due to its superior performance, parallel execution capabilities, and optimized query planning.

polars-bio is a high-performance Python library built on Polars for genomic interval operations and bioinformatics file I/O. It provides a familiar DataFrame-centric API for interval arithmetic (overlap, nearest, merge, complement, etc.) and supports reading/writing major bioinformatics formats like BED, VCF, BAM, and GFF. Key features include streaming, cloud-native I/O, and SQL query support, making it a fast alternative for large-scale genomic data processing.

Vaex is a high-performance Python library designed for lazy, out-of-core DataFrames. It enables processing and visualization of massive tabular datasets (billions of rows) that exceed available RAM. Users can perform fast statistics, aggregations, and build robust ML pipelines on big data files (CSV, Parquet, HDF5) without relying on distributed clusters, making it ideal for single-machine, large-scale analytics.

This skill connects to the DeepEar Lite platform to fetch real-time, high-frequency financial signals. It retrieves crucial data points including signal titles, sentiment summaries, confidence scores, and detailed reasoning. Use this when you require immediate, actionable insights into volatile market trends, stock performance factors, or comprehensive financial analysis.

This comprehensive guide provides advanced workflows for interacting with ClickHouse. It covers efficient bulk data insertion (CSV, JSON), complex analytical querying (funnel analysis, retention), implementing materialized views for pre-aggregation, and utilizing powerful window functions. Ideal for building high-performance OLAP dashboards and executing large-scale data transformations.

A comprehensive guide to designing high-performance schemas in ClickHouse. Learn how to select the optimal MergeTree engine (e.g., ReplacingMergeTree, AggregatingMergeTree), structure the ORDER BY key for maximum query efficiency, and implement effective partitioning strategies for large-scale analytical workloads and ETL processes.

This comprehensive guide provides advanced techniques to diagnose and significantly boost ClickHouse query performance. It covers analyzing slow queries using system tables, optimizing ORDER BY keys, implementing data skipping indexes (Bloom, Set, MinMax), utilizing projections for pre-aggregation, and fine-tuning server settings and materialized views. Essential for high-volume OLAP environments.