Microsoft Power BI Cookbook.:
Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, UNKNOWN :
Packt Publishing,
2017.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of 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 and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Pow ... |
| Beschreibung: | 1 online resource (786) |
| ISBN: | 1788293789 9781788293785 |
Internformat
MARC
| LEADER | 00000cam a2200000Ma 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-on1005565948 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr |n||||||||| | ||
| 008 | 171006s2017 xx o 000 0 eng d | ||
| 040 | |a IDEBK |b eng |e pn |c IDEBK |d EBLCP |d MERUC |d IDB |d YDX |d COO |d TEFOD |d NLE |d N$T |d OCLCQ |d OCLCF |d INT |d OCLCQ |d UKMGB |d OCLCQ |d UKAHL |d CNCEN |d OCLCQ |d OCLCO |d K6U |d OCLCQ |d OCL |d OCLCO |d OCLCL | ||
| 016 | 7 | |a 018554442 |2 Uk | |
| 019 | |a 1005189050 | ||
| 020 | |a 1788293789 |q (electronic bk.) | ||
| 020 | |a 9781788293785 |q (electronic bk.) | ||
| 020 | |z 1788290143 | ||
| 035 | |a (OCoLC)1005565948 |z (OCoLC)1005189050 | ||
| 037 | |a 1038631 |b MIL | ||
| 037 | |a 4935A1AD-383D-4770-BCD3-AC0800B70961 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a T55.4-60.8 | |
| 072 | 7 | |a CKB |x 000000 |2 bisacsh | |
| 082 | 7 | |a 641.5 |2 23 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Powell, Brett. | |
| 245 | 1 | 0 | |a Microsoft Power BI Cookbook. |
| 260 | |a Birmingham, UNKNOWN : |b Packt Publishing, |c 2017. | ||
| 300 | |a 1 online resource (786) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 588 | 0 | |a Print version record. | |
| 505 | 0 | |a Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration. | |
| 505 | 8 | |a How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ... | |
| 505 | 8 | |a Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ... | |
| 505 | 8 | |a There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ... | |
| 505 | 8 | |a Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example. | |
| 520 | |a Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of 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 and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Pow ... | ||
| 650 | 0 | |a Business intelligence |x Computer programs. | |
| 650 | 0 | |a Information visualization |x Computer programs. | |
| 650 | 0 | |a Business |x Data processing. |0 http://id.loc.gov/authorities/subjects/sh85018264 | |
| 650 | 0 | |a Visual analytics. |0 http://id.loc.gov/authorities/subjects/sh2007004134 | |
| 650 | 0 | |a Management |x Data processing. |0 http://id.loc.gov/authorities/subjects/sh85080339 | |
| 650 | 6 | |a Visualisation de l'information |x Logiciels. | |
| 650 | 6 | |a Gestion |x Informatique. | |
| 650 | 6 | |a Analyse visuelle. | |
| 650 | 7 | |a COMPUTERS |x Data Visualization. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Enterprise Applications |x Business Intelligence Tools. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Enterprise Applications |x General. |2 bisacsh | |
| 650 | 7 | |a COOKING |x General. |2 bisacsh | |
| 650 | 7 | |a Management |x Data processing |2 fast | |
| 650 | 7 | |a Information visualization |x Computer programs |2 fast | |
| 650 | 7 | |a Business |x Data processing |2 fast | |
| 650 | 7 | |a Visual analytics |2 fast | |
| 758 | |i has work: |a MICROSOFT POWER BI COOKBOOK (Text) |1 https://id.oclc.org/worldcat/entity/E39PCXjJppMwyj8x64QJr7GBcd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1607847 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH33464367 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL5061722 | ||
| 938 | |a EBSCOhost |b EBSC |n 1607847 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis38740576 | ||
| 938 | |a YBP Library Services |b YANK |n 14853067 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-on1005565948 |
|---|---|
| _version_ | 1816882402096578561 |
| adam_text | |
| any_adam_object | |
| author | Powell, Brett |
| author_facet | Powell, Brett |
| author_role | |
| author_sort | Powell, Brett |
| author_variant | b p bp |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | T - Technology |
| callnumber-label | T55 |
| callnumber-raw | T55.4-60.8 |
| callnumber-search | T55.4-60.8 |
| callnumber-sort | T 255.4 260.8 |
| callnumber-subject | T - General Technology |
| collection | ZDB-4-EBA |
| contents | Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration. How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ... Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ... There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ... Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example. |
| ctrlnum | (OCoLC)1005565948 |
| dewey-full | 641.5 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 641 - Food and drink |
| dewey-raw | 641.5 |
| dewey-search | 641.5 |
| dewey-sort | 3641.5 |
| dewey-tens | 640 - Home and family management |
| discipline | Agrar-/Forst-/Ernährungs-/Haushaltswissenschaft / Gartenbau |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>08403cam a2200709Ma 4500</leader><controlfield tag="001">ZDB-4-EBA-on1005565948</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr |n|||||||||</controlfield><controlfield tag="008">171006s2017 xx o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">IDEBK</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">IDEBK</subfield><subfield code="d">EBLCP</subfield><subfield code="d">MERUC</subfield><subfield code="d">IDB</subfield><subfield code="d">YDX</subfield><subfield code="d">COO</subfield><subfield code="d">TEFOD</subfield><subfield code="d">NLE</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCF</subfield><subfield code="d">INT</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKMGB</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UKAHL</subfield><subfield code="d">CNCEN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">K6U</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCL</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">018554442</subfield><subfield code="2">Uk</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1005189050</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1788293789</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781788293785</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1788290143</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1005565948</subfield><subfield code="z">(OCoLC)1005189050</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">1038631</subfield><subfield code="b">MIL</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">4935A1AD-383D-4770-BCD3-AC0800B70961</subfield><subfield code="b">OverDrive, Inc.</subfield><subfield code="n">http://www.overdrive.com</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">T55.4-60.8</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">CKB</subfield><subfield code="x">000000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">641.5</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Powell, Brett.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Power BI Cookbook.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham, UNKNOWN :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2017.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (786)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Print version record.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="a">Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration.</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ...</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example.</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of 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 and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Pow ...</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business intelligence</subfield><subfield code="x">Computer programs.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Information visualization</subfield><subfield code="x">Computer programs.</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business</subfield><subfield code="x">Data processing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85018264</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Visual analytics.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh2007004134</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Management</subfield><subfield code="x">Data processing.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85080339</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Visualisation de l'information</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Gestion</subfield><subfield code="x">Informatique.</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Analyse visuelle.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Data Visualization.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Enterprise Applications</subfield><subfield code="x">Business Intelligence Tools.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Enterprise Applications</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COOKING</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Management</subfield><subfield code="x">Data processing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Information visualization</subfield><subfield code="x">Computer programs</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Business</subfield><subfield code="x">Data processing</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Visual analytics</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">MICROSOFT POWER BI COOKBOOK (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCXjJppMwyj8x64QJr7GBcd</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1607847</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">Askews and Holts Library Services</subfield><subfield code="b">ASKH</subfield><subfield code="n">AH33464367</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL5061722</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1607847</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis38740576</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">14853067</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-on1005565948 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:28:02Z |
| institution | BVB |
| isbn | 1788293789 9781788293785 |
| language | English |
| oclc_num | 1005565948 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (786) |
| psigel | ZDB-4-EBA |
| publishDate | 2017 |
| publishDateSearch | 2017 |
| publishDateSort | 2017 |
| publisher | Packt Publishing, |
| record_format | marc |
| spelling | Powell, Brett. Microsoft Power BI Cookbook. Birmingham, UNKNOWN : Packt Publishing, 2017. 1 online resource (786) text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration. How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ... Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ... There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ... Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example. Get more out of Microsoft Power BI turning your data into actionable insights About This Book From connecting to your data sources to developing and deploying immersive, mobile-ready dashboards and visualizations, this book covers it all Over 90 hands-on, technical recipes, tips, and use cases from across the Power BI platform including the Power BI Service and Mobile Applications Proven development techniques and guidance for implementing custom solutions with DAX and M languages Who This Book Is For This book is for BI professionals who wish to enhance their knowledge of Power BI beyond and to enhance the value of the Power BI solutions they deliver to business users. Those who are looking at quick solutions to common problems while using Power BI will also find this book to be a very useful resource .Some experience with Power BI will be useful. What You Will Learn Cleanse, stage, and integrate your data sources with Power BI Abstract data complexities and provide users with intuitive, self-service BI capabilities Build business logic and analysis into your solutions via the DAX programming language and dynamic, dashboard-ready calculations Take advantage of the analytics and predictive capabilities of Power BI Make your solutions more dynamic and user specific and/or defined including use cases of parameters, functions, and row level security Understand the differences and implications of DirectQuery, Live Connections, and Import-Mode Power BI datasets and how to deploy content to the Power BI Service and schedule refreshes Integrate other Microsoft data tools such as Excel and SQL Server Reporting Services into your Power BI solution In Detail Microsoft Power BI is a business intelligence and analytics platform consisting of applications and services designed to provide coherent, visual and interactive insights of 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 and services. Get familiar with Power BI development tools and services, go deep into the data connectivity and transformation, modeling, visualization and analytical capabilities of Power BI, and see Power BI's functional programming languages of DAX and M come alive to deliver powerful solutions to address common, challenging scenarios in business intelligence. This book will excite and empower you to get more out of Pow ... Business intelligence Computer programs. Information visualization Computer programs. Business Data processing. http://id.loc.gov/authorities/subjects/sh85018264 Visual analytics. http://id.loc.gov/authorities/subjects/sh2007004134 Management Data processing. http://id.loc.gov/authorities/subjects/sh85080339 Visualisation de l'information Logiciels. Gestion Informatique. Analyse visuelle. COMPUTERS Data Visualization. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Enterprise Applications General. bisacsh COOKING General. bisacsh Management Data processing fast Information visualization Computer programs fast Business Data processing fast Visual analytics fast has work: MICROSOFT POWER BI COOKBOOK (Text) https://id.oclc.org/worldcat/entity/E39PCXjJppMwyj8x64QJr7GBcd https://id.oclc.org/worldcat/ontology/hasWork FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1607847 Volltext |
| spellingShingle | Powell, Brett Microsoft Power BI Cookbook. Cover; Title Page; Copyright; Credits; Foreword; About the Author; About the Reviewers; www.PacktPub.com; Customer Feedback; Table of Contents; Preface; Chapter 1: Configuring Power BI Development Tools; Introduction; Configuring Power BI Desktop options and settings; Getting ready; How to do it ... ; Installing and running Power BI Desktop; Configuring Power BI Desktop options; How it works ... ; There's more ... ; See also; Power BI's advantages over Excel; Power BI Security and Data Source Privacy; Installing the On-Premises Data Gateway; Getting ready; Hardware and network configuration. How to do it ... Installation of on-premises gateway; How it works ... ; Gateway recovery key; There's more ... ; See also ... ; Installing Power BI Publisher for Excel; How to do it ... ; Installation of Power BI Publisher for Excel; There's more ... ; Installing and Configuring DAX Studio; How to do it ... ; Installation of DAX Studio; Configuration of DAX Studio; How it works ... ; There's more ... ; Guy in a Cube video channel; Chapter 2: Accessing and Retrieving Data; Introduction; Viewing and analyzing M functions; Getting ready; How to do it ... ; Formula Bar; Advanced Editor window; How it works ... Query foldingM query structure; Lazy evaluation; There's more ... ; Partial query folding; Limitations of query folding; See also ... ; M language references; Establishing and managing connections to data sources; Getting ready; How to do it ... ; Isolate data sources from individual queries; Query groups; Manage source credentials and privacy levels; How it works ... ; Data Source settings; Data source privacy settings; There's more ... ; See also; Building source queries for DirectQuery models; Getting ready; How to do it ... ; Applying M transformations with DirectQuery models; How it works ... There's more ... DirectQuery project candidates; DirectQuery performance; See also; Importing data to Power BI Desktop models; How to do it ... ; Denormalize a dimension; Provide automatic sorting; How it works ... ; There's more ... ; One GB dataset limit and Power BI Premium; See also; Applying multiple filtering conditions; Getting ready; How to do it ... ; Query filter example steps; How it works ... ; There's more ... ; Filtering via the Query Editor interface; See also; Choosing columns and column names; How to do it ... ; Identify expensive columns; Select columns; Rename columns; How it works ... Column memory usageThere's more ... ; Fact table column eliminations; Column orders; See also; Transforming and cleansing source data; Getting ready; How to do it ... ; Remove duplicates; Update a column through a join; There's more ... ; See also; Creating custom and conditional columns; How to do it ... ; Create a dynamic banding attribute; Create a formatted name column; Comparing the current and previous rows; How it works ... ; Conditional expression syntax; Case sensitivity; Conditional expression evaluation; Query folding of custom columns; There's more ... ; Add column from example. Business intelligence Computer programs. Information visualization Computer programs. Business Data processing. http://id.loc.gov/authorities/subjects/sh85018264 Visual analytics. http://id.loc.gov/authorities/subjects/sh2007004134 Management Data processing. http://id.loc.gov/authorities/subjects/sh85080339 Visualisation de l'information Logiciels. Gestion Informatique. Analyse visuelle. COMPUTERS Data Visualization. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Enterprise Applications General. bisacsh COOKING General. bisacsh Management Data processing fast Information visualization Computer programs fast Business Data processing fast Visual analytics fast |
| subject_GND | http://id.loc.gov/authorities/subjects/sh85018264 http://id.loc.gov/authorities/subjects/sh2007004134 http://id.loc.gov/authorities/subjects/sh85080339 |
| title | Microsoft Power BI Cookbook. |
| title_auth | Microsoft Power BI Cookbook. |
| title_exact_search | Microsoft Power BI Cookbook. |
| title_full | Microsoft Power BI Cookbook. |
| title_fullStr | Microsoft Power BI Cookbook. |
| title_full_unstemmed | Microsoft Power BI Cookbook. |
| title_short | Microsoft Power BI Cookbook. |
| title_sort | microsoft power bi cookbook |
| topic | Business intelligence Computer programs. Information visualization Computer programs. Business Data processing. http://id.loc.gov/authorities/subjects/sh85018264 Visual analytics. http://id.loc.gov/authorities/subjects/sh2007004134 Management Data processing. http://id.loc.gov/authorities/subjects/sh85080339 Visualisation de l'information Logiciels. Gestion Informatique. Analyse visuelle. COMPUTERS Data Visualization. bisacsh COMPUTERS Enterprise Applications Business Intelligence Tools. bisacsh COMPUTERS Enterprise Applications General. bisacsh COOKING General. bisacsh Management Data processing fast Information visualization Computer programs fast Business Data processing fast Visual analytics fast |
| topic_facet | Business intelligence Computer programs. Information visualization Computer programs. Business Data processing. Visual analytics. Management Data processing. Visualisation de l'information Logiciels. Gestion Informatique. Analyse visuelle. COMPUTERS Data Visualization. COMPUTERS Enterprise Applications Business Intelligence Tools. COMPUTERS Enterprise Applications General. COOKING General. Management Data processing Information visualization Computer programs Business Data processing Visual analytics |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1607847 |
| work_keys_str_mv | AT powellbrett microsoftpowerbicookbook |