BI Python Toolkit — Binom Governance

BI tool

What this export can and cannot decide

BI exports create review material, not finished governance.

For sales / discovery

For tech / BI owner

Not designed for

Which script should I use?

Script	Use it for	Useful output	Next step
`bi_kpi_export.py`	KPI / measure formulas from Qlik, Power BI model.bim or Tableau workbook files.	`plan-json`, `csv`, `markdown`	Load the result into the KPI Definition task and complete owner, grain, filters and status.
`qlik_app_inventory.py`	Qlik Cloud app inventory and, optionally, sheet inventory including published/approved state.	`csv`, `plan-json`, `markdown`	Use it in app-scope, impact or cleanup tasks to decide which apps/sheets need review.

Downloads

Save the files into your local Python project folder. API keys stay on your machine.

Example commands

Adjust filenames, tenant and API key for your environment.

python3 bi_kpi_export.py qlik --input qlik-measures.json --format plan-json --output kpis.plan.json
python3 bi_kpi_export.py powerbi --input model.bim --format csv --output powerbi-kpis.csv
python3 bi_kpi_export.py tableau --input workbook.twbx --format markdown --output tableau-kpis.md

QLIK_TENANT="https://tenant.eu.qlikcloud.com" QLIK_API_KEY="..." python3 qlik_app_inventory.py --include-sheets --format csv --output qlik-inventory.csv

What do I do with the export?

CSV

Use CSV for Excel, quick filtering, app inventories and manual cleanup lists.

Markdown

Use Markdown for Sprint Planner notes, tickets, pull requests or wiki pages.

Plan JSON

Use plan JSON when you want structured rows that match planner-style tables and later automation.

After import, review each row: remove duplicates, assign an owner, mark status, and turn unclear formulas or unpublished sheets into follow-up tasks.

View and copy scripts

Review the Python files directly here, copy them, or download them as files.