3. Analyze and Visualize Your Dataset

a) Import Your Dataset in Silk

  1. Sign-up for Silk and create your first silk site

  2. Go to your Google Sheet and set the sharing options to “Anyone with the link can view”

  3. Copy the URL of your Google Sheet

  4. On Silk, go to your Dashboard

  5. Select “Google Spreadsheet” as the import method and copy your URL

  6. Select the “Import Companies” Sheet

  7. Delete and rearrange columns

  8. Some tags needs adjustments before import. This is the case for “Location”, “US State”, “Country”, "Region". For all four, click on the gear icon and select “Split on other character”. Type “|”. (Fig. 1)

  9. Start the Import!

  10. Repeat step 1 to 7, and this time select the “Import Jobs” sheet

  11. Some tags need adjustments before import. This is the case for “Company” (Click the gear icon and select “Link to datacard”) and “Tags” (Click the gear icon and select “Split on commas”)

  12. Start the import!

b) Start Looking for Patterns and Interesting Visuals

  1. Check out your homepage for auto-generated visualizations. Tweak what you like, delete what you don’t.

  2. Play around in Explore mode to create visualizations you want on your homepage. Decide the chart type, the variable to plot, the sorting order and the filters. When you see something you like, copy it to the homepage and then go back to exploring.

  3. Some suggestions:

    • Map job offers by hiring company's location. Add a filter for region. Color the pins on whether the job offering allows remote work.

    • Scatterplot: Median compensation vs. Equity. What's the best offer?

    • What are the top 10 European cities hiring growth hackers?

    • Is remote work common? Notice any regional patterns?

    • What are most common skills (tags) sought after in the North American growth hacker job market?

    • What are the top five job offers with the highest maximum or median compensation for a full-time contract?

    • Which companies have most job openings for growth hackers?