Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

by Reza Rad

Overview

Written in an easy-to-follow, example-driven format, there are plenty of step-by-step instructions to help get you started! The book has a friendly approach, with the opportunity to learn by experimenting. If you are a BI and Data Warehouse developer new to Microsoft Business Intelligence, and looking to get a good understanding of the different components of Microsoft SQL Server for Business Intelligence, this book is for you. It's assumed that you will have some experience in databases systems and T-SQL. This book is will give you a good upshot view of each component and scenarios featuring the use of that component in Data Warehousing and Business Intelligence systems.

Product Details

ISBN-13:	9781849688895
Publisher:	Packt Publishing
Publication date:	05/26/2014
Sold by:	Barnes & Noble
Format:	eBook
Pages:	350
File size:	25 MB
Note:	This product may take a few minutes to download.

About the Author

Reza Rad has more than 10 years of experience in databases and soft ware 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 highquality data warehousing and BI solutions for them. He has worked with industries in different sectors, such as Health, Finance, Logistics, Sales, Order Management, Manufacturing, Telecommunication, and so on.

Reza has been awarded the Microsoft Most Valuable Professional in SQL Server from 2011 to 2014. He is an international speaker in SQL Server, BI, and DW conferences around the world. He speaks in SQL PASS Summits, Microsoft TechEd, SQL Saturdays, SQL Server user groups, and code camps.

Reza has written books on SQL Server and databases. One of his most recent books is SQL Server 2012 Integration Services: An Expert Cookbook, Packt Publishing.

Reza is a big fan of datarelated technologies, his expertise is in EIM, ETL, Data governance, big data, data warehousing, BI, data visualizati on, Master Data Management, OLAP, and so on. He is the author of Webcast series on the RADACAD website (http://www.radacad.com). He writes articles and blog posts on his technical blog (http://www.rad.pasfu.com); he writes about most of the Microsoft technologies, such as SSIS, MDS, DQS, SSAS, Power BI, HDInsight, and so on. His blog contains the latest information on his presentations and publications.

Reza is a Mentor and a Microsoft Certified Trainer. He has been in the professional training business for many years. He conducts extensive 400 handedlevel training for many enterprises around the world via both remote and inperson training. He is an active member of MSDN forums, especially those on SQL Server and Power BI. He is also the leader of the New Zealand Data Warehousing and Business Intelligence user group, which is a registered chapter of PASS.

Table of Contents

1. Data Warehouse Design
2. Understanding Business Intelligence
3. The architecture and components of a BI system
4. Building the data warehouse
5. Summary
6. SQL Server Analysis Services Multidimensional Cube Development
7. Tabular Model Development of SQL Server Analysis Services
8. ETL with Integration Services
9. Master Data Management
10. Data Quality and Data Cleansing
11. Data Mining - Descriptive Models in SSAS
12. Identifying Data Patterns - Predictive Models in SSAS
13. Reporting Services
14. Dashboard Design
15. Power BI
16. Integrating Reports in Applications