Russo, Marco
Tabular Modeling in Microsoft SQL Server Analysis Services
- ISBN 13:
- 9781509302772
- author:
- Russo, Marco
- format:
- Paperback
- publisher:
- Microsoft Press
- language:
- English
- Publication Year:
- 2017
- Pages:
- 512
- Dimensions:
- 22.9 x 18.7 x 2.5 centimetres (0
- Genre:
- Computers, Server & Database, General Database,
- Condition:
- New
- Availability:
- Item usually sent within 2 working days
Description
Tabular Modeling in Microsoft SQL Server Analysis Services provides a comprehensive guide to creating corporate-level business intelligence solutions using the tabular model. Two experienced BI experts lead you through detailed examples and best practices, covering topics such as building, deploying, and querying a tabular model. You'll learn 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, and integrate data from multiple sources into a single view of company information. The book also covers implementing security, partitioning strategies, and optimising your data model to reduce memory footprint. By the end of this hands-on guide, you'll be able to deploy and manipulate tabular models using C# and PowerShell, choose between in-memory and pass-through engines, and select the proper hardware and virtualisation configurations for your organisation.