{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["report2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"report2","index":0,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[1,2,1,3],[1,4,1,5],[2,2,2,3],[2,4,2,5],[3,2,3,3],[5,2,5,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[15,2,15,3],[16,2,16,3],[19,2,19,3],[26,2,26,3],[26,4,26,5],[27,2,27,3],[27,4,27,5],[28,2,28,3],[29,2,29,3],[30,2,30,3],[33,2,33,3],[34,2,34,3]],"flags":["formulas_cached_only"]}
[null,"1.","Record Nr.",null,"UNINA9910137177903321"]
[null,null,"Autore",null,"Linoff Gordon S."]
[null,null,"Titolo",null,"Data analysis using SQL and Excel / / Gordon S. Linoff"]
[null,null,"Pubbl/distr/stampa",null,"Indianapolis, Indiana : , : Wiley, , 2016"]
[{"$nulls":4},"©2016"]
[null,null,"ISBN",null,"1-119-02144-8"]
[{"$nulls":4},"1-119-18341-3"]
[{"$nulls":4},"1-119-02145-6"]
[null,null,"Edizione",null,"[Second edition.]"]
[null,null,"Descrizione fisica",null,"1 online resource (795 p.)"]
[null,null,"Collana",null,"THEi Wiley ebooks"]
[null,null,"Disciplina",null,"005.756"]
[null,null,"Soggetti",null,"SQL (Computer program language)"]
[{"$nulls":4},"Querying (Computer science)"]
[{"$nulls":4},"Data mining"]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Monografia"]
[null,null,null,"Note generali","Includes index."]
[null,null,"Nota di contenuto",null,"Data 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"]
[{"$nulls":4},"What 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"]
[{"$nulls":4},"The 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; "]
[{"$nulls":4},"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"]
[{"$nulls":4},"Chapter 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"]
[{"$nulls":4},"Histograms 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"]
[{"$nulls":4},"Handling Upper- and Lowercase"]
[null,"2.","Record Nr.",null,"UNISA996205510403316"]
[null,null,"Titolo",null,"Frontiers of electrical and electronic engineering"]
[null,null,"Pubbl/distr/stampa",null,"Beijing : , : Springer Asia, , 2012-2013"]
[null,null,"ISSN",null,"2095-2740"]
[null,null,"Soggetti",null,"Electrical engineering - Research"]
[{"$nulls":4},"Engineering - Research"]
[{"$nulls":4},"Periodicals."]
[null,null,"Lingua di pubblicazione",null,"Inglese"]
[null,null,"Formato",null,"Materiale a stampa"]
[null,null,null,"Livello bibliografico","Periodico"]
[null,null,null,"Note generali","Refereed/Peer-reviewed"]
[null,null,null,"Nota di bibliografia","Includes bibliographical references."]