In short, DQS allows to check the quality of your data and clean it. More complex tasks linked to the management of the model and the definition of business rules are done via a web interface.ĭata Quality Services (DQS) is a brand new feature in SQL Server 2012. New entities can be created either directly from Excel or imported from an existing table in SQL Server 2012 MDS. The new MS-Excel Add-in will allow data stewards, business users responsible for a particular data set, to edit members of an entity leveraging all the familiar functionality of Excel. With SQL Server 2012 we get a more robust and mature solution because of the progress made both on usability via a new MS-Excel Add-in and on the performance of the product with enhancements in the Business Rules modules. Master Data Services (MDS) was already present in SQL Server2008 R2 and was the result of the integration of the acquired technology of Stratature into SQL Server. Master Data Management (MDM) is a set of tools and processes that aim to deliver a single clean and consistent view of each master data entity (product, customer, employee, financial account, …) that exists within the organization. Master Data Services is Microsoft’s answer to the Master Data Management challenge. Data Integration Area Master Data Services Finally, it is not the goal of this article to review all the new functionalities of SQL Server 2012, we focus on the once relevant for BI & data warehousing. In this Insight, we will highlight the new functionalities that we think are important for Microsoft Business Intelligence customers and professionals and comment on how we could use them in real life. They can even be imported in and updated from within PowerPoint. These reports can be shared and deployed in SharePoint where colleagues can access them. End users have the possibility to create BI applications themselves with PowerPivot and create reports with Power View. On the end-user side of BI project, Microsoft has made major innovations to render the BI platform more agile than ever with PowerPivot and Power View. On the data management side, with the Index Columnstore on the database and the Tabular Model in Analysis Services, Microsoft has introduced a new technology Xvelocity™ (previously known as Vertipaq™) that increases the performance of ad-hoc queries. In the new version of SSIS, Microsoft has made important enhancements to increase the productivity for developing and managing SSIS Packages. They re-enforce and broaden the current offering of Integration Services, Microsoft’s ETL (Extraction, Transformation & Loading) tool. In the data integration area, Microsoft has made a step forward with the introduction of two components: Master Data Services and Data Quality Services. With respect to Business Intelligence & Data Warehousing, this version offers some interesting new functionality, of which this Insight reviews the highlights. Early April 2012, Microsoft officially released SQL Server 2012.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |