Now that you have learnt how to load data into a Redshift table, in this segment, you will learn how to use Redshift to analyse the data. Let’s watch the next video where Kamlesh will explain this in detail.
In this video, our SME explained how to perform exploratory data analysis in Redshift. The queries provided below are for your reference.
- Find the total sales on a given calendar date.
- Find the top 10 buyers by the quantity that they purchased.
- Find events in the 9.99 percentile in terms of all-time gross sales
Pro-tip
By far you have learnt how to create a Redshift cluster and know how to create and load data into a Redshift table. At this point, we would highly recommend you practice running Redshift queries on various datasets that you can find. Please feel free to share your findings on the DF.