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