Skill UI

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.

A comprehensive workflow for scraping and extracting structured data from Google search results using the SerpApi. It captures all key components, including organic listings, knowledge graphs, answer boxes, People Also Ask (PAA), local pack results, and related searches. Ideal for SEO monitoring, market research, competitive analysis, or building search-powered features that require deep, structured data insights.

A comprehensive guide and set of tools for embedding dynamic Python visualizations (using matplotlib and seaborn) into Power BI reports. It details the structured workflow, including script injection, data handling (dataset DataFrame), and mandatory best practices for generating static PNG output. Ideal for advanced data analysis and complex reporting.

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.