Skill UI

This skill provides production patterns for implementing robust data quality validation using Great Expectations, dbt tests, and formal data contracts. It is essential for building reliable, automated, and verifiable data pipelines, ensuring data integrity throughout the entire ETL/ELT process, and establishing clear data governance rules.

This skill safely randomizes the order of repetitive JSON objects within an array without corrupting the data or breaking the JSON syntax. It acts as a data engineer, rigorously validating the input schema (checking for property consistency and lack of nesting) before performing the shuffle. It ensures data integrity is maintained while reordering records, making it ideal for testing, simulation, or data preparation workflows.

Create truthful, accessible, publication-ready scientific figures using Matplotlib, Seaborn, or Plotly. Ensures data integrity, proper encoding, accessibility compliance, and journal export planning for research publications. Includes guidelines for uncertainty displays, color/contrast review, and metadata validation.

This guide identifies and provides solutions for common anti-patterns and mistakes when working with Snowflake. It covers best practices in SQL writing, warehouse resource management, data loading strategies (e.g., using MERGE), and access control setup. It is essential for auditing existing deployments, onboarding new users, or performing code reviews to ensure cost efficiency and data integrity.

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.

Bilig WorkPaper provides a code-first runtime environment for complex spreadsheet business logic. It allows agents to interact with structured data using formulas and JSON workbooks via deterministic API calls (MCP/TypeScript). This is ideal for replacing unreliable UI automation in use cases like quote calculators, budget modeling, and data validation, ensuring calculation integrity through explicit read-back proof.

This skill provides a comprehensive framework for evaluating Power BI reports. It assesses report quality, usage adoption rates, performance metrics, and structural integrity across different lifecycle stages (development, testing, active use). It analyzes usage data, audience reach, and performance bottlenecks, generating actionable feedback and optimization recommendations to ensure reports are effective and maintainable.

This tool allows users to export comprehensive marketing data—including KPIs, contact records, campaign results, and performance snapshots—to external data stores. It supports integration with BigQuery for advanced data warehousing, Google Sheets for stakeholder collaboration, and Supabase for custom application development. The process includes mandatory PII handling, schema transformation, and detailed execution summaries to ensure compliance and data integrity for downstream analytics and reporting.

A comprehensive guide for preparing scholarly manuscripts involving spatial data. It outlines best practices for documenting data provenance (sources, projections, processing chains), ensuring reproducibility, and adhering to critical ethical standards such as geoprivacy and human-subjects protection. Essential for maintaining research integrity in academic publishing.

A comprehensive guide detailing the selection of appropriate statistical estimators (e.g., DiD, Panel FE, ANOVA) for various research designs. It also outlines rigorous best practices for ensuring data integrity, conducting robustness checks, and adhering to journal code-sharing policies, ensuring highly reproducible empirical research.

This guide provides comprehensive guidelines for selecting, validating, and defending rigorous research designs for Contemporary Accounting Research (CAR) manuscripts. It covers various approaches—including panel archival, controlled experiments, analytical models, field studies, and surveys—while stressing critical rigor checks like identification strategy, internal validity, and model discipline. It also mandates adherence to ethical review processes and data integrity policies.

This guide provides comprehensive standards for designing, quantifying, and narrating scientific figures and tables for high-impact publications. It details best practices for maintaining image integrity (e.g., uncropped blots, linear adjustments), ensuring all data points are quantified across replicates, and structuring the visual evidence to advance a clear, mechanistic argument step-by-step.