O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft Power BI Dashboards Step by Step, First Edition

Book Description

Your hands-on guide to building effective Power BI dashboards

 

Expand your expertise–and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you're an experienced business intelligence professional or manager, you'll get all the guidance, examples, and code you need to succeed–even if you've never used Power BI before.

  • Successfully design, architect, and implement Power BI in your organization
  • Take full advantage of any Microsoft Power BI platform, including Power BI Premium
  • Make upfront decisions that position your Power BI project for success
  • Build rich, live dashboards to monitor crucial data from across your organization
  • Aggregate data and data elements from numerous internal and external data sources
  • Develop dynamic visualizations, including charts, maps, and graphs
  • Bring data to life with stunning interactive reports
  • Ensure dashboard security and compliance
  • Drive user adoption through effective training

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. Contents
  6. Acknowledgments
  7. About the author
  8. Introduction
    1. Who this book is for
    2. The Step by Step approach
    3. Features and conventions
    4. Download the practice files
    5. Ebook edition
    6. Get support and give feedback
  9. 1 Introduction to Power BI
    1. An introduction to Power BI
    2. Power BI features
    3. Power BI platforms
    4. Power BI licensing models
    5. Set up Power BI
    6. Prepare a dashboard in Power BI service
    7. General note for Power BI security
    8. Skills review
    9. Practice tasks
  10. 2 Power BI architecture and administration
    1. Power BI architecture
    2. The Power BI Admin Portal
    3. Power BI data models and report development
    4. Skills review
    5. Practice tasks
  11. 3 Visuals in Power BI
    1. Overview of visuals in Power BI
    2. Power BI visuals out of the box
    3. Third-party visuals in Power BI
    4. Drill through Power BI visuals
    5. Apply filters in Power BI reports
    6. Skills review
    7. Practice tasks
  12. 4 Power BI report development
    1. Data sources supported by Power BI
    2. Build a Power BI report in Power BI Desktop
    3. Publish your report to Power BI service
    4. Skills review
    5. Practice tasks
  13. 5 Use DAX in Power BI
    1. Calculated columns and measures
    2. DAX expressions syntax and context
    3. DAX functions
    4. Skills review
    5. Practice tasks
  14. 6 Develop Power BI reports from Excel
    1. Import data from an Excel workbook into Power BI
    2. Add a measure and a calculated column
    3. Add Power BI visuals to the report
    4. Arrange the visuals
    5. Prepare the report for mobile view
    6. Publish and view the report
    7. Prepare a dashboard from the report
    8. Skills review
    9. Practice tasks
  15. 7 Develop Power BI reports from SharePoint Online
    1. Build a Power BI report based on data from a SharePoint Online list
    2. Build a Power BI report based on data from a SharePoint Online folder
    3. Refresh report data in a Power BI report
    4. Embed Power BI reports in SharePoint Online
    5. Skills review
    6. Practice tasks
  16. 8 Develop Power BI reports from SharePoint On-Premises
    1. Import data from a SharePoint On-Premises list into Power BI
    2. Create a Power BI report
    3. Set up a data gateway
    4. Configure Power BI to use the data gateway and set up refresh functionality
    5. Skills review
    6. Practice tasks
  17. 9 Develop Power BI reports from SQL
    1. Import data from a SQL Server database into Power BI
    2. Create a Power BI report
    3. Set up a data gateway
    4. Configure Row-Level Security (RLS) in Power BI
    5. Skills review
    6. Practice tasks
  18. 10 Develop Power BI reports from SSAS cube
    1. Basic terminology
    2. Import data from an SSAS cube into Power BI
    3. Create a Power BI report
    4. Set up and configure a data gateway
    5. Skills review
    6. Practice tasks
  19. 11 Develop Power BI reports from Azure SQL
    1. Overview of the Azure SQL portal
    2. Import data from an Azure SQL database into Power BI
    3. Create a Power BI report
    4. Set up a live data connection and data refresh functionality
    5. Skills review
    6. Practice tasks
  20. 12 Develop Power BI reports from Oracle
    1. Import data from an Oracle database into Power BI
    2. Create a Power BI report
    3. Set up and configure a data gateway
    4. Skills review
    5. Practice tasks
  21. 13 Develop Power BI reports from Dynamics 365
    1. Import data from Dynamics 365 into Power BI Desktop
    2. Create a Power BI report
    3. Import data from Dynamics 365 into Power BI service
    4. Embed a Power BI dashboard into a Dynamics 365 dashboard
    5. Set up data refresh functionality
    6. Skills review
    7. Practice tasks
  22. Index
  23. Code Snippets