Store besparelser
Hurtig levering
Gemte
Log ind
0
Kurv
Kurv

Tabular Modeling in Microsoft SQL Server Analysis Services

Af: Marco Russo, Alberto Ferrari Engelsk Paperback

Tabular Modeling in Microsoft SQL Server Analysis Services

Af: Marco Russo, Alberto Ferrari Engelsk Paperback
Tjek vores konkurrenters priser
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
Tjek vores konkurrenters priser
Normalpris
kr 473
Fragt: 39 kr
6 - 8 hverdage
20 kr
Pakkegebyr
God 4 anmeldelser på
Tjek vores konkurrenters priser
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
Produktdetaljer
Sprog: Engelsk
Sider: 512
ISBN-13: 9781509302772
Indbinding: Paperback
Udgave: 2
ISBN-10: 1509302778
Kategori: Databasesoftware
Udg. Dato: 1 maj 2017
Længde: 28mm
Bredde: 229mm
Højde: 188mm
Forlag: Microsoft Press,U.S.
Oplagsdato: 1 maj 2017
Forfatter(e): Marco Russo, Alberto Ferrari
Forfatter(e) Marco Russo, Alberto Ferrari


Kategori Databasesoftware


ISBN-13 9781509302772


Sprog Engelsk


Indbinding Paperback


Sider 512


Udgave 2


Længde 28mm


Bredde 229mm


Højde 188mm


Udg. Dato 1 maj 2017


Oplagsdato 1 maj 2017


Forlag Microsoft Press,U.S.

Kategori sammenhænge