Tag Archives: 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.

Business Intelligence Demo VHD (Part 2 of 10) – Windows Server 2012

We continue the build by installing Windows Server 2012 Standard Edition with GUI.  The default install choice is server code (no GUI) but we will want the GUI to work with SharePoint and BI features interactively.   For security, I am using “pass@word1” on all areas including local Administrator.

NOTE – There are some helpful tricks at http://www.win2012workstation.com/ if you plan to use this server with RDP for demos to get a more robust desktop like experience.  Otherwise, you can always browse over HTTP from the VM host.   Sometimes that’s a good way to show cross browser compatibility (IE, FireFox, Chrome, etc.)

image_thumb3

image

image

image

image

image

image

image

image

image

image_thumb

image_thumb2

I like to run Windows Update before doing anything else just to make sure I’m current and hopefully avoid errors.

image_thumb1

 

I modified the computer name to be “DEMO2013A” for matching the Content Pack scripts from CodePlex documented requirements.

image

image

I modified the user “Administrator” to be just “Admin” for easier typing.  This name will have to be typed into all sorts of places, easier to save a few keystrokes.

image

image

Next, it’s a good idea to load the VM guest additions.  This might be different for other VM products (VMWare, Hyper-V, etc.)

image_thumb11

Then we can modify PowerShell to have unrestricted execution policy.   This will allow for running any PS1 script file without security prompt.  I am using this for DEV, but in practice it is better to keep “RemoteSigned” for production.

image_thumb22

Next, we run the Microsoft Content Pack Installer so that we can deploy package files downloaded from https://sharepointdemobuilds.codeplex.com/

image

image_thumb8

image_thumb10

Business Intelligence Demo VHD (Part 1 of 10) – Prepare VM

This series of posts covers in detail my experience with installing SharePoint 2013 and SQL 2012 BI features using  http://sharepointdemobuilds.codeplex.com/

One of my favorite demos with SP2010 was the “Information Worker” VHD because it had so many great visuals, people, org charts, SharePoint team sites, and databases for BI.  I haven’t been able to find any IW download VHD for SP2013.

However, today we have http://sharepointdemobuilds.codeplex.com/.  Ivan Sanders was kind enough to package sample content with automated deployment.   NOTE – There is no complete VHD file.  You must obtain installation media for each Microsoft product (Windows, SQL, SharePoint).  Trial editions are available and work fine, but you will need install from media. Below are screenshots from my experience configuring SP2013 with the demo content.  

Please leave a comment if you found this post series helpful.  Smile

First we need to create a VHD container for the machine we plan to build.   This can be done on any Windows 7/8 machine by opening Computer Manager and right clicking on Disk Management.  I chose to create a 96 GB dynamic file.   That allows room to expand while minimizing current disk usage.

image

image

The disk must be initialize to prepare it for the Windows O/S install we’ll perform next.   Default options (MBR) are fine here.

image

image

image

image

The VHD file is now complete and ready for use in any VM host software.  I chose VHD format for wide compatibility.  

image

 

Next, we will create the VM guest machine.  I am using VirtualBox (http://www.virtualbox.org) because it’s free and runs well on any Windows 7/8 desktop.   The specifications I am using are shown below.  NOTE – More RAM would boost performance.  I have 10GB RAM and pointed to the VHD file we just created for storage.   Also, I attached the Windows 2012 install media ISO to the virtual CD-ROM so we can boot and install.

image

image

image

image

image

image

image

image

FIXED – Rule “User account requirement for Farm administrator” failed

When installing PowerPivot on SharePoint 2010 you might see the below error.   Behind the scenes several permissions are being verified, not just Farm Admin.   In my case I also needed to grant SQL SYSADMIN permission to the user account performing the install.  This error message is confusing because it can occur even if you are listed on Central Administration as a Farm Admin.  So before you run “setup.exe” on the SQL CD, be sure to double check your permissions.

 

PowerPivot install account needs:

  • Local Administrator 
  • Farm Administrator 
  • SQL sysadmin fixed role 

Rule "User account requirement for Farm administrator " failed.  The user is not a farm administrator.

image

 

image

image

 

image

Return to Top ▲Return to Top ▲