Explore Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Free Learning

You're reading from Mastering Microsoft Power BI Expert techniques for effective data analytics and business intelligence

Product type Paperback

Published in Mar 2018

Publisher Packt

ISBN-13 9781788297233

Length 638 pages

Edition 1st Edition

Languages

Tools

Power BI

Concepts

Business Intelligence

Author (1):

Brett Powell

View More author details

Table of Contents (15) Chapters

Preface

1. Planning Power BI Projects FREE CHAPTER

2. Connecting to Sources and Transforming Data with M

3. Designing Import and DirectQuery Data Models

4. Developing DAX Measures and Security Roles

5. Creating and Formatting Power BI Reports

6. Applying Custom Visuals, Animation, and Analytics

7. Designing Power BI Dashboards and Architectures

8. Managing Application Workspaces and Content

9. Managing the On-Premises Data Gateway

10. Deploying the Power BI Report Server

11. Creating Power BI Apps and Content Distribution

12. Administering Power BI for an Organization

13. Scaling with Premium and Analysis Services

14. Other Books You May Enjoy

Leave a review - let other readers know what you think

Analysis Services

Analysis Services has been Microsoft's enterprise Online Analytical Processing (OLAP) BI engine for many years. The Analysis Services Tabular model including the DAX programming language, in-memory and columnar storage, and columnar compression was first introduced with Microsoft's entry to self-service business intelligence with Power Pivot for Excel 2010. Analysis Services Tabular, which now includes the Power Query M programming language and the optional DirectQuery storage mode described earlier in this book, is the default installation mode of SSAS 2017. Additionally, the Analysis Services Tabular engine is built into Excel, Power BI, and the Azure Analysis Services PaaS offering.

The data model built into Excel workbooks is limited to in-memory storage mode and does not support bi-directional relationships. Additionally, Excel workbooks containing...

The rest of the chapter is locked

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $19.99/month. Cancel anytime

Authors (1)

Powell

Brett Powell is the owner of and business intelligence consultant at Frontline Analytics LLC, a data and analytics research and consulting firm and Microsoft Power BI partner. He has worked with Power BI technologies since they were first introduced as the PowerPivot add-in for Excel 2010 and has been a Power BI architect and lead BI consultant for organizations across the retail, manufacturing, and financial services industries. Additionally, Brett has led Boston's Power BI User Group, delivered presentations at technology events such as Power BI World Tour, and maintains the popular Insight Quest Microsoft BI blog.

See other products by Powell