Data infrastructure · 2025
Workbook Conversion
Understand a workbook before planning its migration.
This migration workflow builds on natezim’s open-source twbx-powerbi-converter. It brings sources, fields, calculations and views into a readable guide, suggests translations and makes manual-review work visible.
- Status
- Shipped
- Domain
- Migration tooling
- Role
- Open-source adaptation & migration workflow
- Year
- 2025
Explore the workflow with illustrative content.
Collect the source material
The first layer represents the records behind the work. Choose a source to follow its connection through the example.
Organise it into a document
The middle layer brings the chosen information into a structured page. The highlighted passage follows the selected source.
Keep the evidence in view
A separate review layer keeps the source reference close to the passage it supports. The connection remains visible when the document is inspected.
Illustrative content · no live data
Follow the logic into a new reporting format
Stack
- Python
- Document API
- Formula translation
- Desktop GUI
A desktop tool that inventories an analytics workbook and prepares a migration guide with formula mappings and items requiring manual review.
Map the existing workbook
The extraction brings together data-source information, fields, calculation dependencies, worksheets, dashboards and parameters.
A consolidated output makes it easier to assess the scope of a migration and review changes to the source workbook.
Translate what has a clear equivalent
Formula and chart mappings provide a starting point for the destination platform.
Tableau’s level-of-detail calculations need particular care because their filtering and aggregation behaviour does not translate directly to DAX. The guide identifies these areas for manual review.
Support a realistic implementation plan
Dependency and complexity information helps organise the work into a practical sequence.
The desktop interface produces a guide that an analyst or project lead can use in planning discussions, with manual-review items kept visible alongside the proposed translations.
Pipeline
Open-source conversion workflow
Stage Can reject
-
01
Workbook
Source file
-
02
Inspect
Fields, calculations and views
-
03
Dependency graph
Calculation order
-
04
Translate
Suggested target formulas
-
05
Review gaps
Manual-review items
Check LOD and filter behaviour
-
06
Guide
Step-by-step migration
Behind the work
The skills
that came together.
Migration analysis
- Workbook inventory and dependency analysis
- Formula and chart mapping
- Identification of platform-specific behaviour
Tool development
- Desktop interfaces for analysts
- Structured documentation generation
- Complexity and effort-assessment support
Project highlights
-
A clear inventory
Workbook structure gathered into one guide
-
Translation support
Formula and chart mappings to review
-
Manual work made visible
Platform-specific items identified early