THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS   (RSS)
Showing page 1 of 16 (160 total posts)
  • Announcements at PASS Summit 2015: #SSAS CTP3 and more #sqlpass #summit15

    I’m sitting at the bloggers table at the Day 1 keynote of PASS Summit 2015 and I try to recap the important news for the BI community. SQL Server Analysis Services 2016 CTP 3 will be available in a few days here, but Microsoft already announced the news in this release: Previously announced news (most of them already described in this ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 28, 2015
  • PASS Summit 2015 and news about on-premises BI #ssas #tabular #sqlpass

    I don’t usually blog about news, unless there is a relevant impact on future directions. Last week we have seen a huge number of announcements for Power BI (Custom Visuals now available to anyone through a gallery online, you can import them in also in Power BI Desktop, and a number of improvements in Power BI Service and a new version of the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 26, 2015
  • Hardware and Virtualization Settings for Analysis Services Tabular #ssas #tabular

    If you use Analysis Services Tabular, you should dedicate a good amount of time in hardware selection. Unfortunately, throwing money in expensive hardware configuration could be a very bad idea, resulting in your 1,500$ desktop running faster than your expensive 100,000$ server. Moreover, if you use virtualization you have to be very careful in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 22, 2015
  • Challenge your #dax skills with DAX Puzzle #powerbi #powerpivot

    Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution. You can download a sample file (in Power BI Desktop, which is freely available to anyone – ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 21, 2015
  • The Definitive Guide to DAX is now available! #dax #powerpivot #powerbi #ssas #tabular

    I am so happy to announce that The Definitive Guide to DAX is finally available! I and Alberto Ferrari spent one year writing this book, and several years collecting the knowledge necessary to do that. The complete title is The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI. You can ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 20, 2015
  • Large Dimensions in SSAS Tabular #ssas #vertipaq

    After many years of helping several companies around the world creating small and large data models using SQL Server Analysis Services Tabular, I’ve seen a common performance issue that is underestimated at design time. The VertiPaq engine in SSAS Tabular is amazingly fast, you can have billion of rows in a table and query performance are ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 20, 2015
  • VertiPaq Analyzer for Analysis Services #ssas #tabular #powerpivot #powerbi

    During the writing of The Definitive Guide to DAX I wanted a simple way to analyze the content and distribution of data compressed in the VertiPaq engine, used by Analysis Services Tabular, Power Pivot and Power BI models. I always relied on BISM Memory Report (thanks Kasper!), but when you focus on a single database there are a number of details ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 28, 2015
  • BI on your terms with SQL Server 2016

    The last few years Microsoft's strategy was all about cloud first (or cloud only?), releasing new BI products and updates to existing products to the cloud in high pace without almost any investments in on-premises BI. In 2015 Microsoft seems to change its course, they now aim more on the enabling of hybrid scenarios, investing a lot in both ...
    Posted to Jorg Klein (Weblog) by jorg on May 22, 2015
  • New features in DAX Editor #dax #tabular #ssas

    In the last few weeks I and Teo Lachev took the ownership of DAX Editor code. It is an add-in for Visual Studio that allows you to edit DAX measures in a text editor instead of using the Measure grid. It also provides other features (such as editing measures of an online Tabular database and performing a few queries). The user interface is not ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 7, 2015
  • Power BI Analysis Services Connector Security

    The Power BI Analysis Services Connector can be used to connect from the Power BI service to your on premises tabular Analysis Services models. In this blogpost I will look into the security and authentication possibilities that the SSAS Connector offers. Dynamic row-level security based on the Power BI user name to an on premises SSAS Tabular ...
    Posted to Jorg Klein (Weblog) by jorg on March 19, 2015
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement