Home Page Icon
Home Page
Table of Contents for
Dedication
Close
Dedication
by Brian Cox
How Libraries Should Manage Data
Cover image
Title page
Table of Contents
Copyright
Dedication
About the author
1. Introduction
2. Lifting the fog
First steps – project management
3. Step away from the spreadsheet – common errors in using spreadsheets, and their ramifications
The ten table commandments
4. Starting from scratch
How low do you go?
Measuring loans and accounting for variation
Visits and how to organize the data into columns
Browsed items and avoiding false conclusions
5. Getting the most out of your raw data
Keep it simple stupid!
Make it easy stupid! Absolute and relative formulas
Formulas you must know
Typical error messages and what they mean
Managing error messages
6. Stop, police!
Protecting data
Data validation
Using tables
Using a table to populate a validation list
Dependent lookups
7. Pivot magic
How to create a pivot table
Anatomy of a pivot table
Bringing it all together
8. Moving beyond basic pivots
Relational databases
PowerPivot
How to use PowerPivot
Creating a PowerPivot PivotTable
The difference between a measure and a calculated column
Adding a measures
9. How to create your own desktop library cube
Making the “desktop cube”
Sourcing the datasets
Using MS Access to create a merged dataset
Linking PowerPivot to the merged dataset
Adding a few more tables
Adding calculated columns to PowerPivot
Creating relationships
Writing measures
Some suggested views
10. Beyond the ordinary
Index
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Copyright
Next
Next Chapter
About the author
Dedication
Dedicated to Khrystyne and Harriett
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset