Adventure Works

Tools:

  • 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)
  • SQL Server 2019
  • SSMS (execute script to generate the Adventure Works DB)
  • Adventure Works Dataset
  • Azure Spatial Anchors (Augmented Reality) & Power BI (Data in Space)

Report:

RFM (recency, frequency, and monetary value)

RFM stands for recency, frequency, and monetary value.

The idea is to segment customers based on when their last purchase was, how often they’ve purchased in the past, and how much they’ve spent overall. All three of these measures have proven to be effective predictors of a customer’s willingness to engage in marketing messages and offers.

Augmented Reality (Data in Space):

With Azure Spatial Anchors it’s possible to attach a Power BI report to specific areas of interest (banana in this case).

ERD: