qlik-assessment

Estrelas6

Forks7

Atualizado24 de junho de 2026 às 21:15

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.

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Fonte

sigmacomputing

sigmacomputing/quickstarts-public

Abrir repositório GitHub Ver repositórios do creator

Download

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Analistas de sistemas de computadorInformática e Matemática·SOC 15-1211

Explorador de arquivos

10 arquivos

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).

Mais deste repositório

mesmo repositório

hex-to-sigma

sigmacomputing/quickstarts-public

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-316

cognos-assessment

sigmacomputing/quickstarts-public

Take inventory of an IBM Cognos Analytics estate and produce a migration-readiness readout — content-tree counts, per-artifact conversion complexity (scored against the Cognos→Sigma converter's exact coverage), an estate-wide auto-migration percentage, a named gap analysis, and an effort/wave plan. Use when a user wants to scope a Cognos→Sigma migration, audit Cognos sprawl, or pick which modules / reports to convert first. Read-only, all-free, ~Tableau-assessment-style pre-scoping that complements (does not replace) a deeper paid engagement.

2026-07-276

cognos-to-sigma

sigmacomputing/quickstarts-public

Migrate IBM Cognos Analytics content to Sigma. Use when the user has a Cognos Data Module, Framework Manager package, report (Report Studio / CA Reporting), or dashboard (exploration) and wants to recreate it in Sigma. Converts Data Module JSON → Sigma data model and report-spec XML → Sigma workbook, translating the Cognos expression DSL and flagging constructs with no clean Sigma analog. Dashboards (exploration JSON) are hand-authored per refs/dashboard-migration.md (tabs → separate Sigma pages). Discovery via the CA REST API.

2026-07-276

sisense-assessment

sigmacomputing/quickstarts-public

Take inventory of a Sisense estate and produce a migration-readiness readout — ElastiCube/Live model counts, dashboard counts, a widget-type histogram, JAQL complexity, dataset/connection mix, and per-dashboard AUTO / HINT / MANUAL / UNHANDLED tags scored against the sisense-to-sigma converter's actual coverage. Use when a user wants to scope a Sisense→Sigma migration, audit BI sprawl, or pick which dashboards to convert first. Read-only, all-free pre-scoping over the Sisense REST API.

2026-07-216

sisense-to-sigma

sigmacomputing/quickstarts-public

Migrate Sisense to Sigma. Use when the user has a Sisense instance — ElastiCube or Live data models and dashboards — and wants to recreate them in Sigma. Pulls the source live over the Sisense REST API (data model schema export + dashboards/widgets), converts the model to a Sigma data model and the dashboards to a Sigma workbook (pivot2→pivot-table, indicator→KPI, chart/*→chart, filters→controls), translates JAQL formulas to Sigma formulas, and verifies data parity by running JAQL against Sisense and comparing to the Sigma query. For a full migration it lands the source data in Snowflake so both tools read the same warehouse. Translates what maps cleanly and flags what doesn't (custom JAQL, BloX/plugin widgets, scripted dashboards) instead of emitting wrong logic.

2026-07-216

metabase-assessment

sigmacomputing/quickstarts-public

Take inventory of a Metabase instance and produce a migration-readiness readout — collection-tree counts, per-artifact conversion complexity (scored against the Metabase→Sigma converter's exact coverage), an estate-wide auto-migration percentage, a named gap analysis, and an effort/wave plan. Use when a user wants to scope a Metabase→Sigma migration, audit Metabase sprawl, or pick which models / questions / dashboards to convert first. Read-only, all-free, ~Tableau-assessment-style pre-scoping that complements (does not replace) a deeper paid engagement.

2026-06-256

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).