Category: Amazon Athena

The Association of Schools and Programs of Public Health (ASPPH) — a nonprofit association with a vision for improved health and well-being for everyone, everywhere — partnered with Amazon Web Services (AWS) Professional Services (AWS ProServe) to move their curated data to a managed data lake on AWS. In this blog post, we share how ASPPH and AWS designed and built the data lake and the results of moving to a modern, scalable data architecture.

Healthcare authorities and providers use state-run controlled substance databases (CSDs) to track prescriptions and identify patients for substance abuse. CSDs help evaluate treatment options, screen patients who may be at risk for drug abuse problems, and make informed decisions about prescribing medication. This post explains how healthcare authorities can leverage CSD data to enhance their decision-making processes within business operations by using Amazon Web Services (AWS).

At the end of 2022, Northwestern University’s Kellogg School of Management had a decision to make. The on-premises SQL server used by faculty and students had reached the end of its life, and the school needed to identify a cost-effective way forward while ensuring that the datasets would remain highly available for researchers to use on demand. After weighing various options, Kellogg worked with Amazon Web Services (AWS) to create a data lake that fit its unique needs.

Climate risk consists of transition risk and physical risk. Transition risk represents regulatory and market-based risks while physical climate risk covers climate-related earth processes and its effects on the built and natural environment. In this blog post, we highlight how to use Amazon Web Services (AWS) to enrich your asset portfolio with open climate data hosted in AWS.

Fleet managers can use Amazon Web Services (AWS) to ingest and analyze fleet driver data. In this post, we share how a large public transit agency in the United States worked with AWS to create a proof-of-concept (POC) to analyze operator behavior and improve its visibility of sudden acceleration-based events.

Learn how the National Cancer Institute Imaging Data Commons (IDC) team migrated the Imaging Data Commons data to AWS using AWS DataSync. Plus, learn how to get started with IDC data, which is accessible at no cost through the AWS Open Data Sponsorship Program.

As the amount of health data increases, different healthcare, life sciences, population health, and public health organizations are working to modernize their data infrastructure, unify their data, and innovate faster with technologies like artificial intelligence and machine learning (AI/ML). In this blog post, we dive deep on architecture guidance that enables healthcare providers to improve patient care.

In 2020, Meta introduced the Daylight Map Distribution, which combines OpenStreetMap (OSM) data with quality and consistency checks from Daylight mapping partners to create a no-cost, stable, and simple-to-use global map. This blog post provides a brief overview of OSM and Daylight followed by a step-by-step tutorial using five real-world examples. We combine the powerful query capabilities of Amazon Athena from with the feature-rich Daylight OSM data to demonstrate a typical OSM data analysis workflow.

At AWS, many public sector customers operate fleets of vehicles (e.g. emergency response, public transportation) that generate location data, which is ultimately stored in a data lake. These customers frequently ask how they can quickly visualize this data and extract insights that can help them optimize how they operate their vehicle fleets. In this post, learn how to use Amazon Athena and Amazon Location Service to perform ad hoc reverse geocoding on a notional dataset of vehicle location history, and visualize the results on an Amazon QuickSight map.

Many public sector customers in government, healthcare, and life sciences have data lakes that contain addresses (e.g., 123 Main Street). These customers frequently ask how they can quickly visualize these addresses on a geographic map to get a more intuitive understanding of how these addresses are distributed. In this post, learn how to use Amazon Athena and Amazon Location Service to perform ad hoc geocoding on an example dataset and visualize these geocoded addresses on an Amazon QuickSight map.