Marco Russo's Blog
View full profileInternet of Things in 2015 #summit15 #sqlpass
David DeWitt and Rimma Nehme delivered the day 2 keynote at PASS Summit 2015 talking about Internet of Things. Many PASS attendees know David for providing some of the best keynotes every, technical and without vaporware and marketing stuffs. So this Read more
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 Read more
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 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