Discovering batch insights with Amazon QuickSight (cont.)

  • Once your data has been imported, you can start playing around with QuickSight to see what visualizations you can create. Select the + ADD button on the top left to add a visualization.

  • Under Visual types, select a Horizontal Bar Chart visualization.

  • Drag the item_name variable to be the value for the Y axis field well and event_id as the Value field well

  • Double click the name at the top of the graph to edit it and change it to Most popular hats by count of events

  • Double click the Y axis and Rename it Hat types

  • Double click the X axis and Rename it to Amount of purchases by players.

  • You can also do things like filter, sort, change the colors, and more with QuickSight.

  • Your graph should look similar to this:

This graph lets us know which hats are most popular by all of our players and which are least popular. It shows that the Unicorn Hat is the most popular and the Student Hat is the least popular

  • Select the + ADD button on the top left to add a new visualization.

  • Under Visual types, select a Tree map visualization.

  • Drag the country_id variable to be the value for the Group by field well

  • Drag the real_value to be the value for both the Size and Color field wells

  • Double click the name at the top of the graph to edit it and change it to Revenue by Country

  • Your graph should look similar to this:

This graph shows the revenue spent by players in different countries.

  • Let’s make one more graph. Select the + ADD button on the top left to add a new visualization.

  • Under Visual types, select a Pie chart visualization.

  • Drag the platform variable to be the value for the Group/Color field well

  • Double click the name at the top of the graph to edit it and change it to Most popular platforms used to play Peculiar Wizards

  • Your graph should look similar to this:

This graph shows us that most of our players use an iPhone to play the Peculiar Wizards game, while PC is the least popular platform to play the game.

  • You can also see suggested insights from QuickSight. On the left-hand navigation pane, select Insights and QuickSight will suggest some insights for you.

  • For example, QuickSight suggests to add a Total Aggregation insight for real_value which shows how much money you have made so far. In this case, it is $55,297, but this is randomly generated data so yours will probably be different.

At the end of the day, you can create dashboards and visualizations with QuickSight like the ones below!

Congratulations! You created batch visualizations in QuickSight. You can explore QuickSight more if you’d like to see what other visualizations you can make. See if you can replicate the completed dashboards shown above!