AI Skills for Data Analyst

Facilitates the creation, editing, and analysis of spreadsheet files, ensuring professional formatting and error-free formulas.

Generates thorough, cited research reports from multiple web sources using firecrawl and exa tools for in-depth analysis.

Facilitates neural search for web, code, and company research using Exa MCP, enhancing information retrieval and analysis.

Processes and converts documents using the Nutrient DWS API, supporting various formats and OCR capabilities.

Provides best practices for ClickHouse database patterns, query optimization, and analytics for high-performance data engineering.

Provides a decision framework for choosing between regex and LLM for structured text parsing, optimizing accuracy and cost.

Facilitates a research-first workflow to identify existing tools and libraries before coding, enhancing efficiency and reducing redundancy.

Provides PostgreSQL database patterns for query optimization, schema design, indexing, and security based on Supabase best practices.

Enables tracking of user interactions in Metabase by adding product analytics events using Snowplow for enhanced data insights.

Enhances SQL query performance through optimization techniques, indexing strategies, and EXPLAIN analysis for faster database operations.

Facilitates data quality validation using Great Expectations and dbt tests to ensure reliable data pipelines and metrics.

Guides implementation of GDPR-compliant data handling, focusing on consent management and privacy controls for EU personal data.

Implements evaluation strategies for LLM applications using metrics, human feedback, and benchmarking to ensure quality and performance.

Optimizes Apache Spark jobs through partitioning, caching, and memory tuning to enhance performance and scalability.

Optimizes Python code performance through profiling and best practices, enhancing application speed and efficiency.

Equips users with advanced memory forensics techniques for incident response and malware analysis using tools like Volatility.

Facilitates the documentation of significant technical decisions through Architecture Decision Records (ADRs) for better project clarity.

Provides a checklist of common Python anti-patterns to avoid, aiding in code review, debugging, and establishing coding standards.

Designs effective KPI dashboards with best practices for metrics selection and visualization to enhance business decision-making.

Transforms raw data into compelling narratives that drive decisions and inspire action through effective visualization and storytelling.