For the preparation of my upcoming talk about SQL Server 2012 Master Data Services on the Microsoft Business Analytics Day (hosted by my company element61), I read the book Master Data Services 2nd edition by Tyler Graham.
I had almost no prior experience with MDS up to this point (I very quickly glanced over it in preparation for the 70-463 exam and I guess I didn’t answer a lot of questions about MDS correctly), so I needed a book that could introduce me to the concepts of MDS and how I can effectively manage master data using this tool.
Tyler Graham was part of the development team of SQL Server Master Data Services right from the start, so if anyone is qualified about writing a book about MDS it’s probably him. You can notice his profound knowledge throughout the book, as he frequently delves deeper in the MDS web service (I didn’t even know there was one) and references hidden stored procedures and views to make MDS do your bidding. The book accomplishes its goal: I know have a good working knowledge of the tool and if I have to use it in a project tomorrow, I know where to start.
The book starts with an introduction to manager master data in general, which is very welcome for someone new to the field, just like me. The book then thoroughly explains how to install and configure MDS. In the next chapter, the business use case used throughout the book is introduces and in the following chapter you learn about creating models.
Chapter 5 explains how you can import data into MDS, using the various staging tables. I would have put this chapter later in the book, because the examples show you how to populate objects you have never even heard of and you don’t exactly know what they represent or how you can use them. A bit confusing. The author talks how you can automate the import process using stored procedures – very useful when you plan on using SSIS to load MDS – and he says he will explain them in the next section. However, the next section is about web services and he never mentions the stored procedures again. A missed opportunity…
The next chapters explain how to create hierarchies, collections, business rules and so on. The whole time the same business case is used for the examples: a clothing company managing financial and product data with MDS. The examples are real-life and they help you to understand how to work with the product.
Then there’s a whole chapter on using Excel as the front-end for MDS. This is great, as this really opens up MDS for the business user, which gives MDS an advantage over its competitors. However, the book uses a sample workbook you can supposedly download from mdsuser.com. But the Excel is nowhere to be found in this site. The book also mentions another site you can download samples from, but that site doesn’t even exist anymore.
At that point we’re at chapter 11, which is a long chapter on how to implement security. The author goes into great detail to explain how it works in MDS. This chapter is certainly useful as a reference when you are implementing permissions in MDS. Chapter 12 shortly explains how to create subscription views so that you can extract data from the system (which is basically the point of a master data implementation, otherwise it wouldn’t be a much use). The next chapter is all about web services, so I gladly skipped that one. The last chapter talks about advanced modelling, but is just a few pages with a few tips and a few reminders of what not to do with MDS. Very interesting though was the authors take on MDS and slowly changing dimensions.
All in all this was a very decent book that showed me how to work with Master Data Services and how to get the most out of it. The author always explains the differences between the previous version and also warns you about what will not work (well) in MDS and how you can possibly circumvent it by fiddling around in the database.
The biggest downside – for me personally – is something that is probably out of control of the author: the format of the eBook. The book was purchased on ebooks.com in PDF format, but the PDF look like some poorly converted eBook format (epub or mobi or something like that). There were no page numbers, no headings or footers and every page just went to the next one, leading to awkward section endings. There were also no margins, which makes it difficult to decently print a page. The book is supposed to be 416 pages long, but the PDF has only 337 pages. Quite a difference. Maybe ebooks.com throw the section about stored procedures away with their lousy conversion. Bad ebooks.com.
This might be normal for an actual eBook for reading on a Kindle or a tablet (I have no idea, I own neither of both), but when I buy a PDF I expect it to look like the actual book. Again, this has nothing to do with the efforts of the author: he wrote an excellent book on Master Data Services. The samples are OK with this book, but a few more effort could be put into them. All in all I recommend this book to everyone who wants to learn more about SQL Server 2012 Master Data Services. Just don’t buy it from ebooks.com.