Skill UI

Automates churn analysis workflows by offering guidance, best practices, and production-ready code for SQL, visualization, statistical work, and BI outputs within data analytics projects.

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.

Provides automated regression analysis guidance, best practices, code snippets, and validation for SQL, BI, visualization, and statistical workflows in data analytics projects.

Seaborn is a powerful Python library for creating publication-quality statistical graphics. It is designed for dataset-oriented plotting, making it ideal for exploratory data analysis, multivariate analysis, and visualizing complex relationships, distributions, and comparisons with minimal code. It builds upon Matplotlib, offering high-level interfaces for functions like scatterplots, heatmaps, and pair plots.

A comprehensive skill for building detailed threat actor profiles. It systematically collects and correlates intelligence from diverse open-source sources, including vendor reports, dark web forums, social media, and code repositories. The resulting structured dossiers map adversary motivations, capabilities, infrastructure, and Tactics, Techniques, and Procedures (TTPs), enabling robust attribution and defensive planning.

This skill detects covert data exfiltration occurring over DNS tunnels. It analyzes DNS query names by computing Shannon entropy, examining query length distributions, and identifying high subdomain cardinality. It is essential for security operations, incident response, and proactive threat hunting when suspicious or encoded DNS activity is suspected.

Astropy is a core Python library for astronomy and astrophysics workflows. It provides essential functionality for astronomical research and data analysis, including coordinate transformations, unit and quantity calculations, FITS file operations, cosmological calculations, precise time handling, tabular data manipulation, and astronomical image processing. Use it for implementing or debugging astronomical data analysis code.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.

A static analysis tool that audits SQL code for common cost and performance anti-patterns (e.g., full-table scans, Cartesian joins). It calculates a query health score (0-100) for data warehouses like BigQuery, Snowflake, and Redshift, providing a prioritized, actionable plan with concrete fixes and estimated cost savings. Essential for FinOps and data quality assurance.

This skill utilizes hyperbolic space embedding (Poincare ball model) to represent complex data structures with inherent hierarchy, such as dependency trees, ontologies, or module taxonomies. Unlike standard Euclidean embeddings, hyperbolic space preserves hierarchical distances efficiently, allowing for accurate distance calculations (geodesic distance) that grow logarithmically with tree depth. It is ideal for advanced knowledge graph analysis and code architecture mapping.

This guide details the rigorous data analysis and reporting standards required for top-tier academic journals, such as AJPS. It focuses intensely on reproducibility, ensuring that all results—from primary findings to exploratory models—are generated by a single, seeded master script. Key requirements include reporting uncertainty intervals, proving robustness, adhering to pre-registration discipline, and accommodating mandatory third-party code verification. Use this when conducting complex empirical research in social sciences or political science, needing to withstand intensive methodolo...

A comprehensive guide for strengthening the methodological rigor of academic manuscripts, particularly for high-stakes journals. It covers advanced techniques for causal identification (e.g., Difference-in-Differences, Instrumental Variables, Regression Discontinuity), pre-analysis planning, linking theory to empirical tests, and defending claims against skeptical reviewers. This skill focuses on methodological architecture, not code.