20. January 2018 12:00
by Aaron Medacco
0 Comments

New Pluralsight Course: Visualizing Data with Amazon QuickSight

20. January 2018 12:00 by Aaron Medacco | 0 Comments

I've recently completed another course for Pluralsight, this time for Amazon QuickSight. QuickSight is a business intelligence offering within the AWS suite that allows you to import your data and analyze it using dynamic visualization. It's a rather young service, competing with other big-name products like Power BI and Tableau. It'll be interesting to see how this service evolves in the coming years given the pace at which Amazon Web Services moves. And while there are some limitations to the product which I think will be addressed soon, it's a fast and easy data analysis tool to use, especially if you're an AWS customer who already stores their data within the Amazon cloud. 

In Visualizing Data with Amazon QuickSight, I assume the viewer has no experience with Amazon QuickSight or with data analysis at all. The course begins by covering the basics such as account creation, setup and user access management. From there, it covers how to connect or import your data wherever it is to QuickSight. This might mean a flat file you want to import ad-hoc style, objects in S3, a Redshift cluster (which served as the primary data source for the course), or a database stored on-premises or with another provider. Then, I walkthrough how data preparation is done in QuickSight, which is essentially the process for taking data in it's unmodified, raw form and formatting it into a data set that will provide the most value in data analysis. Naturally, data analysis finishes out the course where we enter a deep-dive into the QuickSight data analysis interface and explore the different visualizations and features available to us.

Visualizing Data in Amazon QuickSight

Pluralsight courses are a lot of work, but I'm very satisfied with how this one turned out. There's a lot of demos, but being a very visual tool, that's not a surprise. Plus, "death by slides" is a real thing of which I've suffered through as a student myself. If you're curious about Amazon QuickSight and want to see how you might use it for your own data, go check it out

Cheers!

10. January 2018 00:06
by Aaron Medacco
0 Comments

No Custom SQL Query Option in Amazon QuickSight

10. January 2018 00:06 by Aaron Medacco | 0 Comments

Whether you're practiced or new in using Amazon QuickSight to analyze your data, you're probably already aware of the fact that you define the data set for a SQL database source by either using the table selector found in the data preparation interface or you can write a custom SQL query. However, you've also probably noticed that the option to use a custom SQL query is sometimes absent from the interface when in data preparation:

Amazon QuickSight Missing SQL Option

This can happen sometimes, particularly when you have already defined and saved a data set using the table selector option. This doesn't mean you can't use the custom SQL query option. You just need to create a brand new data set from the data source so that you get into data preparation prior to the data set's creation. Doing this, you should now see the option to use custom SQL in the tables section. 

Cheers!

Copyright © 2016-2017 Aaron Medacco