Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.
Microsoft cloud engineer - SharePoint, Office 365, Azure, DotNet, Angular, JavaScript.

Business Intelligence

Enable Business Intelligence on any Team Site

Have you worked on a standard SP2013 Team Site then recognized a need to activate BI features.   The BI Center template comes with a lot preloaded.   I used that baseline to compare Activated Features and got the list below.

Running this PowerShell will enable the same features so you can apply BI work to any other base template (Team Site, Community, etc.)   Cheers! 

shades_smile

 

PowerShell

# target
$url = "http://portal/sites/team"
# scope
$webfeat = "PPSMonDatasourceCtype,PPSRibbon,PPSSiteCollectionMaster,PPSWebParts,PPSWorkspaceCtype".Split(",")
$sitefeat = "BICenterDashboardsLib,BICenterDataConnections,BICenterDataconnectionsLib,BICenterDataConnectionsListInstance,BICenterPPSContentPages,BICenterPPSNavigationLink,BICenterPPSWorkspaceListInstance,BICenterSampleData,PPSSiteMaster,PPSWorkspaceList".Split(",")
# activate
foreach ($f in $webfeat) {
	Write-Host "Activating Web - $f"
	Enable-SPFeature -Identity $f -Url $url
}
foreach ($f in $sitefeat) {
	Write-Host "Activating Site - $f"
	Enable-SPFeature -Identity $f -Url $url
}
Write-Host "DONE"

Site Features

PPSMonDatasourceCtype
PPSRibbon
PPSSiteCollectionMaster
PPSWebParts
PPSWorkspaceCtype  

Web Features

BICenterDashboardsLib
BICenterDataConnections
BICenterDataconnectionsLib
BICenterDataConnectionsListInstance
BICenterPPSContentPages
BICenterPPSNavigationLink
BICenterPPSWorkspaceListInstance
BICenterSampleData
PPSSiteMaster
PPSWorkspaceList

PowerMap – 6 min video introduction (Excel 2013)

I heard a lot about PowerMap and wanted to record a quick getting started video with how to download, screenshots, and play a sample XLSX workbook.  

Background

The “Power” family of Business Intelligence features is getting a lot of attention at conferences, SharePoint Saturday, Channel 9, and social media.   Personally I hadn’t worked hands-on with the features before.   The idea is simple and practical – everyone uses Excel for data, so why not leverage that as the BI design surface?

Video Content

  • PowerMap screenshots
  • Download PowerMap EXE for Excel 2013
  • Download sample XLS PowerMap workbooks
  • How to play the Chicago sample XLSX

If you found it helpful please leave a comment below.  Enjoy! 

shades_smile

Downloads

 

Watch Video

PowerMap – 6 min video introduction (Excel 2013) from Jeff Jones on Vimeo.

Screenshots

image
image
image
image
image
image
image
image

SQL Server 2012 Service Pack 2

Today I noticed a bunch of new Microsoft Downloads posted on that RSS feed for various components within SQL Server 2012.   Service Pack 2 is now out and each component has a new download available.   These can be helpful for anyone working on Business Intelligence projects with SharePoint 2013.  Links below.  Enjoy! 

Smile

 

SQL Server 2012 SP2 = 11.00.5058.0

Microsoft® SQL Server® 2012 Service Pack 2 (SP2)

Microsoft® SQL Server® 2012 SP2 Report Builder

Microsoft® SQL Server® 2012 SP2 Reporting Services Add-in for Microsoft® SharePoint®

Microsoft® SQL Server® 2012 SP2 PowerPivot® for Microsoft SharePoint 2013®

Microsoft® SQL Server® 2012 Service Pack 2 (SP2) Master Data Services Add-in For Microsoft® Excel®

Microsoft® SQL Server® 2012 SP2 PowerPivot for Microsoft Excel® 2010

Microsoft® SQL Server® 2012 SP2 Semantic Language Statistics

VIDEO – Tour of SSRS, PowerPivot, and PowerView

I wanted to record an introduction to the new reporting and Business Intelligence capability within SharePoint 2013.   After loading SP2013, there are a few steps to activate the backend Service Applications for BI.   The SQL 2012 install media is needed for this to install SSRS Integrated Mode and PowerPivot.

However, once those are online you can load great samples like “PowerView – Hello World Picnic” to browse real data and confirm it all works correctly.   Very cool stuff, enjoy!  

Smile

References

 

SSRS-PowerPivot-PowerView from Jeff Jones on Vimeo.

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