Kemlat Header
Kemlat
  • Home
  • About
  • Services
    Business & TransformationA clear view of the problem and a plan you can deliver.8 Project & DeliveryGovernance that connects plans to results.3 ERP & CRMConnected processes and data in systems that fit your work.2 Digital ProductsWebsites, apps and platforms built around your needs.8 AI & AutomationPractical solutions for tasks that should take less time.8 Quality EngineeringMore confidence in every release.3 Cloud & SecurityA dependable foundation for your digital work.5 Managed ServicesStability, support and improvement after launch.3 Brand & CreativeAn identity and experience that tell your story clearly.4 Digital GrowthBetter visibility and decisions based on performance.5 Games & ImmersiveInteractive experiences for learning and for brands.4 Training & EnablementSkills your team can put to work.3
    All services56

    The KEMLAT Method

    KEMLAT
    Build your projectPick the services you need and get an approximate cost range in a minute.
  • Work
  • The Method
  • Insights
  • Contact
ARGet in touch
  • Home
  • About
  • Business & Transformation Project & Delivery ERP & CRM Digital Products AI & Automation Quality Engineering Cloud & Security Managed Services Brand & Creative Digital Growth Games & Immersive Training & EnablementAll services Build your project
  • Work
  • The Method
  • Insights
  • Contact
Get in touch
العربية [email protected] +962 79 122 3241
Check the Main Menu location in Apppearance->Menus->Display Location.
Reporting Architecture: One Data Model, Many Reports - Kemlat Insights
Kemlat2026-10-21T16:52:05+03:00
All insightsاقرأ بالعربية
Enterprise Systems

Reporting Architecture: One Data Model, Many Reports

When the sales report and the finance report disagree, meetings turn into arguments about numbers. A shared data model means every report uses the same definitions, so the numbers reconcile.

13 November 20265 min read
Share
Reporting Architecture: One Data Model, Many Reports - Kemlat Insights

The sales director’s report says last month’s revenue was JOD 1.42 million. The finance report says JOD 1.37 million. The meeting spends twenty minutes arguing about which number is right, and nobody discusses what to do about the result. Both reports are probably correct by their own logic. The real problem is that each was built separately, with its own rules, from its own extract.

Why separate reports drift apart

In most mid-sized organisations, reports grow one at a time. Someone needs a sales view, so an analyst builds a workbook from an enterprise resource planning (ERP) export. Finance builds its own pack. Operations has a dashboard made by a consultant three years ago. Each one defines revenue, margin or “active customer” slightly differently, applies its own filters and refreshes on its own schedule.

The differences are often small and reasonable. One report counts invoices, another counts orders. One excludes returns, another nets them off later. One uses invoice date, another delivery date. But when nobody can explain the gap in a meeting, trust in all the reports falls, and managers go back to asking someone to “just pull the numbers” by hand.

There is a cost in time as well. Every separate report has its own extract, its own cleaning steps and its own maintenance. When a product category is renamed or a new branch opens, someone has to update five workbooks instead of one, and usually one of them gets missed.

The idea: one model, many reports

A better reporting architecture separates the data and its business rules from the reports that display it. Data is collected and cleaned once, business definitions are written once in a shared model, and every report reads from that model. The layers look like this:

LayerPurposeTypical owner
SourcesERP, point-of-sale (POS), customer relationship management (CRM) and human resources (HR) systems, plus spreadsheets that hold the original dataSystem owners in each department
Staging and cleaningCopies of source data, standardised and checkedData or business intelligence (BI) lead
Shared data modelBusiness tables and agreed measures such as net revenue, gross margin and on-time deliveryBI lead, with finance and operations sign-off
Reports and dashboardsViews for specific audiences and decisionsReport authors in each team

In a Microsoft environment, this might be a central Power BI semantic model (the shared dataset holding tables and calculations) that many reports connect to, fed from a small data warehouse or a set of cleaned tables. Other BI tools follow the same principle under different names. The important part is the separation, not the product.

A scenario: a trading group with two companies

Imagine a family-owned group in Amman with a distribution company on one ERP and a retail company on an older accounting system. The owners want a monthly group view, and each company’s managers want their own operational reports.

Without a shared model, someone exports from both systems every month, maps accounts and products by hand, and builds a group pack in Excel. Each company also has its own reports with different definitions. When the owners ask why the group margin differs from the companies’ figures, the answer takes days.

