#6,439 in Computers & technology books
Use arrows to jump to the previous/next product

Reddit mentions of Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference)

Sentiment score: 1
Reddit mentions: 1

We found 1 Reddit mentions of Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference). Here are the top ones.

Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference)
Buying options
View on Amazon.com
or
    Features:
  • Microsoft Press
Specs:
Height8.9 Inches
Length7.4 Inches
Number of items1
Release dateApril 2017
Weight1.8518830008 Pounds
Width1.1 Inches

idea-bulb Interested in what Redditors like? Check out our Shuffle feature

Shuffle: random products popular on Reddit

Found 1 comment on Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference):

u/Data_cruncher ยท 10 pointsr/PowerBI

Yes, it's absolutely doable. That's a very standard sized fact table for SSAS Tabular.

Some points I'd like to highlight:

  • Purchase and read this entire book: Tabular Modeling in Microsoft SQL Server Analysis Services (Developer Reference) 2nd Edition
  • Begin with "Import" mode. Import mode physically moves the data from SQL into the Vertipaq engine; this is best practice. If you've exhausted all options and avenues on attack then you can fall back to "Direct Query" mode; this is not best practice.
  • When using Import mode, you must partition your table. This mechanism incrementally loads the data so you don't need to physically move 250M rows with every refresh. Note: this is NOT SQL Server "partitioning" - same name but completely different.
  • Download Vertipaq Analyzer and use it as soon as all 250M rows are loaded. It will highlight problem columns. Your goal is to remove high cardinality columns (columns with high distinct counts). For example, instead of storing a column of type DateTime, you should split it into one column of type Date and and another of type Time. You'll find big performance boosts. The book in my first bullet point goes through this and many other examples.