What do you think?
Rate this book
Microsoft SQL Server 2014 Business Intelligence Development Beginner’s Guide
Get to grips with Microsoft Business Intelligence and data warehousing technologies using this practi cal guideAbout This BookDiscover the Dimensional Modeling concept while designing a data warehouseLearn Data Movement based on technologies such as SSIS, MDS, and DQSDesign dashboards and reports with Microsoft BI technologiesWho This Book Is ForIf 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.
What You Will LearnPerform Data Modeling with SSAS Multidimensional and MDXUse DAX and SSAS tabular for Data ModelingManage Master Data with MDSReveal Knowledge Driven Data Quality with DQSUnderstand prediction and Data MiningIdentify data patterns and predictive modelsDesign Dashboards with PerformancePoint and Power ViewExplore Power Query and Power Map as components of Power BICreate Reports with SQL Server Reporting Services and integrate them in applicationsIn DetailTake 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.
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.
What You Will LearnPerform Data Modeling with SSAS Multidimensional and MDXUse DAX and SSAS tabular for Data ModelingManage Master Data with MDSReveal Knowledge Driven Data Quality with DQSUnderstand prediction and Data MiningIdentify data patterns and predictive modelsDesign Dashboards with PerformancePoint and Power ViewExplore Power Query and Power Map as components of Power BICreate Reports with SQL Server Reporting Services and integrate them in applicationsIn DetailTake 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.
351 pages, Kindle Edition
First published May 18, 2014
1 person is currently reading
13 people want to read
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
June 3, 2020
There are some grammatical errors and vague instructions in the "Time for Action" examples, but overall a pretty good book if you starting out and trying to learn Microsoft SQL Server for Business Intelligence.
Displaying 1 of 1 review