Skill UI

A comprehensive skill for managing the entire lifecycle of datasets on the Hugging Face Hub. It allows users to initialize, configure, and stream updates for datasets of various types (Chat, Text Classification, Tabular). Crucially, it extends data handling capabilities by enabling powerful SQL-based querying and transformation directly on Hub datasets using the DuckDB engine, facilitating advanced data exploration and pipeline creation.

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.

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.

Provides expert guidance for connecting to Power BI Desktop's local tabular model using the Tabular Object Model (TOM) and ADOMD.NET via PowerShell. This skill covers model enumeration, executing DAX queries, metadata modification (tables, measures, relationships), query tracing, and model refreshing. It is specifically designed for managing the underlying data model structure when external tools like Tabular Editor CLI are unavailable.

A comprehensive guide to authoring, optimizing, and validating Power Query M expressions used within semantic model partitions. This resource covers crucial topics such as maintaining query folding for performance, applying early filtering and column pruning, and leveraging the Power Query API for robust data validation and debugging.

Velociraptor is a powerful open-source platform for endpoint visibility and digital forensics. It allows users to deploy agents across thousands of endpoints and execute sophisticated VQL (Velociraptor Query Language) queries. This enables large-scale, on-demand forensic artifact collection, TTP hunting, and continuous monitoring during incident response, even on air-gapped or unmanaged systems.

Query Microsoft Fabric and Power BI semantic models with DAX to build trustworthy dashboards: reuse governed measures, design KPIs with target and trend, wire crossfiltering, and test queries with an execute-inspect-fix loop.