000 02894cam a22004457i 4500
001 807
003 MYCC
005 20260804144949.0
008 241213t20242024caua 001 0 eng d
010 _a 2024391723
020 _a9781098148829
_qpaperback
020 _a1098148827
_qpaperback
035 _a23951547
035 _a(OCoLC)1404056203
040 _aYDX
_beng
_erda
_cYDX
_dOCLCO
_dBDX
_dOCLCQ
_dTMI
_dOPW
_dOCLCO
_dTMI
_dYDX
_dWZW
_dOCLCO
_dDLC
_dMYCC
042 _alccopycat
050 0 0 _aHF5548.4.M523
_bM68 2024
082 0 4 _a005.54
_223
100 1 _aMount, George
_c(Writer on data analytics),
_eauthor.
245 1 0 _aModern Data Analytics in Excel :
_bUsing Power Query, Power Pivot, and more for Enhanced Data Analytics /
_cGeorge Mount.
250 _aFirst edition.
264 1 _aSebastopol, CA :
_bO'Reilly Media, Inc.,
_c2024.
264 4 _c©2024
300 _axvi, 224 pages :
_billustrations ;
_c24 cm
336 _atext
_btxt
_2rdacontent
337 _aunmediated
_bn
_2rdamedia
338 _avolume
_bnc
_2rdacarrier
500 _aIncludes index.
500 _aIncludes exercise.
520 _aIf 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 0 0 _aMicrosoft Excel (Computer file)
650 0 _aElectronic spreadsheets
_xComputer programs.
650 0 _aBusiness
_xComputer programs.
650 6 _aTableurs
_xLogiciels.
655 7 _aInstructional and educational works.
_2lcgft
655 7 _aMatériel d'éducation et de formation.
_2rvmgf
906 _a7
_bcbc
_ccopycat
_d2
_encip
_f20
_gy-gencatlg
942 _2ddc
_cBK
999 _c807
_d807