August 2013 - Posts

• Dynamic Calculation of Inventory with #dax in #powerpivot and #ssas #tabular

  I recently wrote an article on SQLBI describing the dynamic calculation of stock inventory in DAX. With this technique, you can avoid creating a snapshot fact table just to store the inventory stock for every day and every product, creating a table that Read More... Posted Tuesday, August 27, 2013 3:18 PM by Marco Russo (SQLBI) | 2 Comments Filed under: SSAS, PowerPivot, DAX, Tabular, Excel 2013

• SSAS Maestro and MCM:BI, MCA:BI, MCSM:BI – make your voice heard #ssas #mcsm #sqlserver

  Two years ago Microsoft started a certification program called SSAS Maestro , which was intended to be as a step towards a broader certification such as a Microsoft Certified Architect (MCA) or Microsoft Certified Solution Master (MCSM) for Business Intelligence Read More... Posted Thursday, August 22, 2013 2:58 PM by Marco Russo (SQLBI) | 27 Comments Filed under: Analysis Services, SSAS Maestro

• Excel 2013 stand-alone now includes #powerpivot

  This time Microsoft listened to the many complaints received since Excel 2013 release and the stand-alone version of Excel now includes Power Pivot and Power View! This is a very important news because there were customer who didn’t upgrade from Excel Read More... Posted Monday, August 19, 2013 9:49 AM by Marco Russo (SQLBI) | 2 Comments Filed under: PowerPivot, Power View, Excel 2013

• Performance Tuning of #tabular models in Analysis Services 2012 #ssas

  In the last weeks the Microsoft BI buzzword has been Power BI for Office 365, which will be available soon in preview. I read a few comments about the fact that there is a constant discussion about the future but a lack of information and discussion about Read More... Posted Monday, August 5, 2013 3:37 PM by Marco Russo (SQLBI) | 0 Comments Filed under: SSAS, Analysis Services, PowerPivot, BISM, Tabular