Microsoft Tabular Modeling Cookbook: No prior knowledgeof tabular modeling is needed to benefit from this brilliant cookbook. This is the total guide to developing and managing analytical models using the Business Intelligence Semantic Models technology.

te Braak

$19.99 per month

4.7 (7 Ratings)

Paperback Dec 2013 320 pages 1st Edition

te Braak

$19.99 per month

4.7 (7 Ratings)

Paperback Dec 2013 320 pages 1st Edition

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!

Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!

50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

Thousands of reference materials covering every tech concept you need to stay up to date.

Subscribe now

View plans & pricing

View table of contents

Preview Book

Key benefits

Develop tabular models for personal use
Learn about the modeling techniques which are required to overcome commonly encountered problems and master advanced modeling scenarios
Understand the techniques required to promote personal models to corporate enterprise environments and manage the models in a corporate environment
Learn tips and tricks for querying tabular models and learn how to access the data within them for dynamic reporting including the development of interactive workbooks

Description

Business Intelligence Semantic Models (BISM) is a technology that is designed to deliver analytical information to users through a variety of mechanisms that include model structure, definition, and design. This book demonstrates how to create BISM models so that information can be presented to users in an intuitive and easy-to-use format. Once the model is defined, we also show you how it can be managed and maintained so that the data in it remains current and secure. Microsoft Tabular Modeling Cookbook is an all-encompassing guide to developing, managing, creating, and using analytical models using the Business Intelligence Semantic Model (BISM). This title covers a range of modeling situations and common data analysis related problems to show you the techniques required to turn data into information using tabular modeling. Microsoft Tabular Modeling Cookbook examines three areas of tabular modeling: model development, model management and maintenance, and reporting. This book is a practical guide on how to develop semantic models and turn business data into information. It covers all phases of the model lifecycle from creation to administration and finally reporting. It also shows you how to create models which are designed to analyze data. All sections of BISM modeling from development to management and finally reporting are covered. The sections on development examine a wide range of techniques and tricks required to build models, including moving data into the model, structuring the model to manipulate the data, and finally the formulas required to answer common business questions; all of these are discussed in this book in detail. Finally, the book examines methods of reporting on the data within the model, including the creation of data-driven workbooks and reports for a powerful end user experience.

Who is this book for?

This book is designed for developers who wish to develop powerful and dynamic models for users as well as those who are responsible for the administration of models in corporate environments. It is also targeted at analysts and users of Excel who wish to advance their knowledge of Excel through the development of tabular models or who wish to analyze data through tabular modeling techniques. We assume no prior knowledge of tabular modeling.

What you will learn

Create tabular models which present custom information to users
Create simple and complex DAX formulas and measures that address business questions and concerns
Learn the basics of tabular modeling and how to structure the model and control what information is presented to the user
Understand the methods of importing data into the model and the techniques to manage the data access components of the model
Learn about the DAX calculations and modeling concepts required to present custom-specific user requirements to model users
Explore the techniques required to promote and manage tabular models in corporate environments
Learn methods to report and query on the data within the model
Understand the techniques required to extend the native reporting capabilities in Excel through the use of Visual Basic for Application (VBA) within workbooks in order to provide a rich and customizable reporting framework for users

What do you get with a Packt Subscription?

Free for first 7 days. $19.99 p/m after that. Cancel any time!

Unlimited ad-free access to the largest independent learning library in tech. Access this title and thousands more!

50+ new titles added per month, including many first-to-market concepts and exclusive early access to books as they are being written.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

Thousands of reference materials covering every tech concept you need to stay up to date.

Subscribe now

View plans & pricing

Frequently bought together

$60.99

SQL Server Analysis Services 2012 Cube Development Cookbook

$65.99

$65.99

Total $ 192.97

Filter reviews by

All

Amazon verified reviews

Mark Polino May 25, 2014

I was really impressed with the Microsoft Tabular Modeling Cookbook. The book nailed Power Pivot and does a good job of covering Power Pivot with SSAS Tabular too.

Amazon Verified review

Dan English Feb 22, 2014

The book is written by Paul te Braak, who is a lead business intelligence consultant in Australia and is one of the developers on the DAX Studio project, and he has put together an outstanding cookbook. When the book was released I was surprised and excited. I was surprised because I did not know that Paul was working on this (he is the sole author, big kudos to Paul), and excited because I knew it was going to be a good one. I had this one on my radar list of books to add to my collection; I am definitely a big fan of the Packt Publishing Cookbook series style of books. Microsoft Tabular Modeling CookbookWhat I like about the books is that they introduce a topic or situation and then go over the solution in a very simple and easy to understand format – Getting Ready, How to do it, How it Works, There’s more. Paul adds a lot of great insights in this book in explaining how the solutions work as well as including a bunch of ‘Tips’ along the way as well.Paul does a great job on slowly working you into the Tabular modeling concepts and the only tool you need to get going is Excel and the Power Pivot add-in. Paul’s examples use Excel workbooks and flat files for the most part, so that makes it really easy to get started and get your learn on.What is amazing is that this book is just over 300 pages and it is loaded with great content that covers items such as how to use Power Pivot, hierarchies, drilldown, parent-child hierarchies (including how to hidememberif in DAX), smart measures, smart keys, programmatic access in Excel – cube functions and VBA, querying with DAX, Power View, and more! Simply amazing, Paul does a fabulous job and this is a great intro book that progresses into advanced topics and has great examples, tips, and insights that are a big time value add.I would definitely rate this as a must have for anyone doing tabular SSAS development and give it 5 out of 5 stars – image.Awesome job Paul and thanks for writing the book and sharing!

Chuck Barrow Apr 09, 2014

Self-service business intelligence depends on managers and directors learning the skills necessary to make their own reports rather than requesting reports and dashboards from pricy programmers and consultants. This cookbook provides outstanding instruction, examples, and screenshots that can be referenced by both beginner and more advanced report makers. I am getting to the point where I can create my own advanced PowerPivots, and this book definitely taught me quite a bit. But more importantly, I am training others to create their own reports (rather than asking me every time), and the Microsoft Tabular Modeling Cookbook serves as a nice guide and reference text for those who are intimidated by the subject matter, but who also need to learn this new, essential skill. This is a must-have reference book for any organization that wants to enable Microsoft's self-service Business Intelligence.

JesseKraut Apr 09, 2014

I was very impressed with this book it goes into a lot of details but gives a great high level overview of the tabular model as well. I found that the examples were really good in Excel and easy to follow. The advanced topics were really good going through the DAX language and how to query the tabular model. I like how they incorporated the Power View Visualizations to show the power of the data using the tabular models. They did a great job showing the difference from individual models in PowerPivot and Server Side models in SSAS. Lastly this book does a wonderful job at showing the maintenance of the tabular models where the administration comes into play like deploying models and security.

Alex Heaton Feb 06, 2016

Awesome book. I learned so much and used it as a guide to do a big powerpivot project. I used Excel 2016 and I was still able to use this book.I borrowed this book from the library of my work. I still have a lot to learn from it and I don't want to give it back so I'm going to buy my own copy.

Microsoft Tabular Modeling Cookbook: No prior knowledgeof tabular modeling is needed to benefit from this brilliant cookbook. This is the total guide to developing and managing analytical models using the Business Intelligence Semantic Models technology.

What do you get with a Packt Subscription?