Tabular Modeling in Microsoft SQL Server Analysis Services - Marco Russo - Paperback Bog - Microsoft Press,U.S. - 2017 - Engelsk - Booktok.dk

Description

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 -