ATLAS Tutorial: Data Sources - Visit

Summary

This video explores the Atlas platform's data sources capability, focusing on the visit report. It demonstrates how to analyze different types of visits through a tree map, table, and various graphs. The platform allows users to drill down into detailed reports, such as outpatient visits, stratified by year, age, and gender. The script also covers the analysis of visit frequency by month and the age at first occurrence, providing a comprehensive understanding of patient visit patterns over time.

Takeaways

• 🗺️ The Atlas platform allows users to explore data sources and reports through a standardized common data model.
• 📊 The visit report begins with a tree map representation, which shows the prevalence and density of different types of visits.
• 🔍 Hovering over sections of the tree map provides detailed statistics about the visits, such as percentages and averages.
• 📝 The report includes a table view for a more detailed and organized look at the data, listing different types of visits and their prevalence.
• 🔑 Users can drill down into specific visit types to access additional reports and stratifications.
• 📈 The prevalence of outpatient visits is shown over time, with a trellis graph by age and gender, providing insights into demographic trends.
• 📉 The report also includes a graph showing the prevalence of visits by month, indicating any seasonal variations in visit frequency.
• 📊 The 'age at first occurrence' graph uses a box plot to display the median and distribution of ages for first visits, by gender.
• 🔄 The visit report demonstrates the ability to explore data for different concepts, such as inpatient visits, for comparative analysis.
• 🔗 The script concludes with an invitation to visit Odyssey.org for more information about Atlas and the platform's capabilities.

Q & A

What is the main focus of the video script?

The video script focuses on demonstrating the visit report feature within the data sources capability of the Atlas platform, which allows users to explore and analyze various types of patient visits using the OMOP common data model.

What is the OMOP common data model mentioned in the script?

The OMOP common data model is a standardized data structure used in observational health data research, which allows for the systematic analysis of data from different sources in a consistent manner.

What does the tree map representation in the visit report show?

The tree map representation in the visit report shows the prevalence and density of information associated with different types of visits, providing a visual overview of the data composition.

How can users interact with the tree map in the visit report?

Users can hover over the boxes in the tree map to get more detailed information about the data, such as the percentage of persons with a certain type of visit and the average number of visits.

What additional view is available for the visit report data?

Besides the tree map, there is also a tabular view available, which lists the different types of visits and provides detailed statistics such as the number of persons, prevalence, and records per person.

How can users drill down into specific visit types for more detailed analysis?

Users can click on a row representing a specific visit type in the table view to access additional drill-down reports that provide more in-depth information stratified by various factors like year, age, and gender.

What type of graph is used to represent the prevalence of outpatient visits over time?

A line graph is used, with the x-axis representing the calendar year and the y-axis showing the prevalence of visits per thousand persons, trellised by age deciles and with separate line series for males and females.

What insights can be derived from the prevalence graph by year, age, and gender?

The graph provides insights into the trajectory of visits over time, the composition of patients experiencing these visits, differences in visit prevalence between genders, and how utilization varies across different age groups.

What does the prevalence by month graph represent?

The prevalence by month graph represents the frequency of a particular type of visit, with the x-axis showing the calendar month and the y-axis showing the prevalence per thousand person years.

How is the age at first occurrence of an outpatient visit represented in the visit drill down?

The age at first occurrence is represented using a box plot, showing the median age, as well as the distribution of ages at the 10th, 25th, 75th, and 90th percentiles.

What additional information can users explore beyond outpatient visits?

Users can also explore inpatient visits and other concepts within the data domain, with the ability to drill down into each concept for a complete summary and detailed analysis.

Where can users find more information about Atlas and the additional reports available within the data sources tab?

For more information about Atlas and the additional reports available, users can visit the Odyssey website at Odyssey.org.

Outlines

00:00

📊 Exploring Visit Report in Atlas Platform

