CODEWITHSUNDEEP
powerbidata-modelingstar-schemaoracle-sql-data-modeler
Nolann Salaun
Nolann Salaun

Reputation: 3

Is this star schema model valid or does it required updates to be more efficient?

I am working with a DataWarehouse from which I'll be collecting data, I am trying to build a star model schema on data modeler in order to be then use on Snowflake and then later in Power BI for BI analysis. The Datawarehouse with all the columns that I can use is names as FinOps_DW, the other tables are following the convention with fact and dimension tables. I have in the DW some id such as resource_id and account_id however when I build my schema I created a new id column to cover all the attributes of the tables and not only resource or account. Is it a good practice to do so? What could be done to improve this star schema model ? Is it allowed to avoid multiple id in a single table (outside of the fact table) ? Does the choices of tables sounds logical to you ? enter image description here

I've been trying to test various tables composition from the DW attributes but I lack of experience in star schema design.

Upvotes: 0

Views: 37

Answers (0)

Related Questions