Large dataset needed

Hi AF-OD

Greetings! I am Vijay, an Independent Advisor. I am here to work with you on this problem.

Download One Hundred Thousand Records file or Five Hundred Thousand Records file having more than 30 columns from my blog post

Downloads 16 - Sample CSV Files / Data Sets for Testing - Human Resources - http://eforexcel.com/wp/downloads-16-sample-csv...

Do let me know if you have any more question or require further help.

Disclaimer - This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.

Just to bring this discussion up to date, I found a couple more free large test data sets

Photovoltaic time series for European countries and different system configurations      March 28, 2019https://zenodo.org/record/2613651#.XSGZKXvTUl5

This repository comprises 38 years-long hourly time series representing the photovoltaic (PV) capacity factors in every European country (EU-28 plus Serbia, Bosnia-Herzegovina, Norway, and Switzerland). 3 letter codes (ISO-3166-3) are used to identify the countries. Time series include years from 1979 to 2017. For every country, four different time series assuming alternative PV configurations, i.e., rooftop, optimum tilt, 2-axis tracking, and delta are provided.

Same Sex Marriage Results in Excel – Australian Census Survey        2017 11 08

https://office-watch.com/2017/sex-marriage-results-excel/****Next Wednesday, Australia gets the results of their Same Sex Marriage survey with the details available to everyone with Excel.  Here’s how to get the survey results. The Australian Bureau of Statistics will post the results at  https://marriagesurvey.abs.gov.au/results and they’ve published the ‘template’ worksheets already with empty cells. – Free Sample Data

Hi Vijay,

I am very grateful for your response.

The links you sent are quite useful as they have datasets that meet the criteria required for my assignment.

Regards,

AF-OD

Thank you very much Rohn007 for your prompt response.

I have checked the links you sent above they are very good. The records criteria are met  (as they are > 50000 records). However, I could not find a file that matches the column criteria of around 30 columns.

The dataset is needed to complete a research assignment.

Thanks again for your help.

Regards,

AF-OD

There is test data with these links, I don't know if it meets your criteria.  Why do you need test data that specific size?  Are you looking for a rough total data size? Can you substitute more rows for less columns?

49 dashboards to visualize US State to State migration trends             June 12th, 2014

https://chandoo.org/wp/visualize-state-migration-contest/****https://chandoo.org/wp/state-migration-dashboard-contest-entries/****About a month and half ago, we held our annual dashboard contest. This time the theme is to visualize state to state migration in USA. You can find the contest data-set & details here.

We received 49 outstanding entries for this. Most of the entries are truly inspiring. They are loaded with powerful analysis, stunning visualizations, amazing display of Excel skill and design finesse. It took me almost 2 weeks to process the results and present them here.

Analyzing half a million consumer complaints [Part 1 of 3]http://chandoo.org/wp/2016/02/16/analyzing-consumer-complaints-1/

***How would you analyze data when you have lots of it?***That is the inspiration for this series.

Regional Trends [Part 2 of 3]http://chandoo.org/wp/2016/02/18/analyzing-customer-complaints-2/****In this article, let’s explore three ways to analyze regional trends.

Customer Satisfaction Scorecard [Part 3 of 3]http://chandoo.org/wp/2016/02/23/customer-satisfaction-scorecard/

For the customer satisfaction scorecard, let’s focus on individual companies.

Click here to see Aussie accounting magic in Excel 2017 12 08****https://office-watch.com/2017/click-see-aussie-accounting-magic-excel/

The Australian tax authorities have released some interesting data about the biggest corporate (non) taxpayers in an Excel format.  It’s raw data ready for extra calculations, charts and PivotTables.

Another example of how publicly available data can be used by anyone to dig into previously obscure areas using Excel tools.

(Sample data for learning exercise downloaded:  excel pt @Sample data-)

Take a look at this wiki. It has links to demonstrations of PivotTables / Dashboards. The demonstrations usually come with downloadable example files with example data.

Getting Started with “PowerQuery” / “Get & Transform” > Tables > PivotTables > PivotCharts > Dashboards ... WIKI:   https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_o365b/get-started-with-get-transform-tables-pivottables/fea2f31d-7835-4f77-ad34-6fe3e6d07620?tm=1537369871055****

Data- Same Sex Marriage Results in Excel – Australian Census Survey           2017 11 08

https://office-watch.com/2017/sex-marriage-results-excel/****Next Wednesday, Australia gets the results of their Same Sex Marriage survey with the details available to everyone with Excel.  Here’s how to get the survey results. The Australian Bureau of Statistics will post the results at  https://marriagesurvey.abs.gov.au/results and they’ve published the ‘template’ worksheets already with empty cells. – Free Sample Data

Check with other county websites to see if they have downloabale data.

Check with weather services, they likely have large downloadable data sets.

DIY:

**Create Random Text in Excel**   ****August 21, 2014

http://blog.contextures.com/archives/2014/08/21/create-random-text-in-excel/

I needed some test data to play with.  I needed 2 types of data:

    Numbers: sample test scores in one column

    Text: random Region names and Gender in other columns.

**Generating Random Data to Set Up a Pivot Table Tutorial******         January 14, 2013

http://ozdusoleil.com/2013/01/14/generating-random-data-to-set-up-a-pivot-table-tutorial/

Blogpost associated with this video: http://datascopic.net/generate-data/

Often we need to generate a set of bogus data in order to create examples or test solutions. In this video, I show how to generate fake call center data in order to show an example of a pivot table. This includes: RAND, RANDBETWEEN, date formatting, Find-Replace

I need to copy a notebook from a School account that is no longer active

Excel random number generator – RAND and RANDBETWEEN functions           2015 07 08   Svetlana Cheusheva****https://www.ablebits.com/office-addins-blog/2015/07/08/random-number-generator-excel/

The tutorial explains the specificities of the Excel random number generator algorithm and demonstrates how to use RAND and RANDBETWEEN functions in Excel to generate random numbers, dates, passwords and other text strings.

@ Get 6 types of random data in Excel with Random Generator                     2011 06 29   Maria Azbel****Random Generator allows filling your worksheets with accidental numbers, dates, custom list values, Booleans and strings. That means you can generate almost everything from Ids, passwords and order of something to math tasks and equations.

**Random Numbers in a Range** ****http://excel.tips.net/T002812_Random_Numbers_in_a_Range.html

Excel provides several different functions that you can use to generate random numbers. One of the most useful is the RANDBETWEEN function, which allows you to generate a random number between a lower and upper boundary that you specify.