Details

Subject(s)

• Business—Data processing [Browse]
• Business intelligence—Computer programs [Browse]
• Information visualization—Computer programs [Browse]

Author

• Powell, Brett [Browse]

Series

Expert insight. [More in this series]

Summary note

Now in color, this edition helps you unlock the full potential of Power BI with new recipes and comprehensive techniques on advanced data tools and AI Key Features Dive into Microsoft Data Fabric for deeper insights and robust data strategies Implement Hybrid tables, create comprehensive scorecards, and establish shared cloud connections effortlessly Uncover new and updated data visualization tools that turn complex data into clear, actionable charts and reports Book Description Since its first edition the Power BI Cookbook has been a best-selling resource for BI developers and data analysts to produce impactful, quality BI solutions. This new and updated edition retains the rigorous details and concepts readers of prior editions have enjoyed while also demonstrating powerful new capabilities and updated guidance aligned to the current state of the platform. In this book, with step-by-step instructions, you will learn to navigate the complexities of data integration and visualization in Power BI. From creating robust data models to implementing sophisticated reporting techniques, this Power BI book empowers you to make informed decisions based on actionable insights. It also introduces you to new capabilities such as Hybrid tables and scorecards, enhancing your ability to communicate and analyze business performance. It also expands and improvises on the core of the previous edition like parameterizing Power BI solutions, authoring reports, data intelligence, and integrating advanced analytics. This edition not only updates you on the latest features but also prepares you for future innovations with a preview of upcoming AI enhancements in Power BI. Whether you're refining your skills or aspiring to become an expert, this book is an invaluable resource for leveraging Power BI to its fullest potential What you will learn Analyze and integrate business data using Microsoft Data Fabric Create impactful visualizations and manage Hybrid tables Develop shared cloud connections and advanced scorecards Enhance report accuracy and dynamics using real-time data processing Implement efficient data governance and security measures within Power BI Who this book is for This book is designed for data analysts, business intelligence professionals, and anyone involved in data processing or analytics who seeks to enhance their skills with Power BI's latest features and prepare for future advancements in the field.

Notes

Includes index.

Source of description

• Description based on publisher supplied metadata and other sources.
• Description based on print version record.

Contents

• Cover
• Copyright
• Contributors
• Preface
• Chapter 1: Installing and Licensing Power BI Tools
• Technical Requirements
• Installing and Configuring Power BI Desktop
• Getting ready
• How to install and configure Power BI Desktop
• How it works
• There's more…
• See also
• Installing SQL Server and the AdventureWorks Database
• How to install SQL Server
• Installing Developer Edition of SQL Server
• Installing SQL Server Management Studio
• How to install the AdventureWorks database
• Installing and Using Power BI Report Builder
• How to install Power BI Report Builder
• Creating an On-Premises Data Gateway
• How to create the gateway
• Installing Additional Tools
• How to install DAX Studio
• Thinking about Licensing
• How to license Power BI
• Summary
• Chapter 2: Accessing, Retrieving, and Transforming Data
• Importing Data
• How to import data
• There's more...
• Using DirectQuery
• How to use DirectQuery
• Creating Dataflows
• How to create a dataflow
• Applying Filters
• How to apply multiple filters
• Transforming and Cleansing Data
• How to transform and cleanse data
• Creating Custom Columns
• How to create custom columns
• See also.
• Combining and Merging Queries
• How to combine queries
• Profiling Source Data
• How to profile source data
• Diagnosing Queries
• How to diagnose queries
• Extending the Core M Library
• How to extend the core M library
• Chapter 3: Building a Power BI Semantic Model
• Designing a Semantic Model
• How to design a semantic model
• Implementing a Semantic Model
• How to implement a semantic model
• Creating Relationships
• How to create relationships
• Configuring Model Metadata
• How to configure model metadata
• Enriching a Model with DAX Measures
• How to enrich a model with DAX measures
• Creating Hierarchies and Groups
• How to create hierarchies and groups
• Supporting Virtual Table Relationships
• How to support virtual table relationships
• Designing Column-Level Security
• How to design column-level security
• Leveraging Aggregation Tables
• How to leverage aggregation tables
• Utilizing Hybrid Tables
• How to utilize hybrid tables
• How it works.
• Chapter 4: Authoring Power BI Reports
• Building Rich and Intuitive Reports
• How to build rich and intuitive reports
• Filtering at Different Scopes
• How to filter at different scopes
• Integrating Card Visualizations
• How to integrate card visualizations
• Using Slicers
• How to use slicers
• Controlling Visual Interactions
• How to control visual interactions
• Utilizing Graphical Visualizations
• How to utilize graphical visualizations
• Creating Table and Matrix Visuals
• How to create table and matrix visuals
• Enhancing Reports
• How to enhance reports
• Formatting Reports for Publication
• How to format reports for publication
• Designing Mobile Layouts
• How to design mobile layouts
• Creating Paginated Reports
• How to create paginated reports
• Chapter 5: Working in the Power BI Service
• Building a Dashboard
• How to build a dashboard
• Preparing for Q&
• A
• How to prepare for Q&
• Adding Alerts and Subscriptions
• How to add alerts and subscriptions
• Streaming Semantic Models
• How to stream semantic models
• Authoring Dataflows
• How to author dataflows
• Creating Scorecards
• How to create scorecards
• Chapter 6: Getting Serious About Date Intelligence
• Preparing the Date Dimension via the Query Editor
• How to prepare the date dimension
• Authoring Date Intelligence Measures
• How to author date intelligence measures
• Developing Advanced Date Intelligence Measures
• How to develop advanced date intelligence measures
• Simplifying Date Intelligence with DAX and Calculated Tables
• How to simplify date intelligence
• Leveraging Calculation Groups
• How to leverage calculation groups
• Chapter 7: Parameterizing Power BI Solutions
• Filtering Reports Dynamically
• How to filter reports dynamically
• Leveraging Query Parameters
• How to leverage query parameters
• Working with Templates
• How to work with templates
• Converting Static Queries to Dynamic Functions
• Getting ready.
• How to convert static queries to dynamic functions
• Capturing User Selections with Parameter Tables
• How to capture user selection with parameter tables
• Forecasting with What-If Analysis
• How to forecast with what-if analysis
• Chapter 8: Implementing Dynamic User-Based Visibility in Power BI
• Defining RLS Roles and Filter Expressions
• How to define RLS roles and filter expressions
• Designing Dynamic Security Models
• How to build dynamic security models
• Building Dynamic Security for DirectQuery
• How to build dynamic security models for DirectQuery
• Displaying the Current Filter Context
• How to display the current filter context
• Avoiding Manual User Clicks
• How to avoid manual user clicks
• Chapter 9: Applying Advanced Analytics and Custom Visuals
• Incorporating Advanced Analytics
• How to incorporate advanced analytics
• Enriching Content with Custom Visuals and Quick Insights
• How to enrich content with custom visuals and Quick Insights
• Creating Geospatial Mapping with ArcGIS Maps
• How to create geospatial mapping with ArcGIS maps
• Democratizing Artificial Intelligence.

Show 149 more Contents items

ISBN

9781835464663 ((electronic bk.))

OCLC

1451040755

Statement on language in description

Princeton University Library aims to describe library materials in a manner that is respectful to the individuals and communities who create, use, and are represented in the collections we manage. Read more...