Comments : Leave a Comment »
Tags: Power View multidimensional cubes
Categories : BI Industry, Microsoft BI Platform, Power View, PowerPivot, SolidQ, SSAS Administration, SSAS Design
The Power View connectivity for Multidimensional Models has been released to the public as part of SQL Server 2012 Service Pack 1 Cumulative Update 4. This announcement was made by Robert Bruckner to the SQL Server BI community last night, on May 31, 2013. The official public announcement, posted by Siva Harinath, is on the Analysis Service & PowerPivot Blog.
In March, I posted about the public preview of the “Microsoft SQL Server 2012 With Power View For Multidimensional Models”. Well, the official release is now available for those currently using SQL Server 2012. When the preview became available a couple of months ago, I was very excited to test it out so I downloaded it, quickly scanned the release notes and then proceeded to upgrade an existing SQL Server 2012 SP1 development server. What I missed in the release notes was the requirement to uninstall several existing components and then to install them from scratch. That wasn’t as easy as I had hoped but it’s pretty typical for prereleased software to not include upgrade support. After all, the product teams are focused on finishing features and debugging and not getting all the upgrades and installation details sorted out. Those steps usually happen last in the release cycle.
Not to worry, this new capability is now part of the Cumulative Update 4 for SQL Server 2012. This means that it will be fully-supported as an upgrade to an existing SQL Server 2012 installation. This is very exciting news. If you have seen Power View demonstrated with new SSAS tabular models and PowerPivot models in Excel and SharePoint, you know what a simple and powerful data browsing and visualization tool it is. Some people have been a little disappointed that Power View initially only worked with new xVelocity-based tabular models and not the multidimensional cubes built with SQL Server Analysis Services, that have become common in many Microsoft centered IT shops throughout the industry.
The Microsoft product teams have shared a lot of good news, like this, recently about BI innovations – with Power View in Excel 2013 and GeoFlow recently released. They are likely to share even more good news in the weeks and months ahead. It’s an exciting time to see some very impressive, powerful, fun to develop and fun to use BI business and IT tools all coming together to meet very real business problems.
I don’t know about you but I’m going to get this baby installed and working right away. I have clients who have been waiting patiently (and some not so patiently) to use Power View with their existing cubes. I love to be the bearer of good news.
As is usual when something noteworthy happens on the Microsoft BI community, Chris Webb has blog eloquently on the topic and with significant detail. Read today’s post on his blog here.
Comments : 3 Comments »
Categories : BI Industry, Microsoft BI Platform, PASS
In this morning’s keynote address at the PASS business Analytics Conference, Amir Netz demonstrated using GeoFlow, a geographic data visualization add-in for Excel 2013, with a set of data showing the success of pop starts and their countries of origin. It was a very interesting display of 3D geographical data. Amir gets so excited when he does these demonstrations and his passion for these new BI tools is infectious.
The public beta for GeoFlow is released publically today and you can download the installer from here. I blogged about GeoFlow in a short video presentation titled SQL Server Community World Tour with GeoFlow. I need to update my very brief set of data but it does show some of the capabilities of an earlier private preview version of the tool.
From the official Microsoft Connect page for GeoFlow, this is what you can expect to see in this release:
The GeoFlow Preview for Excel contains the following new features:
A single install for 32-bit and 64-bit versions
Geo-disambiguation dialog showing what values were not geocoded
Support for Tables which have Relationships
Add Data button in the Excel Ribbon, part of the Map split button which allows you to add data from your sheet to the Data Model after selecting it
Refresh Data button in the GeoFlow ribbon
2D charts and brushing
Touch navigation and gestures
New tour model with no need to save or refresh your scene
Transitions and Effects
Many improvements in the UI – ribbon, time controls, navigation controls
You can read more details in the Getting Started document.
GeoFlow can be installed here.
(Apr 14 13 Update) – GeoFlow requires Microsoft Office 2013 Pro Plus. Make sure you have that edition of Excel installed and then download and install the add-in. After that, open a document in Excel, go to File > Options and Add-Ins, select to manage COM Add-ins and hit the Go button. Check the GeoFlow for Microsoft Excel item and click OK. That should do it!
You’ll find the GeoFlow option on the Insert ribbon, GeoFlow group and the Map drop-down button.
If you can’t get to the content on the Microsoft Connect site, try this link. You must log into the Connect site using a Microsoft account like you would to use HotMail.
Comments : Leave a Comment »
Categories : Microsoft BI Platform
These are the sample reports from the Penton eLearning session today on SSRS Report Expressions:
This view is necessary to add to the AdventureWorksDWxxxx database:
Comments : 2 Comments »
Categories : Microsoft BI Platform
I’ve posted two feedback items on the Microsoft Connect today, suggesting feature enhancements to Power View and Reporting Services. If you think these capabilities would be important, I encourage you to follow the links below to the Microsoft Connect site and vote on these items. Read the rest of this entry »
Comments : 1 Comment »
Categories : Microsoft BI Platform, MVP Community, PASS, Power View, PowerPivot, SolidQ, SQL Saturday, SQL Server, SQLServerPedia
Today in Vancouver, British Columbia, at the SQL Saturday #198; I presented a session titled “Data Visualization Choices”. As promised, my slide deck is available for download here.
This is the first draft of the session I’m preparing for the PASS Business Analytics Conference coming up on April 11-12 in Chicago. I’ll have another update for that conference.