Astrato GoodViz Challenge:

What you need to know

• Dashboards must be created using Astrato and submitted via Astrato Galaxy or via LinkedIn (See the detailed instructions below)
• Competition entries close on 13 January
• Our amazing Industry Solutions team – plus special guest judge and analyst extraordinaire, Jocelyn Rivera – will judge all the entries
• Competition winners will be announced on 20 January
• Entries are open to anyone, regardless of geographical location
• 1st prize is $1,000!*
• The top 2 runners-up will each get a $500 prize*

*Prize money is subject to change based on local currency and can be claimed in vouchers to your favorite stores** and/or donated to charity. If you choose to make a charitable donation, you may use all or part of your prize money to do so.

**We are happy to offer vouchers for most stores, so long as they allow for the purchase of online gift certificates. We reserve the right to research any stores before purchasing vouchers and may refuse to support stores that are deemed to be offensive or inappropriate.

How to enter

Your mission, should you choose to accept it…

You work for a large, multinational manufacturing company with a successful graduate internship program, designed to give young people an opportunity to gain work experience in their chosen field.

You’ve been contributing to the program as an on-campus recruiter, and you’ve noticed that applications from female students are consistently low. So, you’ve formed a taskforce dedicated to recruiting female graduates to join the company’s many engineering and computer science-focused teams.

Now, your job is to build a compelling, interesting dashboard that you can present to your company’s leadership to make the case for investing in this worthy and significant program!

1. Sign up for Astrato

1. Sign up at app.astrato.io
2. Join our community of Astratonauts in the Astrato Galaxy to ask questions, learn more, and be inspired.

2. Connect to the data schema in Astrato

1. Log in to Astrato
2. If this is your first time logging in, make sure that you import the demo workbooks by clicking on the demo workbook card from the workbook section to establish a connection to the demo data!
3. Click “Create Workbook” at the top right corner of your workspace.
4. On the next screen, select “New Data View”.
5. Select the Demodata Snowflake connection from the Data Source list. This will open the Data View Editor.
6. Select the Labor and Education Sample Schema

3. Create a data view in Astrato

• There are 3 tables under Labor and Education Sample Schema:
  1. STATS stemeducation – US STEM Education Data (Degrees by Sex and Race & Ethnicity)
  2. STATS Laborstatistics Demographics – US Labor Bureau Statistics by Race & Ethnicity
  3. STATS Laborstatistics Sex – US Labor Bureau Statistics by Sex

• Define your data view by creating joins and/or defining dimensions & measures
• Click “Create Workbook” when your data view is complete. You can always return to the Data View Editor by clicking on the data source heading from your workbook.

4. Start your data exploration

1. Explore the data and put together an executive dashboard to address your mission
2. We are looking for:
   1. An informative and professional dashboard
   2. A creative and easy-to-understand data story

5. Launch your work

1. Publish your workbook
2. Enable and create an Embed link for submission, view our Embeds – Overview and Key Steps page for instructions
3. Log into Astrato Galaxy
4. Go to the Inspiration category
5. Create a New post and share your submission by posting a screenshot and inserting the Embed link created earlier
6. Write 1-2 sentences on any interesting findings or conclusions and don’t forget to add the “GoodViz” tag to your submission
7. Share your submission on LinkedIn and tag @AstratoAnalytics (We’d really love that!)
8. Follow @AstratoAnalytics on LinkedIn for updates on the challenge and to see if you won. Good luck!