LEADER 04790nam  2200697   450 
001 9910808119903321
005 20230731114256.0
010   $a1-119-02144-8
010   $a1-119-18341-3
010   $a1-119-02145-6
035   $a(CKB)3710000000526798
035   $a(EBL)4187166
035   $a(SSID)ssj0001636516
035   $a(PQKBManifestationID)16387376
035   $a(PQKBTitleCode)TC0001636516
035   $a(PQKBWorkID)14950804
035   $a(PQKB)10707684
035   $a(Au-PeEL)EBL4187166
035   $a(CaPaEBR)ebr11128093
035   $a(CaONFJC)MIL879752
035   $a(PPN)194575209
035   $a(CaSebORM)9781119021438
035   $a(MiAaPQ)EBC4187166
035   $a(OCoLC)931864545
035   $a(EXLCZ)993710000000526798
100   $a20151228h20162016  uy             0
101 0 $aeng
135   $aurcnu||||||||
181   $ctxt
182   $cc
183   $acr
200 10$aData analysis using SQL and Excel /$fGordon S. Linoff
205   $aSecond edition.
210  1$aIndianapolis, Indiana :$cWiley,$d2016.
210  4$d©2016
215   $a1 online resource (795 p.)
225 1 $aTHEi Wiley ebooks
300   $aIncludes index.
311   $a1-119-02143-X 
327   $aData Analysis Using SQL and Excel®; About the Author; Credits; Acknowledgments; Contents at a Glance; Contents; Foreword; Introduction; Chapter 1 A Data Miner Looks at SQL; Databases, SQL, and Big Data; What Is Big Data?; Relational Databases; Hadoop and Hive; NoSQL and Other Types of Databases; SQL; Picturing the Structure of the Data; What Is a Data Model?; What Is a Table?; Allowing NULL Values; Column Types; What Is an Entity-Relationship Diagram?; The Zip Code Tables; Subscription Dataset; Purchases Dataset; Tips on Naming Things; Picturing Data Analysis Using Dataflows
327   $aWhat Is a Dataflow? READ: Reading a Database Table; OUTPUT: Outputting a Table (or Chart); SELECT: Selecting Various Columns in the Table; FILTER: Filtering Rows Based on a Condition; APPEND: Appending New Calculated Columns; UNION: Combining Multiple Datasets into One; AGGREGATE: Aggregating Values; LOOKUP: Looking Up Values in One Table in Another; CROSS JOIN: Generating the Cartesian Product of Two Tables; JOIN: Combining Two Tables Using a Key Column; SORT: Ordering the Results of a Dataset; Dataflows, SQL, and Relational Algebra; SQL Queries; What to Do, Not How to Do It
327   $aThe SELECT Statement A Basic SQL Query; A Basic Summary SQL Query; What It Means to Join Tables; Cross-Joins: The Most General Joins; Lookup: A Useful Join; Equijoins; Nonequijoins; Outer Joins; Other Important Capabilities in SQL; UNION ALL; CASE; IN; Window Functions; Subqueries and Common Table Expressions Are Our Friends; Subqueries for Naming Variables; Subqueries for Handling Summaries; Subqueries and IN; Rewriting the "IN" as a JOIN; Correlated Subqueries; NOT IN Operator; EXISTS and NOT EXISTS Operators; Subqueries for UNION ALL; Lessons Learned
327   $aChapter 2 What's in a Table? Getting Started with Data Exploration What Is Data Exploration?; Excel for Charting; A Basic Chart: Column Charts; Inserting the Data; Creating the Column Chart; Formatting the Column Chart; Bar Charts in Cells; Character-Based Bar Charts; Conditional Formatting-Based Bar Charts; Useful Variations on the Column Chart; A New Query; Side-by-Side Columns; Stacked Columns; Stacked and Normalized Columns; Number of Orders and Revenue; Other Types of Charts; Line Charts; Area Charts; X-Y Charts (Scatter Plots); Sparklines; What Values Are in the Columns?; Histograms
327   $aHistograms of Counts Cumulative Histograms of Counts; Histograms (Frequencies) for Numeric Values; Ranges Based on the Number of Digits, Using Numeric Techniques; Ranges Based on the Number of Digits, Using String Techniques; More Refined Ranges: First Digit Plus Number of Digits; Breaking Numeric Values into Equal-Sized Groups; More Values to Explore-Min, Max, and Mode; Minimum and Maximum Values; The Most Common Value (Mode); Calculating Mode Using Basic SQL; Calculating Mode Using Window Functions; Exploring String Values; Histogram of Length; Strings Starting or Ending with Spaces
327   $aHandling Upper- and Lowercase
410  0$aTHEi Wiley ebooks.
606   $aSQL (Computer program language)
606   $aQuerying (Computer science)
606   $aData mining
615  0$aSQL (Computer program language)
615  0$aQuerying (Computer science)
615  0$aData mining.
676   $a005.756
700   $aLinoff$b Gordon S.$0145033
801  0$bMiAaPQ
801  1$bMiAaPQ
801  2$bMiAaPQ
906   $aBOOK
912   $a9910808119903321
996   $aData analysis using SQL and Excel$94063275
997   $aUNINA