Software for Data Work 101

Data work relies on software — but the landscape can feel overwhelming. This path cuts through the noise by explaining the main categories of software used in data work, what each type does, and how to think about choosing tools for your situation. No prior technical experience required.

• Difficulty: Beginner
• 8 lessons reading
• No prior knowledge required

• What software categories exist for data work
• The difference between open-source and commercial software
• When spreadsheets are the right tool — and when they are not
• What databases do and when you need one
• How GIS software handles spatial data
• Tools for cleaning and standardizing data
• How visualization and reporting software communicates information
• How to build a simple, practical data toolkit

Understanding Data Software

What software is, the main categories used in data work, and how to think about choosing the right tool for the job.

Open Source vs Commercial Software

Understand the difference between open-source and commercial software — ownership, licensing, costs, support, and flexibility.

Spreadsheet Software

Spreadsheets are the most widely used data tool. Learn what they do well, where they fall short, and how to use them effectively.

Database Software

When your data outgrows a spreadsheet, a database is the answer. Learn what databases do and when you need one.

GIS Software

Geographic Information System software handles spatial data — maps, coordinates, and location-based analysis.

Data Cleaning Software

Messy data is the norm. Learn about the tools designed to clean, validate, standardize, and deduplicate data.

Visualization and Reporting Software

Charts, dashboards, and reports turn data into decisions. Learn how visualization software communicates information.

Building Your Data Toolkit

How to match tools to your actual needs, avoid unnecessary complexity, and build a practical toolkit that grows with you.