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 Cover Title Page Copyright Page Dedication Contents Acknowledgments About the author i: Introduction Who this book is for The Step by Step approach Features and conventions Download the practice files Ebook edition Get support and give feedback 1 Introduction to Power BI Sidebar: Practice files An introduction to Power BI Sidebar: Real-world scenario Sidebar: Using Power BI effectively to streamline organizational growth Sidebar: A word on datasets Power BI features Power BI platforms Power BI licensing models Set up Power BI Prepare a dashboard in Power BI service General note for Power BI security Skills review Practice tasks 2 Power BI architecture and administration Power BI architecture The Power BI Admin Portal Power BI data models and report development Sidebar: Relationship view Skills review Practice tasks 3 Visuals in Power BI Overview of visuals in Power BI Power BI visuals out of the box Third-party visuals in Power BI Sidebar: Other ways to import third-party visuals into Power BI Sidebar: More options Drill through Power BI visuals Apply filters in Power BI reports Sidebar: Slicers Skills review Practice tasks 4 Power BI report development Sidebar: Practice files Data sources supported by Power BI Build a Power BI report in Power BI Desktop Sidebar: Relationship view Publish your report to Power BI service Skills review Practice tasks 5 Use DAX in Power BI Calculated columns and measures Sidebar: DAX capabilities DAX expressions syntax and context DAX functions Skills review Practice tasks 6 Develop Power BI reports from Excel Sidebar: Practice files Import data from an Excel workbook into Power BI Add a measure and a calculated column Add Power BI visuals to the report Arrange the visuals Prepare the report for mobile view Publish and view the report Prepare a dashboard from the report Skills review Practice tasks 7 Develop Power BI reports from SharePoint Online Sidebar: Practice files Build a Power BI report based on data from a SharePoint Online list Build a Power BI report based on data from a SharePoint Online folder Refresh report data in a Power BI report Embed Power BI reports in SharePoint Online Skills review Practice tasks 8 Develop Power BI reports from SharePoint On-Premises Sidebar: Practice files Import data from a SharePoint On-Premises list into Power BI Create a Power BI report Set up a data gateway Configure Power BI to use the data gateway and set up refresh functionality Skills review Practice tasks 9 Develop Power BI reports from SQL Sidebar: Practice files Import data from a SQL Server database into Power BI Create a Power BI report Set up a data gateway Configure Row-Level Security (RLS) in Power BI Sidebar: Limitations of RLS in Power BI Skills review Practice tasks 10 Develop Power BI reports from SSAS cube Sidebar: Practice files Basic terminology Import data from an SSAS cube into Power BI Create a Power BI report Set up and configure a data gateway Skills review Practice tasks 11 Develop Power BI reports from Azure SQL Sidebar: Practice files Overview of the Azure SQL portal Import data from an Azure SQL database into Power BI Create a Power BI report Set up a live data connection and data refresh functionality Skills review Practice tasks 12 Develop Power BI reports from Oracle Sidebar: Practice files Import data from an Oracle database into Power BI Create a Power BI report Set up and configure a data gateway Skills review Practice tasks 13 Develop Power BI reports from Dynamics 365 Sidebar: Practice files Import data from Dynamics 365 into Power BI Desktop Sidebar: URL syntax Create a Power BI report Import data from Dynamics 365 into Power BI service Embed a Power BI dashboard into a Dynamics 365 dashboard Set up data refresh functionality Skills review Practice tasks Index A B C D E F G H I K L M N O P Q R S T U V W X Y This guide takes you through creating world-class business analysis dashboards that integrate today's most widely-used data sources, using any of Microsoft's Power BI platforms, including the new Power BI Premium. Author Errin O'Connor has worked with 70+ Fortune(R) 500 companies and led 450+ Power BI engagements: he is singularly well-qualified to guide you through successfully designing, architecting, and implementing Power BI in your organisation. Using real-world examples and success stories, hands-on guide walks through the key decisions analysts and developers need to make upfront, and introduces all the concepts, skills, and techniques you'll need to achieve your goals
