Google Analytics

Tools:

• Google Analytics 4 (setup property to track web traffic and send data to Big Query)
• Google Tag Manager (contains tracking tags)
• Big Query (daily ETL of web traffic data into a staging table)
• Power BI Desktop (create reports, measures, calculated columns, data models)
• Power BI Service (embed code for public report)
• Power BI Personal Gateway (to refresh dataset)

Report:

ERD:

Process: