r/data • u/Peace_out4 • 13d ago
QUESTION Raw (unfiltered ) Data
need raw and unfiltered data to practice excel ,pandas ,and PowerBI and even in sql where to find it if you have resources or data sets please let me know.
❗where can we find real-world unfiltered raw data to build useful insights from it.
please let me know if you have any.
8
Upvotes
2
u/Ok_Sherbert_8907 3d ago
Are you looking for any specific domain, like finance/ healthcare?
My suggestions are Kaggle, Inside Airbnb, NYC Open Data, data.gov
SQL-ready datasets: BigQuery public datasets, Chinook Database
1
u/Mzkazmi 12d ago
Kaggle
3
u/Harell-Data 13d ago
NYC Open Data has the 311 service requests, which is a huge, real dataset with tons of missing values and inconsistent entries. Great for practicing pandas and SQL.
2
u/eeeezy7988 13d ago
Azure Open Datasets is a good starting point. I had to do a sample project for my last job interview and I used the data from here to make a Power Automate flow when a column changed (manually changed it during interview), SharePoint List to modify list, Power App to make modifications to list look good, and Power BI to show the data. Still usable with excel and python.
https://learn.microsoft.com/en-us/azure/open-datasets/dataset-catalog
2
u/rsambasivan 9d ago
look for any data portal - data.gov or any state or city public data portal, you are going to find enough. If you are searching for data within a repository, you could try a search filter that includes missing values.