Back to your Cognos workflow

BI rationalization

A clearer BI estate.
A reason for every next step.

Find overlapping reports, understand what makes each asset useful, and focus your next investment on the work that matters.

FROM ANALYZED ASSETS TO INFORMED DECISIONS
  1. Start withYour reports, models and analysis
  2. Work with CoDashScore. Compare. Inspect the evidence.
  3. Your team decidesKeep, consolidate or review for retirement

The rationalization workflow

Follow the evidence to the next action.

Explore each step, from the inventory to the workspace review. Your report owners bring the business context.

Start with the assets you can see.

Review analyzed assets across your selected platforms. Inspect their tables, fields, calculations and complexity before choosing the scope.

Understand the estate: input, work and outcome
  1. You bringAnalyzed BI assets
  2. CoDash helps youSearch and scope the inventory
  3. You take forwardA defined set of assets to review

Export the inventory as CSV. Coverage reflects the assets and metadata available from your source platforms.

Give the review a consistent starting point.

Choose a strategy template and run the analysis. Inspect asset scores and recommendations alongside the available evidence.

Review the scores: input, work and outcome
  1. You choosePlatforms and a review strategy
  2. CoDash helps youScore the selected assets
  3. You take forwardRecommendations to investigate

Scores cover usage, uniqueness, business value, freshness and dependency safety. Confirm the available inputs with report owners; a score alone does not establish business value.

See what is shared—and what still matters.

Explore groups of similar assets, their overlap and the suggested reference asset. Open the detail to compare shared tables, fields and calculations, alongside differences.

Compare the overlap: input, work and outcome
  1. You inspectA group of similar assets
  2. CoDash helps youCompare shared and unique content
  3. You take forwardConsolidation candidates with evidence

Similarity is a reason to investigate. Confirm audiences, filters and reporting obligations before treating two reports as interchangeable.

Put business context beside the recommendation.

Review the asset's score breakdown, strategy context and similar reports. Work with the owner to decide what should stay, change or be considered for retirement.

Agree the next action: input, work and outcome
  1. CoDash providesThe asset's supporting evidence
  2. Your team addsBusiness need and reporting context
  3. You decideThe appropriate next action

Your team owns acceptance and retirement decisions. Validate replacement coverage and dependencies before changing the reporting people rely on.

Continue with the evidence in view.

Open an asset and its related candidates in an analyzer workspace for further review or consolidation work. Use exports and run history to support the wider team discussion.

Take the work forward: input, work and outcome
  1. You selectAn asset and related candidates
  2. CoDash helps youContinue the workspace review
  3. Your team plansThe next reporting improvement

Inventory, scores and similarity groups can be exported as CSV. Run history retains the strategy and scope context for completed analysis.

Understand the recommendations

A recommendation starts the conversation.

CoDash surfaces the evidence. Your team confirms the action against business needs, dependencies and reporting obligations.

Scroll to compare all columns

From a recommendation to an owner-reviewed action
RecommendationWhat to exploreWhat your team confirms
KeepThe asset's distinct contributionWho relies on it and which reporting needs it serves
MergeShared content and a consolidation candidateThe replacement preserves required calculations, filters and coverage
ArchiveWhether the asset is a retirement candidateUsage, dependencies and obligations before any retirement
Review requiredThe evidence or context needing closer attentionWhat to investigate before choosing an action

An example in practice

Shared data. Different reporting needs.

An illustrative comparison of two sales reports. Shared content helps identify candidates; differences shape the decision.

Scroll to compare all columns

Illustrative example: monthly sales and regional sales
Review pointMonthly sales reportRegional sales report
Shared contentSales, customer and product dataSales, customer and product data
Distinct contentMonth-end totals and period comparisonsTerritory detail and regional filters
Owner confirmsMonth-end reporting requirementsRegional managers' reporting needs
How the team uses the comparison
  1. CoDashSurface the overlap

    Inspect shared content and the differences that remain.

  2. Report ownersConfirm the required coverage

    Check that both reporting needs can still be met.

  3. Agreed next stepKeep separate or consolidate

    Validate the proposed result before retiring any source report.

Connect the pillars

Put the review to work.

Improve reporting where it is, or move selected assets along a supported migration direction. Rationalization helps focus either path.

Your next step

See the evidence behind your next decision.

Bring a group of reports you want to understand. Explore how the rationalization workflow can help your team review them.

See rationalization in action