Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition



Bookstore > Books > Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition

Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
Price$47.99 - $65.10
Rating
AuthorsMarco Russo, Alberto Ferrari
PublisherMicrosoft Press
Published2017
Pages512
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101509302778
ISBN-139781509302772
EBook Hardcover Paperback

Create a semantic model and analyze 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 organization'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; Optimize 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 virtualization configurations; Deploy and manipulate tabular models from C# and PowerShell using AMO and TOM libraries.


  1. (4 books)
  2. (3 books)



4 5 6

Similar Books


Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

by Ross Mistry, Stacia Misner

Introducing Microsoft SQL Server 2012 explores the exciting enhancements and new capabilities engineered into SQL Server, ranging from improvements in operation to those in reporting and management. This book is for anyone who has an interest in SQL Server 2012 and wants to understand its capabilities, including database administrators, a...

Price:  $17.99  |  Publisher:  Microsoft Press  |  Release:  2012

Business Intelligence with SQL Server Reporting Services

Business Intelligence with SQL Server Reporting Services

by Adam Aspin

Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the power of the Reporting Services toolkit to combine charts, gauges, sparklines, indicators, and maps into compelling dashboards and scorecards. Create compelling visualizations that seize your audience's attention and ...

Price:  $49.99  |  Publisher:  Apress  |  Release:  2015

Microsoft SQL Server 2012 Analysis Services

Microsoft SQL Server 2012 Analysis Services

by Marco Russo, Alberto Ferrari, Chris Webb

Analyze tabular data using the BI Semantic Model (BISM) in Microsoft SQL Server 2012 Analysis Services - and discover a simpler method for creating corporate-level BI solutions. Led by three BI experts, you'll learn how to build, deploy, and query a BISM tabular model with step-by-step guides, examples, and best practices. This hands-on b...

Price:  $9.75  |  Publisher:  Microsoft Press  |  Release:  2012

Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

by Jayaram Krishnaswamy

In the present day information-centric world we live in, the success of an enterprise depends enormously on how its information is generated, handled, and disseminated. With ample screenshots and over 65 hands-on exercises, this book will guide you effortlessly through creating cutting edge reports using SQL Server Reporting Services 2012...

Price:  $32.99  |  Publisher:  Packt Publishing  |  Release:  2013

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

by Paul Turley, Riccardo Muti, Christopher Finlan

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports provides a comprehensive lesson in business intelligence (BI), operational reporting and Reporting Services architecture using a clear, concise tutorial approach. You'll learn effective report solution design based upon many years of experience with successful re...

Price:  $36.22  |  Publisher:  Wrox  |  Release:  2017

Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking

by Dmitri Korotkevitch

Master SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.SQ...

Price:  $24.47  |  Publisher:  Apress  |  Release:  2018

SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

by Basit A. Masood-Al-Farooq

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve ...

Price:  $26.99  |  Publisher:  Packt Publishing  |  Release:  2014

Microsoft SQL Server 2012 T-SQL Fundamentals

Microsoft SQL Server 2012 T-SQL Fundamentals

by Itzik Ben-Gan

Gain a solid understanding of T-SQL and write better queries.Master the fundamentals of Transact-SQL - and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you'll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each cha...

Price:  $19.06  |  Publisher:  Microsoft Press  |  Release:  2012