What we assess

The Microsoft BI estate is more than reports.

Modernization scope usually spans jobs, packages, datasets, stored procedures, semantic models, schedules, execution history, and access gaps. TangleMap assesses those surfaces together so teams can see the estate before choosing a path.

Core data estate

SQL Server

Databases, schemas, tables, views, stored procedures, functions, object definitions when included, linked-server candidates, and unresolved dependency warnings.

Orchestration

SQL Agent

Jobs, steps, schedules, owners, enabled state, commands, run context, and references to SSIS, SQL, PowerShell, and related operational patterns.

Reporting

SSRS

Catalog items, reports, shared datasets, embedded and shared data sources, parameters, RDL definitions, linked reports, subscriptions, item security, and execution-log summaries where access allows.

ETL catalog

SSISDB

SSISDB projects, packages, environments, environment variables, parameters, environment references, execution history, and SQL target candidates.

Semantic layer

SSAS Tabular

Tabular 1200+ models, tables, columns, measures, relationships, partitions, data sources, refresh metadata, and partition query definitions where available.

Target consideration

Power BI readiness

Power BI can be considered as a modernization direction, but it is not treated as the assumed answer or a core v1 source system.

Usage signals where available.

Execution and usage history improve prioritization, but the assessment does not depend on every source retaining complete history.

Coverage gaps are part of the output.

Permission limitations, unsupported versions, dynamic SQL, expressions, and inaccessible metadata reduce confidence. Those limits should be visible in the assessment rather than hidden.

Next step

Start with the assessment question.

If the estate is hard to document, hard to scope, or hard to modernize with confidence, start by turning it into structured evidence.