Skill UI

A comprehensive guide to building production-ready Apache Airflow Directed Acyclic Graphs (DAGs). This skill covers best practices for operators, sensors, testing, deployment, and designing robust data pipelines. Use this when orchestrating complex workflows, managing ETL processes, or ensuring reliable batch job execution in a production environment.

This comprehensive skill simulates an expert business analyst, specializing in transforming complex raw data into actionable, strategic insights. The scope covers modern Business Intelligence (BI) platforms (Tableau, Power BI), AI-powered predictive modeling, designing robust KPI/OKR frameworks, advanced financial modeling, and optimizing business processes. It is designed for users needing to drive data-driven decision-making and create executive-level reports.

This comprehensive reference architecture details a multi-stage pipeline for web scraping and content ingestion using Firecrawl. It seamlessly integrates single-page scraping, site-wide crawling, URL mapping, and structured data extraction. The subsequent processing layer handles cleaning, deduplication, and chunking, making this blueprint ideal for designing robust knowledge bases, RAG systems, and complex AI data pipelines.

SimPy is a powerful, process-based discrete-event simulation framework written in Python. It is designed for modeling complex systems where entities interact with shared resources and time-based events occur, such as manufacturing lines, service queues, network traffic, or logistics networks. Use this skill to analyze resource contention, simulate process optimization, conduct capacity planning, and model dynamic system behaviors.

This skill automatically generates an interactive SQL Notebook designed to validate changes in dbt models or snapshots. It processes changes identified from a GitHub PR or local repository, generating comparison queries that compare 'before' (production) and 'after' (development) data states. It is essential for embedding data observability and quality checks into CI/CD pipelines.

Vaex is a high-performance Python library designed for processing and analyzing large tabular datasets that exceed available RAM. It supports out-of-core DataFrame operations, lazy evaluation, fast aggregations, and efficient visualization of big data. Ideal for working with massive CSV, HDF5, Arrow, or Parquet files, performing statistics on billions of rows, and building machine learning pipelines without memory constraints.

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 skill provides a comprehensive, step-by-step workflow for building complete Power BI reports from scratch using the pbir CLI. It guides users through model discovery, defining design briefs, visual layout, data validation, and final publishing. Ideal for automating the entire business intelligence (BI) reporting process and ensuring adherence to professional design standards.

This skill processes raw, unstructured materials (e.g., conversations, reports, controversies) into highly structured, reusable casebook entries. It focuses on identifying core facts, defining mechanism chains, and mapping responsibility links while ensuring rigorous data anonymization. It is designed for deep knowledge management and pattern recognition, helping users build a reliable, reusable knowledge base for future professional analysis, rather than generating immediate advice.

A systematic skill designed to investigate data incidents, including freshness delays, volume anomalies, schema changes, and ETL failures. It guides the agent through a comprehensive process using Monte Carlo's observability metadata and optional direct data querying to pinpoint the root cause.

This guide assists researchers in strengthening the methodological rigor of academic work, particularly in political science. It provides structured methods for defending research design, covering rigorous causal identification for quantitative work (e.g., DiD, IV, RDD) and systematic case selection/process tracing for qualitative analysis. Use this when facing reviewer skepticism or preparing a pre-analysis plan to ensure the evidence credibly connects to the theoretical argument.

This guide provides a rigorous framework for strengthening research design in complex social science manuscripts. It covers methodologies ranging from advanced quantitative causal inference (e.g., DID, IV, RDD) to systematic qualitative case selection and process tracing. It teaches how to defend assumptions, rule out rival explanations, and generalize findings beyond the specific case or setting.