Project description:
Data Connection and Transformation
Utilized AWS DataBrew for data connection and transformation, working closely with the client to create tailored relationships and basic transformations not handled within QuickSight
Data Storage
Stored transformed data in Amazon S3, ensuring an organized and accessible data repository
Data Cataloging
Employed crawlers to catalog the data, creating a structured and searchable data catalog
Querying
Leveraged Amazon Athena for querying the formatted tables in the data catalog, preparing the data for BI analysis
QuickSight Integration for BI
Integrated the prepared data with QuickSight, delivering insightful dashboards tailored to NVPC's needs
