{"product_id":"tabular-modeling-in-microsoft-sql-server-analysis-services","title":"Tabular Modeling in Microsoft SQL Server Analysis Services","description":"\u003ch3\u003eCreate corporate-level business intelligence (BI) solutions\u003c\/h3\u003e \u003cp\u003eCreate a semantic model and analyse data using the tabular model in SQL Server 2016 Analysis Services. 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. \u003c\/p\u003e \u003cp\u003eDiscover how to:\u003c\/p\u003e \u003cul\u003e  \u003cli\u003eDetermine when a tabular or multidimensional model is right for your project \u003c\/li\u003e  \u003cli\u003eBuild a tabular model using SQL Server Data Tools in Microsoft Visual Studio 2015 \u003c\/li\u003e  \u003cli\u003eIntegrate data from multiple sources into a single, coherent view of company information \u003c\/li\u003e  \u003cli\u003eChoose a data-modeling technique that meets your organisation's performance and usability requirements \u003c\/li\u003e  \u003cli\u003eImplement security by establishing administrative and data user roles \u003c\/li\u003e  \u003cli\u003eDefine and implement partitioning strategies to reduce processing time \u003c\/li\u003e  \u003cli\u003eUse Tabular Model Scripting Language (TMSL) to execute and automate administrative tasks \u003c\/li\u003e  \u003cli\u003eOptimise your data model to reduce the memory footprint for VertiPaq \u003c\/li\u003e  \u003cli\u003eChoose between in-memory (VertiPaq) and pass-through (DirectQuery) engines for tabular models \u003c\/li\u003e  \u003cli\u003eSelect the proper hardware and virtualisation configurations \u003c\/li\u003e  \u003cli\u003eDeploy and manipulate tabular models from C# and PowerShell using AMO and TOM libraries\u003c\/li\u003e \u003c\/ul\u003e","brand":"Pearson Education","offers":[{"title":"Default Title","offer_id":45998719205614,"sku":"9781509302772","price":73.29,"currency_code":"AUD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0630\/9612\/7726\/files\/1509302778.jpg?v=1733539915","url":"https:\/\/bookland.com.au\/products\/tabular-modeling-in-microsoft-sql-server-analysis-services","provider":"Book Land AU","version":"1.0","type":"link"}