qlik-assessment

Estrellas9

Forks9

Actualizado27 de julio de 2026 a las 15:53

Take inventory of a Qlik Cloud tenant and produce a migration-readiness readout — app/space/user counts, per-app complexity (master-measure expression convertibility, chart-type coverage, Set Analysis / Section Access flags, data model size), reload health, and a value/cost-ranked migration shortlist. Use to scope a Qlik→Sigma migration or audit BI sprawl. qlik-cli driven; hands off to qlik-to-sigma.

Instalación

Instalar con Codex o Claude Copia este prompt, pégalo en Codex, Claude u otro asistente, y deja que revise la página de la skill y la instale por ti.

Fuente

twells89

twells89/sigma-migration-skills

Abrir repositorio de GitHub Ver repositorios del creador

Descarga

Ocupaciones relacionadasSOC

Basado en la clasificación ocupacional SOC

Desarrolladores de softwareOcupaciones informáticas y matemáticas·SOC 15-1252

Explorador de archivos

15 archivos

SKILL.md

readonly

name	qlik-assessment
description	Take inventory of a Qlik Cloud tenant and produce a migration-readiness readout — app/space/user counts, per-app complexity (master-measure expression convertibility, chart-type coverage, Set Analysis / Section Access flags, data model size), reload health, and a value/cost-ranked migration shortlist. Use to scope a Qlik→Sigma migration or audit BI sprawl. qlik-cli driven; hands off to qlik-to-sigma.
user-invocable	true

Qlik Assessment

STATUS: working inventory (qlik-cli driven). Mirrors tableau-assessment / powerbi-assessment / domo-assessment: same value / (1 + cost) scoring and migrate-first / easy-win / moderate / needs-gap-scout / retire tags.

Read first:

refs/complexity-scoring.md — the Qlik convertibility rubric (expression + viz buckets)
../qlik-to-sigma/refs/connection.md — qlik-cli auth + the two M2M gotchas
PRIVACY.md — read-only posture
refs/output-shapes.md — exact inventory.json shape the renderers consume
refs/readout-template.md — readout.html section ordering + Sigma-branded theme

The key idea

The same convert_qlik_to_sigma translation rules that drive the converter also predict migration effort: bucket each master-measure expression (auto / manual / unhandled) and each chart's viz type against Sigma's coverage. Set Analysis → manual (Sigma SumIf); Aggr()/Dual()/selection-state/Range* → unhandled.

Phases

Probe — qlik context use; qlik item ls --resourceType app; confirm spaces/users visibility (M2M only sees granted spaces — see connection.md). 1–2. Inventory — apps (+ itemViews, resourceReloadStatus, lastReloadTime, hasSectionAccess, isDirectQueryMode, resourceSize), spaces, users. scripts/qlik-inventory.py.
Per-app complexity — master measures (Engine MeasureList) bucketed by expression; chart objects bucketed by viz type; Section Access & DirectQuery flags; data-model table count from the load script.
Shortlist — cost = 10·unhandled + 3·manual + 1·hint; value = itemViews × √(distinct, when available) else size/complexity proxy; score = value/(1+cost); tag.
Readout — qlik-inventory.py writes inventory.json + readout.md; then scripts/render-readout-html.rb --out <dir> renders the customer-facing, Sigma-branded readout.html (same theme as tableau-assessment).
Hand off — to qlik-to-sigma (ask the user which apps first).

Scripts

Script	Phase	Purpose
`scripts/qlik-inventory.py`	0–4	Enumerate apps/spaces/users, per-app expression+viz complexity, score + tag → `inventory.json` + `readout.md`
`scripts/render-readout-html.rb`	5	Render the Sigma-branded `readout.html` from `inventory.json` (`ruby scripts/render-readout-html.rb --out <dir>`)

qlik-inventory.py --out assessment-<tenant> (uses the active qlik-cli context). Per-app deep complexity reuses the MeasureList enumeration from qlik-to-sigma/scripts/qlik-discover.py.

Open work

Usage granularity: itemViews is app-level; per-sheet usage needs the tenant audit/usage API.
Cross-tenant roll-up via the DomoStats-equivalent (Qlik "App analyzer" governance apps).

Más de este repositorio

mismo repositorio

domo-to-sigma

twells89/sigma-migration-skills

Convert a Domo dashboard (pages + cards + DataSets + Beast Modes) into a Sigma data model and matching workbook. Use when the user has a Domo instance and wants to recreate a dashboard in Sigma. Discovery via Domo's public + private APIs, Beast Mode (MySQL-dialect SQL) → Sigma formula translation, a reuse check before building a new data model, data model + workbook creation via the Sigma REST API, layout generation, Domo PDP → Sigma row-level-security detection, and parity verification against the same warehouse — driven by `scripts/*.rb`.

2026-07-319

hex-to-sigma

twells89/sigma-migration-skills

