Synopsis
Microsoft SQL Server, Excel, and SharePoint come with powerful components for Business Intelligence and Data Warehousing. Designing and implementing a reliable ETL system is possible with Data movement technologies. Data modeling technologies help to create tabular and dimensional models based on an existing data warehouse. Dashboard and Reporting tools help in creating frontend of the BI system which is useful in making business decisions. Data mining algorithms help in creating predictive models based on data patterns.
Take advantage of the real power behind the BI components of SQL Server 2012, 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 build your own 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. Later, reporting and dashboard technologies will be revealed with real-world samples. Data mining will be used to get predictive models based on existing data patterns. The book is packed with real-world examples which will give you a good understanding of BI and DW components of SQL Server 2012, Excel 2013, and SharePoint 2013.
You will learn how to convert business requirements to a data warehouse with Dimensional Modeling. Data modeling technologies explained with examples help you to create OLAP cube and tabular models based on an existing data warehouse. SSIS, DQS, and MDS illustrated in this book give you an understanding of how to create an ETL process by considering data consistency and data quality. SSRS and PerformancePoint tools are later explained with scenarios of creating the BI frontend tools for dashboards and reporting. We will also learn to use data mining algorithms used for predictive data models based on existing data patterns.
By the end, you will be able to design and implement a data warehouse and BI system from end to end, from user requirements to analytical reporting in Microsoft Business Intelligence with SQL Server 2012.
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.
"About this title" may belong to another edition of this title.
