Tabular Modeling in Microsoft SQL Server Analysis Services

Marco Russo, Alberto Ferrari

$168.95 $143.41

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

Microsoft Press
24 April 2017

SQL Server & MS SQL

Series: Developer Reference

Create a semantic model and analyse data using the tabular model in SQL Server 2016 Analysis Services to create corporate-level business intelligence (BI) solutions. Led by two BI experts, you will learn how to build, deploy, and query a tabular model by following detailed examples and best practices. This hands-on book shows you how to use the tabular model’s in-memory database to perform rapid analytics—whether you are new to Analysis Services or already familiar with its multidimensional model.

Discover how to:

Determine when a tabular or multidimensional model is right for your project

Build a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2015

Integrate data from multiple sources into a single, coherent view of company information

Choose a data-modeling technique that meets your organisation’s performance and usability requirements

Implement security by establishing administrative and data user roles

Define and implement partitioning strategies to reduce processing time

Use Tabular Model Scripting Language (TMSL) to execute and automate administrative tasks

Optimise your data model to reduce the memory footprint for VertiPaq

Choose between in-memory (VertiPaq) and pass-through (DirectQuery) engines for tabular models

Select the proper hardware and virtualisation configurations

Deploy and manipulate tabular models from C# and PowerShell using AMO and TOM libraries

By: Marco Russo, Alberto Ferrari
Imprint: Microsoft Press
Country of Publication: United States
Edition: 2nd edition
Dimensions: Height: 228mm, Width: 188mm, Spine: 26mm
Weight: 840g
ISBN: 9781509302772
ISBN 10: 1509302778
Series: Developer Reference
Pages: 512
Publication Date: 24 April 2017
Audience: Professional and scholarly , Undergraduate
Format: Paperback
Publisher's Status: Active

CHAPTER 1 Introducing the tabular model CHAPTER 2 Getting started with the tabular model CHAPTER 3 Loading data inside Tabular CHAPTER 4 Introducing calculations in DAX CHAPTER 5 Building hierarchies CHAPTER 6 Data modeling in Tabular CHAPTER 7 Tabular Model Scripting Language (TMSL) CHAPTER 8 The tabular presentation layer CHAPTER 9 Using DirectQuery CHAPTER 10 Security CHAPTER 11 Processing and partitioning tabular models CHAPTER 12 Inside VertiPaq CHAPTER 13 Interfacing with Tabular CHAPTER 14 Monitoring and tuning a Tabular service CHAPTER 15 Optimizing tabular models CHAPTER 16 Choosing hardware and virtualization

Marco Russo and Alberto Ferrari are the founders of sqlbi.com, where they regularly publish articles about Microsoft Power Pivot, Power BI, DAX, and SQL Server Analysis Services. Russo and Ferrari have worked with Analysis Services since the first version in 1999. Both Russo and Ferrari provide consultancy and mentoring on business intelligence (BI). They are also frequent speakers at major international conferences, including Microsoft Ignite, PASS Summit, and SQLBits.

LOW FLAT RATE AUST-WIDE $9.90 DELIVERY INFO

Tabular Modeling in Microsoft SQL Server Analysis Services

Marco Russo, Alberto Ferrari

$168.95 $143.41

Paperback

See Also

Contact Abbeys

Contact Galaxy

Contact Language

Contact Us

About ABBEY'S