メニュー
このリポジトリの skills
SkillsMP は MadewellRD/skills-lab から 1,540 件の skill を収集しています。skill を開くとソースと詳細を確認できます。
MadewellRD/skills-lab収集済み skill 1,540 件中 40 件を表示しています。
design data classification and access control covering pii phi and pci classification of physical columns, roles groups and actual grants, row-level security predicates, column masking and tokenization, enforcement points, purpose limitation per audience,…
原文の言語: 英語
respond to bad data in production covering severity by consumer exposure rather than row count, containment that pauses dependents and holds exports, evidence capture before any re-run, lineage-derived blast radius including external recipients, the backfill…
原文の言語: 英語
plan data platform migration covering scope and what is deliberately retired rather than carried, dual-run design, parity reconciliation across row counts control totals and metric values with a stated tolerance, historical backfill depth, consumer cutover…
原文の言語: 英語
design conceptual logical and physical data models with a declared grain per fact, transaction periodic snapshot and accumulating snapshot fact types, conformed dimensions and the bus matrix, slowly changing dimension type per attribute with effective dating,…
原文の言語: 英語
design data observability monitors and alert routing covering freshness sla, row volume anomaly, schema drift detection, distribution and null rate drift, job failure, consumer lag, lineage-aware alert grouping and suppression, detection coverage, alert noise…
原文の言語: 英語
analyze data platform spend covering the compute storage and transfer breakdown from the billing export, top cost drivers named as specific queries pipelines and dashboards, spend attribution and the unattributable share, efficiency findings across partition…
原文の言語: 英語
define a data product as the decision it serves, naming consumers and external recipients, output port, accountable owner, criticality tier, regulatory or contractual use, and agreed freshness completeness and accuracy targets, plus the tables dashboards and…
原文の言語: 英語
design data quality tests and validation, writing out the actual assertions for freshness, volume, uniqueness at the declared grain, not null, referential integrity, accepted values, distribution drift and business rules, deriving thresholds from history or…
原文の言語: 英語
design data retention and erasure covering retention schedules with their regulatory contractual or operational basis, deletion mechanisms that actually remove data given table format snapshots time travel and backups, the propagation map of every derived…
原文の言語: 英語
design batch and change data capture ingestion, covering extraction pattern and watermark selection, snapshot plus stream stitching at a consistent log position, delete propagation, idempotency and deduplication keys, raw record preservation for replay,…
原文の言語: 英語
build data lineage and metadata covering column-level and table-level lineage from sql parsing, orchestrator metadata and query history, upstream and downstream impact analysis, blast radius, catalog registration and stewardship, business glossary mapping,…
原文の言語: 英語
define metrics and the semantic layer covering metric expressions with filters exclusions and denominators, entity dimension and measure modeling, grain validity, additive semi-additive and non-additive aggregation, distinct counts that do not roll up, time…
原文の言語: 英語
profile source systems before extraction, establishing record grain, candidate and actual primary keys, uniqueness violations, null rates, cardinality, value ranges, encoding and type surprises, arrival cadence and lateness, hard versus soft delete behavior,…
原文の言語: 英語
design streaming data pipelines covering event time versus processing time, partition keys and the ordering they buy, tumbling hopping sliding and session windows, watermarks and allowed lateness, delivery semantics as the consumer observes them, state store…
原文の言語: 英語
design the layered sql transformation stack from staging through intermediate to marts, covering materialization and incremental strategy with merge keys and lookback windows, deduplication and record selection, slowly changing dimension implementation with…
原文の言語: 英語
design warehouse and lakehouse storage, covering zone and layer architecture, table format and its transactional guarantees, partitioning against real query predicates, clustering and sort order, file sizing and compaction, snapshot and time travel retention…
原文の言語: 英語
reconcile balance sheet accounts to their supporting detail, tie subledgers to their general ledger control accounts, reconcile bank statements to book balances with outstanding items listed individually, age reconciling items and flag those surviving…
原文の言語: 英語
set the chart of accounts structure and its segments, the accounting policy elections in force, technical accounting memos, materiality thresholds with their benchmark, and the mapping from operational systems into the general ledger. use for coa design,…
原文の言語: 英語
classify three way match exceptions by cause, build the received-not-invoiced accrual from receipts rather than from arrived invoices, prepare the payment proposal with terms and early payment discounts captured, detect duplicate and near-duplicate invoices,…
原文の言語: 英語
produce the receivable aging tied to its control account, days sales outstanding with the formula stated, dispute triage separating billing defects from delivery problems from credit risk, a collections plan with an action owner and date per account, the…
原文の言語: 英語
run the audit request list with an owner due date and state per item, assemble traceable support packages that let a sampled item be followed from the ledger to its source document, tie the financial statements to the trial balance, respond to samples and…
原文の言語: 英語
review the billing run against executed contract terms, find contracts billed at the wrong amount or schedule or not billed at all, quantify unbilled and over-billed positions, tie invoiced amounts to recognized revenue, prepare credit memo and rebill…
原文の言語: 英語
build the annual operating plan by department and account with a named budget holder on every line, the driver and headcount model with start date timing and fully loaded cost, committed contractual spend separated from discretionary spend, the revenue build…
原文の言語: 英語
build the cash position by bank account and entity, the direct thirteen week receipts and disbursements forecast with its low point week, runway with the burn definition named explicitly, working capital movements explaining profit against cash, covenant…
原文の言語: 英語
tie the cap table grant by grant to the board consents that authorized each one, report the option pool position across authorized granted exercised forfeited and available, compute stock compensation expense with its model and inputs stated, produce the…
原文の言語: 英語
review travel and expense reports against the policy provision each item breaches, reconcile the corporate card program including unsubmitted spend and the accrual it drives, code entertainment benefits and non-deductible categories for their tax treatment,…
原文の言語: 英語
orchestrate accounting and finance operations across month-end close, revenue recognition and deferred revenue, accounts receivable and collections, accounts payable and three way match, expense management, spend approval and delegation of authority, chart of…
原文の言語: 英語
produce financial statements and the consolidation with eliminations shown, the disclosure set the framework requires, the board and investor package narrative, non-gaap and adjusted measures with their reconciliations, covenant computations built on the…
原文の言語: 英語
produce the reforecast with actuals to date separated from projection, driver-based scenarios distinguished by specific named assumptions rather than by percentage haircuts, the step changes a run rate cannot see such as contract ends launches and hiring,…
原文の言語: 英語
build the control matrix mapping each control to the risk it addresses with its owner frequency and evidence of operation, analyze segregation of duties conflicts across the erp banking and billing systems, run user access and privileged access reviews,…
原文の言語: 英語
run the close calendar and name the dependency holding up anything late, test cutoff at the period boundary, assemble the journal entry package with a preparer and a separate reviewer on every entry, establish accrual completeness from what was received…
原文の言語: 英語
run the five step revenue analysis per contract covering performance obligations, transaction price and variable consideration, standalone selling price and allocation, over time versus point in time recognition, the revenue schedule and deferred revenue…
原文の言語: 英語
build arr and mrr with the movement bridge from opening through new expansion contraction and churn to closing across the whole customer base, reconcile the run rate to recognized revenue, define and compute net and gross revenue retention and logo and…
原文の言語: 英語
determine the approver a commitment requires under the delegation of authority matrix, compute total commitment value including renewal and auto-renewal exposure rather than the first invoice, check budget headroom on the specific line the spend consumes,…
原文の言語: 英語
prepare the income tax provision with its current and deferred components, the effective tax rate reconciliation, the deferred tax roll-forward and valuation allowance evidence, nexus and registration exposure by jurisdiction, the indirect tax position for…
原文の言語: 英語
explain budget to actual and forecast to actual variances at the level the budget holder can act on, decompose movements into price volume mix timing and classification effects, separate timing differences from run rate changes, identify variances caused by…
原文の言語: 英語
triage cloud cost anomalies and trace each spike to the specific change that caused it rather than to the service the charge landed under. covers detection basis and baseline per anomaly, delta amount and duration, triage into explained expected waste or…
原文の言語: 英語
build cloud and vendor spend budgets scoped to named budget holders with a stated basis per line. covers run-rate baselines separated from growth assumptions and step changes, cost estimates for planned launches migrations and decommissions built from…
原文の言語: 英語
design and operate internal cloud chargeback and showback covering the model and its rationale, the internal rate card with the basis for any markup or subsidy, a chargeback ledger that balances to the provider invoice with the residual shown rather than…
原文の言語: 英語
prepare cloud and vendor negotiation positions covering the evidence pack with spend history and growth case modeled the way a vendor account team models it, commit sizing options with shortfall and true-up exposure quantified per option, an ask list valued…
原文の言語: 英語