04 · BI Modernization
Modernizing the BI layer.
Migrating ~19 Tableau dashboards from direct database connections to governed published data sources while improving consistency and uncovering a hidden data-quality issue.
Before
Direct database connections
After
Governed published sources
The problem
A growing Tableau environment had dashboards connecting directly to underlying database structures, creating opportunities for inconsistent logic and duplicated reporting patterns.
The work
I migrated approximately 19 dashboards to governed published data sources, standardizing the reporting layer and reviewing the underlying joins and deduplication logic.
The discovery
During the migration, I identified a non-deterministic deduplication issue affecting downstream metrics. The migration therefore became a data-quality investigation as well as a BI modernization effort.
The outcome
The reporting layer became more governed and consistent, while a hidden issue that could distort downstream metrics was surfaced and resolved.
Confidentiality note
Dashboard names, source structures, and company-specific implementation details are generalized for this public portfolio.
← Back to all work