Beyond Excel: Use databases and SQL to reduce your workload and enhance your reporting

Number 4841
Subject Data
Source Thomas Thoren
Affiliation The Lens
Year 2016
Summary Excel is a great tool for most jobs, but it has its limitations. Large files can mean long wait times and it can be difficult to understand and reproduce old work. Databases, however, are faster and powerful enough to handle large amounts of data. And with SQL, you can easily document and reproduce your data analysis which means you’ll be ready to quickly recreate a Census data analysis when new data is released.
Tags sql; databases; files; analysis
Files Only members can download tipsheets! Log in to get access.