Having one version of the truth in a data warehouse and even in database systems is an important step. In this chapter, you will learn why we need Master Data Management (MDM) in the BI solution, and you will learn about the structure of Master Data Services as a Microsoft service for implementing MDM solutions. You will also learn how to create models and entities with Master Data Services, how to work with WebUI and Microsoft Excel Add-in, and how to create business rules and secure information.
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By :
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
By:
Overview of this book
Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Free Chapter
Data Warehouse Design
SQL Server Analysis Services Multidimensional Cube Development
Tabular Model Development of SQL Server Analysis Services
ETL with Integration Services
Master Data Management
Data Quality and Data Cleansing
Data Mining – Descriptive Models in SSAS
Identifying Data Patterns – Predictive Models in SSAS
Reporting Services
Dashboard Design
Power BI
Integrating Reports in Applications
Index
Customer Reviews