Data & Analytics

ferroxlabs Skill

Tech social media content expert covering platform-specific formats (Twitter/X threads, LinkedIn posts, Dev.to articles), developer community engagement, code screenshots, technical threads, hashtag strategy, scheduling, and analytics. Use when the user asks about social media tech, social media tech best practices, or needs guidance on social media tech implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Quick techniques for cleaning CSV files - deduplication, normalization, encoding fixes, merging, and common data quality repairs using command-line tools and scripting. Use when the user asks about csv data cleaner, related techniques, best practices, or needs guidance in this domain. Do NOT use when the request is outside the scope of csv data cleaner or requires a different specialized skill.

ferroxlabs Skill

Search implementation expertise covering full-text search, indexing strategies, relevance scoring, faceted search, autocomplete, fuzzy matching, search analytics, and Elasticsearch/Typesense/Meilisearch patterns. Use when the user asks about search engineer, search engineer best practices, or needs guidance on search engineer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Advanced pandas techniques for data wrangling including performance optimization, method chaining patterns, MultiIndex operations, memory management, and idiomatic pandas code. Use when the user asks about pandas power user, related techniques, best practices, or needs guidance in this domain. Do NOT use when the request is outside the scope of pandas power user or requires a different specialized skill.

ferroxlabs Skill

Apache Spark expertise covering RDD vs DataFrame vs Dataset APIs, partitioning strategies, shuffle optimization, broadcast joins, caching, Spark SQL, structured streaming, UDFs, cluster sizing, performance tuning, and PySpark patterns for building scalable distributed data processing applications. Use when the user asks about spark engineer, spark engineer best practices, or needs guidance on spark engineer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Advanced SQL expertise including window functions, CTEs, recursive queries, query optimization with EXPLAIN plans, indexing strategies, pivot/unpivot operations, JSON operations, full-text search, stored procedures, and identification of performance anti-patterns across PostgreSQL, MySQL, and SQL Server. Use when the user asks about sql master, sql master best practices, or needs guidance on sql master implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Guide for cohort-based analytics including retention analysis, customer lifetime value calculation, behavioral segmentation, funnel analysis, and time-based cohort tracking with Python and SQL implementations. Use when the user asks about cohort analyst, related techniques, best practices, or needs guidance in this domain. Do NOT use when the request is outside the scope of cohort analyst or requires a different specialized skill.

ferroxlabs Skill

Expert data format transformation covering CSV parsing edge cases, encoding detection, JSON/XML/Parquet/Avro conversion, data type inference, schema validation, large file handling with streaming parsers, delimiter detection, and handling of malformed data across all common data interchange formats. Use when the user asks about csv transformer, csv transformer best practices, or needs guidance on csv transformer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

ClickHouse columnar OLAP expert covering table engine selection (MergeTree family), materialized views, aggregating merge trees, data sharding and replication, query optimization for analytical workloads, data ingestion patterns, and partition management for high-performance analytics. Use when the user asks about clickhouse analyst, clickhouse analyst best practices, or needs guidance on clickhouse analyst implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Advanced SQL for analytics covering window functions, CTEs, recursive queries, query optimization, pivoting, and complex analytical patterns for data warehouses and analytics databases. Use when the user asks about sql analytics expert, related techniques, best practices, or needs guidance in this domain. Do NOT use when the request is outside the scope of sql analytics expert or requires a different specialized skill.

ferroxlabs Skill

Complete inventory management system covering stock tracking methods, reorder point calculations, demand forecasting, ABC analysis, supplier relationship management, warehouse organization, inventory management software selection, shrinkage control, and just-in-time vs safety stock strategies. Use when the user asks about inventory manager or needs help with related topics. Do NOT use for unrelated domains or when a more specialized skill exists.

ferroxlabs Skill

Produces a data validation rule set for a spreadsheet. Defines validation type (list, range, custom formula, date, text length), error message text, and input hint text for each field. Prevents data quality problems at the point of data entry. Use when the user needs to restrict what can be entered into spreadsheet cells to maintain data quality. Do NOT use for cleaning existing dirty data (use spreadsheet-data-cleaning), conditional formatting rules (use conditional-formatting-rules), or building lookup formulas (use excel-lookup-formulas).

ferroxlabs Skill

