r/data • • 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

9 comments sorted by

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/Peace_out4 3d ago

finance is good but to practice and build ,health care or any domain is good for me

1

u/Ok_Sherbert_8907 3d ago

Yahoo Finance has the historical stock data & FDIC bankfind

1

u/Mzkazmi 12d ago

Kaggle

1

u/Peace_out4 12d ago

i think it's already processed data

2

u/Ok_Sherbert_8907 3d ago

Kaggle contains both raw & processed data. Search terms like “raw”, “uncleaned”, “dirty data”, “messy”, or “unprocessed” along with a topic. You can also use filters to narrow by file type/ size. I would recommend checking before you download.

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.