Master Data Services, Data Quality Services with SQL 2012 -2014 and Excel


Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.


After completing this course, students will gain the skills to:

  • have a basic understanding of the concepts behind master data management
  • configure Master Data Services
  • create models and entities
  • add attributes including domain-based attributes
  • add a member via the web interface
  • reverse a transaction
  • create and configure attribute groups
  • create and configure derived hierarchies
  • create and configure collections
  • create a leaf member with T-SQL
  • delete a member with the web interface and examine results in SSMS
  • view errors in batch files
  • load leaf members with SQL Server Integration Services and flat files
  • create and configure versions
  • navigate the business rules interface
  • create a business rule
  • populate a value based on another value
  • explore and fix validation issues
  • set up security in MDS
  • create and configure a subscription view
  • create a connection to an MDS database using Excel
  • publish data to an MDS database using Excel
  • filter data using Excel
  • save a query to Excel
  • create an entity from data in Excel
  • create a new knowledge base
  • create a DQS Quality Cleansing Project.

Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: 55073
  • Duration: 3 days
  • Price: $2,391.00

Next Step

Enquire Now
Tell a Friend