Many useful tips can be garnered from the below sources:
1. SSAS 2005 Performance Guide
2. BIDs Helper:
3. Many-to-many design aggregation design
-
Blogroll
-
-
Sending Alerts From Fabric Workspace Monitoring Using KQL Querysets And Activator - I’ve always been a big fan of using Log Analytics to analyse Power BI engine activity (I’ve blogged about it many times) and so, naturally, I was very happ...6 days ago
-
-
Power BI – creating dynamic per recipient subscriptions for paginated reports with multi-value parameters - At the time of writing this post there is no built-in support for creating dynamic per recipient subscriptions for paginated reports if your report has any...1 month ago
-
How Apache Spark™ performs a fast count using the parquet metadata - A common question I run into is how does Apache Spark™ perform fast counts against Parquet files. TL;DR: Spark is able to read the parquet metadata witho...10 months ago
-
Automating Partition Creation - By Bryan C. Smith The use of multiple partitions per measure group is promoted to improve both query and processing performance as well as the overal...17 years ago
-
-
New composite models in Power BI: A milestone in Business Intelligence - Power BI sets a new milestone in Business Intelligence: Marco describes the importance of new composite models in an article, and Alberto shows them in act...4 years ago
-
Good Bye BI - "Every new beginning comes from some other beginning's end" ( Seneca ) I spent big chunk of my professional career working on what we call today BI. From P...14 years ago
-
SQLCAT at PASS Summit 2018 - This week in Seattle, PASS Summit 2018 will be happening for the twentieth time. As for many years...6 years ago
-
-
DAX Code Snippet: Year To Date in Charts - This short blog post tries to show the different ways to solve the same problem in DAX and in MDX. If you look at the picture you can see two ways of prese...9 years ago
-
Posts
No comments:
Post a Comment