This post recommendations some of the tips and methods that we safeguarded in my webinar Performance Strategies for Strength BI Study Models . There are many info and techniques, and lengthened causes and sources on the speech slides.
My personal example research for it chat was a customized Opportunities table off Sales force. Which real world data desk originates from an individual which can be sanitized for confidentiality. The fresh analogy possess more than 382,100000 rows and that actually an enormous dining table to have Stamina BI. When the data is stacked on Energy BI, the fresh new held file size to your disk balloons to over 500MB. Inside thoughts these details set uses up more than 1GB.
- Calculation edits was slow
- Slicers with the reports slowed down
- Rejuvenate of information took extended to load and processes the job dining table
Why are this table unwieldy to your columnar research shop is actually partly the sequence columns, thirteen of them is over 200 characters enough time. You to community format are a likely signal that text thinking was joined by the typing which have numerous other opinions, most likely in every single low-blank occupation.
All of the suggestion the following may not connect with your difficulty. To find out more about for each and every tip, excite feedback this new glides from my demonstration or view the filed webinar here.
When it comes to dining tables with 10’s off millions of rows, the brand new 1M-row wall space or “Chunking” may interfere with effective compression cost, please read this article to learn more: