Marco Russo's Blog
View full profileNew PowerPivot 2013 book available! #excel #powerpivot
Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010 . In the previous Read more
Interviewed in SQL Down Under podcast #sqlserver #ssas #powerpivot
I’ve been interviewed by Greg Low in SQL Down Under show 58, and this is *not* an April fool! We talked for one hour about Tabular, Multidimensional, Data Warehouse and just a little bit about music (you can discover which music genre I’m used to listen…). Read more
Pre-Conference Seminar about DAX at TechEd 2013 #msteched #dax #ssas
If you are using Microsoft BI stack and you still didn’t start learning DAX, you should not wait any longer. One of the option you have is starting with one of our books , or you can also attend one of our workshop about Tabular or PowerPivot . But if Read more
Cost of Process Defrag in Analysis Services Tabular #ssas #tabular
I recently received a question about the memory required to run a Process Defrag on a Tabular model in Analysis Services. The Process Defrag is useful when you run incremental processing of a table frequently, or when some of the values in the dictionary Read more
Discount for PASS Business Analytics Conference 2013 #passbac #ssas #sqlpass
One month ago I wrote about my sessions at PASS Business Analytics Conference 2013, in Chicago, IL on April 10-12, 2013. If you still have not registered, you can save $200 by using the code BAC228BL and you should hurry up, because there is another discount Read more
Microsoft BI Security White Paper #ssas #powerpivot #sharepoint #ssrs
There is a new whitepaper from Microsoft, Microsoft BI Authentication and Identity Delegation , which describes all the authentication and delegation scenarios with Microsoft BI technologies: Personal BI Scenarios (Excel) Team BI Scenarios (SharePoint) Read more
Update to the PowerPivot for Excel 2013 licensing #powerpivot #excel
UPDATE Aug 16, 2013 : Excel 2013 stand-alone now includes Power Pivot and Power View! Rob Collie Ken Puls (thanks Bob!) wrote a very interesting post about the PowerPivot for Excel 2013 licensing . Short recap: PowerPivot for Excel 2013 is only available Read more
Querying with DAX video available on Project Botticelli #dax #ssas #powerpivot
I recently published a video session on Project Botticelli web site regarding querying in DAX. You can write DAX queries to extract data from both PowerPivot and SSAS Tabular models. This could be particularly useful in three scenarios: Reports in Reporting Read more
Workshop and Events in Europe next month #ssas #tabular #powerpivot
As I mentioned a couple of weeks ago, I and Alberto are starting to travel again, delivering SSAS Tabular Workshop and other free community events around Europe. This is the updated list of our next dates, including community events: Online – SSAS Tabular Read more
SQLBits XI in May 2013 – many reasons to attend! #sqlbits #dax #tabular
I and Alberto Ferrari will speak at SQLBits XI (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX! Here are our sessions: Thursday, 02 May 2013 – Training Day – From 0 to DAX The Read more