Skill UI

This guide provides a comprehensive methodology for load testing and capacity planning within Snowflake data warehouses. It covers optimizing query performance by adjusting warehouse sizes (Scale UP), simulating high concurrency using multi-threading (Scale OUT), and configuring advanced scaling policies (Standard, Economy, Maximized). Users can benchmark critical queries using SQL and simulate real-world user traffic using Python, ensuring robust and cost-efficient production environments.

This skill guides the design of statistically rigorous A/B tests for optimizing product features, UI/UX changes, onboarding flows, and pricing models. It generates a complete test plan, including formulating hypotheses, calculating required sample sizes, estimating test duration, defining primary and guardrail metrics, and providing a detailed guide on interpreting results (ship, iterate, or reject).

A comprehensive guide for strengthening the methodological rigor of academic manuscripts, particularly for high-stakes journals. It covers advanced techniques for causal identification (e.g., Difference-in-Differences, Instrumental Variables, Regression Discontinuity), pre-analysis planning, linking theory to empirical tests, and defending claims against skeptical reviewers. This skill focuses on methodological architecture, not code.

A comprehensive guide for planning and stress-testing empirical analysis in financial intermediation, specifically for high-impact journals. It covers the construction of bank/loan-level panel datasets, defining variables (growth vs. levels), implementing advanced econometric specifications (e.g., fixed effects), and executing substantial robustness checks (placebo periods, alternative clustering). It also guides the planning of reproducible numerical illustrations for theoretical models.