Transcript Microsoft Business Intelligence Community * Month

What You’re Missing If You’re
Not Using Master Data Services
Steve Moss
Solution Architect, Slalom
Please Support Our Sponsors
SQL Saturday is made possible with the generous support
of these sponsors. You can support them by opting-in
and visiting them in the sponsor area.


www.slalom.com





•
•
•
•
•
•
MDS enables users to curate Sets of Objects. This capability is
powerful in a wide variety of scenarios across all organization
levels
The top barrier to adopting BI/Analytics products is data quality. Also note Integration
and compatibility issues at 40%.







PPS
PPS
Admin
•
•
•
•
•
•
Essbase
Essbase
Analysis
Services
DW
Accoun
ts
Entity
Project
Product
Locatio
n
Channe
l
Dynamics
ERP
Admin Spreadshee
t
ERP
SAP
ETL
EAI
Custom

Review
Spreadsheet
Business
User
IT Admin
E-Mail
© Affecto 2008



PPS
Essbase
Essbase
Analysis
Services
DW
•
•
•
•
•
•
Accoun
ts
Entity
Project
Product
Locatio
n
Channe
l
Dynamics
MDM
ERP
ETL
EAI
SAP
Custom
Business
User
© Affecto 2008
Validation
Authoring business rules
to ensure data
correctness
Modeling
Entities, Attributes,
Hierarchies
Role-based Security and
Transaction Annotation
Excel AddIn
MDS
Master Data
Stewardship
Data Matching
(DQS Integrated)
Web UI
Versioning
Loading batched
data through
Staging Tables
Excel
Enabling Integration & Sharing
Registering to
changes through
APIs
DWH
Consuming data
through Views
Workflow /
Notifications
External
(CRM, ..)
WEB-UI
Excel Add-In
WCF
BizTalk / Others
Workflow /
Notifications
MDS Service
CRM/ERP
IIS Service
DWH
BizTalk / Others
BI
OLAP
SSIS
Excel
PW
Pivot
Subscription
Views
MDS Database
Entity Based
Staging Tables
Cleansing and
Matching
(DQS)
SSIS
External System
External
System




It will bring up the following dialog
*SQL 2012 and Excel 2010+
16
:
*SQL 2012 and Excel 2010+


*SQL 2012+ and Excel 2010+
So you could find all the transactions done by
someone after a certain time and revert them
to the previous value!
*SQL 2012 and Excel 2010+
 http://mdsutilities.codeplex.com/
28

 http://msdn.microsoft.com/en-us/library/hh270298.aspx
29
To summarize, if you’re not using Master Data
Services, you’re missing out on a richlyfeatured platform whose functionality can help
you solve business problems.
30
MDS with Profisee Maestro
Platform Infrastructure
Azure Cloud Availability
Stewardship Interface
Web Part Library
Application Management Portal
Salesforce® Connector
Software Development Kit
Visual Studio Extensions
Dynamics ® CRM Connector
Staging & View Based Integration
Hierarchy Management
Real-Time Event Based Integration
Business Rules & Validation
Notifications
Matching Engine
Version Control
Workflow
Mastering & De-Duplication
Security & Permissions
Data Quality Services
Survivorship Engine
Logical & Physical Modeling
Industry Models & Reference Data
Event & Queue Management
Robust MDM Database
System Aware Identity Management
Federation Manager
Operational MDM
Mobile Device Support
Codeless
Application
Deployment Options For Desktop, On-Premise, Cloud and Mobile


Master Data Services Excel add-in
Dynamic Content
Compression
 http://blogs.msdn.com/b/mds/archive/2015/01/06/update-for-the-master-data-services-mds-excel-add-in.aspx
 http://sqlblog.com/blogs/mds_team/archive/2015/06/02/performance-and-scale-improvement-in-sql-server-2016.aspx
Exporting data Whitepaper: https://msdn.microsoft.com/en-us/library/jj218341.aspx
 https://www.slalom.com/thinking/12-things-youre-missing-out-on-if-youre-not-using-sql-server-mds
 https://www.slalom.com/thinking/solve-business-problems-with-master-data-services
Profisee: extend MDS platform! http://www.profisee.com/
 https://technet.microsoft.com/en-us/library/ff486968(v=sql.105).aspx