Produces working Excel/Sheets lookup formulas for specific use cases. Generates exact VLOOKUP, HLOOKUP, INDEX/MATCH, and XLOOKUP formula strings with error handling wrappers, exact vs. approximate match settings, and performance guidance. Use when the user needs to look up values across spreadsheet tables, match data between sheets, or build cross-reference formulas. Do NOT use for pivot table construction (use pivot-table-builder), data cleaning formulas (use spreadsheet-data-cleaning), or conditional formatting rules (use conditional-formatting-rules).

ferroxlabs Skill

Analytics engineering expertise covering dbt best practices, metrics layer design, semantic modeling, dashboard design principles, KPI definition, A/B test analysis, cohort analysis, funnel analysis, retention analysis, and SQL style guide for building trusted, well-documented analytical systems. Use when the user asks about analytics engineer, analytics engineer best practices, or needs guidance on analytics engineer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Builds a pivot table specification from a described dataset. Determines field placement (rows, columns, values, filters), aggregation function selection, grouping rules, and formatting instructions. Output is the exact setup configuration. Use when the user needs to summarize data by categories, create cross-tabulations, or build summary tables from detailed records. Do NOT use for lookup formulas (use excel-lookup-formulas), data cleaning (use spreadsheet-data-cleaning), or chart creation (use chart-type-selector).

ferroxlabs Skill

CockroachDB distributed SQL expert covering multi-region deployment, survivability goals, schema design for distributed systems, online schema changes, transaction contention management, follower reads, locality-optimized partitioning, and operational best practices for globally distributed SQL databases. Use when the user asks about cockroachdb engineer, cockroachdb engineer best practices, or needs guidance on cockroachdb engineer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Generates a priority-ordered data cleaning protocol for a specific dataset. Identifies quality issues (duplicates, nulls, type mismatches, outliers) and produces the exact cleaning operations with formulas and documentation. Use when the user has a dataset with quality problems and needs a systematic plan to clean it before analysis. Do NOT use for initial data exploration (use eda-framework), statistical testing (use hypothesis-testing), or writing SQL/Python cleaning scripts (software-development scope).

ferroxlabs Skill

Produces Google Sheets-specific advanced formula patterns including ARRAYFORMULA, IMPORTRANGE, QUERY function syntax, Apps Script trigger patterns, and key behavioral differences from Excel. Generates exact formula strings for Sheets-native automation. Use when the user works in Google Sheets and needs formulas or features that differ from Excel or are unique to Sheets. Do NOT use for general spreadsheet formulas that work in both Excel and Sheets (use excel-lookup-formulas), data cleaning (use spreadsheet-data-cleaning), or full Apps Script programming (software-development scope).

ferroxlabs Skill

Designs spreadsheet automation using built-in features including named ranges, drop-down validation lists, INDIRECT references for dynamic ranges, array formulas, and QUERY/FILTER functions. Produces the specific formula strings for self-updating, self-validating spreadsheets. Use when the user wants to make their spreadsheet more automated, dynamic, or self-maintaining without VBA or scripts. Do NOT use for data validation rule design (use data-validation-setup), data cleaning formulas (use spreadsheet-data-cleaning), or Google Apps Script programming (software-development scope).

ferroxlabs Skill

Advanced Excel and Google Sheets mastery covering lookup functions, pivot tables, conditional formatting, macros and Apps Script, data validation, dashboard creation, and financial modeling techniques for business analysis. Use when the user asks about spreadsheet wizard, related techniques, best practices, or needs guidance in this domain. Do NOT use when the request is outside the scope of spreadsheet wizard or requires a different specialized skill.

ferroxlabs Skill

Builds a spreadsheet financial model structure with input, calculation, and output sections. Produces the formula architecture with assumption documentation and sensitivity analysis table. Outputs cell-ready formulas, not descriptions of what formulas to use. Use when the user needs to build a financial model, revenue projection, cost analysis, or business case in a spreadsheet. Do NOT use for personal budgeting (use budget-planning in personal-finance), business strategy analysis (use SWOT or financial analysis in business category), or data visualization of financial data (use chart-type-selector).

ferroxlabs Skill

