Modern data analytics in Excel:
If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to th...
Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | Englisch |
| Veröffentlicht: |
Sebastopol, CA
O'Reilly Media, Inc.
2024
|
| Ausgabe: | First edition. |
| Schlagwörter: | |
| Links: | https://learning.oreilly.com/library/view/-/9781098148812/?ar |
| Zusammenfassung: | If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. George Mount of Stringfest Analytics shows business analysts, data analysts, and business intelligence specialists how to make bigger gains right from your spreadsheets by using Excel's latest features. You'll learn how to build repeatable data cleaning workflows with Power Query, and design relational data models straight from your workbook with Power Pivot. You'll also explore other exciting new features for analytics, such as dynamic array functions, AI-powered insights, and Python integration. Learn how to build reports and analyses that were previously difficult or impossible to do in Excel. This book shows you how to: Build repeatable data cleaning processes for Excel with Power Query Create relational data models and analysis measures with Power Pivot Pull data quickly with dynamic arrays Use AI to uncover patterns and trends from inside Excel Integrate Python functionality with Excel for automated analysis and reporting. |
| Umfang: | 1 online resource (300 pages) illustrations |
Internformat
MARC
| LEADER | 00000cam a22000002c 4500 | ||
|---|---|---|---|
| 001 | ZDB-30-ORH-100860516 | ||
| 003 | DE-627-1 | ||
| 005 | 20240603113704.0 | ||
| 007 | cr uuu---uuuuu | ||
| 008 | 240227s2024 xx |||||o 00| ||eng c | ||
| 035 | |a (DE-627-1)100860516 | ||
| 035 | |a (DE-599)KEP100860516 | ||
| 035 | |a (ORHE)9781098148812 | ||
| 035 | |a (DE-627-1)100860516 | ||
| 040 | |a DE-627 |b ger |c DE-627 |e rda | ||
| 041 | |a eng | ||
| 082 | 0 | |a 005.54 |2 23/eng/20240213 | |
| 100 | 1 | |a Mount, George |e VerfasserIn |4 aut | |
| 245 | 1 | 0 | |a Modern data analytics in Excel |c George Mount |
| 250 | |a First edition. | ||
| 264 | 1 | |a Sebastopol, CA |b O'Reilly Media, Inc. |c 2024 | |
| 300 | |a 1 online resource (300 pages) |b illustrations | ||
| 336 | |a Text |b txt |2 rdacontent | ||
| 337 | |a Computermedien |b c |2 rdamedia | ||
| 338 | |a Online-Ressource |b cr |2 rdacarrier | ||
| 520 | |a If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. George Mount of Stringfest Analytics shows business analysts, data analysts, and business intelligence specialists how to make bigger gains right from your spreadsheets by using Excel's latest features. You'll learn how to build repeatable data cleaning workflows with Power Query, and design relational data models straight from your workbook with Power Pivot. You'll also explore other exciting new features for analytics, such as dynamic array functions, AI-powered insights, and Python integration. Learn how to build reports and analyses that were previously difficult or impossible to do in Excel. This book shows you how to: Build repeatable data cleaning processes for Excel with Power Query Create relational data models and analysis measures with Power Pivot Pull data quickly with dynamic arrays Use AI to uncover patterns and trends from inside Excel Integrate Python functionality with Excel for automated analysis and reporting. | ||
| 630 | 2 | 0 | |a Microsoft Excel (Computer file) |
| 650 | 0 | |a Electronic spreadsheets |x Computer programs | |
| 650 | 0 | |a Business |x Computer programs | |
| 966 | 4 | 0 | |l DE-91 |p ZDB-30-ORH |q TUM_PDA_ORH |u https://learning.oreilly.com/library/view/-/9781098148812/?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-100860516 |
|---|---|
| _version_ | 1833357140219133952 |
| 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 | localTUM |
| collection | ZDB-30-ORH |
| ctrlnum | (DE-627-1)100860516 (DE-599)KEP100860516 (ORHE)9781098148812 |
| 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 | First edition. |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02451cam a22003492c 4500</leader><controlfield tag="001">ZDB-30-ORH-100860516</controlfield><controlfield tag="003">DE-627-1</controlfield><controlfield tag="005">20240603113704.0</controlfield><controlfield tag="007">cr uuu---uuuuu</controlfield><controlfield tag="008">240227s2024 xx |||||o 00| ||eng c</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)100860516</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)KEP100860516</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ORHE)9781098148812</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-627-1)100860516</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/20240213</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Mount, George</subfield><subfield code="e">VerfasserIn</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="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">Sebastopol, CA</subfield><subfield code="b">O'Reilly Media, Inc.</subfield><subfield code="c">2024</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (300 pages)</subfield><subfield code="b">illustrations</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="520" ind1=" " ind2=" "><subfield code="a">If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. George Mount of Stringfest Analytics shows business analysts, data analysts, and business intelligence specialists how to make bigger gains right from your spreadsheets by using Excel's latest features. You'll learn how to build repeatable data cleaning workflows with Power Query, and design relational data models straight from your workbook with Power Pivot. You'll also explore other exciting new features for analytics, such as dynamic array functions, AI-powered insights, and Python integration. Learn how to build reports and analyses that were previously difficult or impossible to do in Excel. This book shows you how to: Build repeatable data cleaning processes for Excel with Power Query Create relational data models and analysis measures with Power Pivot Pull data quickly with dynamic arrays Use AI to uncover patterns and trends from inside Excel Integrate Python functionality with Excel for automated analysis and reporting.</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">Electronic spreadsheets</subfield><subfield code="x">Computer programs</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Business</subfield><subfield code="x">Computer programs</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/-/9781098148812/?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-100860516 |
| illustrated | Illustrated |
| indexdate | 2025-05-28T09:46:57Z |
| institution | BVB |
| language | English |
| open_access_boolean | |
| owner | DE-91 DE-BY-TUM |
| owner_facet | DE-91 DE-BY-TUM |
| physical | 1 online resource (300 pages) illustrations |
| psigel | ZDB-30-ORH TUM_PDA_ORH ZDB-30-ORH |
| publishDate | 2024 |
| publishDateSearch | 2024 |
| publishDateSort | 2024 |
| publisher | O'Reilly Media, Inc. |
| record_format | marc |
| spelling | Mount, George VerfasserIn aut Modern data analytics in Excel George Mount First edition. Sebastopol, CA O'Reilly Media, Inc. 2024 1 online resource (300 pages) illustrations Text txt rdacontent Computermedien c rdamedia Online-Ressource cr rdacarrier If you haven't modernized your data cleaning and reporting processes in Microsoft Excel, you're missing out on big productivity gains. And if you're looking to conduct rigorous data analysis, more can be done in Excel than you think. This practical book serves as an introduction to the modern Excel suite of features along with other powerful tools for analytics. George Mount of Stringfest Analytics shows business analysts, data analysts, and business intelligence specialists how to make bigger gains right from your spreadsheets by using Excel's latest features. You'll learn how to build repeatable data cleaning workflows with Power Query, and design relational data models straight from your workbook with Power Pivot. You'll also explore other exciting new features for analytics, such as dynamic array functions, AI-powered insights, and Python integration. Learn how to build reports and analyses that were previously difficult or impossible to do in Excel. This book shows you how to: Build repeatable data cleaning processes for Excel with Power Query Create relational data models and analysis measures with Power Pivot Pull data quickly with dynamic arrays Use AI to uncover patterns and trends from inside Excel Integrate Python functionality with Excel for automated analysis and reporting. Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs |
| spellingShingle | Mount, George Modern data analytics in Excel Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs |
| title | Modern data analytics in Excel |
| title_auth | Modern data analytics in Excel |
| title_exact_search | Modern data analytics in Excel |
| title_full | Modern data analytics in Excel George Mount |
| title_fullStr | Modern data analytics in Excel George Mount |
| title_full_unstemmed | Modern data analytics in Excel George Mount |
| title_short | Modern data analytics in Excel |
| title_sort | modern data analytics in excel |
| topic | Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs |
| topic_facet | Microsoft Excel (Computer file) Electronic spreadsheets Computer programs Business Computer programs |
| work_keys_str_mv | AT mountgeorge moderndataanalyticsinexcel |