Advice on a Pizza model

michellepace — Sun, 25 Jun 2023 23:26:36 GMT

Hello there. I am trying to improve my modelling technique. I realise my model will change sometimes based on the types of measures I want to create. However right now I'm just trying to do my initial "logical modelling." I'm more than happy to upload the data if needed.

Question 1: For the below, for any seasoned data modellers out there with strong DAX capabilities - can you see any floors in my design?

Question 2: Is it "right" that I have hidden the Orders table? Or should I simply rather combine the Orders and OrderDetails tables, and just have one table... would it make my DAX simplier?

Question 3: I am a bit concerned that I have two dimension tables (Pizzas, PizzaTypes) on top of one "fact" table. Is this okay, is there a special way I would have to handle the DAX here?

Question 4: I never know which table is best practice to hide the "id" column. For example, should I hide "pizza_type_id" on the OrderDetails table (but not the PizzTypes table).

Thanks in advance, Michelle

topic Advice on a Pizza model in DAX Commands and Tips

Advice on a Pizza model