Description
In this course, you will :
- demonstrates how to use all of QuickSight's features.
- Learn how to connect to data sources such as Excel files, S3 buckets, and SQL Server; how to transform data and add calculations; how to load data into the QuickSight visualisation interface; and how to create and format engaging visualisations and dashboards.
- explains how to share your work via dashboards that others can access on their computers or mobile devices, as well as how to share work outside of the platform via email, exports, and embedded applications
Syllabus :
1. Getting Started with AWS QuickSight
- Introducing Amazon Web Services (AWS) and QuickSight
- Comparing cloud vs. desktop applications
- Introducing visual components
2. Extracting Data
- Overviewing supported data sources
- Leveraging super-fast, parallel, in-memory, calculation engine (SPICE)
- Connecting to files
- Connecting to AWS cloud services
- Connecting to corporate data sources
- Connecting to SaaS
- Understanding data source limitations and settings
3. Transforming Data
- Renaming fields
- Removing fields
- Filtering rows
- Changing data types
- Creating calculated fields
- Adding conditional fields
- Setting up geospatial grouping
4. Loading Data
- Creating data sets
- Sharing data sets
- Refreshing data
- Joining tables
- Deleting data sets
5. Creating Visualizations
- Creating visuals
- Exploring visualization options
- Aggregating measures
- Formatting visuals
- Sorting data logically
- Filtering visuals
- Adding color themes
- Leveraging conditional formatting
- Creating table calculations
6. Configuring Dashboards
- Introducing visualization best practices
- Interacting between visualizations
- Drilling down into visuals
- Utilizing parameters
- Adding on-screen controls
- Creating stories
- Leveraging ML Insights
7. Sharing Your Analysis
- Navigating dashboard of visualizations
- Emailing reports
- Viewing on a mobile device
- Exporting reports and data
- Setting up anomaly alerts
- Embedding dashboards