Tabular Modeling in Microsoft SQL Server Analysis Services, 2nd Edition
| Price | $45.42 - $51.78
|
| Rating |  |
| Authors | Marco Russo, Alberto Ferrari |
| Publisher | Microsoft Press |
| Published | 2017 |
| Pages | 512 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1509302778 |
| ISBN-13 | 9781509302772 |
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.
Adventure Works Database:
→ https://itbook.store/files/9781509302772/database.zip
Contoso Database:
→ http://ptgmedia.pearsoncmg.com/imprint_downloads/microsoftpress/bookreg/9781509302772/SSAS_Tabular_Database_Contoso.zip
Source Code:
→ https://itbook.store/files/9781509302772/sourcecode.zip
- Marco Russo (6 books)
- Alberto Ferrari (5 books)
5 5 22
Similar Books
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...
Price: $9.75 | Publisher: Microsoft Press | Release: 2012
by Edward Pollack
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to impro...
Price: $30.40 | Publisher: Apress | Release: 2019
Microsoft SQL Server 2012 Integration Services
by Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding, Kaarthik Sivashanmugam
Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle compl...
Price: $8.80 | Publisher: Microsoft Press | Release: 2012
Professional Microsoft SQL Server 2012 Integration Services 
by Brian Knight, Erik Veerman, Jessica M. Moss, Mike Davis, Chris Rock
Microsoft SQL Server 2012 Integration Services (SISS) builds on the revolutionary database product suite first introduced in 2005. With this crucial resource, you will explore how this newest release serves as a powerful tool for performing extraction, transformation, and load operations (ETL). A team of SQL Server experts deciphers this ...
Price: $32.99 | Publisher: Wrox | Release: 2012
by Philip Seamark, Thomas Martens
Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft's leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Serve...
Price: $30.08 | Publisher: Apress | Release: 2019
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes, 2nd Edition
by Ben Forta
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.This handy pocket guide starts with ...
Price: $17.59 | Publisher: SAMS Publishing | Release: 2017
Professional Microsoft SQL Server 2012 Reporting Services
by Paul Turley, Robert M. Bruckner, Thiago Silva, Ken Withee, Grant Paisley
SQL Server Reporting Services allows you to create reports and business intelligence (BI) solutions. With this updated resource, a team of experts shows you how Reporting Services makes reporting faster, easier and more powerful than ever in web, desktop, and portal solutions. New coverage discusses the new reporting tool called Crescent,...
Price: $7.49 | Publisher: Wrox | Release: 2012
Microsoft SQL Server 2008 Management and Administration
by Ross Mistry, Hilary Cotter
If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you've been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft's f...
Price: $9.87 | Publisher: SAMS Publishing | Release: 2008