OPENING THE STARTER FILE — NorthlakeTherapy
==========================================

Everything here is synthetic data. No real company or person is represented.

WHAT YOU HAVE
-------------
Tables, already named and typed:
  - clinics (12 rows)
  - therapists (260 rows)
  - patients (260 rows)
  - insurers (12 rows)
  - patient_insurers (1,200 rows)
  - treatment_plans (260 rows)
  - appointments (1,200 rows)
  - insurance_claims (1,200 rows)

Relationships, already built:
  - therapists.clinic_id -> clinics.clinic_id
  - patients.referring_clinic_id -> clinics.clinic_id
  - patient_insurers.patient_id -> patients.patient_id
  - patient_insurers.insurer_id -> insurers.insurer_id
  - treatment_plans.patient_id -> patients.patient_id
  - treatment_plans.therapist_id -> therapists.therapist_id
  - appointments.treatment_plan_id -> treatment_plans.treatment_plan_id
  - appointments.therapist_id -> therapists.therapist_id
  - appointments.clinic_id -> clinics.clinic_id
  - insurance_claims.appointment_id -> appointments.appointment_id
  - insurance_claims.insurer_id -> insurers.insurer_id

Report pages, already created and empty — one per visual you must build:
  1. Page 1
  2. Page 2
  3. Page 3


HOW TO OPEN (recommended)
-------------------------
1. Copy the whole folder to your machine. Keep it together; the project
   references the data by relative path.
2. Copy the "data" folder to:  C:\PowerBI\Data
   (or leave it where it is and change the path in step 4)
3. Open Power BI Desktop, then File > Open report > Browse reports, and
   choose "NorthlakeTherapy.pbip".
4. If Power BI cannot find the data, go to Transform data > Manage parameters
   and set "DataFolder" to the folder holding the CSV files.
   Then Close & Apply.
5. Build your visuals on the pages already created for you.

If your Power BI Desktop does not offer to open .pbip projects, enable it under
File > Options and settings > Options > Preview features > "Power BI Project
(.pbip) save option", then restart Desktop.


IF THAT DOES NOT WORK
---------------------
Open "NorthlakeTherapy.pbids" instead. It connects Power BI to the data folder but
does not build the model — you will create the tables and relationships
yourself. Slower, but it always works.


WHAT NOT TO DO
--------------
Do not retype the data by hand, and do not edit the CSV files. Your work is
graded against these exact rows.
