Modern data analytics in Excel: using Power Query, Power Pivot, and more for enhanced data analytics
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Beijing
O'Reilly
May 2024
|
| Ausgabe: | First edition |
| Online-Zugang: | DE-1050 |
| Beschreibung: | 1 Online-Ressource (xvi, 224 Seiten) |
| ISBN: | 9781098148799 |
Internformat
MARC
| LEADER | 00000nmm a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV049679022 | ||
| 003 | DE-604 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 240507s2024 |||| o||u| ||||||eng d | ||
| 020 | |a 9781098148799 |9 978-1-098-14879-9 | ||
| 035 | |a (OCoLC)1437843342 | ||
| 035 | |a (DE-599)BVBBV049679022 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1050 | ||
| 100 | 1 | |a Mount, George |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Modern data analytics in Excel |b using Power Query, Power Pivot, and more for enhanced data analytics |c George Mount |
| 250 | |a First edition | ||
| 264 | 1 | |a Beijing |b O'Reilly |c May 2024 | |
| 300 | |a 1 Online-Ressource (xvi, 224 Seiten) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 505 | 8 | |a Cover -- Copyright -- Table of Contents -- Preface -- Learning Objective -- Prerequisites -- Technical Requirements -- Technological Requirements -- How I Got Here -- What Is "Modern Analytics"? Why Excel? -- Book Overview -- Part I, Data Cleaning and Transformation with Power Query -- Part II, Data Modeling and Analysis with Power Pivot -- Part III, The Excel Data Analytics Toolkit -- End-of-Chapter Exercises -- This Is Not a Laundry List -- Conventions Used in This Book -- Using Code Examples -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments | |
| 505 | 8 | |a Part I. Data Cleaning and Transformation with Power Query -- Chapter 1. Tables: The Portal to Modern Excel -- Creating and Referring to Table Headers -- Viewing the Table Footers -- Naming Excel Tables -- Formatting Excel Tables -- Updating Table Ranges -- Organizing Data for Analytics -- Conclusion -- Exercises -- Chapter 2. First Steps in Excel Power Query -- What Is Power Query? -- Power Query as Excel Myth Buster -- "Excel Is Not Reproducible" -- "Excel Does Not Have a True null" -- "Excel Can't Process More Than 1,048,576 Rows" -- Power Query as Excel's ETL Tool -- Extract -- Transform | |
| 505 | 8 | |a Load -- A Tour of the Power Query Editor -- The Ribbon Menu -- Queries -- The Imported Data -- Exiting the Power Query Editor -- Returning to the Power Query Editor -- Data Profiling in Power Query -- What Is Data Profiling? -- Exploring the Data Preview Options -- Overriding the Thousand-Row Limit -- Closing Out of Data Profiling -- Conclusion -- Exercises -- Chapter 3. Transforming Rows in Power Query -- Removing the Missing Values -- Refreshing the Query -- Splitting Data into Rows -- Filling in Headers and Cell Values -- Replacing Column Headers -- Filling Down Blank Rows -- Conclusion | |
| 505 | 8 | |a Exercises -- Chapter 4. Transforming Columns in Power Query -- Changing Column Case -- Delimiting by Column -- Changing Data Types -- Deleting Columns -- Working with Dates -- Creating Custom Columns -- Loading & Inspecting the Data -- Calculated Columns Versus Measures -- Reshaping Data -- Conclusion -- Exercises -- Chapter 5. Merging and Appending Data in Power Query -- Appending Multiple Sources -- Connecting to External Excel Workbooks -- Appending the Queries -- Understanding Relational Joins -- Left Outer Join: Think VLOOKUP() -- Inner Join: Only the Matches -- Managing Your Queries | |
| 505 | 8 | |a Grouping Your Queries -- Viewing Query Dependencies -- Conclusion -- Exercises -- Part II. Data Modeling and Analysis with Power Pivot -- Chapter 6. First Steps in Power Pivot -- What Is Power Pivot? -- Why Power Pivot? -- Power Pivot and the Data Model -- Loading the Power Pivot Add-in -- A Brief Tour of the Power Pivot Add-In -- Data Model -- Calculations -- Tables -- Relationships -- Settings -- Conclusion -- Exercises -- Chapter 7. Creating Relational Models in Power Pivot -- Connecting Data to Power Pivot -- Creating Relationships -- Identifying Fact and Dimension Tables | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |z 978-1-098-14882-9 |
| 912 | |a ZDB-30-PQE | ||
| 966 | e | |u https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31306555 |l DE-1050 |p ZDB-30-PQE |q FHD01_PQE_Kauf |x Aggregator |3 Volltext | |
Datensatz im Suchindex
| _version_ | 1805082310166446080 |
|---|---|
| adam_text | |
| any_adam_object | |
| author | Mount, George |
| author_facet | Mount, George |
| author_role | aut |
| author_sort | Mount, George |
| author_variant | g m gm |
| building | Verbundindex |
| bvnumber | BV049679022 |
| collection | ZDB-30-PQE |
| contents | Cover -- Copyright -- Table of Contents -- Preface -- Learning Objective -- Prerequisites -- Technical Requirements -- Technological Requirements -- How I Got Here -- What Is "Modern Analytics"? Why Excel? -- Book Overview -- Part I, Data Cleaning and Transformation with Power Query -- Part II, Data Modeling and Analysis with Power Pivot -- Part III, The Excel Data Analytics Toolkit -- End-of-Chapter Exercises -- This Is Not a Laundry List -- Conventions Used in This Book -- Using Code Examples -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments Part I. Data Cleaning and Transformation with Power Query -- Chapter 1. Tables: The Portal to Modern Excel -- Creating and Referring to Table Headers -- Viewing the Table Footers -- Naming Excel Tables -- Formatting Excel Tables -- Updating Table Ranges -- Organizing Data for Analytics -- Conclusion -- Exercises -- Chapter 2. First Steps in Excel Power Query -- What Is Power Query? -- Power Query as Excel Myth Buster -- "Excel Is Not Reproducible" -- "Excel Does Not Have a True null" -- "Excel Can't Process More Than 1,048,576 Rows" -- Power Query as Excel's ETL Tool -- Extract -- Transform Load -- A Tour of the Power Query Editor -- The Ribbon Menu -- Queries -- The Imported Data -- Exiting the Power Query Editor -- Returning to the Power Query Editor -- Data Profiling in Power Query -- What Is Data Profiling? -- Exploring the Data Preview Options -- Overriding the Thousand-Row Limit -- Closing Out of Data Profiling -- Conclusion -- Exercises -- Chapter 3. Transforming Rows in Power Query -- Removing the Missing Values -- Refreshing the Query -- Splitting Data into Rows -- Filling in Headers and Cell Values -- Replacing Column Headers -- Filling Down Blank Rows -- Conclusion Exercises -- Chapter 4. Transforming Columns in Power Query -- Changing Column Case -- Delimiting by Column -- Changing Data Types -- Deleting Columns -- Working with Dates -- Creating Custom Columns -- Loading & Inspecting the Data -- Calculated Columns Versus Measures -- Reshaping Data -- Conclusion -- Exercises -- Chapter 5. Merging and Appending Data in Power Query -- Appending Multiple Sources -- Connecting to External Excel Workbooks -- Appending the Queries -- Understanding Relational Joins -- Left Outer Join: Think VLOOKUP() -- Inner Join: Only the Matches -- Managing Your Queries Grouping Your Queries -- Viewing Query Dependencies -- Conclusion -- Exercises -- Part II. Data Modeling and Analysis with Power Pivot -- Chapter 6. First Steps in Power Pivot -- What Is Power Pivot? -- Why Power Pivot? -- Power Pivot and the Data Model -- Loading the Power Pivot Add-in -- A Brief Tour of the Power Pivot Add-In -- Data Model -- Calculations -- Tables -- Relationships -- Settings -- Conclusion -- Exercises -- Chapter 7. Creating Relational Models in Power Pivot -- Connecting Data to Power Pivot -- Creating Relationships -- Identifying Fact and Dimension Tables |
| ctrlnum | (OCoLC)1437843342 (DE-599)BVBBV049679022 |
| edition | First edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nmm a2200000 c 4500</leader><controlfield tag="001">BV049679022</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">240507s2024 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781098148799</subfield><subfield code="9">978-1-098-14879-9</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1437843342</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049679022</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mount, George</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Modern data analytics in Excel</subfield><subfield code="b">using Power Query, Power Pivot, and more for enhanced data analytics</subfield><subfield code="c">George Mount</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">First edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">May 2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Ressource (xvi, 224 Seiten)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Copyright -- Table of Contents -- Preface -- Learning Objective -- Prerequisites -- Technical Requirements -- Technological Requirements -- How I Got Here -- What Is "Modern Analytics"? Why Excel? -- Book Overview -- Part I, Data Cleaning and Transformation with Power Query -- Part II, Data Modeling and Analysis with Power Pivot -- Part III, The Excel Data Analytics Toolkit -- End-of-Chapter Exercises -- This Is Not a Laundry List -- Conventions Used in This Book -- Using Code Examples -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Part I. Data Cleaning and Transformation with Power Query -- Chapter 1. Tables: The Portal to Modern Excel -- Creating and Referring to Table Headers -- Viewing the Table Footers -- Naming Excel Tables -- Formatting Excel Tables -- Updating Table Ranges -- Organizing Data for Analytics -- Conclusion -- Exercises -- Chapter 2. First Steps in Excel Power Query -- What Is Power Query? -- Power Query as Excel Myth Buster -- "Excel Is Not Reproducible" -- "Excel Does Not Have a True null" -- "Excel Can't Process More Than 1,048,576 Rows" -- Power Query as Excel's ETL Tool -- Extract -- Transform</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Load -- A Tour of the Power Query Editor -- The Ribbon Menu -- Queries -- The Imported Data -- Exiting the Power Query Editor -- Returning to the Power Query Editor -- Data Profiling in Power Query -- What Is Data Profiling? -- Exploring the Data Preview Options -- Overriding the Thousand-Row Limit -- Closing Out of Data Profiling -- Conclusion -- Exercises -- Chapter 3. Transforming Rows in Power Query -- Removing the Missing Values -- Refreshing the Query -- Splitting Data into Rows -- Filling in Headers and Cell Values -- Replacing Column Headers -- Filling Down Blank Rows -- Conclusion</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Exercises -- Chapter 4. Transforming Columns in Power Query -- Changing Column Case -- Delimiting by Column -- Changing Data Types -- Deleting Columns -- Working with Dates -- Creating Custom Columns -- Loading & Inspecting the Data -- Calculated Columns Versus Measures -- Reshaping Data -- Conclusion -- Exercises -- Chapter 5. Merging and Appending Data in Power Query -- Appending Multiple Sources -- Connecting to External Excel Workbooks -- Appending the Queries -- Understanding Relational Joins -- Left Outer Join: Think VLOOKUP() -- Inner Join: Only the Matches -- Managing Your Queries</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Grouping Your Queries -- Viewing Query Dependencies -- Conclusion -- Exercises -- Part II. Data Modeling and Analysis with Power Pivot -- Chapter 6. First Steps in Power Pivot -- What Is Power Pivot? -- Why Power Pivot? -- Power Pivot and the Data Model -- Loading the Power Pivot Add-in -- A Brief Tour of the Power Pivot Add-In -- Data Model -- Calculations -- Tables -- Relationships -- Settings -- Conclusion -- Exercises -- Chapter 7. Creating Relational Models in Power Pivot -- Connecting Data to Power Pivot -- Creating Relationships -- Identifying Fact and Dimension Tables</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">978-1-098-14882-9</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-30-PQE</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://ebookcentral.proquest.com/lib/th-deggendorf/detail.action?docID=31306555</subfield><subfield code="l">DE-1050</subfield><subfield code="p">ZDB-30-PQE</subfield><subfield code="q">FHD01_PQE_Kauf</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV049679022 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-20T07:30:38Z |
| institution | BVB |
| isbn | 9781098148799 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-035021845 |
| oclc_num | 1437843342 |
| open_access_boolean | |
| owner | DE-1050 |
| owner_facet | DE-1050 |
| physical | 1 Online-Ressource (xvi, 224 Seiten) |
| psigel | ZDB-30-PQE ZDB-30-PQE FHD01_PQE_Kauf |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Mount, George Verfasser aut Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics George Mount First edition Beijing O'Reilly May 2024 1 Online-Ressource (xvi, 224 Seiten) txt rdacontent c rdamedia cr rdacarrier Cover -- Copyright -- Table of Contents -- Preface -- Learning Objective -- Prerequisites -- Technical Requirements -- Technological Requirements -- How I Got Here -- What Is "Modern Analytics"? Why Excel? -- Book Overview -- Part I, Data Cleaning and Transformation with Power Query -- Part II, Data Modeling and Analysis with Power Pivot -- Part III, The Excel Data Analytics Toolkit -- End-of-Chapter Exercises -- This Is Not a Laundry List -- Conventions Used in This Book -- Using Code Examples -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments Part I. Data Cleaning and Transformation with Power Query -- Chapter 1. Tables: The Portal to Modern Excel -- Creating and Referring to Table Headers -- Viewing the Table Footers -- Naming Excel Tables -- Formatting Excel Tables -- Updating Table Ranges -- Organizing Data for Analytics -- Conclusion -- Exercises -- Chapter 2. First Steps in Excel Power Query -- What Is Power Query? -- Power Query as Excel Myth Buster -- "Excel Is Not Reproducible" -- "Excel Does Not Have a True null" -- "Excel Can't Process More Than 1,048,576 Rows" -- Power Query as Excel's ETL Tool -- Extract -- Transform Load -- A Tour of the Power Query Editor -- The Ribbon Menu -- Queries -- The Imported Data -- Exiting the Power Query Editor -- Returning to the Power Query Editor -- Data Profiling in Power Query -- What Is Data Profiling? -- Exploring the Data Preview Options -- Overriding the Thousand-Row Limit -- Closing Out of Data Profiling -- Conclusion -- Exercises -- Chapter 3. Transforming Rows in Power Query -- Removing the Missing Values -- Refreshing the Query -- Splitting Data into Rows -- Filling in Headers and Cell Values -- Replacing Column Headers -- Filling Down Blank Rows -- Conclusion Exercises -- Chapter 4. Transforming Columns in Power Query -- Changing Column Case -- Delimiting by Column -- Changing Data Types -- Deleting Columns -- Working with Dates -- Creating Custom Columns -- Loading & Inspecting the Data -- Calculated Columns Versus Measures -- Reshaping Data -- Conclusion -- Exercises -- Chapter 5. Merging and Appending Data in Power Query -- Appending Multiple Sources -- Connecting to External Excel Workbooks -- Appending the Queries -- Understanding Relational Joins -- Left Outer Join: Think VLOOKUP() -- Inner Join: Only the Matches -- Managing Your Queries Grouping Your Queries -- Viewing Query Dependencies -- Conclusion -- Exercises -- Part II. Data Modeling and Analysis with Power Pivot -- Chapter 6. First Steps in Power Pivot -- What Is Power Pivot? -- Why Power Pivot? -- Power Pivot and the Data Model -- Loading the Power Pivot Add-in -- A Brief Tour of the Power Pivot Add-In -- Data Model -- Calculations -- Tables -- Relationships -- Settings -- Conclusion -- Exercises -- Chapter 7. Creating Relational Models in Power Pivot -- Connecting Data to Power Pivot -- Creating Relationships -- Identifying Fact and Dimension Tables Erscheint auch als Druck-Ausgabe 978-1-098-14882-9 |
| spellingShingle | Mount, George Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics Cover -- Copyright -- Table of Contents -- Preface -- Learning Objective -- Prerequisites -- Technical Requirements -- Technological Requirements -- How I Got Here -- What Is "Modern Analytics"? Why Excel? -- Book Overview -- Part I, Data Cleaning and Transformation with Power Query -- Part II, Data Modeling and Analysis with Power Pivot -- Part III, The Excel Data Analytics Toolkit -- End-of-Chapter Exercises -- This Is Not a Laundry List -- Conventions Used in This Book -- Using Code Examples -- O'Reilly Online Learning -- How to Contact Us -- Acknowledgments Part I. Data Cleaning and Transformation with Power Query -- Chapter 1. Tables: The Portal to Modern Excel -- Creating and Referring to Table Headers -- Viewing the Table Footers -- Naming Excel Tables -- Formatting Excel Tables -- Updating Table Ranges -- Organizing Data for Analytics -- Conclusion -- Exercises -- Chapter 2. First Steps in Excel Power Query -- What Is Power Query? -- Power Query as Excel Myth Buster -- "Excel Is Not Reproducible" -- "Excel Does Not Have a True null" -- "Excel Can't Process More Than 1,048,576 Rows" -- Power Query as Excel's ETL Tool -- Extract -- Transform Load -- A Tour of the Power Query Editor -- The Ribbon Menu -- Queries -- The Imported Data -- Exiting the Power Query Editor -- Returning to the Power Query Editor -- Data Profiling in Power Query -- What Is Data Profiling? -- Exploring the Data Preview Options -- Overriding the Thousand-Row Limit -- Closing Out of Data Profiling -- Conclusion -- Exercises -- Chapter 3. Transforming Rows in Power Query -- Removing the Missing Values -- Refreshing the Query -- Splitting Data into Rows -- Filling in Headers and Cell Values -- Replacing Column Headers -- Filling Down Blank Rows -- Conclusion Exercises -- Chapter 4. Transforming Columns in Power Query -- Changing Column Case -- Delimiting by Column -- Changing Data Types -- Deleting Columns -- Working with Dates -- Creating Custom Columns -- Loading & Inspecting the Data -- Calculated Columns Versus Measures -- Reshaping Data -- Conclusion -- Exercises -- Chapter 5. Merging and Appending Data in Power Query -- Appending Multiple Sources -- Connecting to External Excel Workbooks -- Appending the Queries -- Understanding Relational Joins -- Left Outer Join: Think VLOOKUP() -- Inner Join: Only the Matches -- Managing Your Queries Grouping Your Queries -- Viewing Query Dependencies -- Conclusion -- Exercises -- Part II. Data Modeling and Analysis with Power Pivot -- Chapter 6. First Steps in Power Pivot -- What Is Power Pivot? -- Why Power Pivot? -- Power Pivot and the Data Model -- Loading the Power Pivot Add-in -- A Brief Tour of the Power Pivot Add-In -- Data Model -- Calculations -- Tables -- Relationships -- Settings -- Conclusion -- Exercises -- Chapter 7. Creating Relational Models in Power Pivot -- Connecting Data to Power Pivot -- Creating Relationships -- Identifying Fact and Dimension Tables |
| title | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics |
| title_auth | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics |
| title_exact_search | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics |
| title_full | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics George Mount |
| title_fullStr | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics George Mount |
| title_full_unstemmed | Modern data analytics in Excel using Power Query, Power Pivot, and more for enhanced data analytics George Mount |
| title_short | Modern data analytics in Excel |
| title_sort | modern data analytics in excel using power query power pivot and more for enhanced data analytics |
| title_sub | using Power Query, Power Pivot, and more for enhanced data analytics |
| work_keys_str_mv | AT mountgeorge moderndataanalyticsinexcelusingpowerquerypowerpivotandmoreforenhanceddataanalytics |