Tomislav Piasevoli's Books

MDX with SSAS 2012 Cookbook

By: Tomislav Piasevoli Sherry Li

Write a review Read reviews Take a Quiz Solve Book Puzzle

This book is written in a recipe-based style packed full of practical tips and techniques to help you analyse multidimensional data stored in SSAS 2012 cubes. If you need to master MDX queries in SSAS, then this book is for you!If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you. This book is also an essential resource for report developers who need to access the multidimensional cubes through the MDX language. The book assumes you have some basic working knowledge of MDX and a basic understanding of dimensional modelling and cube design.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

650

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

184968961X

ISBN 13

9781849689618

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

By: Tomislav Piasevoli,Sherry Li

Write a review Read reviews Take a Quiz Solve Book Puzzle

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

By: Tomislav Piasevoli,Sherry Li

Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes About This Book Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples Who This Book Is For This book is for anyone who has been involved in working with multidimensional data. If you are a multidimensional cube developer, a multidimensional database administrator, or a report developer who writes MDX queries to access multidimensional cube, this book will help you. If you are a power cube user or an experienced business analyst, you will also find this book invaluable in your data analysis. This book is for you are interested in doing more data analysis so that the management can make timely and accurate business decisions. What You Will Learn Grasp the fundamental MDX concepts, features, and techniques Work with sets Work with Time dimension and create time-aware calculations Make analytical reports compact, concise, and efficient Navigate cubes Master MDX for reporting with Reporting Services (new) Perform business analytics Design efficient cubes and efficient MDX queries Create metadata-driven calculations (new) Capture MDX queries and many other techniques In Detail If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations. Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques. In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster. Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is – MDX recipes for your success. Style and approach This book is written in a cookbook format, where you can browse through and look for solutions to a particular problem in one place. Each recipe is short, to the point and grouped by relevancy. All the recipes are sequenced in a logical progression; you will be able to build up your understanding of the topic incrementally.

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

582

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1786467887

ISBN 13

9781786467881

MDX with SSAS 2012 Cookbook

By: Tomislav Piasevoli Sherry Li

Write a review Read reviews Take a Quiz Solve Book Puzzle

MDX with SSAS 2012 Cookbook

By: Tomislav Piasevoli Sherry Li

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

650

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

184968961X

ISBN 13

9781849689618

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

By: Tomislav Piasevoli,Sherry Li

Write a review Read reviews Take a Quiz Solve Book Puzzle

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

By: Tomislav Piasevoli,Sherry Li

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

582

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1786467887

ISBN 13

9781786467881

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

By: Tomislav Piasevoli

Write a review Read reviews Take a Quiz Solve Book Puzzle

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

By: Tomislav Piasevoli

80 recipes for enriching your Business Intelligence solutions with high-performance MDX calculations and flexible MDX queries Enrich your BI solutions by implementing best practice MDX calculations Master a wide range of time-related, context-aware, and business-related calculations Enhance your solutions by combining MDX with utility dimensions Become skilled in making reports concise Learn how to optimize, dissect, and debug your MDX calculations Maximize your learning with detailed explanations following each solution Packed with practical, hands-on cookbook recipes, illustrating the techniques to enrich your Business Intelligence solutions In Detail Microsoft SQL Server is an enterprise database platform that contains a multitude of technologies, Analysis Services being one of them. SQL Server Analysis Services (SSAS) provides OLAP and data mining capabilities and allows users to analyze multidimensional data stored in cubes using the MDX query language. This cookbook contains over 80 practical, task-based recipes that show how Microsoft SQL Server 2008 R2 Analysis Services solutions can be taken further by enriching them with high-performance MDX calculations and flexible MDX queries. Packed with immediately usable, real-world recipes, the book starts with elementary techniques that lay the foundation for designing further MDX calculations and queries. Here you will find topics such as iterations on a set, Boolean logic, and dissecting and optimizing MDX calculations. In the first half of the book you will learn how to efficiently work with time, strings, metadata, calculated members and sets in general, and how to implement MDX solutions that are appropriate in a particular context: a time-aware calculation, a concise report, a calculation relative to another. You will also learn how to implement various types of conditional formatting, how to perform typical MDX calculations like ranks, percentages and average

Average ratings

N/A

Write a review

Solve jigsaw puzzle

Age

Page Count

480

Publisher

Packt Publishing Ltd

Published Date

ISBN 10

1849681309

ISBN 13

9781849681308

Book's by Tomislav Piasevoli

MDX with SSAS 2012 Cookbook

MDX with SSAS 2012 Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with SSAS 2012 Cookbook

MDX with SSAS 2012 Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook

Username

Password

Username

Password

Password again

Birthday

Email