
Welcome to this amazing journey through the universe of Data and BI, this time by adding Amazon Quicksight to your toolbox.
Learn how to create a Quicksight Account from scratch.
Understand Quicksight Pricing and Subscriptions modules and their main differences.
Learn the different users and roles within Quicksight and how to manage them.
SPICE is one of the powerful features that Quicksights offers, Learn what is it and how to manage it.
QuickSight provides a secure platform that enables you to distribute dashboards and insights to tens of thousands of users. Let's take a closer look at this video.
Virtual Private Cloud (VPC) enables you to launch AWS resources into a virtual network that you've defined. Like SQL Servers etc. Learn how to connect QS to a particular resource on a VPC.
An IAM user is a resource in IAM that has associated credentials and permissions. Learn how to create an IAM user to be used on AWS CLI.
QS have two options to create and manage groups, one is the newest User Interface and the other one is using the CLI. or Comand Line Interface. On this lecture, we will learn how to use the AWS CLI to create and manage gourps on QS
Let's talk about Data Sources and Datasets in QuickSight
We will connect to a Redshift cluster to create our first dataset.
Learn how the 'Direct Query' mode works.
Learn how to create and manage Datasets in SPICE and how it may improve the performance of your Dashboards.
Learn how to connect to Amazon S3 (Simple Storage Service) and upload data from a file stored in an S3 Bucket.
You will learn how to connect to a local file in your computer and save it as a new dataset in SPICE
We will discuss concepts such as Dimensions and Measures, and you will learn how to change the Data Types to the columns in your datasets.
You will learn how to use Geospatial fields and hierarchies. We will also talk about the benefits and limitations of Automatic Geocoding in Quicksight.
You will learn how to add new columns to your original table by Joining it with other tables from different data sources.
You will learn about one limitation that QuickSight has when it comes to creating datasets with Joins and Geospatial fields.
You will learn about how to organize your data to make it more accessible and easier to use. We will talk briefly about creating Calculated fields in the Data Preparation stage.
Learn how to apply row-level security to your Users in QuickSight.
Learn how to apply row-level security to your Groups in QuickSight, and how to add more granularity to your filters.
Learn how to implement column-level security to your Users and Groups in QuickSight.
Sharing a Dataset is a great way to collaborate with other users in your organization, let's learn how to do it in QuickSight.
If you want to cut some costs in SPICE, you should delete all the Datasets that are not being used. Learn about the precautions you should take before doing it.
It's time to make the data talk! Start by creating a new Analyis.
Let's learn how the Analysis environment looks in QuickSight.
Let's create our first Visual in QuickSight!
You're on a roll! Let's create your first Calculated Field. But don't think this is an easy topic, we're just scratching the surface of a very powerful feature. Check the documentation in the Resources if you really want to master Calculated Fields in QuickSight.
Let's understand in depth the KPI visuals. And as we do it, we will find and correct issues in our dataset by using Dataset Filters. These kinds of tricks will become very useful in your daily data adventures.
Let's add a little pop to our Dashboard by setting up Conditional Formatting in our KPIs.
Let's dive into Bar Charts. These, together with Line Charts are the visual types that you will use more often. We can guarantee that!
Drill-down layers add value to your visuals while saving some space in your Dashboard. Let's learn how to do it!
Let's apply what we learned and let's pinpoint and fix some issues in our dataset.
If your data has geographic fields, knowing how to use maps will add a lot of value to your work. Let's learn the fundamentals of the geospatial visual types in Quicksight.
Parameters have many different functionalities. We will now learn how to use Parameters to Control our visuals by using Controls and Calculated fields.
Let's tune up our Dashboard by adding dynamic Titles and Tooltips to our Visuals.
Learn how to add two measures to the same Visual.
Let's recap and validate our job so far while we learn how to edit our Calculated Fields.
Filters are key in Quicksight (as well as in any other BI Tool). Let's learn how to apply numeric filters to our Visuals.
Filtering by Dimensions is key in any Dashboard or Analysis. Let's learn how to set these in Quicksight.
When you share a Dashboard, chances are that your users will need to explore and focus on a particular date range. This is something you can set up creating Date Filters.
Let's add some boost to our regular Date Filters by using Parameters!
Adding actions to your Dashboards simplifies a lot the navigation by creating simple interactions with the data. Let's learn how to set up Filter Actions.
Adding actions to your Dashboards simplifies a lot the navigation by creating simple interactions with the data. Let's learn how to set up URL Actions.
Adding actions to your Dashboards simplifies a lot the navigation by creating simple interactions with the data. Let's learn how to set up Navigation Actions.
The final touch to every Dashboard is visual Customization. This lecture will show you how to apply your visual identity to any Dashboard in Quicksight.
After your work is done, if you're part of a team you can share your Analysis with your colleagues for reviewing or enhancement.
Congratulations! Your analysis is ready and now it's time to share with a wider audience. Now is when Dashboards come into play. In this lecture, we'll explore how to create and share Dashboards, as well as how to control the actions that the users can take.
Keep the users engaged by sending them the Dashboards they use via email on a schedule.
We welcome you to this course where you will learn the fundamentals of Amazon QuickSight (and lots of advanced features too).
If you are here, you probably already asked yourself and Google: what is Amazon QuickSight? But just as a refresher:
Amazon Quicksight is a cloud-scale business intelligence (BI) service that you can use to deliver easy-to-understand insights. Amazon QuickSight connects to data in the cloud and many different sources. In a single data dashboard, QuickSight can include AWS data, third-party data, big data, spreadsheet data, and more. As a fully managed cloud-based service, Amazon QuickSight provides enterprise-grade security, global availability, and built-in redundancy. It also provides the user-management tools that you need to scale from 10 users to 10,000, all with no infrastructure to deploy or manage.
QuickSight gives decision-makers the opportunity to explore and interpret information in an interactive visual environment. They have secure access to dashboards from any device on your network and from mobile devices.
And you will be able to build all that right after completing this course: we guarantee it!
In this course, we will focus on Connecting to your Data and Prepping it for analysis. Then we will thoroughly guide you through the Dashboard creative process and you will learn some cool tricks that you won’t find elsewhere. And the best of all: once you’re finished, you will have an actual Dashboard with real data and a lot of functionalities that you can show to everyone! But before showing it to others, please, take some time to apply what you learned and improve it, make it really yours and take the first step into your new Amazon QuickSight Rockstar.
There are other QuickSight features, like Machine Learning Insights, and Q. You can learn about those in our YouTube channel (Data Doozers), so join us there as well! Good luck and thanks for joining us in this amazing journey of Data analysis and visualizations.