This paragraph introduces the functionality of the Atlas platform's data sources capability, focusing on the visit report. The visit report begins with a tree map representation, which visually displays the prevalence and density of different types of visits. Users can interact with the tree map to get specific insights, such as the percentage of outpatient visits and the average number of visits per person. The report also includes a tabular view, listing the types of visits, the number of persons affected, prevalence, and records per person. By selecting a specific visit type, users can drill down into more detailed reports, such as the prevalence of outpatient visits stratified by year, age, and gender. The graph provides a macro understanding of the trajectory of visits over time, showing patterns like gender differences and age group utilization. The paragraph concludes with a box plot analysis of the age at first occurrence of an outpatient visit, illustrating the median, percentiles, and interquartile range.

05:01

🔚 Conclusion of Visit Report Demonstration

The final paragraph wraps up the demonstration of the visit report feature within the data sources tab of the Atlas platform. It serves as a conclusion, summarizing the capabilities and inviting viewers to seek more information about Odyssey, including additional details on Atlas and the variety of reports available. The paragraph directs interested parties to visit Odyssey's official website for further exploration and resources.

Keywords

💡Atlas platform

The Atlas platform is the central focus of the video, serving as a data analysis tool that allows users to explore and report on various data sources. It is mentioned as a way to access and standardize data to the OMOP Common Data Model, which is essential for conducting comprehensive data analysis. The script describes navigating through the platform to select different reports, emphasizing its user interface and functionality.

💡Data sources

Data sources refer to the origins of the information that is being analyzed within the Atlas platform. The script discusses selecting data sources and how they can be standardized to a common model, which is crucial for ensuring consistency and comparability in the data analysis process. The video demonstrates how to access and interact with these data sources within the platform.

💡OMOP Common Data Model

The OMOP Common Data Model is a standardized framework used to structure health data, allowing for interoperability and ease of analysis across different datasets. In the script, it is mentioned as the model to which data is standardized, highlighting its importance in the data analysis process facilitated by the Atlas platform.

💡Visit report

The visit report is a specific type of report within the Atlas platform that focuses on analyzing different types of patient visits to healthcare facilities. The script describes the visit report's features, such as the tree map representation and the tabular view, which provide insights into the prevalence and characteristics of visits.

💡Tree map

A tree map is a visualization technique used in the Atlas platform to represent hierarchical data as nested rectangles. In the script, it is used to show the prevalence and density of information associated with different types of visits, providing a visual summary of the data at a glance.

💡Prevalence

Prevalence in the context of the video refers to the proportion of a population that has a particular characteristic, such as having an outpatient visit. The script uses the term to describe the frequency of different types of visits within the data source, indicating how common these visits are among the population.

💡Tabular view

The tabular view is a way of representing data in rows and columns, allowing for detailed examination of individual data points. In the script, it is mentioned as an alternative to the tree map, providing a more granular look at the data, including the number of persons, prevalence, and records per person for different types of visits.

💡Drill down

Drill down is an analytical process of examining data at increasingly detailed levels. The script describes using the drill-down feature in the Atlas platform to explore additional information about specific concepts, such as outpatient visits, and to gain deeper insights into the data.

💡Stratification

Stratification in data analysis involves dividing data into subgroups based on certain characteristics to better understand variations within the data. The script mentions the prevalence of outpatient visits being stratified by year, age, and gender, which allows for a more nuanced understanding of visit patterns across different demographics.

💡Trellis graph

A trellis graph is a type of visualization that displays multiple instances of the same graph, each representing a subset of the data. In the script, it is used to show the prevalence of visits broken down by age deciles and gender, providing a detailed comparison across different age groups and genders.

💡Box plot

A box plot is a graphical representation of the distribution of data based on the five-number summary: minimum, first quartile (Q1), median, third quartile (Q3), and maximum. The script describes using a box plot to show the age at first occurrence of an outpatient visit, illustrating the distribution and central tendency of the ages within the data source.

💡Odyssey

Odyssey is the overarching system or organization that the Atlas platform is a part of. The script ends with a reference to Odyssey, suggesting that it is the provider or developer of the Atlas platform and offering additional information and resources for users interested in learning more about the platform's capabilities.

Highlights

Introduction to exploring the visit report within the data sources capability of the Atlas platform.

Ability to select data sources standardized to the OMOP common data model.

Selection of the visit report for detailed analysis.

Tree map representation of the prevalence and density of different types of visits.

