Microsoft Sql Server 2014 Business Intelligence Development: Get To Grips With Microsoft Business Intelligence And Data Warehousing Technologies Using This Practical Guide

E-Book Overview

Take advantage of the real power behind the BI components of SQL Server 2014, Excel 2013, and SharePoint 2013 with this hands-on book. This book will give you a competitive advantage by helping you to quickly learn how to design and build BI system with Microsoft BI tools. This book starts with designing a data warehouse with dimensional modeling, and then looks at creating data models based on SSAS multidimensional and Tabular technologies. It will illustrate how to use SSIS for ETL, and MDS and DQS for data governance and data quality. The book is packed with real-world examples that will give you a good understanding of the BI and DW components of SQL Server 2014, Excel 2013, and SharePoint 2013.

E-Book Content

www.it-ebooks.info Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Get to grips with Microsoft Business Intelligence and data warehousing technologies using this practical guide Reza Rad BIRMINGHAM - MUMBAI www.it-ebooks.info Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide Copyright © 2014 Packt Publishing All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information. First published: May 2014 Production Reference: 2220514 Published by Packt Publishing Ltd. Livery Place 35 Livery Street Birmingham B3 2PB, UK. ISBN 978-1-84968-888-8 www.packtpub.com Cover Image by Artie Ng ([email protected]) www.it-ebooks.info Credits Author Project Coordinator Reza Rad Amey Sawant Reviewers Proofreaders John Heaton Simran Bhogal Goh Yong Hwee Maria Gould Raunak T. Jhawar Ameesha Green Francesco Quaratino Paul Hindle James Serra Indexer Priya Subramani Acquisition Editor James Jones Graphics Content Development Editor Madhuja Chaudhari Valentina Dsilva Disha Haria Yuvraj Mannari Technical Editors Abhinash Sahu Pragnesh Bilimoria Taabish Khan Pooja Nair Copy Editors Sayanee Mukherjee Production Coordinator Komal Ramchandani Cover Work Komal Ramchandani Aditya Nair Alfida Paiva www.it-ebooks.info About the Author Reza Rad has more than 10 years of experience in databases and software applications. Most of his work experience is in data warehousing and business intelligence. He has worked with Microsoft technologies from SQL Server 7 and Visual Basic 6 to the latest versions of SQL Server and .NET. He has a Bachelor's degree in Computer Engineering. Reza is a DW/BI architect and consultant. He has worked with large enterprises around the world and delivered high-quality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics