SQL 2012 Business Intelligence Automation of Demo Builds Part 3 SelfService BI

The reason I created this project on CodePlex is that everyone has been asking in user groups, SharePoint Saturday events etc. When we will have a downloadable VHD like we did with SharePoint 2010 with the Information Worker VHD. Also, One of the issues that used to bug me was having to download 60 750MB files and then merge them together in get one SharePoint 2010 Demo VHD.

After learning how Microsoft was packaging their Demos I thought we could have many more of them available for folks to use and they are fun to share, there had to be a better way. Not including the Installation media Windows Server 2012, SQL Server 2012 , and SharePoint 2013. All of the Content packs we have deployed so far as a group are less than a 750MB download…


The reason I created this project on codeplex is that everyone has been asking in user groups, SharePoint Saturday events etc. When we will have a downloadable VHD…

Project Description
Through the use of Content Packs for SelfService BI, ECM, Search and BigData,  we hope to bring you the ability to use the same demos we have built based with exaples like Contoso Medical, Great White Gears, Contoso Schools, AdventureWorks Camping Supplies, TaolSpinToys,  Contoso Casino, and more. We have extended the Content Pack so that we can now install SQL 2012 SP1 and SharePoint 2013 in almost the same configuration as our environment, that allows us to give you these demos..


Evaluation Copies are OK, we will not be providing any way for them to be re-armed after the 180 day trial is over.

The entire installation is PowerShell with a GUI Interface….

Prerequisites: License Keys and installation media for the following:

  1. Windows Server 2008R2 Sp1 or Windows server 2012
  2. SQL Server 2012 SP1
  3. SharePoint 2013
  • Installed and Configured
  • Windows OS from the list above
  • AD Directory Services Installed and Promoted for the domain Contoso.com

After the SQL 2012 SP1 Installation you will have three instances of Analysis Services (Tabular, Multidimensional, and PowerPivot) this will allow us to share our data with you while reducing the amount of confusion there can be when setting up these services and using them with SharePoint for the first time.



Please let us know if you think we have missed anything we appreciate your feedback and are always looking for folks to beta test our deliverables before we upload them here…http://sharepointdemobuilds.codeplex.com

The Content Packs that we have up so far are the following

Active Directory Content Pack Demo 2.0 – Creates an Employees OU, adds the standard 200 or so Contoso employees to the Employee’s OU with passwords, and Last adds the SPFarm, and SPAdmin service accounts to the Domain Admin’s group

SQL 2012 SP1 Content Pack Demo Build 2.0.0 – Installs SQL 2012 SP1 with three instances of Analysis Services (Tabular, Multidimensional, and PowerPivot) and RS integrated SharePoint mode.

Self-Service BI Demo 2.0 Content Pack – Installs the Self-Service BI Demos with the following databases and models:


• AdventureWorksDW2012
• AutoSalesSourceDW
• ContosoEnergyDW
• ContosoSchoolsDW
• TailspinToys

• AutoSalesModel
• ContosoEnergyModel
• ContosoSchoolsModel
• Customer Profitability
• TailspinToysModel

If you get a chance I would love to have some folks testing the deployment and providing feedback as I continue to add additional Content Packs, it seems I take less time testing the PowerShell scripts the more I use PowerShell because I know it right, lol.. Sad, but a true trap of using a technology everyday and taking your skills for granted..

What’s Planned – Coming Soon

  • People Pack with My Site Provisioning & Social networking Demo 2.0 
  • Visio Services 2013 Demo 2.0
  • Great White Gears demo 2.0
  • AdventureWorks Camping Supplies E-Commerce Demo 2.0




Technorati Tags: ,,

No comments yet. Be the first.

Leave a Reply