I recently presented a free webinar for Pragmatic Works Free Training on the T’s about new Business Intelligence features in SharePoint 2013. If you attended I want to say thank you. It’s always a fun time presenting and the audience is always a lot of fun to interact with before presenting. If you were unable to join the session here is a link to the recording that you can watch for free. The Q&A can be found below.
Q: Do the improvements mean that we can do security without Kerberos in 2013?
A: Yes and no. The security improvements I showed in this webinar are specific to PerformancePoint and Excel services connection to SQL Server Analysis Services only. This does not affect SSRS typing to connect to any source. So there definitely could still be a need for Kerberos for other connection scenarios. Keep in mind these settings also don’t affect other security models for the rest of your SharePoint farm, just those two specific BI applications.
Q: In the Browser View Options can you only select certain worksheets to deploy to SharePoint so you can essentially hide some of the worksheets from users?
A: That is correct. If you choose to deploy worksheets they will be stored inside the workbook and uploaded, but they will not be visible in the browser to the user.
Q: So what is the best practice for security setup in SP: Using individual credentials and pass it down to data source via SP using Kerberos and delegation of security, or use that single account for all users (Unattended Service Account), or finally pass users credentials as connection property?
A: I’m going to be a consultant here for a moment and say “it depends”. Honestly, it really does. It depends on the data in the report. Human resources data for instance I would say you need to go Kerberos or connection property because access to that data is likely on a per user basis. For instance, I shouldn’t be able to see HR data for the western region if I’m the HR manager for the eastern region. If the data requires less restrictive access, say weather data we have collected then the unattended account is probably just fine since everyone would be connecting under the same credentials and not their own identity.
Q: What version of SQL Server is needed to use SharePoint 2013 features?
A: Power View would need to be SQL Server Reporting Services 2012 or later. The back end for SQL though, to get the PerformancePoint and Excel Services functionality would only need to be 2008R2 SP1 or later.
Q: Do you know if Microsoft plans to add support for multidimensional models for the Excel version of Power View?
A: I don’t have any good insider information on this topic but I think it would be a huge mistake if they didn’t. Look for this in future updates to Excel.
Q: How difficult is to import PerformancePoint 2007 objects into SharePoint 2013?
A: The migration method I showed in the webinar would only work for moving 2013 objects between sites. There is some information about upgrading 2007 objects in this blog post here: http://blogs.msdn.com/b/performancepoint/archive/2010/02/25/upgrading-performancepoint-server-2007-to-pps-2010.aspx
Q: How does do the new security settings you showed affect SSAS security?
A: This will not change your current SSAS security model. You still need to set up roles in your SSAS cubes to handle the mapping between users and the data they can see.
Q: Can Excel and PerformancePoint 2013 show data from SSAS 2005 cubes?
Q: In the excel services report can you view your pie chart and pivot table in the same view?
A: Not in the gallery view, you would have to use the standard view (aka, not setting the browser view options to individual items).
Thanks for everyone who attended the webinar on the Introduction to Data Mining. The recording can be found here: http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/PastWebinars.aspx?ResourceId=613. Here are a few of the questions that some of the attendees had:
Q: Do Data Mining professional also need to be well versed in Statistics?
A: It's not necessary to be a beginner to intermediate in data mining. However if you want to become an expert in data mining, learn more about statistics through a college class is very useful. This is very handy to get the most out of it.
Q: Data mining does not clean the data but they use the clean data for prediction- is that right?
A: You are correct. A large part of a data mining project is the cleansing of the data through ETL or through T-SQL. The reason this is so important is the nature of putting data in buckets. For classification, the fewer the buckets the better. For example, if you have dirty data and you have four versions of the country United States, USA, United States of America and US, data mining won't be able to do as good of a job with customers.
Download the Data Mining in SQL Server.pptx PowerPoint
Thanks for those who attended the webinar on Unit Testing with SSIS and BI xPress. In case you couldn't be there, you can see a recording of it below.
The new version can be downloaded here: http://www.pragmaticworks.com/Products/BI-xPress.aspx.
Some of the questions from the audience to point out:
Q: Daniel: Does it support older version of ssis such as 2008?
Thanks for all who attended the webinar on how to Double your Salary in 3 Years. This webinar is quite personal to me (Brian) and one that I'm passionate about helping others with. You'll be able to find the recordings tomorrow here:
Slides available in the following compressed file:
In this short video, you'll learn how to implement an SSIS framework to detect failures and achieve compliance for regulations like Sarbanes-Oxley. To download BI xPress mentioned in the video please visit the following link: http://www.pragmaticworks.com/Products/BI-xPress.aspx.
In SQL Server 2012, you now have the choice between doing a cube in MOLAP or Tabular mode. This Whiteboard Wednesday shows you the benefit and cons to each of these modes.
Navigating through the array of Microsoft visualization tools can be quite difficult. In this video, Devin Knight and Brian Knight show the pros and cons of each of the tools and the appropriate time to use each. There is of course lots of grey area in your selection.
We also refer to a decision matrix Excel spreadsheet in the video. You can find that attached here: Reporting Decision Matrix
Until next time,
Each and every Wednesday Pragmatic Works is excited to bring you Whiteboard Wednesday, a discussion on patterns, best practices or rants about our industry. In this first video, you'll see some of the top visualization mistakes that people make in building reports. At a glance those are:
These are of course a subset of many of the issues. Let us know if you can think of others in the comments section below. This topic is part of the our Master's SSRS class, given monthly.
Until next time!
This week, the new quarterly update was release of BI xPress was released. The release had over a hundred improvements in it but I wanted to highlight 3 of the neater ones. There are also a lot of down payments in this release that will show themselves in a spring release. If you already have BI xPress, the release is a free update if you’re under maintenance. These are just a small fraction of the BI xPress overall features. For more information, see the
entire product feature list here.
Free Trial Download
Every report in the monitoring console has been redeveloped in WPF, giving it better performance and interactivity. View packages running live and view errors while they occur in a visual method. You can also stack packages side-by-side to see the all run at the same time.
Update 2 – SSIS Catalog Import
The SSIS catalog import tool will enable users to import native performance and execution data from a 2012 SSIS catalog to the BI xPress auditing database. This will make it possible for users to view execution data for packages that do not have the auditing framework. It allows you to combine multiple server’s auditing information into a single view.
While BI xPress has add-ins into the Visual Studio environment, you can now also use the Pragmatic Workbench to launch all the components. You can now customize the look and feel of the workbench’s metro interface.
While we do offer in-person training around the country, we also offer live virtual instruction from our top consultants in the field. So, when does it make sense to go virtual versus in-person?
See our Upcoming Virtual Training Classes. This January, you will receive an additional $200 off any training class that you book in 2013.
There are draw-backs of course. If your co-workers can’t leave you alone if you’re in the office, it’s best to be in-person training instead of virtual but be aware of the differences in cost. Our in-person training is offered in bootcamp-style or workshop style around the country (schedule here: http://www.pragmaticworks.com/LearningCenter/Bootcamps.aspx).