Power Pivot Guru - We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced

It's time for another July TechNet Guru winner!

Paul Turley is our Analysis Services/BI TechNet Guru for July! See the TechNet Guru Contributions for July 2013.

Paul is also an MVP and a member of the TechNet Wiki Advisory Board for SQL Server BI and Power BI content.


Paul Turley's avatar


About Paul: Mentor with SolidQ; MVP, MCT, MCITP-BI, MCTS-BI, MCDBA, MCSD, MSF Practitioner. Author & co-author of Wrox Press Reporting Services Recipes, Professional SQL Server Reporting Services (2000, 2005, 2008 & 2012), Beginning T-SQL (2000, 2005 & 2008), MS Press SQL Server 2005 Integration Services Step-by-Step, Data Warehousing with SQL Server 2000 Analysis Services, & Professional Access 2000 Programming.


Here is the winning article:

We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced


Now let's look at the winning articles:

Guru Award  SQL Server Analysis Services, PowerPivot Technical Guru - July 2013 
Gold Award Winner  Paul Turley We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced Ed Price: "Given the new launch of the Power BI brand, there was a huge opportunity to write a great article on what this new suite looks like, and Paul nailed it! In the comments, Naomi, Dplotnikov, Kishhr, and I all agreed that this is a fantastic article!"
Silver Award Winner  Christian Wade Currency Conversion in SSAS 2012 (Multidimensional & Tabular) Ed Price: "Christian masterfully tells the story of Currency Conversion, and I love how it's told for both Multidimensional and Tabular modelling. Great job!"
Bronze Award Winner  Paras Doshi Custom Calculations for Invoice & Returns using PowerPivot DAX formula Ed Price: "This is an important DAX scenario that Paras walks you through. "

Four entries for this category, but only three entrants, who all won a well deserved medal. Paul's article especially filled the ticket!


And here's an excerpt from the article:

Power View

For now, Power View in Excel 2013 ProPlus and Power View in SharePoint 2010 Enterprise and SharePoint 2013 Enterprise remain the same – the Silverlight-based drag-and-drop visual analytic tool.  With the addition of SQL Server 2012 CU4, Power View in SharePoint can be used with SharePoint published Power Pivot models, SSAS Tabular models and SSAS Multidimensional “cube” models.  There has been no news yet about a non-Silverlight replacement for the on-premise version of Power View.  The Microsoft teams and leadership have heard the requests and feedback, loud-and-clear, from the community and we can only guess that there is more is in-the-works but I make no forecast or assumptions about the eventual availability of an on-premise offering similar to Power BI for Office 365.

Power View add-in in Excel 2013 ProPlus:

Mobile UI/portal:



Read the rest here:

We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced



Thanks to Paul Turley for your great contribution to the TechNet Guru contest! You can read about all the July winners here: TechNet Guru Awards - July 2013


Also, for the August Guru competition, see TechNet Guru Contributions - August 2013.



Are you a Wiki Ninja? http://technet.com/wiki

- User Ed