I've been working on tools to make data analysis workflows easier, and I'm curious about how other data analysts approach their day-to-day work.

What's the part of your workflow that takes up most of your time?

1. Cleaning messy datasets

2. Validating data quality

3. Writing and optimising SQL queries

4. Feature engineering

5. Building dashboards and reports

Do you handle these manually, use existing tools, or have your own automated workflows?

You get a dataset expecting to start analysing it, but first you have to deal with missing values, duplicates, inconsistent formats, incorrect data types and unexpected outliers.

Sometimes cleaning takes longer than the actual analysis.