Introducing Microsoft Power BI

Description

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