data-analytics

Plugin data-analytics from marketplace modootoday in modootoday/marketplace. Commands read from the repo's manifest — 23 days ago.

Skills (16)

• bi-measure-context-debug

  Debug a BI measure, calculated column or conditional-format rule that returns wrong totals - name the model relationships and filter context first, reproduce the wrong value for one filter state and compute the expected value by hand, simplify only while subtotal, grand total and filtered results st

• calculator-reference-case-verification

  Prove a generated calculator, converter or numeric tool correct against known reference cases before anyone uses it - state the formula, domain and unit definitions first, build a reference table of at least 5 cases with boundaries and out-of-range inputs, test round trips and dimensions, reject dup

• chart-geometry-and-claim-recompute

  Check, build or caption charts by recomputing every number from the source data instead of reading the picture - bar totals and stacked sums against printed labels, axis origin and scale, bar length ratio against value ratio, legend to series match, correlation coefficients with sample size and miss

• clickhouse-query-authoring

  Write or review ClickHouse SQL that reads the primary key, states its timezone, deduplicates correctly and takes values as typed parameters - and check the plan before calling it fast. Use when the user writes, debugs or reviews a ClickHouse query, a materialised view or a table's ORDER BY and parti

• cohort-retention

  Build and read cohort retention - users grouped by the period they started, the share still active in each later period, with the activity definition, the timezone and the incomplete latest periods stated - so retention is compared like for like instead of from a single blended number. Use when the

• csv-formula-injection-export-check

  Check a CSV export against spreadsheet formula interpretation and machine-value contracts, including import and save/reopen evidence. Use when reviewing CSV safety, escaping or spreadsheet delivery. Not for exploit payloads or a universal sanitizer guarantee.

• experiment-design-readout

  Design an A/B test before it starts and read it honestly after - one primary metric, the minimum effect worth detecting, the sample size and duration that follow, a stopping rule fixed in advance, guardrail metrics, and a readout that reports the interval and refuses to call a winner from peeking or

• figure-source-key-join-and-total-check

  Build a Sankey, country map, heatmap or publication figure from parsed exports, handwritten records or country statistics without silent mismatches - parse the source into a table and check group totals against the export totals before drawing, join statistic keys to the real boundary or zone list a

• list-normalize-and-diff

  Compare two lists or clean identifier, name and address columns before a hand-off - state the normalization first, report differences in both directions with counts that reconcile, list every merged or dropped key, and keep postal codes and leading zeros. Use when asked what is in one list but not t

• macro-logic-recovery-refactor

  Recover the business logic of old spreadsheet macros or layered code and refactor shared parts without changing behavior - tabulate conditions, inputs, outputs and side effects per routine, keep every difference between near-duplicates as a parameter, treat shared state as an input, and compare outp

• metric-definition

  Define a product or business metric so two people computing it get the same number - the entity counted, the event that counts, the time window and timezone, inclusions and exclusions, the source table, the query, and the guardrail metric that catches gaming. Use when the user introduces or question

• naver-trend-analysis

  Read Naver search and shopping trend data correctly - Data Lab ratios are relative to the peak inside one request, not search volumes; absolute monthly volumes come from the search ad keyword tool; compare keywords only within one request and say which filters were used. Use when analysing Korean se

• open-response-theme-triangulation

  Turn a set of open survey responses into deduplicated idea groups that keep every response id, merge only ideas with a stated similarity reason, report counts in, merged, unclassified and out and reconcile them to the actual number of responses, process large sets in labelled batches so late respons

• retrieval-ranking-readout

  Read a retrieval ranking experiment from labelled queries and ranked results - calculate Recall at k and MRR, separate language slices, audit the candidate corpus and latency measurement, and reject a misleading aggregate win. Use when comparing lexical and embedding search, choosing a multilingual

• spreadsheet-formula-environment-check

  Write a spreadsheet formula or custom function for a named tool, version and locale - confirm the engine and list the functions it lacks before proposing anything, use the locale's argument separator, test blanks, text numbers and separators on sample rows, rebuild highlight-based totals from the co

• survey-recount-and-anonymize

  Before recording survey or interview results someone hands you, recount every tally from the per-row table instead of trusting the summary, name the bucket definitions each count uses, report where the summary and the recount differ, replace company or respondent names with numbers in anything share