With one model, data from both systems is loaded nightly into a staging area. Product categories, customer types and branches are mapped to one shared list. Net revenue and gross margin are defined once, with finance agreeing the rules. The group pack, the distribution sales dashboard and the retail branch report all read from the same model. They show different views, but the numbers reconcile because they come from the same definitions.

Design principles that keep the model useful

  • Define measures in writing first. Before building, write a short definition for each key measure: what it includes, what it excludes and which date it uses. Finance and operations should both sign it off.
  • Build around business entities. Customers, products, branches, dates and transactions are the backbone. Get these shared lists right and most reports become simple.
  • Keep business logic out of individual reports. If a report author needs a new calculation, add it to the model so everyone benefits and nobody creates a competing version.
  • Control changes. Changes to shared measures need a review, because they affect every report at once. A simple change log is usually enough.
  • Apply security once. Rules on which rows of data each person may see, such as branch managers seeing only their branch, belong in the model, not in copies of reports.
  • Show freshness. Every report should display when its data was last refreshed.
Rule of thumb: if two reports show a measure under the same name, they must show the same number. If they genuinely need different logic, give the measures different names.

Getting there one subject at a time

  1. List existing reports. List the reports people actually use, who uses them and which measures they show. You will usually find that a few reports carry most of the weight.
  2. Pick the measures that cause arguments. Revenue, margin and stock value are common starting points.
  3. Build the first version around one subject area, usually sales, and move the most-used reports onto it.
  4. Retire the old versions. Once a report has moved, archive the old workbook so people stop using it.
  5. Extend one subject at a time, adding stock, purchasing or finance as the model proves itself.

Expect the definition work to take longer than the technical build. Agreeing what “net revenue” means across sales and finance can take several conversations. That time is well spent, because every report built afterwards inherits the agreement.

Reports that agree with each other

A shared model turns reporting from a collection of personal workbooks into a reliable service. Meetings move from arguing about the number to discussing what it means. Designing this kind of data architecture, with definitions agreed by the business, is central to our Enterprise Systems service, and it creates the foundation for automated reporting later. If you want a starting point, put your current sales and finance revenue figures side by side for one month and write down every reason they differ.

Found this useful?Share it with your team or someone who needs it.
  • WhatsApp
  • LinkedIn
  • X
  • Facebook
  • Telegram
  • Email
Related service

Enterprise Systems

We design and build systems, and migrate data into them, based on real operational needs, not generic templates.

Also related: Intelligent Automation

Explore our services

Related insights

Single Sign-On and Identity: Keeping System Access Under Control - Kemlat Insights
Enterprise Systems

Single Sign-On and Identity: Keeping System Access Under Control

A sales manager leaves on Thursday and can still log in to the CRM five weeks later. Single sign-on and a clear identity process fix that,…

17 Nov 2026 · 6 min read
Cleaning Historical Data Before a System Migration - Kemlat Insights
Enterprise Systems

Cleaning Historical Data Before a System Migration

Moving fifteen years of records into a new system just in case is a frequent reason migrations run late. Decide what to bring, clean it properly…

16 Nov 2026 · 5 min read
Mobile Apps for Field Teams: When They Are Worth Building - Kemlat Insights
Enterprise Systems

Mobile Apps for Field Teams: When They Are Worth Building

Paper job sheets sent by WhatsApp make the case for an app feel obvious. Sometimes a custom app is right. Often a simpler option fits the…

15 Nov 2026 · 5 min read

Kemlat Footer
Kemlat
Kemlat

We help organisations transform complex operations into clearer ways of working, practical solutions, and measurable outcomes.

Quick Links

  • Home
  • About Kemlat
  • Our Services
  • Selected Work
  • The Method
  • Contact Us

Services

  • Business & Transformation
  • ERP & CRM
  • Digital Products
  • AI & Automation
  • Cloud & Security
  • Digital Growth
  • All services
  • Build your project

Get in Touch

Email [email protected]
Location Almadina Almunawwara St., Amman, Jordan
WhatsApp & Phone +962 79 122 3241

© 2026 Kemlat. All rights reserved.

Privacy Policy Terms of Use
Kemlat Method

Request a Service

Tell us what you need and we will get back to you within one business day.

By sending this form you agree to our privacy policy.

Request received

Thank you. Our team will review your request and contact you within one business day.