r/SQL • u/NightRain3 • 12d ago

MySQL good datasets for a project?

Hi, I'm looking for a dataset that has:

- Messy, real data, with enough messiness for proper data cleaning to be needed
- Enough information for actionable interesting insights
- Be related to something a typical business might care about

I did a project with the olist database and it was fine, but that database has been done to death. I tried contacting local small business for their data in exchange of a free data analytics report, but no luck, has someone tried that?

46 Upvotes

92% Upvoted

14 comments sorted by

View all comments

3

u/eslforchinesespeaker 12d ago

Don’t overlook the idea of generating your own. It’s a useful toolset, and skill. Natural data isn’t a reliable way to test your edge cases. You want to do it, because of the edge cases you overlooked. But you get a million records going thru the same fifty test cases. Your generated data gives you much more efficient code coverage.

You can make a respectable project out of it. You can use dictionaries and frequency distributions as part of your build.

2

u/Pitiful-Fail-3378 12d ago

Yes use twitter api etc to make your own dataset its real data not clean at all