Skill UI

This meta-skill is designed for complex decision analysis when a user provides or references structured documents such as contracts, quotes, spreadsheets, or notices. Instead of simple summarization, it extracts key evidence, identifies risks (e.g., renewal risk, payment terms), and structures the output into decision-ready formats, such as 'sign/reject/negotiate' recommendations, evidence tables, or required next actions. It supports input from PDF, DOCX, and XLSX formats.

This meta-skill provides a complete pipeline to bootstrap a domain knowledge base from any single seed input (URL, PDF, Git repository, or free text). It automatically classifies the source type, ingests the content using a multi-search engine, persists the summary to memory, and finally generates a structured XLSX index file, making the information immediately searchable and usable.

This meta-skill orchestrates a comprehensive workflow for analyzing PDF documents. It handles complex tasks such as summarizing, cross-document comparison, and targeted Q&A. It ensures findings are traceable by indexing evidence from various sources (full PDFs, pasted excerpts, etc.) and synthesizing structured insights across multiple files.

This advanced helper assists users in writing, debugging, and validating complex formulas, pivot tables, and array functions for platforms like Excel and Google Sheets. It ensures formulas are robust by handling common edge cases (e.g., blank rows, mixed data types, time zone quirks) and provides detailed, worked examples. It also manages cross-platform dialect translation.

Provides expert guidance for connecting to a local Power BI Desktop tabular model using PowerShell's Tabular Object Model (TOM) and ADOMD.NET. This skill enables model enumeration, executing complex DAX queries, modifying metadata (fields, measures, parameters), and managing the report canvas state via the Desktop Bridge. It is critical for direct model interaction when external CLIs are unavailable.

Comprehensive guidelines covering best practices for Power BI report development. This includes establishing a consistent design identity, applying visual hierarchy rules (like the 3-30-300 rule), managing color discipline, ensuring accessibility, and structuring pages based on their intended question or purpose. It helps transform raw data into professional, actionable, and user-friendly reports.

This guide details how to integrate R code, primarily using the powerful ggplot2 library, into Power BI reports. It enables the creation of advanced, static, and publication-quality statistical visualizations. The process covers the technical workflow, including setting up the JSON structure, writing the mandatory R script (e.g., using `print(p)`), handling data injection, and adhering to best practices for professional BI reporting.

Provides a structured, actionable review of Power BI reports across their entire lifecycle—from development to active use. The tool assesses report effectiveness, usage adoption, data performance (load times), and structural integrity. It generates a prioritized list of findings and concrete recommendations, helping users determine if reports are worth maintaining, optimizing, or retiring.

An interactive workflow designed to audit and standardize naming conventions within Power BI semantic models stored as TMDL files. It ensures that tables, columns, measures, and display folders adhere to consistent, human-readable, and business-aligned standards. The tool guides users through gathering critical business context before auditing and applying complex, cross-file reference updates to maintain data integrity.

This skill enables the generation of rich, inline SVG graphics directly within Power BI reports. By writing DAX measures that return SVG markup strings and setting the data category to ImageUrl, users can visualize complex charts (like sparklines, gauges, and progress bars) within standard visuals such as Tables, Cards, and Matrices. It guides users through the entire process, including recommended best practices like using existing UDF libraries and adhering to strict VAR-based DAX structures.

This tool guides users through the critical process of designing experiments *before* data collection. It helps select appropriate structures—such as factorial, crossover, or blocked designs—to ensure that collected data is interpretable and allows for robust causal inference. Use it when planning scientific studies, assigning subjects, or optimizing responses across multiple factors.

Calculates statistical power and required sample sizes for study planning. It supports both closed-form methods (for standard tests like t-tests, ANOVA) and simulation-based methods (for complex models like mixed models or survival analysis). Use this skill to determine the minimum detectable effect (MDE) or justify sample sizes for grants and IRB protocols before data collection.