• 100 Queen St W, Brampton, ON L6X 1A4, Canada
  • +1-800-961-0337
START DATE END DATE CLASS TIMINGS MODE LOCATION ACTION
11/19/2018 11/20/2018
  • VLT
Live Online
12/17/2018 12/18/2018
  • VLT
Live Online

About the course

Studies demonstrate that information rots at around 2% a month all associations need to work from solid data while guaranteeing that the uprightness of data and consistency of information is steady crosswise over various applications. Microsoft SQL Server 2012-2014 Master Data Services is a capable component intended to enable an association to make a structure and progressive system for information, so information gathered and utilized over numerous divisions, storehouses and databases is institutionalized and adjusted. This guarantees diverse databases are interoperable. At the point when joined with Data Quality Services and Excel an entire end to end framework is accessible.

Audience profile

55073: Master Data Services, Data Quality Services with SQL 2012-2014 and Excel course is planned for SQL Professionals, Business Intelligence Developers, Data Analysts and Data Stewards and Project Managers that need to figure out how to use Master Data Services. 

At course completion

In the wake of finishing 55073: Master Data Services, Data Quality Services with SQL 2012-2014 & Excel course, understudies will have the capacity to: 

  • Have an essential comprehension of the ideas driving expert information administration. 
  • Arrange Master Data Services. 
  • Make models and elements. 
  • Include characteristics including space based properties. 
  • Include a part through the web interface. 
  • Turn around an exchange. 
  • Make and arrange trait gatherings. 
  • Make and arrange determined progressive systems. 
  • Make and arrange accumulations. 
  • Make a leaf part with T-SQL. 
  • Erase a part with the web interface and look at brings about SSMS. 
  • View mistakes in group records. 
  • Load leaf individuals with SQL Server Integration Services and level records. 
  • Make and design adaptations. 
  • Explore the business rules interface. 
  • Make a business run the show. 
  • Populate an esteem in view of another esteem. 
  • Investigate and fix approval issues. 
  • Set up security in MDS. 
  • Make and design a membership see. 
  • Make an association with a MDS database utilizing Excel. 
  • Distribute information to a MDS database utilizing Excel. 
  • Channel information utilizing Excel. 
  • Spare an inquiry to Excel. 
  • Make an element from information in Excel. 
  • Make another information base. 
  • Make a DQS Quality Cleansing Project.

Module 1: COURSE OVERVIEW 

Module 2: MASTER DATA MANAGEMENT CONCEPTS 

Module 3: MICROSOFT MASTER DATA SERVICES 

Module 4: UNDERSTANDING DATA MODELS 

Module 5: IMPORTING DATA 

Module 6: VERSION MANAGEMENT 

Module 7: BUSINESS RULES 

Module 8: MDS SECURITY 

Module 9: PUBLISHING DATA 

Module 10: EXCEL ADD-IN 

Module 11: DATA QUALITY SERVICES 

Lessons 

  • Design 
  • Information Quality Cleansing 
  • Microsoft Data Quality Solution 
  • Lab : DATA QUALITY SERVICES

Awards