THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Dejan Sarka

DevWeek 2016 BI in SQL Server 2016 Workshop Setup

I got some questions about virtual machine / notebook setup for my Business Intelligence in SQL Server 2016 DevWeek post-conference workshop. I am writing this blog because I want to spread this information as quickly as possible.

There will be no labs during the seminar, no time for this. However, I will make all of the code available. Therefore, if the attendees would like to test the code, they need to prepare their own setup. I will use the following SW:

Windows Server 2012 R2

SQL Server 2016 components

  • Database Engine
  • SSIS
  • SSRS
  • SSAS
  • DQS
  • MDS
  • R Services


  • SQL Server Management Studio (this is not included in SQL Server setup anymore)
  • SQL Server Data Tools
  • R Tools for Visual Studio
  • R Studio

Excel 2016 Professional Plus with add-ins

  • MDS add-in
  • Power Pivot
  • Power Query
  • Power Map
  • Power View
  • Azure ML add-in

Excel 2013 Professional Plus with add-ins

  • Data Mining add-in (this add-in does not work for Excel 2016 yet, this one is announced for Excel 2016 only later this year, after SQL Server 2016 release)

Power BI Apps and Services

  • Power BI Desktop
  • Power BI Service (they need to create a free account at
  • Azure ML (they need to create a free account at

Mobile Publisher

AdventureWorks demo databases version 2016, 2014 or 2012

I know the list is long:-) However, nobody needs to test everything. Just pick the parts you need and you want to learn about.

See you soon!

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS


No Comments

Leave a Comment


About Dejan Sarka

Dejan Sarka, MCT and SQL Server MVP, is an independent consultant, trainer, and developer focusing on database & business intelligence applications. His specialties are advanced topics like data modeling, data mining, and data quality. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or coauthor of fourteen books about databases and SQL Server. Dejan Sarka also developed and is developing many courses and seminars for SolidQ, Microsoft and Pluralsight. He is a regular speaker at many conferences worldwide for more than 15 years, including conferences like Microsoft TechEd, PASS Summit and others.

This Blog


Privacy Statement