Interactive hover feature to present detailed visit information.

Outpatient visit statistics: 76% of persons with an average of 37 visits.

Inpatient visit statistics: 12% of the population with an average of 1.7 visits.

Tabular view of data with line listings for different visit types.

Drill-down feature to explore additional information on selected visit types.

Prevalence of outpatient visits stratified by year, age, and gender.

Trellis graph displaying visit data across different age groups and genders.

Observed values for outpatient visits among specific age and gender groups.

Macro understanding of the trajectory of visits over time.

Visualization of the frequency of visits by calendar month.

Analysis of the stability of visit frequency over time.

Age at first occurrence graph with box plot representation.

Median age at first outpatient visit and distribution analysis.

Capability to explore inpatient visits for consistent utilization patterns.

Summary of all concepts in the data domain with drill-down capability.

Conclusion of the visit report demonstration and invitation to Odyssey.org for more information.

Transcripts

[Music]

today we're going to explore the visit

report within the data sources

capability of the Atlas platform from

Atlas I can click on data sources and

from here I can select any source of

data that has been standardized to the o

mop common data model and select any

number of different reports within the

data sources capability here I've

selected the visit report the visit

report starts with this tree map

representation showing me the prevalence

and density of information associated

with different types of visits within

this particular data source if I hover

over any of these boxes I'm presented

with information representing the

information here for example we can see

that this source 76 percent of persons

have an outpatient visit and on average

persons with an outpatient visit had 37

such visits 12 percent of the population

or 11 million patients had at least one

inpatient visit in on average persons

with an inpatient visit had 1.7 visits

this tree map display allows you to

explore the relative composition however

in this graph above we can see a tab

that says table which represents the

data in a tabular view so here we can

see a line listing representing the four

different types of visits in this data

source outpatient visit emergency room

is an inpatient visit in long term care

visit and we can see the number of

persons the prevalence in the population

and for those different types the

records per person for each of these

particular records we can click on a row

to drill down to additional information

so for example here I will select the

outpatient visit concept once i've

selected that concept additional drill

down reports will be presented here I

can see the prevalence of outpatient

visits stratified by year age and gender

on this graph we can see that the x-axis

represents calendar year

we can see that this source of data for

example has information from the year

2000 through 2017 we can see that the

graph is trellis by age deciles starting

from 0 to 9 all the way through 90 to 99

and each graph has a line series

representing the gender here blue

representing male and pink representing

female if I hover over any particular

line we can see the observed value so

here on where I'm pointing

we can see that amongst patients age 30

to 39 in the year 2011 there were 600

and 2021 outpatient visits per thousand

persons this graph provides you a macro

understanding of the trajectory of

visits over time the composition of

which patients seem to experiencing

these so here we can see that women

appear to have more visits than men the

seems to be some growth in this

particular database and it also seems

that there's a high utilization

consistent across the different age

groups the second graph here is the

prevalence by month here the x-axis is

representing calendar month and the

y-axis is representing the prevalence

per thousand person years for if I hover

over the graph for any given calendar

month I can see the prevalence per

thousand persons so here we can see

April 2007 there were 300 outpatient

visits per thousand persons when this

graph can allow you to see whether or

not the frequency of a particular visit

is stable over time the last graph shown

in the visit drill down is age at first

occurrence here we can see that we are

grouping by gender being male and female

we are showing on the y-axis the age at

first occurrence and we see a box plot

represented here so here in this

particular data source we can see that

the median age at first occurrence of an

outpatient visit was 40 and we can also

see the full distribution represented by

the 10th and 90th percentile as well as

the interquartile range at the 25th and

7

percentile this rounds it up for our

ability to explore the outpatient visit

but we can see that we can select any

concept from this table so now we can

also explore inpatient visits to see

whether or not the pattern of

utilization is consistent for that

particular concept

so in this modality we can see a

complete summary of all the different

concepts represented in this data domain

but be able to drill down to each and

every one this concludes our

demonstration of the visit report in the

data sources tab for more information

about Odyssey including additional

detail on Atlas and the additional

reports available within the data

sources tab please check us out at

Odyssey org