Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Birmingham, UK
Packt Publishing Ltd.
2023
|
| Ausgabe: | 1st edition. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781803240282/?ar |
| Zusammenfassung: | Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data. Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations. This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You'll also understand how to create powerful and flexible measures using DAX and Cube functions. By the end of this book, you'll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions. |
| Beschreibung: | Includes index. - Description based on print version record |
| Umfang: | 1 Online-Ressource (267 pages) |
| ISBN: | 9781803240282 |
Internformat
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-100066453 | ||
| 003 | DE-627-1 | ||
| 005 | 20240228122113.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240104s2023 xx |||||o 00| ||eng c | ||
| 020 | |a 9781803240282 |9 978-1-80324-028-2 | ||
| 035 | |a (DE-627-1)100066453 | ||
| 035 | |a (DE-599)KEP100066453 | ||
| 035 | |a (ORHE)9781803240282 | ||
| 035 | |a (DE-627-1)100066453 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.54 |2 23/eng/20231205 | |
| 100 | 1 | |a Boateng, Bernard Obeng |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Data modeling with Microsoft Excel |b model and analyze data using Power Pivot, DAX, and Cube functions |c Bernard Obeng Boateng |
| 250 | |a 1st edition. | ||
| 264 | 1 | |a Birmingham, UK |b Packt Publishing Ltd. |c 2023 | |
| 300 | |a 1 Online-Ressource (267 pages) | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 500 | |a Includes index. - Description based on print version record | ||
| 520 | |a Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data. Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations. This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You'll also understand how to create powerful and flexible measures using DAX and Cube functions. By the end of this book, you'll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions. | ||
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Data structures (Computer science) | |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs | |
| 650 | 4 | |a Structures de données (Informatique) | |
| 650 | 4 | |a Tableurs ; Logiciels | |
| 650 | 4 | |a Electronic spreadsheets ; Computer programs | |
| 776 | 1 | |z 1803240288 | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 1803240288 |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781803240282/?ar |m X:ORHE |x Aggregator |z lizenzpflichtig |3 Volltext |
| 912 | |a ZDB-30-ORH | ||
| 951 | |a BO | ||
| 912 | |a ZDB-30-ORH | ||
| 049 | |a DE-91 | ||
Datensatz im Suchindex
| DE-BY-TUM_katkey | ZDB-30-ORH-100066453 |
|---|---|
| _version_ | 1835903252764295168 |
| adam_text | |
| any_adam_object | |
| author | Boateng, Bernard Obeng |
| author_facet | Boateng, Bernard Obeng |
| author_role | aut |
| author_sort | Boateng, Bernard Obeng |
| author_variant | b o b bo bob |
| building | Verbundindex |
| bvnumber | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)100066453 (DE-599)KEP100066453 (ORHE)9781803240282 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | 1st edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02704cam a22004332c 4500</leader><controlfield tag="001">ZDB-30-ORH-100066453</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240228122113.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240104s2023 xx |||||o 00| ||eng c</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781803240282</subfield><subfield code="9">978-1-80324-028-2</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)100066453</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP100066453</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781803240282</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)100066453</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-627</subfield><subfield code="b">ger</subfield><subfield code="c">DE-627</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield><subfield code="2">23/eng/20231205</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Boateng, Bernard Obeng</subfield><subfield code="e">VerfasserIn</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data modeling with Microsoft Excel</subfield><subfield code="b">model and analyze data using Power Pivot, DAX, and Cube functions</subfield><subfield code="c">Bernard Obeng Boateng</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1st edition.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, UK</subfield><subfield code="b">Packt Publishing Ltd.</subfield><subfield code="c">2023</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (267 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">Computermedien</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">Online-Ressource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index. - Description based on print version record</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data. Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations. This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You'll also understand how to create powerful and flexible measures using DAX and Cube functions. By the end of this book, you'll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions.</subfield></datafield><datafield tag="630" ind1="2" ind2="0"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Data structures (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Electronic spreadsheets</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Structures de données (Informatique)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Tableurs ; Logiciels</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Electronic spreadsheets ; Computer programs</subfield></datafield><datafield tag="776" ind1="1" ind2=" "><subfield code="z">1803240288</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="z">1803240288</subfield></datafield><datafield tag="966" ind1="4" ind2="0"><subfield code="l">DE-91</subfield><subfield code="p">ZDB-30-ORH</subfield><subfield code="q">TUM_PDA_ORH</subfield><subfield code="u">https://learning.oreilly.com/library/view/-/9781803240282/?ar</subfield><subfield code="m">X:ORHE</subfield><subfield code="x">Aggregator</subfield><subfield code="z">lizenzpflichtig</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="951" ind1=" " ind2=" "><subfield code="a">BO</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-ORH</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-91</subfield></datafield></record></collection> |
| id | ZDB-30-ORH-100066453 |
| illustrated | Not Illustrated |
| indexdate | 2025-06-25T12:16:19Z |
| institution | BVB |
| isbn | 9781803240282 |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 Online-Ressource (267 pages) |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2023 |
| publishDateSearch | 2023 |
| publishDateSort | 2023 |
| publisher | Packt Publishing Ltd. |
| record_format | marc |
| spelling | Boateng, Bernard Obeng VerfasserIn aut Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions Bernard Obeng Boateng 1st edition. Birmingham, UK Packt Publishing Ltd. 2023 1 Online-Ressource (267 pages) Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier Includes index. - Description based on print version record Microsoft Excel's BI solutions have evolved, offering users more flexibility and control over analyzing data directly in Excel. Features like PivotTables, Data Model, Power Query, and Power Pivot empower Excel users to efficiently get, transform, model, aggregate, and visualize data. Data Modeling with Microsoft Excel offers a practical way to demystify the use and application of these tools using real-world examples and simple illustrations. This book will introduce you to the world of data modeling in Excel, as well as definitions and best practices in data structuring for both normalized and denormalized data. The next set of chapters will take you through the useful features of Data Model and Power Pivot, helping you get to grips with the types of schemas (snowflake and star) and create relationships within multiple tables. You'll also understand how to create powerful and flexible measures using DAX and Cube functions. By the end of this book, you'll be able to apply the acquired knowledge in real-world scenarios and build an interactive dashboard that will help you make important decisions. Microsoft Excel (Computer file) Data structures (Computer science) Electronic spreadsheets Computer programs Structures de données (Informatique) Tableurs ; Logiciels Electronic spreadsheets ; Computer programs 1803240288 Erscheint auch als Druck-Ausgabe 1803240288 |
| spellingShingle | Boateng, Bernard Obeng Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions Microsoft Excel (Computer file) Data structures (Computer science) Electronic spreadsheets Computer programs Structures de données (Informatique) Tableurs ; Logiciels Electronic spreadsheets ; Computer programs |
| title | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions |
| title_auth | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions |
| title_exact_search | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions |
| title_full | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions Bernard Obeng Boateng |
| title_fullStr | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions Bernard Obeng Boateng |
| title_full_unstemmed | Data modeling with Microsoft Excel model and analyze data using Power Pivot, DAX, and Cube functions Bernard Obeng Boateng |
| title_short | Data modeling with Microsoft Excel |
| title_sort | data modeling with microsoft excel model and analyze data using power pivot dax and cube functions |
| title_sub | model and analyze data using Power Pivot, DAX, and Cube functions |
| topic | Microsoft Excel (Computer file) Data structures (Computer science) Electronic spreadsheets Computer programs Structures de données (Informatique) Tableurs ; Logiciels Electronic spreadsheets ; Computer programs |
| topic_facet | Microsoft Excel (Computer file) Data structures (Computer science) Electronic spreadsheets Computer programs Structures de données (Informatique) Tableurs ; Logiciels Electronic spreadsheets ; Computer programs |
| work_keys_str_mv | AT boatengbernardobeng datamodelingwithmicrosoftexcelmodelandanalyzedatausingpowerpivotdaxandcubefunctions |