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.

An expert guide for performing complex data analysis, cleaning, and transformation using pandas DataFrames. This skill covers advanced techniques such as vectorized operations, efficient merging, time series resampling, group-by aggregations, and memory optimization, ensuring production-grade code and robust data validation.

This skill simulates the role of a quantitative analyst, providing comprehensive tools for building complex financial models, backtesting trading strategies, and analyzing market data. It covers advanced topics like portfolio optimization (Markowitz, Black-Litterman), calculating risk metrics (VaR, Sharpe ratio), and performing statistical arbitrage. Ideal for quantitative finance professionals needing rigorous data analysis, robust backtesting, and risk-adjusted performance evaluation.

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 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.

This tool applies advanced role mining techniques (including clustering and formal concept analysis) to analyze existing user-permission assignments. It discovers optimal, minimal role sets for Role-Based Access Control (RBAC) systems, helping organizations mitigate 'role explosion' and enforce the principle of least privilege. Ideal for identity governance and access control architecture redesign.

This skill guides security teams on systematically tuning SIEM detection rules in platforms like Splunk and Elastic. It focuses on reducing alert fatigue and false positives by analyzing historical alert volumes, establishing environmental baselines, creating context-aware whitelists, and measuring detection efficacy using metrics like precision and recall. This is crucial for maturing a Security Operations Center (SOC).

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.

Provides systematic Power BI performance troubleshooting guidance covering model optimization, DAX design, report layout, and capacity diagnostics, plus tool-driven measurement tips for faster page loads, interactions, and query execution.

High-performance Python DataFrame library built on Apache Arrow. Covers expression-based API, lazy query optimization, streaming out-of-core processing, aggregations, window functions, joins, and pandas migration for ETL and analytics pipelines.