Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Год: 2014
Автор: Reza Rad
Издательство: Packt
ISBN: 978-1-84968-888-8
Язык: Английский
Качество: Изначально компьютерное (eBook)
Интерактивное оглавление: Да
Количество страниц: 350
Описание: Get to grips with Microsoft Business Intelligence and Data Warehousing technologies using this practical guide with this book and ebook
Discover the Dimensional Modeling concept while designing a data warehouse
Learn Data Movement based on technologies such as SSIS, MDS, and DQS
Design dashboards and reports with Microsoft BI technologies
In Detail
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.
What you will learn from this book
- Perform Data Modeling with SSAS Multidimensional and MDX
- Use DAX and SSAS tabular for Data Modeling
- Manage Master Data with MDS
- Reveal Knowledge Driven Data Quality with DQS
- Understand prediction and Data Mining
- Identify data patterns and predictive models
- Design Dashboards with PerformancePoint and Power View
- Explore Power Query and Power Map as components of Power BI
- Create Reports with SQL Server Reporting Services and integrate them in applications
Примеры страниц Оглавление
Preface 1
Chapter 1: Data Warehouse Design 7
Chapter 2: SQL Server Analysis Services Multidimensional Cube Development 27
Chapter 3: Tabular Model Development of SQL Server Analysis Services 63
Chapter 4: ETL with Integration Services 83
Chapter 5: Master Data Management 119
Chapter 6: Data Quality and Data Cleansing 143
Chapter 7: Data Mining – Descriptive Models in SSAS 171
Chapter 8: Identifying Data Patterns – Predictive Models in SSAS 193
Chapter 9: Reporting Services 219
Chapter 10: Dashboard Design 247
Chapter 11: Power BI 275
Chapter 12: Integrating Reports in Applications 295
Index 323
Опубликовано группой

If you like the topic, please click share to help develop our site.

To download the file disable ad blocking, and reload the page.

disable adblock How to disable ad blocking?

Download by magnet link 66 MB Download Torrent

Login using:

Similar topics

Hans-Jürgen Schönig - Mastering PostgreSQL 10 [2018, PDF, ENG]
 2 MB   0 | 0   16-Aug-18 15:10   12

Current time is: 26-May 05:08 :: All times are UTC + 3