Browse by Tags

• Analysis Services
• BIDS
• BISM
• Book
• Business Intelligence
• Communities
• Conference
• Excel
• MDX
• PowerPivot
• Reporting Services
• SSAS
• Tabular
• UDM

• Meet SQLBI at PASS Summit 2012 #sqlpass

  Next week I and Alberto Ferrari will be in Seattle at PASS Summit 2012 . You can meet us at our sessions, at a book signing and hopefully watching some other session during the conference. Here are our appointments: Thursday, November 08, 2012, 10:15 Read More... Posted Friday, November 02, 2012 3:11 PM by Marco Russo (SQLBI) | 1 Comments Filed under: Analysis Services, DAX, PASS, SSAS, Tabular

• LASTDATE dates arguments and upcoming events #dax #tabular #powerpivot

  Recently I had to write a DAX formula containing a LASTDATE within the logical condition of a FILTER: I found that its behavior was not the one I expected and I further investigated. At the end, I wrote my findings in this article on SQLBI , which can Read More... Posted Monday, October 01, 2012 8:04 PM by Marco Russo (SQLBI) | 0 Comments Filed under: Communities, Conference, DAX, PASS, PowerPivot, SSAS, Tabular

• SSAS Maestro in Madrid (July 2011) and SQLPASS in Seattle (October 2011) #ssasmaestro #sqlpass

  In the last months I talked mostly about PowerPivot, but Analysis Services is still growing and a very good sign of that is the number of downloads of The Many-to-Many Revolution whitepaper, who has been published almost 5 years ago and recently surpassed Read More... Posted Friday, May 13, 2011 2:50 AM by Marco Russo (SQLBI) | 2 Comments Filed under: Analysis Services, DAX, PASS, SSAS

• The Microsoft BI Roadmap: BISM, UDM and Beyond

  Microsoft recently announced a new roadmap for its BI architecture. The next version of SQL Server, codenamed “Denali”, is going to introduce a new semantic model named BISM (Business Intelligence Semantic Model). Analysis Services will host it and it Read More... Posted Monday, November 15, 2010 3:05 PM by Marco Russo (SQLBI) | 6 Comments Filed under: Analysis Services, BIDS, BISM, Business Intelligence, Conference, DAX, Excel, MDX, PASS, PowerPivot, Reporting Services, SSAS, UDM

• Many-to-many relationships in PowerPivot – more samples!

  Alberto wrote a really fine post that should help you to better understand how many-to-many relationships can work in PowerPivot, using a lot of images that explain some concepts better than a thousand words. The example shown by Alberto is really interesting Read More... Posted Wednesday, October 20, 2010 7:55 PM by Marco Russo (SQLBI) | 0 Comments Filed under: DAX, PASS, PowerPivot

• PowerPivot book RTM! And some DAX thoughts…

  Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS . A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is Microsoft® PowerPivot for Excel® 2010: Read More... Posted Friday, September 17, 2010 11:40 AM by Marco Russo (SQLBI) | 14 Comments Filed under: Book, DAX, PASS, PowerPivot