Skill UI

This comprehensive framework allows users to validate and test both crypto and traditional trading strategies against extensive historical market data. It calculates essential performance metrics (Sharpe Ratio, Sortino Ratio, Max Drawdown), simulates trade execution, generates equity curves, and includes advanced parameter grid search optimization tools for robust strategy validation.

A comprehensive guide detailing optimization techniques for Databricks environments. It covers optimal cluster sizing for various workloads (ETL, ML, Streaming), advanced Spark configurations (AQE, memory management), and deep data optimization strategies for Delta Lake, including Z-Ordering and Liquid Clustering. It also provides methods for query plan analysis and join optimization.

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 skill functions as an expert-level web researcher, utilizing advanced search strategies (query optimization, domain filtering) to gather, synthesize, and validate information from multiple web sources. It is ideal for complex research tasks requiring fact verification, identifying trends, and producing structured, actionable insights, ensuring high credibility for the final output.

Guides a Power BI DAX expert through performance, readability, best-practice, and maintainability reviews; recommends variable reuse, context tuning, and error handling; then outputs an optimized formula plus justification for analytics models.

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.

Python framework for single- and multi-objective optimization with NSGA-II/III, MOEA/D, and SPEA2. Supports constraints, ZDT/DTLZ benchmarks, Pareto front analysis, and visualization for engineering design.

This skill converts complex, narrative technical documents, research excerpts, or natural language problem descriptions into a highly structured Mathematical Problem Specification (MPS). It systematically extracts variables, constraints, objectives, and uncertainty parameters. By adhering to a strict Zero-Inference Protocol, it ensures all extracted elements are strictly grounded in the source text, making it invaluable for formalizing real-world optimization, data science, and engineering problems.

This skill provides a comprehensive framework for evaluating Power BI reports. It assesses report quality, usage adoption rates, performance metrics, and structural integrity across different lifecycle stages (development, testing, active use). It analyzes usage data, audience reach, and performance bottlenecks, generating actionable feedback and optimization recommendations to ensure reports are effective and maintainable.

Guidance for designing, building, refreshing, and reviewing Power BI / Analysis Services tabular models from the terminal. Covers star schema, relationships, measures, calculation groups, roles, storage modes, incremental refresh, and model optimization. Routes every operation to the narrowest capable tool: te CLI first, then TOM or MCP, then TMDL. Ensures model quality, performance, and readiness for Copilot/AI.

Expertise for demand forecasting, safety stock optimization, replenishment planning, and promotional lift estimation at multi-location retailers. Use when forecasting demand, setting safety stock, planning replenishment, managing promotions, or optimizing inventory levels.

This tool automates the process of optimizing investment portfolio allocations using a mean-variance engine. It integrates neural prediction models and risk constraints to determine optimal asset weights. Users can set specific risk targets, assess comprehensive risk metrics (variance, correlation), and generate actionable, step-by-step rebalancing plans for professional portfolio management.