You notice different data granularity across sources. How do you align them?

< 1 min read

First, I would analyze the granularity of each data source, such as transaction-level data versus daily or monthly summarized data.
I would identify common dimensions like date, product, or region that can be used to align the datasets.
Next, I would choose a consistent level of granularity based on the reporting requirement.
Usually, I align the data to the higher-level granularity to maintain consistency.
For example, in one project sales data was at transaction level while marketing spend was available monthly, so we aggregated sales to monthly level.
I would apply aggregation or transformation logic in the data preparation layer to standardize the datasets.
After that, I would validate totals with the source systems to ensure accuracy.
If there are limitations due to granularity differences, I would clearly communicate them to stakeholders and document the approach used.

Power BI Essentials