Your Homework:

Build the business language that sits on top of the domain

Use Case: DAMA Blueberry Farms

At DAMA Blueberry Farms, we discovered that every department had a different definition of a blueberry.

Marketing referred to them as Premium Berries, Sales called them Products, Finance measured them as Revenue Units, Operations tracked them as Inventory, and Distribution managed them as Shipments.

Everyone was using the same underlying data, but speaking different business languages.

That’s when we realized we needed a Semantic Layer.

Using your previously identified Gold Layer Assignment and Business questions/processes your task is to identify the:

  • What semantic topics should exist?

  • What metrics belong to each topic?

  • What dimensions should be exposed?

  • What are you missing from the gold layer to inform this?

Executive Revenue Dashboard

  1. Questions Answered:

    • Total Revenue This Month

    • Revenue by Region

    • Revenue by Customer

    • Revenue by Product

    • Revenue Growth %

Customer Sales Dashboard

  1. Questions Answered:

    • Top Customers

    • Revenue by Customer

    • Average Order Value

    • Customer Purchase Frequency

Harvest Performance Dashboard

  1. Questions Answered:

    • Pounds Harvested by Field

    • Yield per Acre

    • Harvested by Employee

    • Harvested by Variety

    • Harvest Trends

Inventory Dashboard

  1. Questions Answered:

    • Inventory On Hand

    • Spoilage Rate

    • Inventory by Product

    • Inventory by Warehouse

Additional Stakeholder Questions they want solved.

  1. How many pounds of blueberries did we harvest this season?

  2. Which fields produced the highest yield?

  3. Which blueberry varieties are the most profitable?

  4. How much revenue did we generate this quarter?

  5. Which customers purchased the most blueberries?

  6. Which regions generate the most revenue?

  7. How much product was lost due to spoilage?

  8. Which employees harvested the most berries?

  9. How accurate were our harvest forecasts?

  10. Which products are growing the fastest?