Gespeichert in:
| Beteilige Person: | |
|---|---|
| Format: | Buch |
| Sprache: | Englisch |
| Veröffentlicht: |
Waltham, MA [u.a.]
Chandos Publishing
2016
|
| Schlagwörter: | |
| Links: | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028347188&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| Umfang: | IX, 137 S. Ill. 23 cm |
| ISBN: | 9780081006634 |
Internformat
MARC
| LEADER | 00000nam a22000002c 4500 | ||
|---|---|---|---|
| 001 | BV042919675 | ||
| 003 | DE-604 | ||
| 005 | 20151109 | ||
| 007 | t| | ||
| 008 | 151012s2016 xx a||| |||| 00||| eng d | ||
| 016 | 7 | |a 017452553 |2 DE-101 | |
| 020 | |a 9780081006634 |c pbk. : £47.50 |9 978-0-08-100663-4 | ||
| 020 | |z 9780081006719 |c PDF ebook : £47.50 |9 9780081006719 | ||
| 035 | |a (OCoLC)930534841 | ||
| 035 | |a (DE-599)BSZ445502606 | ||
| 040 | |a DE-604 |b ger | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-473 | ||
| 082 | 0 | |a 025.002856312 | |
| 084 | |a AN 73000 |0 (DE-625)6267: |2 rvk | ||
| 100 | 1 | |a Cox, Brian |d 1968- |e Verfasser |0 (DE-588)1020718242 |4 aut | |
| 245 | 1 | 0 | |a How libraries should manage data |b practical guidance on how to get the best from your data |c Brian Cox |
| 264 | 1 | |a Waltham, MA [u.a.] |b Chandos Publishing |c 2016 | |
| 300 | |a IX, 137 S. |b Ill. |c 23 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 4 | |a Library administration | |
| 650 | 4 | |a Data mining | |
| 650 | 0 | 7 | |a Datenverwaltung |0 (DE-588)4011168-4 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Wissenschaftliche Bibliothek |0 (DE-588)4066573-2 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Wissenschaftliche Bibliothek |0 (DE-588)4066573-2 |D s |
| 689 | 0 | 1 | |a Datenverwaltung |0 (DE-588)4011168-4 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m Digitalisierung UB Bamberg - ADAM Catalogue Enrichment |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028347188&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-028347188 | |
Datensatz im Suchindex
| _version_ | 1819339086016544768 |
|---|---|
| adam_text | Contents
About the author xi
1 Introduction 1
2 Lifting the fog 5
First steps — project management 8
3 Step away from the spreadsheet — common errors in using
spreadsheets, and their ramifications 13
The ten table commandments 17
4 Starting from scratch 21
How low do you go? 23
Measuring loans and accounting for variation 24
Visits and how to organize the data into columns 32
Browsed items and avoiding false conclusions 35
5 Getting the most out of your raw data 39
Keep it simple stupid! 40
Make it easy stupid! Absolute and relative formulas 42
Formulas you must know 44
Typical error messages and what they mean 57
Managing error messages 58
6 Stop, police! 61
Protecting data 61
Data validation 63
Using tables 67
Using a table to populate a validation list 70
Dependent lookups 71
7 Pivot magic 75
How to create a pivot table
75
Contents
viii
Anatomy of a pivot table 77
Bringing it all together 79
Set up the Contents sheet 79
Set up the Pivot sheet 81
Set up the RawData sheet 82
Set up the Validation sheet 83
Done! 84
8 Moving beyond basic pivots 85
Relational databases 85
PowerPivot 89
How to use PowerPivot 91
Adding calculated columns 93
Creating a PowerPivot PivotTable 93
The difference between a measure and a calculated column 94
Adding a measures 95
9 How to create your own desktop library cube 97
Making the “desktop cube” 102
Sourcing the datasets 103
Using MS Access to create a merged dataset 105
Linking PowerPivot to the merged dataset 108
Adding a few more tables 109
IP address table 109
Resources table 110
Frequency table 110
Date table 111
Adding calculated columns to PowerPivot 113
FormattedDate 113
ResourceUsed 114
Key Minutes Active 116
FrequencyMinutesTotal 118
KeyYearMonthDay 119
Frequency Minu tesDay 119
Location 120
GroupMinutesDay 12Q
GroupMinutesTotal 121
Creating relationships 121
Writing measures 123
DistinctStudents 124
MinutesActive 124
AverageMark 123
Some suggested views 12^
Minutes of usage by resource accessed and faculty 126
Contents ix
Frequency distribution of student usage of resources by faculty 127
Frequency usage by hours 128
Average mark by frequency of library usage 128
10 Beyond the ordinary 131
Index 135
Please go to the Companion Website at http://booksite,elsevier.com/9780081006634/
to download materials mentioned in subsequent chapters, and to use these for yourself
|
| any_adam_object | 1 |
| author | Cox, Brian 1968- |
| author_GND | (DE-588)1020718242 |
| author_facet | Cox, Brian 1968- |
| author_role | aut |
| author_sort | Cox, Brian 1968- |
| author_variant | b c bc |
| building | Verbundindex |
| bvnumber | BV042919675 |
| classification_rvk | AN 73000 |
| ctrlnum | (OCoLC)930534841 (DE-599)BSZ445502606 |
| dewey-full | 025.002856312 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 025 - Operations of libraries and archives |
| dewey-raw | 025.002856312 |
| dewey-search | 025.002856312 |
| dewey-sort | 225.002856312 |
| dewey-tens | 020 - Library and information sciences |
| discipline | Allgemeines |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01617nam a22003972c 4500</leader><controlfield tag="001">BV042919675</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20151109 </controlfield><controlfield tag="007">t|</controlfield><controlfield tag="008">151012s2016 xx a||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">017452553</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780081006634</subfield><subfield code="c">pbk. : £47.50</subfield><subfield code="9">978-0-08-100663-4</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9780081006719</subfield><subfield code="c">PDF ebook : £47.50</subfield><subfield code="9">9780081006719</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)930534841</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BSZ445502606</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-473</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">025.002856312</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">AN 73000</subfield><subfield code="0">(DE-625)6267:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Cox, Brian</subfield><subfield code="d">1968-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1020718242</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">How libraries should manage data</subfield><subfield code="b">practical guidance on how to get the best from your data</subfield><subfield code="c">Brian Cox</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Waltham, MA [u.a.]</subfield><subfield code="b">Chandos Publishing</subfield><subfield code="c">2016</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">IX, 137 S.</subfield><subfield code="b">Ill.</subfield><subfield code="c">23 cm</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">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Library administration</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">Datenverwaltung</subfield><subfield code="0">(DE-588)4011168-4</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Wissenschaftliche Bibliothek</subfield><subfield code="0">(DE-588)4066573-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Wissenschaftliche Bibliothek</subfield><subfield code="0">(DE-588)4066573-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenverwaltung</subfield><subfield code="0">(DE-588)4011168-4</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">Digitalisierung UB Bamberg - ADAM Catalogue Enrichment</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028347188&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-028347188</subfield></datafield></record></collection> |
| id | DE-604.BV042919675 |
| illustrated | Illustrated |
| indexdate | 2024-12-20T17:23:17Z |
| institution | BVB |
| isbn | 9780081006634 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-028347188 |
| oclc_num | 930534841 |
| open_access_boolean | |
| owner | DE-473 DE-BY-UBG |
| owner_facet | DE-473 DE-BY-UBG |
| physical | IX, 137 S. Ill. 23 cm |
| publishDate | 2016 |
| publishDateSearch | 2016 |
| publishDateSort | 2016 |
| publisher | Chandos Publishing |
| record_format | marc |
| spellingShingle | Cox, Brian 1968- How libraries should manage data practical guidance on how to get the best from your data Library administration Data mining Datenverwaltung (DE-588)4011168-4 gnd Wissenschaftliche Bibliothek (DE-588)4066573-2 gnd |
| subject_GND | (DE-588)4011168-4 (DE-588)4066573-2 |
| title | How libraries should manage data practical guidance on how to get the best from your data |
| title_auth | How libraries should manage data practical guidance on how to get the best from your data |
| title_exact_search | How libraries should manage data practical guidance on how to get the best from your data |
| title_full | How libraries should manage data practical guidance on how to get the best from your data Brian Cox |
| title_fullStr | How libraries should manage data practical guidance on how to get the best from your data Brian Cox |
| title_full_unstemmed | How libraries should manage data practical guidance on how to get the best from your data Brian Cox |
| title_short | How libraries should manage data |
| title_sort | how libraries should manage data practical guidance on how to get the best from your data |
| title_sub | practical guidance on how to get the best from your data |
| topic | Library administration Data mining Datenverwaltung (DE-588)4011168-4 gnd Wissenschaftliche Bibliothek (DE-588)4066573-2 gnd |
| topic_facet | Library administration Data mining Datenverwaltung Wissenschaftliche Bibliothek |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=028347188&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT coxbrian howlibrariesshouldmanagedatapracticalguidanceonhowtogetthebestfromyourdata |