Microsoft SQL Server 2014 Business Intelligence Development Beginners Guide

Reza Rad

  • 出版商: Packt Publishing
  • 出版日期: 2014-05-26
  • 售價: $2,130
  • 貴賓價: 9.5$2,024
  • 語言: 英文
  • 頁數: 390
  • 裝訂: Paperback
  • ISBN: 1849688885
  • ISBN-13: 9781849688888
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

商品描述

Get to grips with Microsoft Business Intelligence and Data Warehousing technologies using this practical guide with this book and ebook

Overview

  • 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

Approach

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.

Who this book is written for

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.

商品描述(中文翻譯)

這本書和電子書將幫助您深入了解使用Microsoft商業智能和數據倉儲技術的實用指南。

概述:
- 在設計數據倉儲時,了解維度建模概念
- 學習基於SSIS、MDS和DQS等技術的數據移動
- 使用Microsoft BI技術設計儀表板和報表

詳細內容:
利用SQL Server 2014、Excel 2013和SharePoint 2013的BI組件的真正威力,通過這本實踐指南來獲得競爭優勢。本書將幫助您快速學習如何使用Microsoft BI工具設計和構建BI系統,從而為您提供競爭優勢。

本書首先介紹了使用維度建模設計數據倉儲,然後介紹了基於SSAS多維和Tabular技術創建數據模型。它將演示如何使用SSIS進行ETL,以及使用MDS和DQS進行數據治理和數據質量。本書充滿了真實世界的例子,讓您對SQL Server 2014、Excel 2013和SharePoint 2013的BI和DW組件有很好的理解。

本書的學習重點包括:
- 使用SSAS多維和MDX進行數據建模
- 使用DAX和SSAS Tabular進行數據建模
- 使用MDS管理主數據
- 使用DQS揭示基於知識的數據質量
- 了解預測和數據挖掘
- 識別數據模式和預測模型
- 使用PerformancePoint和Power View設計儀表板
- 探索Power BI的Power Query和Power Map組件
- 使用SQL Server Reporting Services創建報表並將其集成到應用程序中

這本書以易於理解的實例驅動格式撰寫,提供了大量的逐步指導,幫助您入門!本書以友好的方式撰寫,讓您有機會通過實驗學習。

本書適合以下讀者:
- 對Microsoft商業智能新手和數據倉儲開發人員,並希望對Microsoft SQL Server的不同組件有很好的理解
- 假設您對數據庫系統和T-SQL有一些經驗。本書將為您提供每個組件的概述和在數據倉儲和商業智能系統中使用該組件的場景。