Gain Business Insights with AnalyticsIQ and Amazon QuickSight

More Info

Every day, organizations make crucial decisions that affect their business operations. The ability to make timely and informed decisions can significantly influence growth and customer satisfaction. Access to accurate data and the right tools to extract insights can empower organizational leaders to navigate these decisions effectively.

In the healthcare sector, where choices can directly impact individual health outcomes, having precise data to provide insights into personal experiences—especially concerning social determinants of health—can lead to improved health results and potentially save lives. By understanding the diverse social conditions of the individuals they serve—including transportation access, technology use, economic stability, and food security—healthcare providers can tackle disparities and ensure all patients have an equal opportunity to attain their desired health levels.

For instance, consider a healthcare organization or governmental body aiming to identify the various factors affecting public health, particularly among different ethnic groups. In this article, we will guide you on utilizing AnalyticsIQ datasets along with Amazon QuickSight to derive valuable insights that can enhance your organization’s decision-making processes. We will focus on the AnalyticsIQ Social Determinants of Health Sample Data dataset to examine the connections between ethnicity and health, as well as how social determinants influence individual health and wellness.

Solution Overview

The following architecture diagram illustrates the components involved in this solution:

The solution comprises several key elements:

• The AnalyticsIQ Social Determinants of Health Sample Data, which showcases the impact of social determinants on health and wellness, is available under the Extended Provider Program.
• AWS Data Exchange allows users to subscribe to the sample AnalyticsIQ dataset from AWS Marketplace.
• An Amazon Simple Storage Service (S3) bucket is utilized to store the AnalyticsIQ sample dataset.
• QuickSight enterprise edition is employed to create visualizations using the sample dataset.

To implement this solution, follow these high-level steps:

1. Export the dataset to an S3 bucket.
2. Sign up for a QuickSight subscription.
3. Create a QuickSight dataset.
4. Generate visualizations in QuickSight.

Prerequisites

To execute this solution, an AWS account is necessary. If you don’t already possess one, you can sign up easily.

Export the Dataset to an S3 Bucket

To begin working with your dataset, you need to subscribe and then export the data to an S3 bucket. Follow these steps:

1. If you don’t have a bucket, go to the Amazon S3 console and select Create bucket.
2. Assign a unique name for your bucket. Ensure it is created in the us-east-1 Region.
3. To subscribe to the sample dataset, follow this link. In the AWS Data Exchange console, click Continue to subscribe.
4. On the Complete subscription page, select Subscribe.
5. For Select Amazon S3 bucket folder destination, choose your S3 bucket.

The subscription process may take up to 2 minutes to finalize.

6. In the AWS Data Exchange Console, under My subscriptions in the navigation pane, click Entitled Data.
7. Under Products, expand Social Determinants of Health Sample Data – Offline, and select the AnalyticsIQ sample dataset.
8. On the Revisions tab, choose the revision and click Export to Amazon S3. Enter the name of the S3 bucket you created for this dataset, leaving other options at default. Click Export.

You will find the dataset in your S3 bucket under the prefix Sample-Data.

Sign Up for a QuickSight Subscription

To register for a QuickSight subscription, follow these steps:

1. Open QuickSight in the AWS Management Console.
2. Select Sign up for QuickSight and choose Enterprise.
3. Enter a unique name for your QuickSight account and provide a valid email.
4. For Allow access and autodiscovery for these resources, select Amazon S3 and choose Select S3 buckets.
5. Choose the S3 bucket created earlier and finish the process. After your QuickSight account is established, select Go to QuickSight account.

Create a QuickSight Dataset

To create your dataset, complete the following steps:

1. Using a text editor, create a JSON file. Copy the following content and replace the placeholder with your bucket name:

{
    "fileLocations": [
        {
            "URIPrefixes": [
                "https://.s3.amazonaws.com/Sample-Data/"
            ]
        }
    ],
    "globalUploadSettings": {
        "format": "TSV"
    }
}

2. In the QuickSight console, click New data set on the Datasets page.
3. Select S3. For DataSource, provide a name. Upload the JSON file you created. Click Connect and then Visualize.

Create Visualizations in QuickSight

Let’s visualize the average number of vehicles owned by various ethnic groups. For further information about the fields, check the Key Data Points section on the AWS Marketplace listing.

1. Choose the sheet and select the vertical bar chart under Visual types.
2. From the Fields list, drag EthnicIQ_v2 to the X-axis and Number_of_Autos to Value. Set the Aggregate to Average.

Now, let’s visualize the urgent care visits across ethnic groups.

3. Click +Add, and choose Add Visual.
4. Select a pivot table under Visual types.
5. From the Fields list, drag EthnicIQ_v2 to Rows and HW_Urgent_Care_Visits_SC to Values. Set the Aggregate to Average and sort the HW_Urgent_Care_Visits_SC field in descending order.

You can create additional visualizations as shown in the examples.

From the visualizations created using sample data, it is clear that healthcare service utilization diminishes when transportation access is limited. The AA ethnic group has fewer vehicles compared to their peers, resulting in lower wellness scores. Transportation challenges may be a critical factor in this scenario. Job satisfaction also plays a significant role in overall wellness. Additionally, the sample data indicates that the Hispanic community has a higher frequency of recent urgent care visits. Does this suggest that these groups lack adequate preventative care, resulting in more urgent care visits?

Sleep quality and job satisfaction are vital components influencing stress levels and overall health, particularly for shift workers. What strategies could be implemented to enhance sleep quality for this demographic?

These are merely a few of the countless valuable analyses that can be derived from the AnalyticsIQ Social Determinants of Health Sample Data dataset. Such insights are invaluable for health professionals, preventative care advocates, employees, researchers, and government bodies seeking to empower communities and develop better public health and social determinant solutions. For more insights on this topic, you might find this link helpful as they are an authority on the subject.

Clean Up

To avoid incurring ongoing charges, follow these steps to clean your resources:

1. On the QuickSight console, select your datasets and delete them.
2. Navigate to the S3 console, locate your bucket, and delete it.