Data analysis using SQL and Excel:
Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and m...
Saved in:
| Main Author: | |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Indianapolis, IN
John Wiley & Sons, Inc.
[2016]
|
| Edition: | Second edition |
| Subjects: | |
| Online Access: | FCO01 FRO01 HWR01 UBG01 UBT01 Volltext |
| Summary: | Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like |
| Item Description: | Includes index |
| Physical Description: | 1 online resource |
| ISBN: | 9781119021445 1119021448 9781119183419 1119183413 111902143X 9781119021438 9781119021452 1119021456 |
Staff View
MARC
| LEADER | 00000nmm a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV043738199 | ||
| 003 | DE-604 | ||
| 005 | 20230113 | ||
| 007 | cr|uuu---uuuuu | ||
| 008 | 160826s2016 |||| o||u| ||||||eng d | ||
| 020 | |a 9781119021445 |9 978-1-119-02144-5 | ||
| 020 | |a 1119021448 |9 1-119-02144-8 | ||
| 020 | |a 9781119183419 |9 978-1-119-18341-9 | ||
| 020 | |a 1119183413 |9 1-119-18341-3 | ||
| 020 | |a 111902143X |9 1-119-02143-X | ||
| 020 | |a 9781119021438 |9 978-1-119-02143-8 | ||
| 020 | |a 9781119021452 |9 978-1-119-02145-2 | ||
| 020 | |a 1119021456 |9 1-119-02145-6 | ||
| 024 | 7 | |a 10.1002/9781119183419 |2 doi | |
| 035 | |a (ZDB-35-WIC)ocn931864545 | ||
| 035 | |a (ZDB-4-NLEBK)1106926 | ||
| 035 | |a (OCoLC)931864545 | ||
| 035 | |a (DE-599)BVBBV043738199 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-2070s |a DE-861 |a DE-703 |a DE-858 | ||
| 082 | 0 | |a 005.75/85 |2 23 | |
| 100 | 1 | |a Linoff, Gordon |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Data analysis using SQL and Excel |c Gordon S. Linoff |
| 250 | |a Second edition | ||
| 264 | 1 | |a Indianapolis, IN |b John Wiley & Sons, Inc. |c [2016] | |
| 300 | |a 1 online resource | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b c |2 rdamedia | ||
| 338 | |b cr |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 520 | |a Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like | ||
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 7 | |a Microsoft Excel (Computer file) |2 blmlsh | |
| 650 | 7 | |a Microsoft Excel (Computer file) |2 fast | |
| 650 | 7 | |a COMPUTERS / Programming Languages / SQL. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Databases / General |2 bisacsh | |
| 650 | 7 | |a COMPUTERS / Data Processing |2 bisacsh | |
| 650 | 7 | |a Data mining |2 fast | |
| 650 | 7 | |a Querying (Computer science) |2 fast | |
| 650 | 7 | |a SQL (Computer program language) |2 fast | |
| 650 | 4 | |a SQL (Computer program language) | |
| 650 | 4 | |a Querying (Computer science) | |
| 650 | 4 | |a Data mining | |
| 650 | 0 | 7 | |a Datenanalyse |0 (DE-588)4123037-1 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | 1 | |a Datenanalyse |0 (DE-588)4123037-1 |D s |
| 689 | 0 | |8 1\p |5 DE-604 | |
| 689 | 1 | 0 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 1 | 1 | |a Datenanalyse |0 (DE-588)4123037-1 |D s |
| 689 | 1 | |8 2\p |5 DE-604 | |
| 856 | 4 | 0 | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
| 912 | |a ZDB-4-NLEBK |a ZDB-35-WIC | ||
| 940 | 1 | |q UBG_PDA_WIC | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-029149977 | ||
| 883 | 1 | |8 1\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 883 | 1 | |8 2\p |a cgwrk |d 20201028 |q DE-101 |u https://d-nb.info/provenance/plan#cgwrk | |
| 966 | e | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |l FCO01 |p ZDB-35-WIC |q FCO_PDA_WIC_Kauf |x Verlag |3 Volltext | |
| 966 | e | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |l FRO01 |p ZDB-35-WIC |q FRO_PDA_WIC |x Verlag |3 Volltext | |
| 966 | e | |u http://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=1106926 |l HWR01 |p ZDB-4-NLEBK |x Aggregator |3 Volltext | |
| 966 | e | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |l UBG01 |p ZDB-35-WIC |q UBG_PDA_WIC |x Verlag |3 Volltext | |
| 966 | e | |u https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |l UBT01 |p ZDB-35-WIC |q UBT_PDA_WIC_Kauf |x Verlag |3 Volltext | |
Record in the Search Index
| _version_ | 1804176537527779328 |
|---|---|
| any_adam_object | |
| author | Linoff, Gordon |
| author_facet | Linoff, Gordon |
| author_role | aut |
| author_sort | Linoff, Gordon |
| author_variant | g l gl |
| building | Verbundindex |
| bvnumber | BV043738199 |
| collection | ZDB-4-NLEBK ZDB-35-WIC |
| ctrlnum | (ZDB-35-WIC)ocn931864545 (ZDB-4-NLEBK)1106926 (OCoLC)931864545 (DE-599)BVBBV043738199 |
| dewey-full | 005.75/85 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.75/85 |
| dewey-search | 005.75/85 |
| dewey-sort | 15.75 285 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | Second edition |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03859nmm a2200793zc 4500</leader><controlfield tag="001">BV043738199</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20230113 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">160826s2016 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119021445</subfield><subfield code="9">978-1-119-02144-5</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119021448</subfield><subfield code="9">1-119-02144-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119183419</subfield><subfield code="9">978-1-119-18341-9</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119183413</subfield><subfield code="9">1-119-18341-3</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">111902143X</subfield><subfield code="9">1-119-02143-X</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119021438</subfield><subfield code="9">978-1-119-02143-8</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781119021452</subfield><subfield code="9">978-1-119-02145-2</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1119021456</subfield><subfield code="9">1-119-02145-6</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.1002/9781119183419</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-35-WIC)ocn931864545</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-4-NLEBK)1106926</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)931864545</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV043738199</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-2070s</subfield><subfield code="a">DE-861</subfield><subfield code="a">DE-703</subfield><subfield code="a">DE-858</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.75/85</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Linoff, Gordon</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Data analysis using SQL and Excel</subfield><subfield code="c">Gordon S. Linoff</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Indianapolis, IN</subfield><subfield code="b">John Wiley & Sons, Inc.</subfield><subfield code="c">[2016]</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource</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="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">blmlsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Microsoft Excel (Computer file)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Programming Languages / SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Databases / General</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS / Data Processing</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Data mining</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Querying (Computer science)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">SQL (Computer program language)</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">SQL (Computer program language)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Querying (Computer science)</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Data mining</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="8">1\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="689" ind1="1" ind2="0"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2="1"><subfield code="a">Datenanalyse</subfield><subfield code="0">(DE-588)4123037-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-NLEBK</subfield><subfield code="a">ZDB-35-WIC</subfield></datafield><datafield tag="940" ind1="1" ind2=" "><subfield code="q">UBG_PDA_WIC</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-029149977</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">1\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="883" ind1="1" ind2=" "><subfield code="8">2\p</subfield><subfield code="a">cgwrk</subfield><subfield code="d">20201028</subfield><subfield code="q">DE-101</subfield><subfield code="u">https://d-nb.info/provenance/plan#cgwrk</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419</subfield><subfield code="l">FCO01</subfield><subfield code="p">ZDB-35-WIC</subfield><subfield code="q">FCO_PDA_WIC_Kauf</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419</subfield><subfield code="l">FRO01</subfield><subfield code="p">ZDB-35-WIC</subfield><subfield code="q">FRO_PDA_WIC</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">http://search.ebscohost.com/login.aspx?direct=true&db=nlebk&AN=1106926</subfield><subfield code="l">HWR01</subfield><subfield code="p">ZDB-4-NLEBK</subfield><subfield code="x">Aggregator</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419</subfield><subfield code="l">UBG01</subfield><subfield code="p">ZDB-35-WIC</subfield><subfield code="q">UBG_PDA_WIC</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="966" ind1="e" ind2=" "><subfield code="u">https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419</subfield><subfield code="l">UBT01</subfield><subfield code="p">ZDB-35-WIC</subfield><subfield code="q">UBT_PDA_WIC_Kauf</subfield><subfield code="x">Verlag</subfield><subfield code="3">Volltext</subfield></datafield></record></collection> |
| id | DE-604.BV043738199 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-10T07:33:46Z |
| institution | BVB |
| isbn | 9781119021445 1119021448 9781119183419 1119183413 111902143X 9781119021438 9781119021452 1119021456 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-029149977 |
| oclc_num | 931864545 |
| open_access_boolean | |
| owner | DE-2070s DE-861 DE-703 DE-858 |
| owner_facet | DE-2070s DE-861 DE-703 DE-858 |
| physical | 1 online resource |
| psigel | ZDB-4-NLEBK ZDB-35-WIC UBG_PDA_WIC ZDB-35-WIC FCO_PDA_WIC_Kauf ZDB-35-WIC FRO_PDA_WIC ZDB-35-WIC UBG_PDA_WIC ZDB-35-WIC UBT_PDA_WIC_Kauf |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | John Wiley & Sons, Inc. |
| record_format | marc |
| spelling | Linoff, Gordon Verfasser aut Data analysis using SQL and Excel Gordon S. Linoff Second edition Indianapolis, IN John Wiley & Sons, Inc. [2016] 1 online resource txt rdacontent c rdamedia cr rdacarrier Includes index Useful business analysis requires you to effectively transform data into actionable information. This book helps you use SQL and Excel to extract business information from relational databases and use that data to define business dimensions, store transactions about customers, produce results, and more. Each chapter explains when and why to perform a particular type of business analysis in order to obtain useful results, how to design and perform the analysis using SQL and Excel, and what the results should look like Microsoft Excel (Computer file) Microsoft Excel (Computer file) blmlsh Microsoft Excel (Computer file) fast COMPUTERS / Programming Languages / SQL. bisacsh COMPUTERS / Databases / General bisacsh COMPUTERS / Data Processing bisacsh Data mining fast Querying (Computer science) fast SQL (Computer program language) fast SQL (Computer program language) Querying (Computer science) Data mining Datenanalyse (DE-588)4123037-1 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf SQL (DE-588)4134010-3 gnd rswk-swf SQL (DE-588)4134010-3 s Datenanalyse (DE-588)4123037-1 s 1\p DE-604 EXCEL (DE-588)4138932-3 s 2\p DE-604 https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 Verlag URL des Erstveröffentlichers Volltext 1\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk 2\p cgwrk 20201028 DE-101 https://d-nb.info/provenance/plan#cgwrk |
| spellingShingle | Linoff, Gordon Data analysis using SQL and Excel Microsoft Excel (Computer file) Microsoft Excel (Computer file) blmlsh Microsoft Excel (Computer file) fast COMPUTERS / Programming Languages / SQL. bisacsh COMPUTERS / Databases / General bisacsh COMPUTERS / Data Processing bisacsh Data mining fast Querying (Computer science) fast SQL (Computer program language) fast SQL (Computer program language) Querying (Computer science) Data mining Datenanalyse (DE-588)4123037-1 gnd EXCEL (DE-588)4138932-3 gnd SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4123037-1 (DE-588)4138932-3 (DE-588)4134010-3 |
| title | Data analysis using SQL and Excel |
| title_auth | Data analysis using SQL and Excel |
| title_exact_search | Data analysis using SQL and Excel |
| title_full | Data analysis using SQL and Excel Gordon S. Linoff |
| title_fullStr | Data analysis using SQL and Excel Gordon S. Linoff |
| title_full_unstemmed | Data analysis using SQL and Excel Gordon S. Linoff |
| title_short | Data analysis using SQL and Excel |
| title_sort | data analysis using sql and excel |
| topic | Microsoft Excel (Computer file) Microsoft Excel (Computer file) blmlsh Microsoft Excel (Computer file) fast COMPUTERS / Programming Languages / SQL. bisacsh COMPUTERS / Databases / General bisacsh COMPUTERS / Data Processing bisacsh Data mining fast Querying (Computer science) fast SQL (Computer program language) fast SQL (Computer program language) Querying (Computer science) Data mining Datenanalyse (DE-588)4123037-1 gnd EXCEL (DE-588)4138932-3 gnd SQL (DE-588)4134010-3 gnd |
| topic_facet | Microsoft Excel (Computer file) COMPUTERS / Programming Languages / SQL. COMPUTERS / Databases / General COMPUTERS / Data Processing Data mining Querying (Computer science) SQL (Computer program language) Datenanalyse EXCEL SQL |
| url | https://onlinelibrary.wiley.com/doi/book/10.1002/9781119183419 |
| work_keys_str_mv | AT linoffgordon dataanalysisusingsqlandexcel |