Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Data Modeling - is it worth to create a star schema?

Hi guys,   I am working with a single source CSV file, size 11.2 MB, around 43k rows and 19 columns. The information is about Incidents (tickets), so it has information about agents, SLAs, assignm...
Need Help
Tips and Tricks
Tutorial Requests
littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
5 years ago

Ideally you want a star/snowflake schema.  Fact table(s) in the center and dimensions radiating outward.

 

If you don't want to use PQ to create dimensions you can always use DAX to create those tables.  Don't listen to the bot.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Do the dimensions using DAX provide the same performance in the dashboard (processing, slicers, etc..) as the ones in PQ?

    Is it advisable to create no dim tables at all and only use one table with the whole 19 columns?