This is a post is a compilation of posts from Microsoft The reason I am created the compilation along with providing the link for everyone is the SQL Product Group has been doing an amazing job of pushing the envelope and providing us more & more features in the BI Space for use use with SharePoint 2013 Scorecards and Dashboards.
With this release, multidimensional models support analysis and visualization by using Power View in SharePoint mode. No special configuration of your multidimensional models is necessary. There are however some differences in how multidimensional model objects are displayed in Power View compared to other client tools such as Microsoft Excel and Microsoft Performance Point. This release does not support analysis and visualization of multidimensional models by using Power View in Excel 2013.
SQL Server 2012 Service Pack 1 Cumulative Update 4, released May 31st, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements to the “Power View for Multidimensional Models — Preview” that was previously released November 29 2012 and based on customer feedback. This functionality helps customers maximize their existing BI investments by enabling their use with the latest BI end-user tools and adds greater modeling flexibility to the BI Semantic Model. Customers need to upgrade their Analysis Services instance and the Reporting Services add-in for Microsoft SharePoint Server (2010 or 2013) with this Cumulative Update to create Power View reports against their existing cubes.
As everyone knows Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View reports are presentation-ready at all times because they are always connected to your data. Users can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. Power View operates on a BI Semantic Model that resides in Analysis Services databases or PowerPivot workbooks.
With the SQL Server 2012 SP1 CU 4, Power View can consume data from multidimensional models. Now Power View users can connect to both the tabular and multidimensional formats of the BI Semantic Model. This is achieved through native support for Data Analysis Expressions (DAX) in Analysis Services multidimensional models, ensuring optimal performance and functionality.
Understanding Power View for Multidimensional Models
Wow, Thank you to all of the folks at Microsoft on the team that support us and especially the SharePoint PG & Melissa without whom I would not have made it this far, to all the folks at O’Reilly who made co-authoring Business Intelligence in SharePoint 2013 possible, to all of my friends and fellow MVPs past and present who take their Saturdays off to volunteer and attend the SharePoint Saturday Events around the world, to INETA and all of the Microsoft SharePoint User Groups on the West Coast but especially those in California :), to all of the ISVs like telerik, metalogix, CloudShare, Jetbrains, DevExpress, K2, Axceler, CorasWorks, Surfray & AvePoint and many more who all of us and the events, and to all of my friend and associates that are both supporting and looking for answers in the Microsoft Software Developers Forums…
The Microsoft Community Contributor badge is given to those who make notable contributions to Microsoft online communities such as TechNet, MSDN and Microsoft Community.
The value of these resources is greatly enhanced by participants who voluntarily contribute their time and energy to improve the online community experience for others.
Each day around the world, Microsoft Community Contributor recipients contribute to Microsoft online technical communities in a range of ways, including providing helpful answers, translating online resources into local languages and serving as moderators.
Thank you !!!
I just received my copies of Business Intelligence in SharePoint 2013. I will be signing the books and giving them away at the next SharePoint Saturday 2013 in Redmond where I am speaking.
Being an Author and writing a book is very time consuming and can be difficult since you are working with software that is going to change many time’s prior to release and you are typically the first to be writing opn the new features being released.
However, I was lucky enough to work with a few authors (listed below) who are all some of the best folks I have had the pleasure of working with, and I learned a lot about how much my writing needed to improve.
Norm Warren, Mariano Teixeira, Stacia Misner, and Scott Helmers
Our book was listed last week on the Microsoft Press Blog Site
Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server® 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.
Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel® services and publish workbooks on a SharePoint Server. Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot
Create data-driven diagrams that provide interactive processes and context with Microsoft Visio® Services
Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business
Use SharePoint to view BI reports side by side, no matter which tools were used to produced them
I would also like to thank all of the wonderful people at O’Reilly and Microsoft Press for being there when we needed you….
Thank you all !!!