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.
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
- Information Quality Cleansing
- Microsoft Data Quality Solution
- Lab : DATA QUALITY SERVICES