Forum Discussion
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...
amitchandak
Super User
Super UserAnonymous , I know power Query is the suggested way. But in DAX you can get bit slower but less load of data.
New tables using Distinct, Summarize etc
Distinct(Table[Col1])
Summarize(Table, Table[Col2], Table2[Col3])
Check which one performs better.
I think Star Schema is best, the cases when need all or need to ingore some filter , star schmea come bit handy.