AWS Public Sector Blog

Category: AWS Glue

Campaign reporting transformation at Boise State University Foundation

Learn how the Boise State University Foundation transformed quarterly Microsoft Excel reports into real-time dashboards using Amazon Quick, a 780-fold improvement that fundamentally changed how leadership makes decisions. It extracts actionable insights from a decades-old legacy system while supporting a major comprehensive fundraising campaign.

AWS branded background with text "Navigating polymorphic data: A Pariveda guide to AWS Glue and Salesforce integration"

Navigating polymorphic data: A Pariveda guide to AWS Glue and Salesforce integration

This post shares lessons learned by Pariveda, a strategy and technology services firm, during the implementation of a scalable and flexible data integration pipeline for a customer. We review three approaches, all leveraging AWS Glue and Salesforce capabilities, to securely publish data to polymorphic objects and compounded fields.

AWS Branded Background with text "How the University of Minnesota Athletics built a unified data layer to drive fan engagement with AWS"

How the University of Minnesota Athletics built a unified data layer to drive fan engagement with AWS

The University of Minnesota Athletics Department had access to a lot of data, but lacked a way to bring it together. Even answering simple questions, like how many tickets were sold and who received them, required hours of cross-platform data wrangling. In less than a year, the department replaced that complexity with a scalable data lake built on AWS. The new data architecture—which gives the department full visibility into ticketing transactions and digital behavior—was built by a small internal team, without requiring a complete overhaul of their existing systems.

AWS Branded Background with text "Create a multicloud FinOps dashboard with Amazon QuickSight using AWS services"

Create a multicloud FinOps dashboard with Amazon QuickSight using AWS services

In this post, we use AWS Glue, Amazon Athena, and Amazon QuickSight to build a dashboard that tracks costs associated with AWS and third-party providers. This single pane of glass allows for quick monitoring at the senior leadership level, with the ability to dig further into specific spending categories for tools and environments. Additionally, this data system makes further analytics possible.

AWS Branded Background with text "Navigating financial turbulence: How Mid-Hudson Valley Federal Credit Union used AWS AI/ML to enhance forecasting and decision-making

Navigating financial turbulence: How Mid-Hudson Valley Federal Credit Union used AWS AI/ML to enhance forecasting and decision-making

Mid-Hudson Valley Federal Credit Union (MHVFCU) needed to automate their tools and develop advanced forecasting capabilities to make informed decisions for deposit management and growth to maximize benefit for their members. For this purpose, MHVFCU leadership sought a solution that would not only save time in data preparation and analysis but also provide accurate forecasts for balances across four key deposit products: savings, checking, certificate deposits (CDs), and money market. Read this post to learn about the solution they built with AWS.

AWS Branded Background with text "Transforming Medicaid: Crafting a robust data strategy with AWS for operational efficiency"

Transforming Medicaid: Crafting a robust data strategy with AWS for operational efficiency

What if a Medicaid agency could make sure that their leadership and staff had access to a reliable, single source of truth for their data in one unified platform? The implementation of an operational data store (ODS) presents a viable solution. This post explains the architectural choices available with Amazon Web Services (AWS) to effectively create and maintain an ODS.

AWS branded background design with text overlay that says "How Fair Trade USA uses AWS to improve working conditions for farmers"

How Fair Trade USA uses AWS to improve working conditions for farmers

Fair Trade USA™ is a nonprofit organization that is committed to eliminating poverty by promoting sustainable development through ethical trade. They work to ensure fair compensation, safe working conditions for farmers and workers, and sustainable farming practices. In this post, you’ll learn how Fair Trade USA leverages Amazon Web Services (AWS) to improve working conditions for farmers and producers around the world.

AWS branded background design with text overlay that says "Using AWS for EHDS: A technical guide to building a secure health data platform"

Using AWS for EHDS: A technical guide to building a secure health data platform

In an earlier post, Build secure and scalable data platforms for the European Health Data Space (EHDS) with AWS, we discussed a reference architecture for building secure and scalable data platforms for secondary usage of health data in alignment with the European Health Data Space (EHDS) using Amazon Web Services (AWS). This follow-up post walks you through the technical implementation details for building such federated data governance and analysis platforms using AWS. Whether you are a healthcare organization, technology provider, or systems integrator, this post aims to equip you with the technical knowledge to build a secure data platform for secondary usage of health data in alignment with the EHDS Regulation.