Lab - Create Interactive Dashboards with Amazon QuickSight

Overview

Master interactive dashboard creation in Amazon QuickSight by building real-world e-commerce analytics visualizations, from dataset configuration to publishing dynamic business intelligence reports.

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

Taught by

Tags