Architecting Power BI Solutions in Microsoft Fabric

Description

Business Intelligence (BI) tools like Power BI are used by a wide range of professionals, creating diverse and complex scenarios, and finding the right solution can be daunting, especially when multiple approaches exist for a single use case. The author distills his 17 years of experience on various data platform technologies in this book to walk you through various Power BI usage scenarios. The book is structured around Power BI usage scenarios, such as developing solutions for corporate BI reporting, self-service BI reporting, and Power BI for data scientists and independent software vendors (ISVs). Each part highlights common data issues encountered in the usage scenario, the correct approach to solve the problems, and supporting technical guidance. The chapters also introduce you to some of the latest enhancements in Power BI, such as Microsoft Fabric integration with Power BI, AI features like Copilot, Power BI Git integration, and Power BI Governance features. By the end of this book, you'll have learned how to design optimal solutions using Power BI components and pick the right tool for the job, while adhering to security and performance best practices. Part 1: Power BI Fundamentals Chevron down icon Part 1: Power BI Fundamentals Chapter 1: Decoding Power BI Chevron down icon Chapter 1: Decoding Power BI Technical requirements Power BI overview Power BI Desktop The Power BI service Power BI dataflows Other Power BI components Summary Join our community on Discord Chapter 2: Power BI Licensing Chevron down icon Chapter 2: Power BI Licensing Technical requirements The Power BI free license The Power BI Pro license Fabric capacity Power BI Premium per user Power BI Premium per capacity Licensing for Power BI Embedded applications Power BI Report Server licensing The Power BI licensing decision tree Summary Join our community on Discord Chapter 3: Understanding Collaboration and Distribution in Power BI Chevron down icon Chapter 3: Understanding Collaboration and Distribution in Power BI Technical requirements Introducing Power BI Workspace Exploring roles and permissions in Power BI Workspaces Sharing reports and semantic models Publishing apps and reports Sharing via app, Workspace role, or granular permission Summary Join our community on Discord Chapter 4: Power BI Usage Patterns Chevron down icon Chapter 4: Power BI Usage Patterns Technical requirements Introduction to Power BI usage patterns Enterprise BI usage pattern Self-service BI usage pattern Managed self-service BI pattern Summary Join our community on Discord Part 2: Designing Enterprise BI Solutions Chevron down icon Part 2: Designing Enterprise BI Solutions Chapter 5: Deciding on the Storage Mode Chevron down icon Chapter 5: Deciding on the Storage Mode Technical requirements Choosing the storage mode Understanding composite models Exploring aggregations Choosing the storage mode – continued Summary Join our community on Discord Chapter 6: Deciding on an Intermediate Data Store Chevron down icon Chapter 6: Deciding on an Intermediate Data Store Technical requirements Introducing dataflows Introducing datamarts Comparing dataflows and datamarts Using a decision tree to decide between a dataflow and a datamart Summary Join our community on Discord Chapter 7: Understanding Microsoft Fabric Chevron down icon Chapter 7: Understanding Microsoft Fabric Technical requirements An overview of Fabric Reviewing the Fabric architecture Exploring Lakehouse and Data Warehouse Comparing lakehouses, warehouses, dataflows, and datamarts Summary Join our community on Discord Chapter 8: Managing Semantic Model Refresh Chevron down icon Chapter 8: Managing Semantic Model Refresh Technical requirements Performing full semantic model refresh Performing incremental refresh Exploring advanced refresh techniques Using a decision tree to decide the semantic model refresh method Summary Join our community on Discord Chapter 9: Performing Optimizations in Power BI Chevron down icon Chapter 9: Performing Optimizations in Power BI Technical requirements Optimizing a semantic model Optimizing semantic model refresh Performing report optimizations Summary Join our community on Discord Chapter 10: Managing Semantic Model Security Chevron down icon Chapter 10: Managing Semantic Model Security Technical requirements Understanding Power BI architecture and data storage Designing data security Configuring encryption at rest Configuring object-level security Implementing row-level security Summary Join our community on Discord Chapter 11: Performing Power BI Deployments Chevron down icon Chapter 11: Performing Power BI Deployments Technical requirements Certifying Power BI artifacts Understanding deployment pipelines Managing Power BI Git integrations Summary Join our community on Discord Part 3: Power BI for Business Users Chevron down icon Part 3: Power BI for Business Users Chapter 12: Leveraging Artificial Intelligence in Power BI Chevron down icon Chapter 12: Leveraging Artificial Intelligence in Power BI Technical requirements Exploring data using AI Leveraging Copilot in Power BI Leveraging AI in self-service BI scenarios Summary Join our community on Discord Chapter 13: Integrating Power BI with Microsoft 365 Tools Chevron down icon Chapter 13: Integrating Power BI with Microsoft 365 Tools Technical requirements Exploring Power BI semantic models using Excel Experiencing Power BI with Microsoft PowerPoint Collaborating on Microsoft Teams with Power BI apps Summary Join our community on Discord Part 4: Power BI for Data Scientists Chevron down icon Part 4: Power BI for Data Scientists Chapter 14: Uncovering Features of Power BI for Data Scientists Chevron down icon Chapter 14: Uncovering Features of Power BI for Data Scientists Technical requirements Decoding the data science process Understanding Fabric’s data science architecture Developing machine learning model using AutoML Understanding Fabric semantic link Exploring visualization features for data scientists Exploring Power BI integration with AI Insights Summary Join our community on Discord Part 5: Power BI for Administrators Chevron down icon Part 5: Power BI for Administrators Chapter 15: Protecting Data Using Microsoft Purview and Defender Chevron down icon Chapter 15: Protecting Data Using Microsoft Purview and Defender Technical requirements Protecting data using sensitivity labels Configuring Microsoft Defender for Cloud Apps for Power BI Preventing data leaks using data loss prevention policies Controlling access using protection policies Securing Power BI using Conditional Access policies Summary Join our community on Discord Chapter 16: Designing Power BI Governance Chevron down icon Chapter 16: Designing Power BI Governance Technical requirements Understanding the key responsibilities in Power BI Unpacking designing a governance model Designing Power BI governance model for enterprise BI Designing Power BI governance model for managed self-service BI Designing Power BI governance model for self-service BI Summary Join our community on Discord Chapter 17: Managing Fabric Capacities Chevron down icon Chapter 17: Managing Fabric Capacities Technical requirements Understanding Fabric capacities Demystifying the concepts of bursting, smoothing, and throttling Monitoring Fabric capacities Managing capacities Devising capacity management strategies Summary Join our community on Discord Index Chevron down icon Index Why subscribe? Other Books You May Enjoy