Forum Discussion
Microsoft EmployeeFat and Slow Golden Dataset Situation How Could Dataflows and Datamarts Help?
For sure! Another client is doing intense chaining with mixed storage model, i.e direct query an existing dataset (golden dataset) and add additional table using other data sources. It is more complex as they propragate.
Super UserIm having the same challenge with a client's golden dataset. Our case is we cant "remodel" the dataset to answer new questions and requirements, so we ended up with DAX calculations that are complex and time consuming.. The idea of Golden dataset is great, but it has it's challenges, especially if you want to create a optimized data model for fast report.
I dont have any input on your challenges, but one thing that you can try if you want to improve "development-waiting-time" is to use the ALM toolkit to perform data model updates eg. addding measures etc. Just be aware that its still limited.
Microsoft EmployeeHi Tutu thsnks for yoru answer and recommendation to use ALM toolkit, actually I am using Tabular editor for making changes in the model and have to update just once instead of each time, I will take a look at ALM toolkit.
I totally relate to your comment about fat / innefficient / wrongly structured data model leading to complex DAX, in my case I would oike to add the fragile "house of cards" situation, often old reports stop working because slight changes in the data model, for instance two tables actually connected several times indirectly trough other tables, rendering the model unstable and often unpredictable.
Seems we share similar challenges maybe we could remain in touch sharing different solution/improvement approaches. Thanks again!
Juan
- Tutu_in_YYC
For sure! Another client is doing intense chaining with mixed storage model, i.e direct query an existing dataset (golden dataset) and add additional table using other data sources. It is more complex as they propragate.