Convert a Hex project (SQL cells, single-value/METRIC cells, EXPLORE charts, app layout) into a Sigma data model and matching workbook. Discovery via a Hex project export file (Hex's REST API does not expose cell content), calc translation, DM + workbook creation via REST, layout, and warehouse parity verification.

2026-07-319

looker-to-sigma

twells89/sigma-migration-skills

Convert a Looker instance (LookML semantic model + dashboards) into a Sigma data model and matching workbook(s). Use when the user has Looker content — LookML projects, explores, or dashboards (user-defined OR LookML-defined) — and wants to recreate it in Sigma. Discovery via the Looker REST API 4.0 / Looker MCP server (or LookML files offline), model conversion via the local vendored LookML converter (convert_lookml_to_sigma MCP tool as a manual fallback), dashboard → workbook conversion from the Looker Dashboard API JSON, build via the Sigma REST API, and 3-way parity verification against the source warehouse — driven by `scripts/*`.

2026-07-319

powerbi-to-sigma

twells89/sigma-migration-skills

Convert a Power BI report + semantic model into a Sigma data model and matching dashboard. Use when the user has a Power BI report (in Power BI Service / Fabric, or a .pbix/.pbit file) and wants to recreate it in Sigma. Covers connecting to Power BI with no Entra app, extracting the model (TMSL) + report layout (PBIR/Report-Layout), converting via the sigma-data-model MCP, posting the data model + workbook via REST, and parity verification. Can also author dashboards back INTO Power BI via the Fabric write API.

2026-07-319

qlik-to-sigma

twells89/sigma-migration-skills

Convert a Qlik Sense / Qlik Cloud app into a Sigma data model and matching workbook. Use when the user has a Qlik Cloud tenant/app and wants to recreate it in Sigma. Discovery via qlik-cli (Engine + REST), Qlik-expression → Sigma-formula translation via the local vendored convert_qlik_to_sigma converter (MCP tool only as a manual fallback), data model + workbook creation via the Sigma REST API, and parity verification against the source warehouse. Requires qlik-cli + a Sigma SIGMA_API_TOKEN.

2026-07-319

quicksight-to-sigma

twells89/sigma-migration-skills

Convert an Amazon QuickSight analysis or dashboard into a Sigma data model and matching dashboard. Use when the user has a QuickSight analysis/dashboard and wants to recreate it in Sigma. Covers AWS-CLI extraction of the analysis definition + datasets + data sources, calc-field / data-prep translation via the local vendored converter (the convert_quicksight_to_sigma MCP tool is a manual fallback only), posting the data model + workbook via the Sigma REST API, layout, and parity verification against the same warehouse.

2026-07-319

name	qlik-assessment
description	Take inventory of a Qlik Cloud tenant and produce a migration-readiness readout — app/space/user counts, per-app complexity (master-measure expression convertibility, chart-type coverage, Set Analysis / Section Access flags, data model size), reload health, and a value/cost-ranked migration shortlist. Use to scope a Qlik→Sigma migration or audit BI sprawl. qlik-cli driven; hands off to qlik-to-sigma.
user-invocable	true

Qlik Assessment

STATUS: working inventory (qlik-cli driven). Mirrors tableau-assessment / powerbi-assessment / domo-assessment: same value / (1 + cost) scoring and migrate-first / easy-win / moderate / needs-gap-scout / retire tags.

Read first:

refs/complexity-scoring.md — the Qlik convertibility rubric (expression + viz buckets)
../qlik-to-sigma/refs/connection.md — qlik-cli auth + the two M2M gotchas
PRIVACY.md — read-only posture
refs/output-shapes.md — exact inventory.json shape the renderers consume
refs/readout-template.md — readout.html section ordering + Sigma-branded theme

The key idea

Phases

Probe — qlik context use; qlik item ls --resourceType app; confirm spaces/users visibility (M2M only sees granted spaces — see connection.md). 1–2. Inventory — apps (+ itemViews, resourceReloadStatus, lastReloadTime, hasSectionAccess, isDirectQueryMode, resourceSize), spaces, users. scripts/qlik-inventory.py.
Per-app complexity — master measures (Engine MeasureList) bucketed by expression; chart objects bucketed by viz type; Section Access & DirectQuery flags; data-model table count from the load script.
Shortlist — cost = 10·unhandled + 3·manual + 1·hint; value = itemViews × √(distinct, when available) else size/complexity proxy; score = value/(1+cost); tag.
Readout — qlik-inventory.py writes inventory.json + readout.md; then scripts/render-readout-html.rb --out <dir> renders the customer-facing, Sigma-branded readout.html (same theme as tableau-assessment).
Hand off — to qlik-to-sigma (ask the user which apps first).

Scripts

Script	Phase	Purpose
`scripts/qlik-inventory.py`	0–4	Enumerate apps/spaces/users, per-app expression+viz complexity, score + tag → `inventory.json` + `readout.md`
`scripts/render-readout-html.rb`	5	Render the Sigma-branded `readout.html` from `inventory.json` (`ruby scripts/render-readout-html.rb --out <dir>`)

qlik-inventory.py --out assessment-<tenant> (uses the active qlik-cli context). Per-app deep complexity reuses the MeasureList enumeration from qlik-to-sigma/scripts/qlik-discover.py.

Open work

Usage granularity: itemViews is app-level; per-sheet usage needs the tenant audit/usage API.
Cross-tenant roll-up via the DomoStats-equivalent (Qlik "App analyzer" governance apps).