MS Power Query
Wed, 12/16/2015 - 20:15
Making data meaningful: importing data via MS Power Query to Excel
Big data is a broad term for data sets so large or complex that traditional data processing applications are inadequate.
The Microsoft Power Query for Excel allows to import large amounts of data provided by external sources like Wikipedia.
Select a language and hit the button Download.
Select the 32 or 64-bit version and hit Next.
Open the downloaded file.
Check "I accept the terms…" and hit Next.
Hit Next, Install and Finish.
Open Excel and notice the new tab "Power Query".
Click the option Data Catalog Search.
Enter a query in the right sidebar.
Example "medals olympics".
Several kind of search results are offered. The majority by Wikipedia.
Double click at the desired results. The data will be imported and soon appear in your Excel sheet.
Some other examples:
"Most common display resolutions"
"Oil production by country"
"List of countries by number of (mobile phones)"
Save your Excel document (on your computer or on OneDrive).