SQLBits 2017
Master Data Services 2016
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
This session is not only for people working with
Master Data, but also everyone working with Business Intelligence. With Master
Data Services 2016 it's now easy to handle all your dimension data, including
Type 2 history.
In this session you will get a brief introduction to
the basic principles of Master Data Services, together with an overview of all
the new features brought to you with Master Data Services 2016.
You will learn about features like:
You will learn about features like:
- New features and better performance in the Excel Add-In
- Track Type 2 history
- Many-To-Many hierarchies
- New security and administrator capabilities
- New approval flows
Speakers
Stephan Stoltze's other proposed sessions for 2026
ChatGPT for SQL People: An Introduction to LLM-Powered Data Analysis - 2026
Stephan Stoltze's previous sessions
Master Data Services 2016
In this session you will get a brief introduction to the basic principles of Master Data Services, together with an overview of all the new features brought to you with Master Data Services 2016.
Real Life Master Data Management with SQL Server and MDS
In this session you will learn about common MDM scenarios, and get Real Life examples on how to handle these Scenarios by building a MDM Architecture using SQL Server and Master Data Services.
Excel 2013 - Whats new beside PowerPivot and Power View?
You probably already heard a lot of the wonders of PowerPivot and Power View, but will you have any other cool new BI features with Excel 2013. The answer is a big YES! This session will demo a lot of those.
Business Intelligence with Excel 2010
Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.
Writeback-Here Comes the Sun
With Excel 2010 it is finally possible to modify data in a SSAS cube, without using any macros or third party add-ins. This opens for a lot of common business scenarios like budgeting and planning directly from Excel 2010.