Forum Discussion
Doubt about HR sample from Microsoft
There is this example provided by Microsoft
Human Resources sample: Take a tour - Power BI | Microsoft Learn
Looking at the model it seems that the Employee table is a hybrid between fact and Dimension...
Is this modelin recommended? Why is microsoft recommending this? Isn't it better to have a DimEmployee and a Fact.
ps: what is the granualirty of that Employee table provided by microsoft, is it one row per employee? what if the employee left and is re-hired?
Hi , Anonymous
The star schema is a popular data modeling technique used in Power BI to organize data into a central fact table and related dimension tables. The advantages of using a star schema in Power BI include faster query performance, easier report creation, and improved data quality. By reducing the number of tables and relationships in the data model, the star schema simplifies the data structure and makes it easier to understand and use. Additionally, the star schema can improve data quality by reducing the risk of data anomalies and inconsistencies.
Generally, dimension tables are used to maintain the dimension information of fact tables, which can be changed according to the needs of users. And for the fact table, it represents a detailed information, and a row represents a record.
If an employee leaves, you can delete it using logical fields in the fact table or delete it directly from the fact table.This has no practical connection to dimension tables.
For more information, you can refer to :
Understand star schema and the importance for Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
- v-yueyunzh-msft
Community Support
Hi , Anonymous
The star schema is a popular data modeling technique used in Power BI to organize data into a central fact table and related dimension tables. The advantages of using a star schema in Power BI include faster query performance, easier report creation, and improved data quality. By reducing the number of tables and relationships in the data model, the star schema simplifies the data structure and makes it easier to understand and use. Additionally, the star schema can improve data quality by reducing the risk of data anomalies and inconsistencies.
Generally, dimension tables are used to maintain the dimension information of fact tables, which can be changed according to the needs of users. And for the fact table, it represents a detailed information, and a row represents a record.
If an employee leaves, you can delete it using logical fields in the fact table or delete it directly from the fact table.This has no practical connection to dimension tables.
For more information, you can refer to :
Understand star schema and the importance for Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly