Skill UI

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.

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

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.

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.

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.

This guide is designed for authors targeting top-tier journals like Foundations of Computational Mathematics (FoCM). It outlines the journal's high academic standards, requiring deep mathematical rigor, established theorems, and proofs (e.g., convergence, complexity bounds) at the math-computation interface. It emphasizes theoretical foundations over empirical results, making it ideal for advanced research in numerical analysis, optimization theory, and computational geometry.

This guide assists researchers in selecting and rigorously defending the appropriate methodology for Management Science (INFORMS) manuscripts. It covers both analytical modeling approaches (e.g., optimization, stochastic processes, game theory) and empirical designs (e.g., quasi-experiments, field trials). It ensures the chosen design not only matches the research question but also meets strict departmental standards and generates decision-relevant managerial insights.

Patterns and best practices for ClickHouse analytics, including table design, query optimization, aggregations, materialized views, and bulk data ingestion for high-performance OLAP workloads.

Expert guidance for designing scalable batch and streaming data pipelines, covering ETL/ELT, orchestration, dbt transformations, data quality, lakehouse storage, monitoring, and cost optimization.