Microsoft Power BI Cookbook: Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition
Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions tha...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham
Packt Publishing, Limited
2021
|
| Edition: | 2nd ed |
| Subjects: | |
| Links: | https://ebookcentral.proquest.com/lib/th-wildau/detail.action?docID=6739167 |
| Summary: | Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies |
| Item Description: | Description based on publisher supplied metadata and other sources |
| Physical Description: | 1 Online-Ressource (655 Seiten) |
| ISBN: | 9781801811323 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV048224777 | ||
| 003 | DE-604 | ||
| 005 | 20220803 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 220516s2021 xx o|||| 00||| eng d | ||
| 020 | |a 9781801811323 |9 978-1-80181-132-3 | ||
| 035 | |a (ZDB-30-PQE)EBC6739167 | ||
| 035 | |a (ZDB-30-PAD)EBC6739167 | ||
| 035 | |a (ZDB-89-EBL)EBL6739167 | ||
| 035 | |a (OCoLC)1273974620 | ||
| 035 | |a (DE-599)BVBBV048224777 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-526 | ||
| 082 | 0 | |a 658.472028553 | |
| 084 | |a AK 54525 |0 (DE-625)164547: |2 rvk | ||
| 084 | |a ST 530 |0 (DE-625)143679: |2 rvk | ||
| 100 | 1 | |a Deckler, Greg |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Microsoft Power BI Cookbook |b Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| 250 | |a 2nd ed | ||
| 264 | 1 | |a Birmingham |b Packt Publishing, Limited |c 2021 | |
| 264 | 4 | |c ©2021 | |
| 300 | |a 1 Online-Ressource (655 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Configuring Power BI Tools -- Technical Requirements -- Installing and Configuring Power BI Desktop -- Creating an On-Premises Data Gateway -- Installing Analyze in Excel from the Power BI Service -- Installing and Configuring Additional Tools -- Conclusion -- Chapter 2: Accessing and Retrieving Data -- Technical Requirements -- Viewing and Analyzing M Functions -- Managing Queries and Data Sources -- Using DirectQuery -- Importing Data -- Applying Multiple Filters -- Selecting and Renaming Columns -- Transforming and Cleansing Data -- Creating Custom Columns -- Combining and Merging Queries -- Selecting Column Data Types -- Visualizing the M library -- Profiling Source Data -- Diagnosing Queries -- Conclusion -- Chapter 3: Building a Power BI Data Model -- Technical Requirements -- Designing a Data Model -- Implementing a Data Model -- Creating Relationships -- Configuring Model Metadata -- Hiding Columns and Tables -- Enriching a Model with DAX -- Supporting Virtual Table Relationships -- Creating Hierarchies and Groups -- Designing Column Level Security -- Leveraging Aggregation Tables -- Conclusion -- Chapter 4: Authoring Power BI Reports -- Technical Requirements -- Building Rich and Intuitive Reports -- Filtering at Different Scopes -- Integrating Card visualizations -- Using Slicers -- Controlling Visual Interactions -- Utilizing Graphical Visualizations -- Creating Table and Matrix visuals -- Enhancing Reports -- Formatting Reports for Publication -- Designing Mobile Layouts -- Creating Paginated Reports -- Conclusion -- Chapter 5: Working in the Service -- Technical Requirements -- Building a Dashboard -- Preparing for Q& -- A -- Adding Alerts and Subscriptions -- Deploying Content from Excel and SSRS -- Streaming Datasets -- Authoring Dataflows | |
| 505 | 8 | |a Conclusion -- Chapter 6: Getting Serious with Date Intelligence -- Technical Requirements -- Building a Date Dimension Table -- Preparing the Date Dimension via the Query Editor -- Authoring Date Intelligence Measures -- Developing Advanced Date Intelligence Measures -- Simplifying Date Intelligence with DAX and Calculated Tables -- Leveraging Calculation Groups -- Conclusion -- Chapter 7: Parameterizing Power BI Solutions -- Technical requirements -- Filtering reports dynamically -- Leveraging query parameters -- Working with templates -- Converting static queries to dynamic functions -- Capturing user selections with parameter tables -- Forecasting with what-if analysis -- Conclusion -- Chapter 8: Implementing Dynamic User-Based Visibility in Power BI -- Technical Requirements -- Capturing Current User Context -- Defining RLS Roles and Filter Expressions -- Designing Dynamic Security Models -- Building Dynamic Security for DirectQuery -- Displaying the Current Filter Context -- Avoiding Manual User Clicks -- Conclusion -- Chapter 9: Applying Advanced Analytics and Custom Visuals -- Technical Requirements -- Incorporating Advanced Analytics -- Enriching Content with Custom Visuals and Quick Insights -- Creating Geospatial Mapping with ArcGIS Maps -- Democratizing Artificial Intelligence -- Building Animation and Storytelling -- Embedding Statistical Analyses -- Grouping and Binning -- Detecting and Analyzing Clusters -- Forecasting and Anomaly Detection -- Using R and Python Visuals -- Conclusion -- Chapter 10: Administering and Monitoring Power BI -- Technical requirements -- Creating a centralized IT monitoring solution with Power BI -- Constructing a monitoring, visualization, and analysis layer -- Importing and visualizing dynamic management view (DMV) data -- Increasing DBA productivity -- Providing documentation | |
| 505 | 8 | |a Analyzing SSAS tabular databases and gateways -- Analyzing Extended Events -- Visualizing log file data -- Leveraging the Power BI PowerShell Module -- Conclusion -- Chapter 11: Enhancing and Optimizing Existing Power BI Solutions -- Technical Requirements -- Enhancing Data Model Scalability and Usability -- Improving DAX Measure Performance -- Pushing Query Processing Back to Source Systems -- Strengthening Data Import and Integration Processes -- Isolating and Documenting DAX Expressions -- Improving Data Load Speeds with Incremental Refresh -- Conclusion -- Chapter 12: Deploying and Distributing Power BI Content -- Technical Requirements -- Preparing for Content Creation and Collaboration -- Managing Content between Environments -- Sharing Content with Colleagues -- Configuring Workspaces -- Configuring On-Premises Gateway Data Connections -- Publishing Apps -- Publishing Reports to the Public Internet -- Enabling the Mobile Experience -- Distributing Content with Teams -- Conclusion -- Chapter 13: Integrating Power BI with Other Applications -- Technical Requirements -- Integrating SSRS and Excel -- Migrating from Power Pivot for Excel Data to Power BI -- Accessing and Analyzing Power BI Datasets in Excel -- Building Power BI Reports into PowerPoint Presentations -- Connecting to Azure Analysis Services -- Integrating with Power Automate and Power Apps -- Leveraging Dataverse and Dynamics 365 -- Connecting Dynamics 365 Finance and Operations and the Power Platform -- Conclusion -- Why subscribe? -- Other Book You May Enjoy -- Index | |
| 520 | |a Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies | ||
| 650 | 0 | 7 | |a Visualisierung |0 (DE-588)4188417-6 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Visualisierung |0 (DE-588)4188417-6 |D s |
| 689 | 0 | |5 DE-604 | |
| 700 | 1 | |a Powell, Brett |e Sonstige |4 oth | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Deckler, Greg |t Microsoft Power BI Cookbook |d Birmingham : Packt Publishing, Limited,c2021 |z 9781801813044 |
| 912 | |a ZDB-30-PQE | ||
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-033605510 | |
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-wildau/detail.action?docID=6739167 |l DE-526 |p ZDB-30-PQE |q BTW_PDA_PQE_KAUF |x Aggregator |3 Volltext | |
Record in the Search Index
| _version_ | 1818989469273948160 |
|---|---|
| any_adam_object | |
| author | Deckler, Greg |
| author_facet | Deckler, Greg |
| author_role | aut |
| author_sort | Deckler, Greg |
| author_variant | g d gd |
| building | Verbundindex |
| bvnumber | BV048224777 |
| classification_rvk | AK 54525 ST 530 |
| collection | ZDB-30-PQE |
| contents | Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Configuring Power BI Tools -- Technical Requirements -- Installing and Configuring Power BI Desktop -- Creating an On-Premises Data Gateway -- Installing Analyze in Excel from the Power BI Service -- Installing and Configuring Additional Tools -- Conclusion -- Chapter 2: Accessing and Retrieving Data -- Technical Requirements -- Viewing and Analyzing M Functions -- Managing Queries and Data Sources -- Using DirectQuery -- Importing Data -- Applying Multiple Filters -- Selecting and Renaming Columns -- Transforming and Cleansing Data -- Creating Custom Columns -- Combining and Merging Queries -- Selecting Column Data Types -- Visualizing the M library -- Profiling Source Data -- Diagnosing Queries -- Conclusion -- Chapter 3: Building a Power BI Data Model -- Technical Requirements -- Designing a Data Model -- Implementing a Data Model -- Creating Relationships -- Configuring Model Metadata -- Hiding Columns and Tables -- Enriching a Model with DAX -- Supporting Virtual Table Relationships -- Creating Hierarchies and Groups -- Designing Column Level Security -- Leveraging Aggregation Tables -- Conclusion -- Chapter 4: Authoring Power BI Reports -- Technical Requirements -- Building Rich and Intuitive Reports -- Filtering at Different Scopes -- Integrating Card visualizations -- Using Slicers -- Controlling Visual Interactions -- Utilizing Graphical Visualizations -- Creating Table and Matrix visuals -- Enhancing Reports -- Formatting Reports for Publication -- Designing Mobile Layouts -- Creating Paginated Reports -- Conclusion -- Chapter 5: Working in the Service -- Technical Requirements -- Building a Dashboard -- Preparing for Q& -- A -- Adding Alerts and Subscriptions -- Deploying Content from Excel and SSRS -- Streaming Datasets -- Authoring Dataflows Conclusion -- Chapter 6: Getting Serious with Date Intelligence -- Technical Requirements -- Building a Date Dimension Table -- Preparing the Date Dimension via the Query Editor -- Authoring Date Intelligence Measures -- Developing Advanced Date Intelligence Measures -- Simplifying Date Intelligence with DAX and Calculated Tables -- Leveraging Calculation Groups -- Conclusion -- Chapter 7: Parameterizing Power BI Solutions -- Technical requirements -- Filtering reports dynamically -- Leveraging query parameters -- Working with templates -- Converting static queries to dynamic functions -- Capturing user selections with parameter tables -- Forecasting with what-if analysis -- Conclusion -- Chapter 8: Implementing Dynamic User-Based Visibility in Power BI -- Technical Requirements -- Capturing Current User Context -- Defining RLS Roles and Filter Expressions -- Designing Dynamic Security Models -- Building Dynamic Security for DirectQuery -- Displaying the Current Filter Context -- Avoiding Manual User Clicks -- Conclusion -- Chapter 9: Applying Advanced Analytics and Custom Visuals -- Technical Requirements -- Incorporating Advanced Analytics -- Enriching Content with Custom Visuals and Quick Insights -- Creating Geospatial Mapping with ArcGIS Maps -- Democratizing Artificial Intelligence -- Building Animation and Storytelling -- Embedding Statistical Analyses -- Grouping and Binning -- Detecting and Analyzing Clusters -- Forecasting and Anomaly Detection -- Using R and Python Visuals -- Conclusion -- Chapter 10: Administering and Monitoring Power BI -- Technical requirements -- Creating a centralized IT monitoring solution with Power BI -- Constructing a monitoring, visualization, and analysis layer -- Importing and visualizing dynamic management view (DMV) data -- Increasing DBA productivity -- Providing documentation Analyzing SSAS tabular databases and gateways -- Analyzing Extended Events -- Visualizing log file data -- Leveraging the Power BI PowerShell Module -- Conclusion -- Chapter 11: Enhancing and Optimizing Existing Power BI Solutions -- Technical Requirements -- Enhancing Data Model Scalability and Usability -- Improving DAX Measure Performance -- Pushing Query Processing Back to Source Systems -- Strengthening Data Import and Integration Processes -- Isolating and Documenting DAX Expressions -- Improving Data Load Speeds with Incremental Refresh -- Conclusion -- Chapter 12: Deploying and Distributing Power BI Content -- Technical Requirements -- Preparing for Content Creation and Collaboration -- Managing Content between Environments -- Sharing Content with Colleagues -- Configuring Workspaces -- Configuring On-Premises Gateway Data Connections -- Publishing Apps -- Publishing Reports to the Public Internet -- Enabling the Mobile Experience -- Distributing Content with Teams -- Conclusion -- Chapter 13: Integrating Power BI with Other Applications -- Technical Requirements -- Integrating SSRS and Excel -- Migrating from Power Pivot for Excel Data to Power BI -- Accessing and Analyzing Power BI Datasets in Excel -- Building Power BI Reports into PowerPoint Presentations -- Connecting to Azure Analysis Services -- Integrating with Power Automate and Power Apps -- Leveraging Dataverse and Dynamics 365 -- Connecting Dynamics 365 Finance and Operations and the Power Platform -- Conclusion -- Why subscribe? -- Other Book You May Enjoy -- Index |
| ctrlnum | (ZDB-30-PQE)EBC6739167 (ZDB-30-PAD)EBC6739167 (ZDB-89-EBL)EBL6739167 (OCoLC)1273974620 (DE-599)BVBBV048224777 |
| dewey-full | 658.472028553 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.472028553 |
| dewey-search | 658.472028553 |
| dewey-sort | 3658.472028553 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Allgemeines Informatik Wirtschaftswissenschaften |
| edition | 2nd ed |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>07390nam a2200493zc 4500</leader><controlfield tag="001">BV048224777</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20220803 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">220516s2021 xx o|||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781801811323</subfield><subfield code="9">978-1-80181-132-3</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PQE)EBC6739167</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-30-PAD)EBC6739167</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-89-EBL)EBL6739167</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1273974620</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV048224777</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-526</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.472028553</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">AK 54525</subfield><subfield code="0">(DE-625)164547:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 530</subfield><subfield code="0">(DE-625)143679:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Deckler, Greg</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Power BI Cookbook</subfield><subfield code="b">Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">2nd ed</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham</subfield><subfield code="b">Packt Publishing, Limited</subfield><subfield code="c">2021</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2021</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (655 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Configuring Power BI Tools -- Technical Requirements -- Installing and Configuring Power BI Desktop -- Creating an On-Premises Data Gateway -- Installing Analyze in Excel from the Power BI Service -- Installing and Configuring Additional Tools -- Conclusion -- Chapter 2: Accessing and Retrieving Data -- Technical Requirements -- Viewing and Analyzing M Functions -- Managing Queries and Data Sources -- Using DirectQuery -- Importing Data -- Applying Multiple Filters -- Selecting and Renaming Columns -- Transforming and Cleansing Data -- Creating Custom Columns -- Combining and Merging Queries -- Selecting Column Data Types -- Visualizing the M library -- Profiling Source Data -- Diagnosing Queries -- Conclusion -- Chapter 3: Building a Power BI Data Model -- Technical Requirements -- Designing a Data Model -- Implementing a Data Model -- Creating Relationships -- Configuring Model Metadata -- Hiding Columns and Tables -- Enriching a Model with DAX -- Supporting Virtual Table Relationships -- Creating Hierarchies and Groups -- Designing Column Level Security -- Leveraging Aggregation Tables -- Conclusion -- Chapter 4: Authoring Power BI Reports -- Technical Requirements -- Building Rich and Intuitive Reports -- Filtering at Different Scopes -- Integrating Card visualizations -- Using Slicers -- Controlling Visual Interactions -- Utilizing Graphical Visualizations -- Creating Table and Matrix visuals -- Enhancing Reports -- Formatting Reports for Publication -- Designing Mobile Layouts -- Creating Paginated Reports -- Conclusion -- Chapter 5: Working in the Service -- Technical Requirements -- Building a Dashboard -- Preparing for Q&amp -- A -- Adding Alerts and Subscriptions -- Deploying Content from Excel and SSRS -- Streaming Datasets -- Authoring Dataflows</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Conclusion -- Chapter 6: Getting Serious with Date Intelligence -- Technical Requirements -- Building a Date Dimension Table -- Preparing the Date Dimension via the Query Editor -- Authoring Date Intelligence Measures -- Developing Advanced Date Intelligence Measures -- Simplifying Date Intelligence with DAX and Calculated Tables -- Leveraging Calculation Groups -- Conclusion -- Chapter 7: Parameterizing Power BI Solutions -- Technical requirements -- Filtering reports dynamically -- Leveraging query parameters -- Working with templates -- Converting static queries to dynamic functions -- Capturing user selections with parameter tables -- Forecasting with what-if analysis -- Conclusion -- Chapter 8: Implementing Dynamic User-Based Visibility in Power BI -- Technical Requirements -- Capturing Current User Context -- Defining RLS Roles and Filter Expressions -- Designing Dynamic Security Models -- Building Dynamic Security for DirectQuery -- Displaying the Current Filter Context -- Avoiding Manual User Clicks -- Conclusion -- Chapter 9: Applying Advanced Analytics and Custom Visuals -- Technical Requirements -- Incorporating Advanced Analytics -- Enriching Content with Custom Visuals and Quick Insights -- Creating Geospatial Mapping with ArcGIS Maps -- Democratizing Artificial Intelligence -- Building Animation and Storytelling -- Embedding Statistical Analyses -- Grouping and Binning -- Detecting and Analyzing Clusters -- Forecasting and Anomaly Detection -- Using R and Python Visuals -- Conclusion -- Chapter 10: Administering and Monitoring Power BI -- Technical requirements -- Creating a centralized IT monitoring solution with Power BI -- Constructing a monitoring, visualization, and analysis layer -- Importing and visualizing dynamic management view (DMV) data -- Increasing DBA productivity -- Providing documentation</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Analyzing SSAS tabular databases and gateways -- Analyzing Extended Events -- Visualizing log file data -- Leveraging the Power BI PowerShell Module -- Conclusion -- Chapter 11: Enhancing and Optimizing Existing Power BI Solutions -- Technical Requirements -- Enhancing Data Model Scalability and Usability -- Improving DAX Measure Performance -- Pushing Query Processing Back to Source Systems -- Strengthening Data Import and Integration Processes -- Isolating and Documenting DAX Expressions -- Improving Data Load Speeds with Incremental Refresh -- Conclusion -- Chapter 12: Deploying and Distributing Power BI Content -- Technical Requirements -- Preparing for Content Creation and Collaboration -- Managing Content between Environments -- Sharing Content with Colleagues -- Configuring Workspaces -- Configuring On-Premises Gateway Data Connections -- Publishing Apps -- Publishing Reports to the Public Internet -- Enabling the Mobile Experience -- Distributing Content with Teams -- Conclusion -- Chapter 13: Integrating Power BI with Other Applications -- Technical Requirements -- Integrating SSRS and Excel -- Migrating from Power Pivot for Excel Data to Power BI -- Accessing and Analyzing Power BI Datasets in Excel -- Building Power BI Reports into PowerPoint Presentations -- Connecting to Azure Analysis Services -- Integrating with Power Automate and Power Apps -- Leveraging Dataverse and Dynamics 365 -- Connecting Dynamics 365 Finance and Operations and the Power Platform -- Conclusion -- Why subscribe? -- Other Book You May Enjoy -- Index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Visualisierung</subfield><subfield code="0">(DE-588)4188417-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Visualisierung</subfield><subfield code="0">(DE-588)4188417-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Powell, Brett</subfield><subfield code="e">Sonstige</subfield><subfield code="4">oth</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Deckler, Greg</subfield><subfield code="t">Microsoft Power BI Cookbook</subfield><subfield code="d">Birmingham : Packt Publishing, Limited,c2021</subfield><subfield code="z">9781801813044</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-033605510</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-wildau/detail.action?docID=6739167</subfield><subfield code="l">DE-526</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">BTW_PDA_PQE_KAUF</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV048224777 |
| illustrated | Not Illustrated |
| indexdate | 2024-12-20T19:38:58Z |
| institution | BVB |
| isbn | 9781801811323 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-033605510 |
| oclc_num | 1273974620 |
| open_access_boolean | |
| owner | DE-526 |
| owner_facet | DE-526 |
| physical | 1 Online-Ressource (655 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE BTW_PDA_PQE_KAUF |
| publishDate | 2021 |
| publishDateSearch | 2021 |
| publishDateSort | 2021 |
| publisher | Packt Publishing, Limited |
| record_format | marc |
| spelling | Deckler, Greg Verfasser aut Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition 2nd ed Birmingham Packt Publishing, Limited 2021 ©2021 1 Online-Ressource (655 Seiten) txt rdacontent c rdamedia cr rdacarrier Description based on publisher supplied metadata and other sources Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Configuring Power BI Tools -- Technical Requirements -- Installing and Configuring Power BI Desktop -- Creating an On-Premises Data Gateway -- Installing Analyze in Excel from the Power BI Service -- Installing and Configuring Additional Tools -- Conclusion -- Chapter 2: Accessing and Retrieving Data -- Technical Requirements -- Viewing and Analyzing M Functions -- Managing Queries and Data Sources -- Using DirectQuery -- Importing Data -- Applying Multiple Filters -- Selecting and Renaming Columns -- Transforming and Cleansing Data -- Creating Custom Columns -- Combining and Merging Queries -- Selecting Column Data Types -- Visualizing the M library -- Profiling Source Data -- Diagnosing Queries -- Conclusion -- Chapter 3: Building a Power BI Data Model -- Technical Requirements -- Designing a Data Model -- Implementing a Data Model -- Creating Relationships -- Configuring Model Metadata -- Hiding Columns and Tables -- Enriching a Model with DAX -- Supporting Virtual Table Relationships -- Creating Hierarchies and Groups -- Designing Column Level Security -- Leveraging Aggregation Tables -- Conclusion -- Chapter 4: Authoring Power BI Reports -- Technical Requirements -- Building Rich and Intuitive Reports -- Filtering at Different Scopes -- Integrating Card visualizations -- Using Slicers -- Controlling Visual Interactions -- Utilizing Graphical Visualizations -- Creating Table and Matrix visuals -- Enhancing Reports -- Formatting Reports for Publication -- Designing Mobile Layouts -- Creating Paginated Reports -- Conclusion -- Chapter 5: Working in the Service -- Technical Requirements -- Building a Dashboard -- Preparing for Q& -- A -- Adding Alerts and Subscriptions -- Deploying Content from Excel and SSRS -- Streaming Datasets -- Authoring Dataflows Conclusion -- Chapter 6: Getting Serious with Date Intelligence -- Technical Requirements -- Building a Date Dimension Table -- Preparing the Date Dimension via the Query Editor -- Authoring Date Intelligence Measures -- Developing Advanced Date Intelligence Measures -- Simplifying Date Intelligence with DAX and Calculated Tables -- Leveraging Calculation Groups -- Conclusion -- Chapter 7: Parameterizing Power BI Solutions -- Technical requirements -- Filtering reports dynamically -- Leveraging query parameters -- Working with templates -- Converting static queries to dynamic functions -- Capturing user selections with parameter tables -- Forecasting with what-if analysis -- Conclusion -- Chapter 8: Implementing Dynamic User-Based Visibility in Power BI -- Technical Requirements -- Capturing Current User Context -- Defining RLS Roles and Filter Expressions -- Designing Dynamic Security Models -- Building Dynamic Security for DirectQuery -- Displaying the Current Filter Context -- Avoiding Manual User Clicks -- Conclusion -- Chapter 9: Applying Advanced Analytics and Custom Visuals -- Technical Requirements -- Incorporating Advanced Analytics -- Enriching Content with Custom Visuals and Quick Insights -- Creating Geospatial Mapping with ArcGIS Maps -- Democratizing Artificial Intelligence -- Building Animation and Storytelling -- Embedding Statistical Analyses -- Grouping and Binning -- Detecting and Analyzing Clusters -- Forecasting and Anomaly Detection -- Using R and Python Visuals -- Conclusion -- Chapter 10: Administering and Monitoring Power BI -- Technical requirements -- Creating a centralized IT monitoring solution with Power BI -- Constructing a monitoring, visualization, and analysis layer -- Importing and visualizing dynamic management view (DMV) data -- Increasing DBA productivity -- Providing documentation Analyzing SSAS tabular databases and gateways -- Analyzing Extended Events -- Visualizing log file data -- Leveraging the Power BI PowerShell Module -- Conclusion -- Chapter 11: Enhancing and Optimizing Existing Power BI Solutions -- Technical Requirements -- Enhancing Data Model Scalability and Usability -- Improving DAX Measure Performance -- Pushing Query Processing Back to Source Systems -- Strengthening Data Import and Integration Processes -- Isolating and Documenting DAX Expressions -- Improving Data Load Speeds with Incremental Refresh -- Conclusion -- Chapter 12: Deploying and Distributing Power BI Content -- Technical Requirements -- Preparing for Content Creation and Collaboration -- Managing Content between Environments -- Sharing Content with Colleagues -- Configuring Workspaces -- Configuring On-Premises Gateway Data Connections -- Publishing Apps -- Publishing Reports to the Public Internet -- Enabling the Mobile Experience -- Distributing Content with Teams -- Conclusion -- Chapter 13: Integrating Power BI with Other Applications -- Technical Requirements -- Integrating SSRS and Excel -- Migrating from Power Pivot for Excel Data to Power BI -- Accessing and Analyzing Power BI Datasets in Excel -- Building Power BI Reports into PowerPoint Presentations -- Connecting to Azure Analysis Services -- Integrating with Power Automate and Power Apps -- Leveraging Dataverse and Dynamics 365 -- Connecting Dynamics 365 Finance and Operations and the Power Platform -- Conclusion -- Why subscribe? -- Other Book You May Enjoy -- Index Power BI is a business intelligence and analytics services tool by Microsoft designed to provide visual and interactive insights into data. This book will provide thorough, technical examples of using all primary Power BI tools and features as well as demonstrate high impact end-to-end solutions that leverage and integrate these technologies Visualisierung (DE-588)4188417-6 gnd rswk-swf Visualisierung (DE-588)4188417-6 s DE-604 Powell, Brett Sonstige oth Erscheint auch als Druck-Ausgabe Deckler, Greg Microsoft Power BI Cookbook Birmingham : Packt Publishing, Limited,c2021 9781801813044 |
| spellingShingle | Deckler, Greg Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition Cover -- Copyright -- Contributors -- Table of Contents -- Preface -- Chapter 1: Configuring Power BI Tools -- Technical Requirements -- Installing and Configuring Power BI Desktop -- Creating an On-Premises Data Gateway -- Installing Analyze in Excel from the Power BI Service -- Installing and Configuring Additional Tools -- Conclusion -- Chapter 2: Accessing and Retrieving Data -- Technical Requirements -- Viewing and Analyzing M Functions -- Managing Queries and Data Sources -- Using DirectQuery -- Importing Data -- Applying Multiple Filters -- Selecting and Renaming Columns -- Transforming and Cleansing Data -- Creating Custom Columns -- Combining and Merging Queries -- Selecting Column Data Types -- Visualizing the M library -- Profiling Source Data -- Diagnosing Queries -- Conclusion -- Chapter 3: Building a Power BI Data Model -- Technical Requirements -- Designing a Data Model -- Implementing a Data Model -- Creating Relationships -- Configuring Model Metadata -- Hiding Columns and Tables -- Enriching a Model with DAX -- Supporting Virtual Table Relationships -- Creating Hierarchies and Groups -- Designing Column Level Security -- Leveraging Aggregation Tables -- Conclusion -- Chapter 4: Authoring Power BI Reports -- Technical Requirements -- Building Rich and Intuitive Reports -- Filtering at Different Scopes -- Integrating Card visualizations -- Using Slicers -- Controlling Visual Interactions -- Utilizing Graphical Visualizations -- Creating Table and Matrix visuals -- Enhancing Reports -- Formatting Reports for Publication -- Designing Mobile Layouts -- Creating Paginated Reports -- Conclusion -- Chapter 5: Working in the Service -- Technical Requirements -- Building a Dashboard -- Preparing for Q& -- A -- Adding Alerts and Subscriptions -- Deploying Content from Excel and SSRS -- Streaming Datasets -- Authoring Dataflows Conclusion -- Chapter 6: Getting Serious with Date Intelligence -- Technical Requirements -- Building a Date Dimension Table -- Preparing the Date Dimension via the Query Editor -- Authoring Date Intelligence Measures -- Developing Advanced Date Intelligence Measures -- Simplifying Date Intelligence with DAX and Calculated Tables -- Leveraging Calculation Groups -- Conclusion -- Chapter 7: Parameterizing Power BI Solutions -- Technical requirements -- Filtering reports dynamically -- Leveraging query parameters -- Working with templates -- Converting static queries to dynamic functions -- Capturing user selections with parameter tables -- Forecasting with what-if analysis -- Conclusion -- Chapter 8: Implementing Dynamic User-Based Visibility in Power BI -- Technical Requirements -- Capturing Current User Context -- Defining RLS Roles and Filter Expressions -- Designing Dynamic Security Models -- Building Dynamic Security for DirectQuery -- Displaying the Current Filter Context -- Avoiding Manual User Clicks -- Conclusion -- Chapter 9: Applying Advanced Analytics and Custom Visuals -- Technical Requirements -- Incorporating Advanced Analytics -- Enriching Content with Custom Visuals and Quick Insights -- Creating Geospatial Mapping with ArcGIS Maps -- Democratizing Artificial Intelligence -- Building Animation and Storytelling -- Embedding Statistical Analyses -- Grouping and Binning -- Detecting and Analyzing Clusters -- Forecasting and Anomaly Detection -- Using R and Python Visuals -- Conclusion -- Chapter 10: Administering and Monitoring Power BI -- Technical requirements -- Creating a centralized IT monitoring solution with Power BI -- Constructing a monitoring, visualization, and analysis layer -- Importing and visualizing dynamic management view (DMV) data -- Increasing DBA productivity -- Providing documentation Analyzing SSAS tabular databases and gateways -- Analyzing Extended Events -- Visualizing log file data -- Leveraging the Power BI PowerShell Module -- Conclusion -- Chapter 11: Enhancing and Optimizing Existing Power BI Solutions -- Technical Requirements -- Enhancing Data Model Scalability and Usability -- Improving DAX Measure Performance -- Pushing Query Processing Back to Source Systems -- Strengthening Data Import and Integration Processes -- Isolating and Documenting DAX Expressions -- Improving Data Load Speeds with Incremental Refresh -- Conclusion -- Chapter 12: Deploying and Distributing Power BI Content -- Technical Requirements -- Preparing for Content Creation and Collaboration -- Managing Content between Environments -- Sharing Content with Colleagues -- Configuring Workspaces -- Configuring On-Premises Gateway Data Connections -- Publishing Apps -- Publishing Reports to the Public Internet -- Enabling the Mobile Experience -- Distributing Content with Teams -- Conclusion -- Chapter 13: Integrating Power BI with Other Applications -- Technical Requirements -- Integrating SSRS and Excel -- Migrating from Power Pivot for Excel Data to Power BI -- Accessing and Analyzing Power BI Datasets in Excel -- Building Power BI Reports into PowerPoint Presentations -- Connecting to Azure Analysis Services -- Integrating with Power Automate and Power Apps -- Leveraging Dataverse and Dynamics 365 -- Connecting Dynamics 365 Finance and Operations and the Power Platform -- Conclusion -- Why subscribe? -- Other Book You May Enjoy -- Index Visualisierung (DE-588)4188417-6 gnd |
| subject_GND | (DE-588)4188417-6 |
| title | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_auth | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_exact_search | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_full | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_fullStr | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_full_unstemmed | Microsoft Power BI Cookbook Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| title_short | Microsoft Power BI Cookbook |
| title_sort | microsoft power bi cookbook gain expertise in power bi with over 90 hands on recipes tips and use cases 2nd edition |
| title_sub | Gain Expertise in Power BI with over 90 Hands-On Recipes, Tips, and Use Cases, 2nd Edition |
| topic | Visualisierung (DE-588)4188417-6 gnd |
| topic_facet | Visualisierung |
| work_keys_str_mv | AT decklergreg microsoftpowerbicookbookgainexpertiseinpowerbiwithover90handsonrecipestipsandusecases2ndedition AT powellbrett microsoftpowerbicookbookgainexpertiseinpowerbiwithover90handsonrecipestipsandusecases2ndedition |