Here’s a quick chart that I created based on reading up from different sources about licenses required in office 2013/office 365 to use Power View and/or Power BI. It was not straight forward and I had to use multiple sources to find this information, so hopefully this helps you:
Please Note:
Double check w/ official sources. The chart is meant to guide to find the right license for your needs. Please use this as a starting point & use official resources before making a purchase decision.
Power View reports that are hosted on SharePoint has “Edit report” which you cannot hide:
We can’t hide this button but how do you give someone “read-only” access to Power View?
To do so, you’ll have to host the Power View report in a SharePoint library where a user has read-only access. When a user opens the report, he/she could click on edit report & make changes to Power View report but they won’t be able to save the report instead they’ll see an error:
I learned about an interesting new feature in Excel 2013 which they call “FLASH FILL”. Instead of trying to explain it, Let me demo it:
1. I’ve following data in Excel 2013:
2. Now the requirement is to split the FULL NAME into FIRST NAME and LAST NAME.
So I entered Kim in cell B2
Then I typed just Mi in the cell B3 and Excel 2013 predicts correctly for cell B3, B4 and B5 that I am filling up the first name from the Full Name column.
See:
I hit enter for the column First Name.
I performed similar steps for the column Last Name. And there you have it:
That’s about it for demo of Excel 2013’s Flash Fill – very cool!
In this post, we would see how to get started with Fuzzy look-up add-in for excel.
First up, Which problem does Fuzzy Lookup add-in for excel solve? It cleans similar (a.k.a matching) textual data in Excel. E.g. “Mr Paras Doshi”, “Doshi Paras”, “Paras A Doshi” are similar and may refer to the same person – Fuzzy look-up helps you detect such similar textual data. This add-in is really handy if you are “combining” data from different systems where the data is not in the same format – using this add-in you can detect similar looking text and clean the data-set at hand. With that, Here are the steps to download, install and play with this add-in:
1) Download “Fuzzy Lookup add-in for Excel. Read: Over view, system requirements and Instructions
A short post to point out that Power View reports can be exported to PowerPoint (PPT) – and PPT slides would also have a “click to interact” button and if the security plus network access is configured correctly then the Interactive data exploration without leaving the Slides! very cool. I had pointed this fact out earlier here. And the official resource can be found here: Export a Power View Report to PowerPoint
I am referring to SQL Server 2012 BI and SharePoint 2010 here. And here is a step by step guide:
1) Create report > Save it > And then Go to File > Export to Power Point
A note about security: “Export to PowerPoint” requires windows authentication method.
2) Select the location of the PPT file that will have the “Power View” reports.
Now you can store the PowerPoint file at any place but it would be important to consider whether the machine from which it would be accessed has the network access to the SharePoint Power View reports. If not, the Power View reports would just show up as “static images” and the click to interact would not work. Important security point to consider for your scenario.
3) Open the File > start slideshow > Navigate to the slide (if applicable) > can you see the “click to Interact” button? Yes? Great! you can do interactive data exploration from the PowerPoint environment itself! I find this very Impressive because Power View is meant for Business Users to do Data Exploration and create rich visualizations and once they are done with it – they can export it to PowerPoint and show their Power View chops to their boss and peers and more importantly, make better business decisions. Any-how, here’s the image:
