Microsoft Power BI Complete Reference :: Bring Your Data to Life with the Powerful Features of Microsoft Power BI.
The Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life.
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Weitere Verfasser: | , , , |
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham :
Packt Publishing Ltd,
2018.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | The Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. |
| Beschreibung: | Project discovery and ingestion |
| Beschreibung: | 1 online resource (780 pages) |
| ISBN: | 1789955637 9781789955637 |
Internformat
MARC
| LEADER | 00000cam a2200000Mi 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBU-on1081000272 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.0 | ||
| 006 | m o d | ||
| 007 | cr |n|---||||| | ||
| 008 | 190105s2018 enk o 000 0 eng d | ||
| 040 | |a EBLCP |b eng |e pn |c EBLCP |d MERUC |d YDX |d UKAHL |d DEBBG |d OCLCQ |d RDF |d OCLCO |d OCLCQ |d UAB |d N$T |d OCLCQ |d NLW |d OCLCO |d K6U |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 1080584878 | ||
| 020 | |a 1789955637 | ||
| 020 | |a 9781789955637 |q (electronic bk.) | ||
| 035 | |a (OCoLC)1081000272 |z (OCoLC)1080584878 | ||
| 050 | 4 | |a HF5548.4.M523 |b .K554 2018 | |
| 082 | 7 | |a 005.369 | |
| 049 | |a MAIN | ||
| 100 | 1 | |a Knight, Devin. | |
| 245 | 1 | 0 | |a Microsoft Power BI Complete Reference : |b Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| 260 | |a Birmingham : |b Packt Publishing Ltd, |c 2018. | ||
| 300 | |a 1 online resource (780 pages) | ||
| 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; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Getting Started with Importing Data Options; Getting started; Importing data; Excel as a source; SQL Server as a source; Web as a source; DirectQuery; Limitations; Live Connection; Limitations; Which should I choose?; Summary; Chapter 2: Data Transformation Strategies; The Power Query Editor; Transform basics; Use First Row as Headers; Remove Columns; Change type; Add Column From Examples; Advanced data transformation options; Conditional Columns; Fill Down; Unpivot; Merging Queries | |
| 505 | 8 | |a Appending QueriesLeveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships; Editing relationships; Creating a new relationship ; Working with complex relationships; Many-to-many relationships; Cross-filtering direction; Enabling filtering from the many side of a relationship; Role-playing tables; Importing the date table; Usability enhancements; Hiding tables and columns; Renaming tables and columns; Default summarization; How to display one column but sort by another | |
| 505 | 8 | |a Data categorizationCreating hierarchies; Summary; Chapter 4: Leveraging DAX; Building calculated columns; String functions -- Month, Year; Format function -- Month Year; Age calculation; SWITCH() -- age breakdown; Navigation functions -- RELATED; Calculated measures -- the basics; Calculated measure -- basic aggregations; Total Sales; Total Cost; Profit; Profit Margin; Optional parameters; Filter context; Calculate; Percentage of total calculation; Time intelligence; Year to Date Sales; YTD Sales (Fiscal Calendar); Prior Year Sales ; Summary; Chapter 5: Visualizing Data; Data visualization basics | |
| 505 | 8 | |a Visuals for filteringInteractive filtering; The Slicer visual; Visualizing tabular data; The table visual; The Matrix visual; Visualizing categorical data; Bar and Column charts; Pie and Donut charts; The Treemap visual; The Scatter chart; Visualizing trend data; Line and Area charts; Combo charts; The Ribbon Chart; The Waterfall Chart; The Funnel Chart; Visualizing KPI data; The Gauge visual; The KPI visual; Visualizing geographical data; The Map visual; The Filled Map visual; The Shape Map visual; The ArcGIS Map visual; Leveraging Power BI custom visuals; Data visualization tips and tricks | |
| 505 | 8 | |a Edit interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Using a Cloud Deployment with the Power BI Service; Deploying to the Power BI service; DATASETS; WORKBOOKS; Creating and interacting with dashboards; Creating your first dashboard; Asking your dashboard a question; Subscribing to reports and dashboards; Sharing your dashboards; Workspaces; Setting up row-level security; Scheduling data refreshes; Summary; Chapter 7: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode | |
| 500 | |a Project discovery and ingestion | ||
| 520 | |a The Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. | ||
| 630 | 0 | 0 | |a Microsoft Power BI (Computer file) |0 http://id.loc.gov/authorities/names/n2020003664 |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |
| 630 | 0 | 7 | |a Microsoft PowerPivot (Computer file) |2 fast |
| 650 | 0 | |a Business intelligence |x Computer programs. | |
| 650 | 0 | |a Information visualization |x Computer programs. | |
| 650 | 6 | |a Visualisation de l'information |x Logiciels. | |
| 650 | 7 | |a Operational research. |2 bicssc | |
| 650 | 7 | |a Data capture & analysis. |2 bicssc | |
| 650 | 7 | |a Information visualization. |2 bicssc | |
| 650 | 7 | |a Enterprise software. |2 bicssc | |
| 650 | 7 | |a Computers |x Data Processing. |2 bisacsh | |
| 650 | 7 | |a Computers |x Enterprise Applications |x Business Intelligence Tools. |2 bisacsh | |
| 650 | 7 | |a Business |x Data processing |2 fast | |
| 650 | 7 | |a Visual analytics |2 fast | |
| 700 | 1 | |a Knight, Brian. | |
| 700 | 1 | |a Pearson, Mitchell. | |
| 700 | 1 | |a Quintana, Manuel. | |
| 700 | 1 | |a Powell, Brett. | |
| 758 | |i has work: |a Microsoft Power BI complete reference (Text) |1 https://id.oclc.org/worldcat/entity/E39PCFRPGd8pmqQWKqrbYbMByd |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Knight, Devin. |t Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |d Birmingham : Packt Publishing Ltd, ©2018 |z 9781789950045 |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBU |q FWS_PDA_EBU |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1991797 |3 Volltext |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH35804887 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5626924 | ||
| 938 | |a EBSCOhost |b EBSC |n 1991797 | ||
| 938 | |a YBP Library Services |b YANK |n 15914151 | ||
| 994 | |a 92 |b GEBAY | ||
| 912 | |a ZDB-4-EBU | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBU-on1081000272 |
|---|---|
| _version_ | 1816796932857659393 |
| adam_text | |
| any_adam_object | |
| author | Knight, Devin |
| author2 | Knight, Brian Pearson, Mitchell Quintana, Manuel Powell, Brett |
| author2_role | |
| author2_variant | b k bk m p mp m q mq b p bp |
| author_facet | Knight, Devin Knight, Brian Pearson, Mitchell Quintana, Manuel Powell, Brett |
| author_role | |
| author_sort | Knight, Devin |
| author_variant | d k dk |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | H - Social Science |
| callnumber-label | HF5548 |
| callnumber-raw | HF5548.4.M523 .K554 2018 |
| callnumber-search | HF5548.4.M523 .K554 2018 |
| callnumber-sort | HF 45548.4 M523 K554 42018 |
| callnumber-subject | HF - Commerce |
| collection | ZDB-4-EBU |
| contents | Cover; Title Page; Copyright; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Getting Started with Importing Data Options; Getting started; Importing data; Excel as a source; SQL Server as a source; Web as a source; DirectQuery; Limitations; Live Connection; Limitations; Which should I choose?; Summary; Chapter 2: Data Transformation Strategies; The Power Query Editor; Transform basics; Use First Row as Headers; Remove Columns; Change type; Add Column From Examples; Advanced data transformation options; Conditional Columns; Fill Down; Unpivot; Merging Queries Appending QueriesLeveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships; Editing relationships; Creating a new relationship ; Working with complex relationships; Many-to-many relationships; Cross-filtering direction; Enabling filtering from the many side of a relationship; Role-playing tables; Importing the date table; Usability enhancements; Hiding tables and columns; Renaming tables and columns; Default summarization; How to display one column but sort by another Data categorizationCreating hierarchies; Summary; Chapter 4: Leveraging DAX; Building calculated columns; String functions -- Month, Year; Format function -- Month Year; Age calculation; SWITCH() -- age breakdown; Navigation functions -- RELATED; Calculated measures -- the basics; Calculated measure -- basic aggregations; Total Sales; Total Cost; Profit; Profit Margin; Optional parameters; Filter context; Calculate; Percentage of total calculation; Time intelligence; Year to Date Sales; YTD Sales (Fiscal Calendar); Prior Year Sales ; Summary; Chapter 5: Visualizing Data; Data visualization basics Visuals for filteringInteractive filtering; The Slicer visual; Visualizing tabular data; The table visual; The Matrix visual; Visualizing categorical data; Bar and Column charts; Pie and Donut charts; The Treemap visual; The Scatter chart; Visualizing trend data; Line and Area charts; Combo charts; The Ribbon Chart; The Waterfall Chart; The Funnel Chart; Visualizing KPI data; The Gauge visual; The KPI visual; Visualizing geographical data; The Map visual; The Filled Map visual; The Shape Map visual; The ArcGIS Map visual; Leveraging Power BI custom visuals; Data visualization tips and tricks Edit interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Using a Cloud Deployment with the Power BI Service; Deploying to the Power BI service; DATASETS; WORKBOOKS; Creating and interacting with dashboards; Creating your first dashboard; Asking your dashboard a question; Subscribing to reports and dashboards; Sharing your dashboards; Workspaces; Setting up row-level security; Scheduling data refreshes; Summary; Chapter 7: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode |
| ctrlnum | (OCoLC)1081000272 |
| dewey-full | 005.369 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.369 |
| dewey-search | 005.369 |
| dewey-sort | 15.369 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06083cam a2200685Mi 4500</leader><controlfield tag="001">ZDB-4-EBU-on1081000272</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">190105s2018 enk o 000 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">EBLCP</subfield><subfield code="b">eng</subfield><subfield code="e">pn</subfield><subfield code="c">EBLCP</subfield><subfield code="d">MERUC</subfield><subfield code="d">YDX</subfield><subfield code="d">UKAHL</subfield><subfield code="d">DEBBG</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">RDF</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">UAB</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">NLW</subfield><subfield code="d">OCLCO</subfield><subfield code="d">K6U</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">1080584878</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1789955637</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781789955637</subfield><subfield code="q">(electronic bk.)</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1081000272</subfield><subfield code="z">(OCoLC)1080584878</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">HF5548.4.M523</subfield><subfield code="b">.K554 2018</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.369</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Knight, Devin.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Microsoft Power BI Complete Reference :</subfield><subfield code="b">Bring Your Data to Life with the Powerful Features of Microsoft Power BI.</subfield></datafield><datafield tag="260" ind1=" " ind2=" "><subfield code="a">Birmingham :</subfield><subfield code="b">Packt Publishing Ltd,</subfield><subfield code="c">2018.</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (780 pages)</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; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Getting Started with Importing Data Options; Getting started; Importing data; Excel as a source; SQL Server as a source; Web as a source; DirectQuery; Limitations; Live Connection; Limitations; Which should I choose?; Summary; Chapter 2: Data Transformation Strategies; The Power Query Editor; Transform basics; Use First Row as Headers; Remove Columns; Change type; Add Column From Examples; Advanced data transformation options; Conditional Columns; Fill Down; Unpivot; Merging Queries</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Appending QueriesLeveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships; Editing relationships; Creating a new relationship ; Working with complex relationships; Many-to-many relationships; Cross-filtering direction; Enabling filtering from the many side of a relationship; Role-playing tables; Importing the date table; Usability enhancements; Hiding tables and columns; Renaming tables and columns; Default summarization; How to display one column but sort by another</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Data categorizationCreating hierarchies; Summary; Chapter 4: Leveraging DAX; Building calculated columns; String functions -- Month, Year; Format function -- Month Year; Age calculation; SWITCH() -- age breakdown; Navigation functions -- RELATED; Calculated measures -- the basics; Calculated measure -- basic aggregations; Total Sales; Total Cost; Profit; Profit Margin; Optional parameters; Filter context; Calculate; Percentage of total calculation; Time intelligence; Year to Date Sales; YTD Sales (Fiscal Calendar); Prior Year Sales ; Summary; Chapter 5: Visualizing Data; Data visualization basics</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Visuals for filteringInteractive filtering; The Slicer visual; Visualizing tabular data; The table visual; The Matrix visual; Visualizing categorical data; Bar and Column charts; Pie and Donut charts; The Treemap visual; The Scatter chart; Visualizing trend data; Line and Area charts; Combo charts; The Ribbon Chart; The Waterfall Chart; The Funnel Chart; Visualizing KPI data; The Gauge visual; The KPI visual; Visualizing geographical data; The Map visual; The Filled Map visual; The Shape Map visual; The ArcGIS Map visual; Leveraging Power BI custom visuals; Data visualization tips and tricks</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Edit interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Using a Cloud Deployment with the Power BI Service; Deploying to the Power BI service; DATASETS; WORKBOOKS; Creating and interacting with dashboards; Creating your first dashboard; Asking your dashboard a question; Subscribing to reports and dashboards; Sharing your dashboards; Workspaces; Setting up row-level security; Scheduling data refreshes; Summary; Chapter 7: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Project discovery and ingestion</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">The Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life.</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">Microsoft Power BI (Computer file)</subfield><subfield code="0">http://id.loc.gov/authorities/names/n2020003664</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">Microsoft PowerPivot (Computer file)</subfield><subfield code="2">fast</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="6"><subfield code="a">Visualisation de l'information</subfield><subfield code="x">Logiciels.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Operational research.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data capture & analysis.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Information visualization.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Enterprise software.</subfield><subfield code="2">bicssc</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Computers</subfield><subfield code="x">Data Processing.</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">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="700" ind1="1" ind2=" "><subfield code="a">Knight, Brian.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Pearson, Mitchell.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Quintana, Manuel.</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Powell, Brett.</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">Microsoft Power BI complete reference (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PCFRPGd8pmqQWKqrbYbMByd</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Knight, Devin.</subfield><subfield code="t">Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI.</subfield><subfield code="d">Birmingham : Packt Publishing Ltd, ©2018</subfield><subfield code="z">9781789950045</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBU</subfield><subfield code="q">FWS_PDA_EBU</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1991797</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">AH35804887</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest Ebook Central</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL5626924</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">1991797</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">15914151</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-EBU</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBU-on1081000272 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-26T14:49:32Z |
| institution | BVB |
| isbn | 1789955637 9781789955637 |
| language | English |
| oclc_num | 1081000272 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (780 pages) |
| psigel | ZDB-4-EBU |
| publishDate | 2018 |
| publishDateSearch | 2018 |
| publishDateSort | 2018 |
| publisher | Packt Publishing Ltd, |
| record_format | marc |
| spelling | Knight, Devin. Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. Birmingham : Packt Publishing Ltd, 2018. 1 online resource (780 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier Print version record. Cover; Title Page; Copyright; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Getting Started with Importing Data Options; Getting started; Importing data; Excel as a source; SQL Server as a source; Web as a source; DirectQuery; Limitations; Live Connection; Limitations; Which should I choose?; Summary; Chapter 2: Data Transformation Strategies; The Power Query Editor; Transform basics; Use First Row as Headers; Remove Columns; Change type; Add Column From Examples; Advanced data transformation options; Conditional Columns; Fill Down; Unpivot; Merging Queries Appending QueriesLeveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships; Editing relationships; Creating a new relationship ; Working with complex relationships; Many-to-many relationships; Cross-filtering direction; Enabling filtering from the many side of a relationship; Role-playing tables; Importing the date table; Usability enhancements; Hiding tables and columns; Renaming tables and columns; Default summarization; How to display one column but sort by another Data categorizationCreating hierarchies; Summary; Chapter 4: Leveraging DAX; Building calculated columns; String functions -- Month, Year; Format function -- Month Year; Age calculation; SWITCH() -- age breakdown; Navigation functions -- RELATED; Calculated measures -- the basics; Calculated measure -- basic aggregations; Total Sales; Total Cost; Profit; Profit Margin; Optional parameters; Filter context; Calculate; Percentage of total calculation; Time intelligence; Year to Date Sales; YTD Sales (Fiscal Calendar); Prior Year Sales ; Summary; Chapter 5: Visualizing Data; Data visualization basics Visuals for filteringInteractive filtering; The Slicer visual; Visualizing tabular data; The table visual; The Matrix visual; Visualizing categorical data; Bar and Column charts; Pie and Donut charts; The Treemap visual; The Scatter chart; Visualizing trend data; Line and Area charts; Combo charts; The Ribbon Chart; The Waterfall Chart; The Funnel Chart; Visualizing KPI data; The Gauge visual; The KPI visual; Visualizing geographical data; The Map visual; The Filled Map visual; The Shape Map visual; The ArcGIS Map visual; Leveraging Power BI custom visuals; Data visualization tips and tricks Edit interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Using a Cloud Deployment with the Power BI Service; Deploying to the Power BI service; DATASETS; WORKBOOKS; Creating and interacting with dashboards; Creating your first dashboard; Asking your dashboard a question; Subscribing to reports and dashboards; Sharing your dashboards; Workspaces; Setting up row-level security; Scheduling data refreshes; Summary; Chapter 7: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode Project discovery and ingestion The Microsoft Power BI Complete Reference Guide gets you started with business intelligence by showing you how to install the Power BI toolset, design effective data models, and build basic dashboards and visualizations that make your data come to life. Microsoft Power BI (Computer file) http://id.loc.gov/authorities/names/n2020003664 Microsoft Excel (Computer file) fast Microsoft PowerPivot (Computer file) fast Business intelligence Computer programs. Information visualization Computer programs. Visualisation de l'information Logiciels. Operational research. bicssc Data capture & analysis. bicssc Information visualization. bicssc Enterprise software. bicssc Computers Data Processing. bisacsh Computers Enterprise Applications Business Intelligence Tools. bisacsh Business Data processing fast Visual analytics fast Knight, Brian. Pearson, Mitchell. Quintana, Manuel. Powell, Brett. has work: Microsoft Power BI complete reference (Text) https://id.oclc.org/worldcat/entity/E39PCFRPGd8pmqQWKqrbYbMByd https://id.oclc.org/worldcat/ontology/hasWork Print version: Knight, Devin. Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. Birmingham : Packt Publishing Ltd, ©2018 9781789950045 FWS01 ZDB-4-EBU FWS_PDA_EBU https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1991797 Volltext |
| spellingShingle | Knight, Devin Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. Cover; Title Page; Copyright; About Packt; Contributors; Table of Contents; Preface; Chapter 1: Getting Started with Importing Data Options; Getting started; Importing data; Excel as a source; SQL Server as a source; Web as a source; DirectQuery; Limitations; Live Connection; Limitations; Which should I choose?; Summary; Chapter 2: Data Transformation Strategies; The Power Query Editor; Transform basics; Use First Row as Headers; Remove Columns; Change type; Add Column From Examples; Advanced data transformation options; Conditional Columns; Fill Down; Unpivot; Merging Queries Appending QueriesLeveraging R; Installation and configuration; The R Script transform; M formula language; #shared; Summary; Chapter 3: Building the Data Model; Building relationships; Editing relationships; Creating a new relationship ; Working with complex relationships; Many-to-many relationships; Cross-filtering direction; Enabling filtering from the many side of a relationship; Role-playing tables; Importing the date table; Usability enhancements; Hiding tables and columns; Renaming tables and columns; Default summarization; How to display one column but sort by another Data categorizationCreating hierarchies; Summary; Chapter 4: Leveraging DAX; Building calculated columns; String functions -- Month, Year; Format function -- Month Year; Age calculation; SWITCH() -- age breakdown; Navigation functions -- RELATED; Calculated measures -- the basics; Calculated measure -- basic aggregations; Total Sales; Total Cost; Profit; Profit Margin; Optional parameters; Filter context; Calculate; Percentage of total calculation; Time intelligence; Year to Date Sales; YTD Sales (Fiscal Calendar); Prior Year Sales ; Summary; Chapter 5: Visualizing Data; Data visualization basics Visuals for filteringInteractive filtering; The Slicer visual; Visualizing tabular data; The table visual; The Matrix visual; Visualizing categorical data; Bar and Column charts; Pie and Donut charts; The Treemap visual; The Scatter chart; Visualizing trend data; Line and Area charts; Combo charts; The Ribbon Chart; The Waterfall Chart; The Funnel Chart; Visualizing KPI data; The Gauge visual; The KPI visual; Visualizing geographical data; The Map visual; The Filled Map visual; The Shape Map visual; The ArcGIS Map visual; Leveraging Power BI custom visuals; Data visualization tips and tricks Edit interactionsThe Analytics pane; The Top N filter; Show value as; Summary; Chapter 6: Using a Cloud Deployment with the Power BI Service; Deploying to the Power BI service; DATASETS; WORKBOOKS; Creating and interacting with dashboards; Creating your first dashboard; Asking your dashboard a question; Subscribing to reports and dashboards; Sharing your dashboards; Workspaces; Setting up row-level security; Scheduling data refreshes; Summary; Chapter 7: Planning Power BI Projects; Power BI deployment modes; Corporate BI; Self-Service Visualization; Self-Service BI; Choosing a deployment mode Microsoft Power BI (Computer file) http://id.loc.gov/authorities/names/n2020003664 Microsoft Excel (Computer file) fast Microsoft PowerPivot (Computer file) fast Business intelligence Computer programs. Information visualization Computer programs. Visualisation de l'information Logiciels. Operational research. bicssc Data capture & analysis. bicssc Information visualization. bicssc Enterprise software. bicssc Computers Data Processing. bisacsh Computers Enterprise Applications Business Intelligence Tools. bisacsh Business Data processing fast Visual analytics fast |
| subject_GND | http://id.loc.gov/authorities/names/n2020003664 |
| title | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_auth | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_exact_search | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_full | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_fullStr | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_full_unstemmed | Microsoft Power BI Complete Reference : Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| title_short | Microsoft Power BI Complete Reference : |
| title_sort | microsoft power bi complete reference bring your data to life with the powerful features of microsoft power bi |
| title_sub | Bring Your Data to Life with the Powerful Features of Microsoft Power BI. |
| topic | Microsoft Power BI (Computer file) http://id.loc.gov/authorities/names/n2020003664 Microsoft Excel (Computer file) fast Microsoft PowerPivot (Computer file) fast Business intelligence Computer programs. Information visualization Computer programs. Visualisation de l'information Logiciels. Operational research. bicssc Data capture & analysis. bicssc Information visualization. bicssc Enterprise software. bicssc Computers Data Processing. bisacsh Computers Enterprise Applications Business Intelligence Tools. bisacsh Business Data processing fast Visual analytics fast |
| topic_facet | Microsoft Power BI (Computer file) Microsoft Excel (Computer file) Microsoft PowerPivot (Computer file) Business intelligence Computer programs. Information visualization Computer programs. Visualisation de l'information Logiciels. Operational research. Data capture & analysis. Information visualization. Enterprise software. Computers Data Processing. Computers Enterprise Applications Business Intelligence Tools. Business Data processing Visual analytics |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=1991797 |
| work_keys_str_mv | AT knightdevin microsoftpowerbicompletereferencebringyourdatatolifewiththepowerfulfeaturesofmicrosoftpowerbi AT knightbrian microsoftpowerbicompletereferencebringyourdatatolifewiththepowerfulfeaturesofmicrosoftpowerbi AT pearsonmitchell microsoftpowerbicompletereferencebringyourdatatolifewiththepowerfulfeaturesofmicrosoftpowerbi AT quintanamanuel microsoftpowerbicompletereferencebringyourdatatolifewiththepowerfulfeaturesofmicrosoftpowerbi AT powellbrett microsoftpowerbicompletereferencebringyourdatatolifewiththepowerfulfeaturesofmicrosoftpowerbi |