Introducing Microsoft Power BI

Table of contents

1. Cover Page
2. Title Page
3. Copyright Page
4. Contents
5. Introduction
   1. Downloads
      1. Installing the companion content
   2. Acknowledgments
   3. Free ebooks from Microsoft Press
   4. Errata, updates, & book support
   5. We want to hear from you
   6. Stay in touch
6. Chapter 1. Introducing Power BI
   1. Getting started with Power BI
   2. Uploading data to Power BI
   3. Introducing natural-language queries
   4. Introducing Quick Insights
   5. Introduction to reports
   6. Introducing Visual Interactions
   7. Decorating the report
   8. Saving the report
   9. Pinning a report
   10. Refreshing the budget workbook
   11. Filtering a report
   12. Conclusions
7. Chapter 2. Sharing the dashboard
   1. Inviting a user to see a dashboard
      1. Inviting users outside your organization
   2. Creating a group workspace in Power BI
   3. Turning on sharing with Microsoft OneDrive for Business
   4. Viewing reports and dashboards on mobile devices
   5. Conclusions
8. Chapter 3. Understanding data refresh
   1. Introducing data refresh
   2. Introducing the Power BI refresh architecture
   3. Introducing Power BI Desktop
   4. Publishing to Power BI
   5. Installing the Power BI Personal Gateway
   6. Configuring automatic refresh
   7. Conclusions
9. Chapter 4. Using Power BI Desktop
   1. Connecting to a database
   2. Loading from multiple sources
   3. Using Query Editor
   4. Hiding or removing tables
   5. Handling seasonality and sorting months
   6. Conclusions
10. Chapter 5. Getting data from services and content packs
    1. Consuming a service content pack
    2. Creating a custom dataset from a service
    3. Creating a content pack for your organization
    4. Consuming an organizational content pack
    5. Updating an organizational content pack
    6. Conclusions
11. Chapter 6. Building a data model
    1. Loading individual tables
    2. Implementing measures
    3. Creating calculated columns
    4. Improving the report by using measures
    5. Integrating budget information
    6. Reallocating the budget
    7. Conclusions
12. Chapter 7. Improving Power BI reports
    1. Choosing the right visualizations
       1. Choosing between standard visuals
    2. Using custom visualizations
       1. First steps with custom visualizations
       2. Improving reports by using custom visualizations
       3. Identifying conditions when custom visualizations are required
    3. Using DAX in data models
    4. Creating high-density reports
    5. Conclusions
13. Chapter 8. Using Microsoft Power BI in your company
    1. Getting data from existing systems
       1. Understanding differences between data refresh and live connections
       2. Using relational databases on-premises
       3. Using relational databases in the cloud
       4. Using live connections to Analysis Services
    2. Integrating Power BI with Office
       1. Publish Excel data models in Power BI
       2. Consume Power BI content from Excel
       3. Using Power BI Tiles from Office Store
    3. Managing security to access data
       1. Using row-level security
    4. Extending and customizing Power BI
       1. Creating custom visualizations for Power BI
       2. Introducing the Power BI REST API
          1. Limitations
       3. Pushing real-time data to Power BI dashboards
       4. Power BI embedded in applications
    5. Conclusions
14. About the authors
15. Visit us today
16. Analyzing Data with Microsoft Power BI and Power Pivot for Excel
17. Hear about it first
18. Survey
19. Free ebooks
20. Code Snippets