Import the files
CSV and Excel exports from the agreed source systems
Banking Advisory
From files to analysis
CSV and Excel exports from the agreed source systems
Customer identities, fields, definitions, exceptions, and totals
Management answers plus a record of every accepted change
Customer Cube, analysis, charts, and PowerPoint Data Packs
Two different outputs
Output
Customer CubeAn Excel workbook that ties customer and product revenue back to the source files. It includes definitions, reconciliations, exceptions, management explanations, and adjustments.Output
Data PackA PowerPoint chart book built from the Customer Cube. It shows the customer, product, cohort, retention, and concentration views needed for the review.Customer Cube
Account, parent account, customer ID, logo, buying group, or buyer-defined customer hierarchy with explicit matching rules.
SKU, module, service line, contract line, bundle, product family, or revenue category tied to the source hierarchy where available.
Monthly, quarterly, fiscal-year, and LTM views reconciled to billing, revenue, ARR/MRR, or management reporting definitions.
Geography, vertical, cohort, segment, channel, contract type, customer tier, customer size, and renewal window.
Data Pack
Some transaction-services firms use datapack to mean a normalized financial dataset. At Wysdome, Data Pack means the PowerPoint chart book built from the Customer Cube.
How the work is done
Agree on the question, source files, definitions, customer hierarchy, and people reviewing the work.
Match customer identities and tie customer-level totals back to source systems and management reports.
List anomalies, missing information, conflicting records, and the questions management needs to answer.
Keep management's answers with every adjustment, source, reason, and review decision.
Build the Customer Cube and select the Data Pack pages the reviewer needs.
Who this work helps
May hire Wysdome to understand its customer revenue or prepare it for outside review.
May hire Wysdome, use the analysis, or review it as part of a larger engagement.
May examine and challenge the analysis even when another organization paid for it.