Tabular modeling with SQL Server 2016 analysis services cookbook : expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions

Book Cover
Average Rating
Published
Birmingham, UK : Packt Publishing, 2017.
Status
Available Online

Description

Loading Description...

More Details

Format
Language
English
ISBN
9781786461506, 1786461501

Notes

Description
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 pract...
Local note
O'Reilly,O'Reilly Online Learning: Academic/Public Library Edition

Also in this Series

Checking series information...

More Like This

Loading more titles like this title...

Reviews from GoodReads

Loading GoodReads Reviews.

Citations

APA Citation, 7th Edition (style guide)

Wilson, D. (2017). Tabular modeling with SQL Server 2016 analysis services cookbook: expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions . Packt Publishing.

Chicago / Turabian - Author Date Citation, 17th Edition (style guide)

Wilson, Derek. 2017. Tabular Modeling With SQL Server 2016 Analysis Services Cookbook: Expert Tabular Modeling Techniques for Building and Deploying Cutting-edge Business Analytical Reporting Solutions. Birmingham, UK: Packt Publishing.

Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)

Wilson, Derek. Tabular Modeling With SQL Server 2016 Analysis Services Cookbook: Expert Tabular Modeling Techniques for Building and Deploying Cutting-edge Business Analytical Reporting Solutions Birmingham, UK: Packt Publishing, 2017.

Harvard Citation (style guide)

Wilson, D. (2017). Tabular modeling with SQL server 2016 analysis services cookbook: expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions. Birmingham, UK: Packt Publishing.

MLA Citation, 9th Edition (style guide)

Wilson, Derek. Tabular Modeling With SQL Server 2016 Analysis Services Cookbook: Expert Tabular Modeling Techniques for Building and Deploying Cutting-edge Business Analytical Reporting Solutions Packt Publishing, 2017.

Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.

Staff View

Grouped Work ID
c39f9f42-474b-4fcc-4aa9-351ecb5c9828-eng
Go To Grouped Work View in Staff Client

Grouping Information

Grouped Work IDc39f9f42-474b-4fcc-4aa9-351ecb5c9828-eng
Full titletabular modeling with sql server 2016 analysis services cookbook expert tabular modeling techniques for building and deploying cutting edge business analytical reporting solutions
Authorwilson derek
Grouping Categorybook
Last Update2024-10-08 10:55:34AM
Last Indexed2024-12-03 03:29:09AM

Book Cover Information

Image SourcecontentCafe
First LoadedAug 14, 2023
Last UsedNov 13, 2024

Marc Record

First DetectedMar 14, 2023 08:05:59 AM
Last File Modification TimeMar 14, 2023 08:05:59 AM
SuppressedRecord had no items

MARC Record

LEADER04215cam a2200409Ii 4500
001ocn973022390
003OCoLC
00520230314080419.0
006m     o  d        
007cr unu||||||||
008170217s2017    enka    o     000 0 eng d
020 |a 9781786461506
020 |a 1786461501
035 |a (OCoLC)973022390
037 |a CL0500000831|b Safari Books Online
040 |a UMI|b eng|e rda|e pn|c UMI|d OCLCF|d IDEBK|d STF|d OCLCQ|d CEF|d KSU|d DEBBG|d UAB|d QGK|d OCLCO|d OCLCQ
049 |a MAIN
050 4|a QA76.9.C55
1001 |a Wilson, Derek,|e author.
24510|a Tabular modeling with SQL Server 2016 analysis services cookbook :|b expert tabular modeling techniques for building and deploying cutting-edge business analytical reporting solutions /|c Derek Wilson.
264 1|a Birmingham, UK :|b Packt Publishing,|c 2017.
300 |a 1 online resource (1 volume) :|b illustrations
336 |a text|b txt|2 rdacontent
337 |a computer|b c|2 rdamedia
338 |a online resource|b cr|2 rdacarrier
520 |a 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 pract...
588 |a Description based on online resource; title from cover (Safari, viewed February 15, 2017).
590 |a O'Reilly|b O'Reilly Online Learning: Academic/Public Library Edition
63000|a SQL server.|9 16504
63007|a SQL server.|2 fast|0 (OCoLC)fst01376937|9 16504
650 0|a Client/server computing.|9 67679
650 0|a Business intelligence.|9 31574
650 0|a Relational databases.|9 62468
85640|u https://library.access.arlingtonva.us/login?url=https://learning.oreilly.com/library/view/~/9781786468611/?ar|x O'Reilly|z eBook
938 |a ProQuest MyiLibrary Digital eBook Collection|b IDEB|n cis36229878
994 |a 92|b VIA
999 |c 281628|d 281628