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
Workbook Conversion · Interactive concept

Explore the workflow with illustrative content.

Stage 03 / 03

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.

01

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.

02

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.

03

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

  1. 01

    Workbook

    Source file

  2. 02

    Inspect

    Fields, calculations and views

  3. 03

    Dependency graph

    Calculation order

  4. 04

    Translate

    Suggested target formulas

  5. 05

    Review gaps

    Manual-review items

    Check LOD and filter behaviour

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