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
Buy
Preview
Amazon$47.99
BiggerBooks$57.02
eBay$57.18
eBooks.com$47.99
eCampus$58.19
update prices
Price$47.99 - $58.19
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 4

Similar Books


Introducing Microsoft SQL Server 2012

Introducing Microsoft SQL Server 2012

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...
Business Intelligence with SQL Server Reporting Services

Business Intelligence with SQL Server Reporting Services

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 ...
Microsoft SQL Server 2012 Analysis Services

Microsoft SQL Server 2012 Analysis Services

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...
Learning SQL Server Reporting Services 2012

Learning SQL Server Reporting Services 2012

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...
Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

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...
SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

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 ...