Help with transform data + starschema

Hi sencius ,

Regarding your question, converting data includes operations such as renaming columns, changing text to numbers, deleting rows, and setting the first row as a header, etc. For specific operations you can refer to the following articles:

Tutorial: Shape and combine data in Power BI Desktop - Power BI | Microsoft Learn

The correct star architecture consists of multiple dimension tables with a fact table, and there is a one-to-many relationship between the dimension tables and the fact table, details of which can be found in the following article:

Model relationships in Power BI Desktop - Power BI | Microsoft Learn

Understand star schema and the importance for Power BI - Power BI | Microsoft Learn

 

Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.