You are previewing Introducing Microsoft Power BI.
O'Reilly logo
Introducing Microsoft Power BI

Book Description

Get started quickly with Microsoft Power BI! Experts Alberto Ferrari and Marco Russo will help you bring your data to life, transforming your company’s data into rich visuals for you to collect and organize, allowing you to focus on what matters most to you. Stay in the know, spot trends as they happen, and push your business to new limits.

This free ebook introduces Microsoft Power BI basics through a practical, scenario-based guided tour of the tool, showing you how to build analytical solutions using Power BI. Read the ebook to get an overview of Power BI, or dig deeper and follow along on your PC using the book's examples.

Introducing Microsoft Power BI enables you to evaluate when and how to use Power BI. Get inspired to improve business processes in your company by leveraging the available analytical and collaborative features of this environment.

Be sure to watch for the publication of Alberto Ferrari and Marco Russo's upcoming retail book, Analyzing Data with Power BI and Power Pivot for Excel (ISBN 9781509302765). Go to the book's page at the Microsoft Press Store here for more details:

Learn more about Power BI at

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Contents
  5. Introduction
      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