Category: Uncategorised
-
Building a Power BI report on top of a GA4 star schema
In my last article, I went through how I turned the raw GA4 export into a star schema with dbt. This one picks up where that left off, in two parts: first the Power BI semantic model that sits on top of the star schema, then the report itself and the design decisions that went…
-
Turning raw GA4 data into a star schema with dbt
Since GA4 was first introduced, a commonly touted benefit was the ability to export the raw event-level data, and create your own analysis with that data. This is amazing! We were finally able to customise every part of our reporting. We could also easily join the data with other data sources. In this article, I…