Instant Microsoft SQL ServerAnalysis Services 2012 Dimensions and Cube

Anurag Acharya

  • 出版商: Packt Publishing
  • 出版日期: 2013-07-28
  • 售價: $1,030
  • 貴賓價: 9.5$979
  • 語言: 英文
  • 頁數: 72
  • 裝訂: Paperback
  • ISBN: 1849688729
  • ISBN-13: 9781849688727
  • 相關分類: MSSQLSQL
  • 下單後立即進貨 (約3~4週)

商品描述

Learn how to build dimensions and cubes in a SQL Server 2012 development environment

Overview

  • Learn something new in an Instant! A short, fast, focused guide delivering immediate results.
  • Create your own SQL Server development environment.
  • Full of practical tutorials on cube design and development.
  • Learn how to efficiently administrate and manage your SQL Server instance.

In Detail

Microsoft SQL Server Analytical Services, or SSAS, is an analytical processing OLAP tool which allows users to analyze business data quickly and easily.

In this book you will get started with SQL Server cube development. You will start by learning how to install SQL Server 2012 and create a development environment. You will then finish by diving into the development and design of dimension and cubes in SQL Server.

This book starts by jumping into the new and important features of Microsoft SQL Server 2012. Afterwards we will run through the installation of SQL Server then how to check the validation of SQL Server and security consideration during and after installation.

After you have SQL Server running, you will get started with SQL Server cube development, first by creating a development environment, then by developing and designing dimensions and cubes in SQL Server.

Moving on to administration and user management of SQL Server 2012 you will then build your own SQL Server development environment and create your own dimensions and cubes. You will then finish with a journey through further tutorials and guidance on continuing and progressing with SSAS cube development.

What you will learn from this book

  • What’s new In SQL Server 2012 .
  • Evaluation of SQL Server development environment requirements.
  • How to design the SQL Server installation.
  • Components of the development environment.
  • Installation of essential services with SQL Server 2012.
  • Administration of user management and server roles.
  • Build and create dimensions and cubes in a development environment.

Approach

Get to grips with a new technology, understand what it is and what it can do for you, and then get to work with the most important features and tasks. Written in a practical, friendly manner this book will take you through the journey from installing SQL Server to developing your first cubes.

Who this book is written for

"Microsoft SQL Server Analysis Service 2012 Dimensions" and Cube Starter is targeted at anyone who wants to get started with cube development in Microsoft SQL Server Analysis Services. Regardless of whether you are a SQL Server developer who knows nothing about cube development or SSAS or even OLAP, you will be able to pick up this title and quickly start developing cubes.

商品描述(中文翻譯)

學習如何在 SQL Server 2012 開發環境中建立維度和立方體

概述
- 在短時間內學習新知識!一本短小、快速、專注的指南,能夠立即產生效果。
- 建立自己的 SQL Server 開發環境。
- 提供有關立方體設計和開發的實用教程。
- 學習如何高效地管理和管理 SQL Server 實例。

詳細內容
- Microsoft SQL Server Analytical Services(SSAS)是一個分析處理 OLAP 工具,允許用戶快速輕鬆地分析業務數據。
- 在本書中,您將開始進行 SQL Server 立方體開發。您將首先學習如何安裝 SQL Server 2012 並創建開發環境。然後,您將深入研究 SQL Server 中維度和立方體的開發和設計。

本書首先介紹了 Microsoft SQL Server 2012 的新功能。然後,我們將運行 SQL Server 的安裝,然後檢查 SQL Server 的驗證以及安裝期間和安裝後的安全性考慮。

在您運行 SQL Server 之後,您將開始進行 SQL Server 立方體開發,首先創建開發環境,然後在 SQL Server 中開發和設計維度和立方體。

接下來,您將進行 SQL Server 2012 的管理和用戶管理,然後建立自己的 SQL Server 開發環境並創建自己的維度和立方體。最後,您將通過進一步的教程和指導,繼續進行和發展 SSAS 立方體開發的旅程。

本書將學到什麼
- SQL Server 2012 的新功能。
- 評估 SQL Server 開發環境需求。
- 如何設計 SQL Server 安裝。
- 開發環境的組件。
- 使用 SQL Server 2012 安裝必要服務。
- 用戶管理和伺服器角色的管理。
- 在開發環境中建立維度和立方體。

方法
- 熟悉一項新技術,了解它是什麼以及它對您有什麼作用,然後開始使用最重要的功能和任務。本書以實用友好的方式撰寫,將帶您從安裝 SQL Server 到開發您的第一個立方體的旅程。

本書適合對於在 Microsoft SQL Server Analysis Services 中進行立方體開發的任何人。無論您是一位對立方體開發或 SSAS 甚至 OLAP 一無所知的 SQL Server 開發人員,您都能夠閱讀本書並快速開始開發立方體。