Web Design
Crime Dataset Analysis
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis. Created dashboards revealing trends in crime by geography, time, and demographics.
Year :
2024
Project Duration :
4 weeks
Technologies :
Data Warehousing · Amazon Web Services (AWS) · Azure Databricks · Python (Programming Language) · SQL
Project :
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis.
Challenge :
Handling missing or malformed records and maintaining schema consistency across staging layers.
Summary :
Delivered a scalable pipeline that empowered data-driven decisions through structured analysis of crime trends.
More Projects
Web Design
Crime Dataset Analysis
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis. Created dashboards revealing trends in crime by geography, time, and demographics.
Year :
2024
Project Duration :
4 weeks
Technologies :
Data Warehousing · Amazon Web Services (AWS) · Azure Databricks · Python (Programming Language) · SQL
Project :
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis.
Challenge :
Handling missing or malformed records and maintaining schema consistency across staging layers.
Summary :
Delivered a scalable pipeline that empowered data-driven decisions through structured analysis of crime trends.
More Projects
Web Design
Crime Dataset Analysis
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis. Created dashboards revealing trends in crime by geography, time, and demographics.
Year :
2024
Project Duration :
4 weeks
Technologies :
Data Warehousing · Amazon Web Services (AWS) · Azure Databricks · Python (Programming Language) · SQL
Project :
Built an end-to-end data warehousing solution on Databricks and AWS using the bronze-silver-gold data architecture. Ingested data from AWS buckets, performed cleaning and transformations with Python and SQL, and stored the refined datasets for analysis.
Challenge :
Handling missing or malformed records and maintaining schema consistency across staging layers.
Summary :
Delivered a scalable pipeline that empowered data-driven decisions through structured analysis of crime trends.