Understanding Dimensional Modeling

Hi everyone, 

I'm beginning my journey on trying to create a dimensional model for our Power BI environment. I come from an SQL background in reporting of just writing SQL queries for the end user to share via an excel file, but finally we are working towards integrating Power BI as a BI tool for our division. 

However I am finding this to be a bit different than just simply writing an SQL query. 

I am learning that in Power BI you can't simply import the tables you have in SQL server and just join like you normally would in the Power BI Desktop modeling view and expect the same results. I'm finding that one to many relationships is the norm and they have to connect via the many side. Which is where I have come to this design of Dimensional Modeling. 

Most books or examples I find deal with sales or numerical data but we run a case management system so sometimes the examples don't always apply or are hard to replicate using our data. 

I'm really just looking for expert advice on how I should be taking something that I would normally write an SQL query for and create a dimensional model out of it, so that it can be used in Power BI. 

So getting down to an example: 

Lets say a requestor is asking me: For a List of cases that were completed in years 2024 and 2025 by region. The requestor would also like to know of those cases completed, what were the education information and employment information of each of the participants. 

I would simply write my SQL as the following:

select  a2.region, a1.pk_Participant_Id, a1.last_name, a1.first_name, a2.pk_Case_Id,  a3.completion_date, a3.completion_reason, a4.education_level, a5.employment_status
from participant a1
left join case a2
on a1.pk_Participant_Id = a2.fk_Participant_Id
left join completion a3
on a2.pk_Case_Id = a3.fk_Case_Id
left join education a4
on a1.pk_Participant_Id = a4.fk_Participant_Id
left join employment a5
on a1.pk_Participant_Id= a5.fk_Participant_Id 
where a3.completion_date between 2024-01-01 and 2025-12-31             

How would you go about creating a Dimensional model just using the tables from this query?
Participant Table Columns:

• pk_Participant_Id
• last_name
• first_name
• date_of_birth
  Case Table Columns: 

• pk_Case_Id
• fk_Participant_Id
• region
• created_date
  Completion Table Columns:
  

• pk_completion_Id
• fk_Case_Id
• completion_date
• completion_reason

Education Table Columns:

• pk_Education_Id
• fk_Participant_Id
• education_level
• created_date

Employment Table Columns:

• pk_Employment_Id
• fk_Participant_Id
• employment_status
• created_date

Appreciate any help you can all give me.