Marco Russo's Blog
View full profilePASS 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 Read more
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 Read more
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 www.daxpuzzle.com ). 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. Read more
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: Read more
A new hope. Tale from SQL Saturday 454 #sqlsat454
This is one of the few non-technical posts of this blog. Just skip it if you want to quickly come back to 100% BI related topics. Last Saturday we run the SQL Saturday 454 in Turin . I was part of the organization, and actually I was one of the promoters Read more
When to use calculated tables in #dax
In the September release of Power BI Desktop, Microsoft introduced a new important feature: calculated tables. Chris Webb wrote a quick introduction to this feature, and Jason Thomas published a longer post about when to use calculated tables . The reason Read more
Synoptic Panel for Power BI Best Visual Contest #powerbi #contest
Today (September 30, 2015) is the last day to submit an entry in the Power BI Best Visual contest . I and Daniele Perilli (who has the skills to design and implement UI) spent hours thinking about something that would have been challenging and useful Read more
Fix performance issue of pivot tables with Tabular models
If you use SSAS Tabular, this is a very important news! Microsoft released a very important update for Analysis Services 2012 that provides performance improvements to pivot tables connected to an Analysis Services Tabular model: it is SQL Server 2012 Read more
Don’t ignore the Context Transition in #dax
Almost 3 years ago I wrote an article with the rules for DAX code formatting . If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular Read more
Back to the basic: #dax primers for new #powerbi users
The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last Read more