0
Your cart

Your cart is empty

Books > Computing & IT > Computer software packages > Database software

Buy Now

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook (Paperback) Loot Price: R1,569
Discovery Miles 15 690
Tabular Modeling with SQL Server 2016 Analysis Services Cookbook (Paperback): Derek Wilson

Tabular Modeling with SQL Server 2016 Analysis Services Cookbook (Paperback)

Derek Wilson

 (sign in to rate)
Loot Price R1,569 Discovery Miles 15 690 | Repayment Terms: R147 pm x 12*

Bookmark and Share

Expected to ship within 10 - 15 working days

Expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions About This Book * Build and deploy Tabular Model projects from relational data sources * Leverage DAX and create high-performing calculated fields and measures * Create ad-hoc reports based on a Tabular Model solution * Useful tips to monitor and optimize your tabular solutions Who This Book Is For This book is for SQL BI professionals and Architects who want to exploit the full power of the new Tabular models in Analysis Services. Some knowledge of previous versions of Analysis services would be helpful but is not essential. What You Will Learn * Learn all about Tabular services mode and how it speeds up development * Build solutions using sample datasets * Explore built-in actions and transitions in SSAS 2016 * Implement row-column, and role-based security in a Tabular Data model * Realize the benefits of in-memory and DirectQuery deployment modes * Get up to date with the new features added to SQL Server 2016 Analysis Services * Optimize Data Models and Relationships Usage In Detail SQL Server Analysis Service (SSAS) has been widely used across multiple businesses to build smart online analytical reporting solutions. It includes two different types of modeling for analysis services: Tabular and Multi Dimensional. This book covers Tabular modeling, which uses tables and relationships with a fast in-memory engine to provide state of the art compression algorithms and query performance. The book begins by quickly taking you through the concepts required to model tabular data and set up the necessary tools and services. As you learn to create tabular models using tools such as Excel and Power View, you'll be shown various strategies to deploy your model on the server and choose a query mode (In-memory or DirectQuery) that best suits your reporting needs. You'll also learn how to implement key and newly introduced DAX functions to create calculated columns and measures for your model data. Last but not least, you'll be shown techniques that will help you administer and secure your BI implementation along with some widely used tips and tricks to optimize your reporting solution. By the end of this book, you'll have gained hands-on experience with the powerful new features that have been added to Tabular models in SSAS 2016 and you'll be able to improve user satisfaction with faster reports and analytical queries. Style and approach This book takes a practical, recipe-based approach where each recipe lists the steps to address or implement a solution. You will be provided with several approaches to creating a business intelligence semantic model using analysis services.

General

Imprint: Packt Publishing Limited
Country of origin: United Kingdom
Release date: 2017
Authors: Derek Wilson
Dimensions: 235 x 191 x 22mm (L x W x T)
Format: Paperback
Pages: 372
ISBN-13: 978-1-78646-861-1
Categories: Books > Computing & IT > Computer software packages > Database software > General
Promotions
LSN: 1-78646-861-1
Barcode: 9781786468611

Is the information for this product incomplete, wrong or inappropriate? Let us know about it.

Does this product have an incorrect or missing image? Send us a new image.

Is this product missing categories? Add more categories.

Review This Product

No reviews yet - be the first to create one!

You might also like..

Oracle 12c - SQL
Joan Casteel Paperback  (1)
R1,321 R1,183 Discovery Miles 11 830
A Guide To SQL
Philip Pratt, Hassan Afyouni, … Paperback R1,253 R1,119 Discovery Miles 11 190
Database Systems: The Complete Book…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R2,653 Discovery Miles 26 530
Intermediate Access
M. L. Humphrey Hardcover R521 Discovery Miles 5 210
SQL Programming: Java Script and Coding…
Os Swift Hardcover R853 Discovery Miles 8 530
Enterprise Big Data Engineering…
Martin Atzmueller, Samia Oussena, … Hardcover R5,649 Discovery Miles 56 490
Access 2019 Beginner
M. L. Humphrey Hardcover R622 Discovery Miles 6 220
Amazon DynamoDB Encryption Client…
Documentation Team Hardcover R943 Discovery Miles 9 430
Promethean Oracle
Sophia Shultz, Mark Cogan Miscellaneous printed matter R1,014 R788 Discovery Miles 7 880
Joe Celko's Data, Measurements and…
Joe Celko Paperback R1,109 Discovery Miles 11 090
SQL: 1999 - Understanding Relational…
Jim Melton, Alan R. Simon Paperback R2,060 R1,510 Discovery Miles 15 100
Advanced Relational Programming
Filippo Cacace, Gianfranco Lamperti Hardcover R3,374 Discovery Miles 33 740

See more

Partners