HARBORLINE COMPONENTS — Power BI starter kit (fictional dataset)
=================================================================

FICTIONAL company. SYNTHETIC data generated by Summitview Studio for demonstration.
No real client data. Free to use (CC BY 4.0).

THE MODEL (star schema)
  Fact_SalesLine  (one row per order line)
     invoice_date  -> Dim_Date[date]      ACTIVE   — the official revenue date
     order_date    -> Dim_Date[date]      INACTIVE — only for "Booked Orders"
     customer_id   -> Dim_Customer[customer_id]
     product_id    -> Dim_Product[product_id]

WHY THIS DATASET EXISTS
  It has, on purpose, the most common Power BI disease: three "revenue" numbers
  that don't match.
    1. Booked Orders   — orders summed by the date they were placed
    2. Invoiced        — invoices summed by invoice date, before returns
    3. Net Revenue     — invoiced minus credits and returns   <- the official one
  Every old report used one of them and called it "Revenue".
  The fix isn't in the chart, it's in the model: one official definition, and the
  other two named for what they are (see measures.dax).

HOW TO BUILD IT (about ten minutes)
  1. Power BI Desktop > Get data > Text/CSV > load the four CSV files
  2. Mark Dim_Date as a date table (column "date")
  3. Create the relationships above (order_date as INACTIVE)
  4. Paste the measures from measures.dax

Live version of this dashboard: https://summitviewland.com/demo/
Summitview Studio · summitviewland.com · info@summitviewland.com
