Purpose:

The purpose of each project is to visualize different datasets using Power BI and to experiment with different technologies. This includes steps required to generate or connect to each source. The Power BI reports can be found in each section below.

PowerBI

Create a SQL DB for the public dataset Adventure Works and visualize with Power BI.

  • PowerBI
  • DAX (RFM)
  • SQL
1. View

Python

Use Python and an API to create daily csv extracts and copy public sales from Galaxus to visualize with Power BI.

  • Python
  • API
  • Task Scheduler
2. View

GA4/GTM

Setup Google Analytics, Tag Manager and Big Query to analyze web traffic and visualize with Power BI.

  • GA
  • GTM
  • Big Query
3. View