Lab - Create Interactive Dashboards with Amazon QuickSight

Overview

This lab introduces learners to Amazon QuickSight, AWS's cloud-native business intelligence service, providing hands-on experience in creating interactive dashboards and visual analytics. The lab simulates a scenario where the learner, as a data analyst at a growing e-commerce company, is tasked with creating insightful visualizations from the company's sales data.

Syllabus

• Introduction to Amazon QuickSight
Overview of Amazon QuickSight
Benefits as a cloud-native BI service
QuickSight's role in data analytics and visualization
• Setting Up the Environment
QuickSight account setup
Connecting QuickSight to data sources
Importing sample e-commerce sales data
• Data Preparation
Understanding and exploring the dataset
Data cleaning and transformation techniques
Creating and managing datasets in QuickSight
• Creating Visualizations
Introduction to visual types (charts, graphs, tables)
Best practices for selecting visualization types
Designing clear and meaningful visualizations
• Building Interactive Dashboards
Dashboard layout and customization
Adding and configuring visualizations in dashboards
Implementing interactive features (filters, drills, parameters)
• Advanced Features
Leveraging calculated fields and functions
Utilizing SPICE for large data sets
Implementing security features and data access controls
• Real-world Scenario: E-commerce Sales Dashboard
Simulating the analyst task
Identifying key metrics and KPIs for the e-commerce company
Developing a comprehensive sales dashboard
• Publishing and Sharing Dashboards
Options for dashboard publishing
Configuring access permissions
Sharing dashboards with stakeholders
• Review and Assessment
Recap of key concepts and skills
Troubleshooting common issues
Assessment through hands-on project submission
• Conclusion and Next Steps
Exploring additional QuickSight features
Integrating QuickSight with other AWS services
Resources for further learning and development

---

Subjects

Programming