Expert push notification systems covering APNs/FCM integration, notification channels, rich notifications, silent notifications, notification grouping, deep linking, scheduling, analytics, opt-in strategies, and delivery optimization. Use when the user asks about push notification, push notification best practices, or needs guidance on push notification implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Produces spreadsheet-native data cleaning formulas and operations. Generates exact TRIM, CLEAN, TEXT, SUBSTITUTE formulas for text issues, IF/IFERROR wrappers for null handling, COUNTIF for duplicate detection, and a cleaning sequence with before/after column strategy. Use when the user needs to clean data using spreadsheet formulas rather than external tools. Do NOT use for a full data cleaning protocol across any tool (use data-cleaning-protocol), setting up validation rules (use data-validation-setup), or auditing a spreadsheet model (use spreadsheet-model-audit).

ferroxlabs Skill

Audits a spreadsheet model for quality and reliability. Checks formula consistency, hardcoded values in formulas, circular references, missing error handling, and documentation gaps. Produces an audit report with specific remediation steps. Use when the user needs to verify the integrity of a spreadsheet model before relying on its outputs for decisions. Do NOT use for data cleaning (use spreadsheet-data-cleaning), setting up validation rules (use data-validation-setup), or building new financial models (use financial-model-template).

ferroxlabs Skill

Free-to-play mobile game design covering F2P design patterns, retention mechanics, short session design, monetization models (IAP, ads, battle pass), mobile UX, onboarding flows, A/B testing, analytics-driven design, and live operations strategy. Use when the user asks about mobile game designer or needs help with related topics. Do NOT use for unrelated domains or when a more specialized skill exists.

ferroxlabs Skill

Expert mobile analytics covering attribution tracking, funnel analysis, crash reporting integration, A/B testing frameworks, retention and cohort analysis, event taxonomy design, privacy-compliant data collection, real-time dashboards, and actionable metric strategies for iOS and Android applications. Use when the user asks about mobile analytics, mobile analytics best practices, or needs guidance on mobile analytics implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

ferroxlabs Skill

Produces a conditional formatting rule set for a specific use case. Specifies rule type (cell value, formula-based, color scale, data bars), criteria, color assignments with hex codes, and rule priority order. Output is the exact configuration to apply. Use when the user wants to highlight cells, create heat maps, add data bars, or visually encode data values in a spreadsheet. Do NOT use for chart color selection (use color-in-data), data validation rules (use data-validation-setup), or general spreadsheet formulas (use excel-lookup-formulas).

ferroxlabs Skill

Notification system architecture expert covering multi-channel delivery (email, SMS, push, in-app, Slack), user preference management, throttling and rate limiting, template engines, delivery tracking and analytics, batching/digest strategies, priority routing, and notification center design. Use when the user asks about notification system designer, notification system designer best practices, or needs guidance on notification system designer implementation. Do NOT use when the user needs a different specialized skill or is asking about an unrelated technology domain.

nota-america Skill

Takes a curriculum framework and a statutory or accreditation requirement list; produces a coverage table, gap summary, and CSV showing which framework content covers each requirement and where gaps exist.

nota-america Bundle

Use when tasks involve creating, editing, analyzing, or formatting spreadsheets (`.xlsx`, `.csv`, `.tsv`) with formula-aware workflows, cached recalculation, and visual review.

ferroxlabs Skill

Analytics guide for consumer health wearables including Apple Watch, Fitbit, Oura Ring, Garmin, and WHOOP. Covers heart rate variability, sleep staging, activity metrics, recovery scores, trend analysis, and translating raw data into actionable health insights. Use when the user asks about wearable data interpreter, or needs help with analytics guide for consumer health wearables including apple watch, fitbit, oura ring, garmin, and whoop. Do NOT use when the request requires professional medical advice or falls outside the scope of wearable data interpreter.

nota-america Skill

Google Sheets: Read values from a spreadsheet.

nota-america Skill

Google Sheets: Append a row to a spreadsheet.

nota-america Skill

Append a deal status update to a Google Sheets sales tracking spreadsheet.

nota-america Skill

Export a Google Sheets spreadsheet as a CSV file for local backup or processing.

nota-america Bundle

Analyze git repositories to build a security ownership topology (people-to-file), compute bus factor and sensitive-code ownership, and export CSV/JSON for graph databases and visualization. Trigger only when the user explicitly wants a security-oriented ownership or bus-factor analysis grounded in git history (for example: orphaned sensitive code, security maintainers, CODEOWNERS reality checks for risk, sensitive hotspots, or ownership clusters). Do not trigger for general maintainer lists or non-security ownership questions.