In this project you will design a presentation to explore the Kiva data. You will need to answer a total of six research questions: three are provided, and an additional three questions of your own. You will also generate a word cloud of the tags from a selected region or other selection of the data.
This is a challenge because the data set is very large and Excel will have a hard time processing the entire dataset (over 2GB when uncompressed) at once. To simplify this, we will use a database (or CSV files, your choice) to load the data you select using power query, create a data model using connections (without loading all the data into the sheet), map the relationships in the data model, create pivot hierarchies, use power view and maps to display the data. The project is in the same groups as usual.
Link to the data https://ln.sync.com/dl/9e1bc0860/t3vq24tu-2z6cgu6j-h58n9w9y-kzqnakui
Using the data, please prepare an excel file or powerBI presentation with the following (PLEASE NOTE, do not include the data files with your submission, you wont need them if you do not change the structure of the files):
You will answer in your final presentation a total of six questions. Three of the questions listed below, and three of your own based on your exploration of the data.
An example of this (from the assignment instructions) is attached. I made it using https://www.wordclouds.com/ but you are free to try anyone you like. I simply copied and pasted all of the text from the page to create the graphic. You will need to be strategic about how you grab the filtered tags from the category you choose.
Get Free Quote!
364 Experts Online