ATLAS Tutorial: Data Sources - Dashboard

OHDSI
23 May 201903:57

Summary

TLDRThis video tutorial explores the Data Sources tool within the Atlas platform, guiding users through selecting a data source and standardized reports such as dashboard, data density, and condition occurrence. It demonstrates the visualization of data through tables and graphs, including patient demographics, age distribution, and observation periods. The dashboard report offers insights into the database's population stability and patient observation trends over time, with data available from 2000 to October 2018.

Takeaways

  • 📊 The 'DataSources' tool within the Atlas platform is used for analyzing observational databases.
  • 🔍 Users can select from multiple data sources configured in their Atlas environment.
  • 📈 The platform offers a variety of standardized reports such as dashboards, data density, and various condition and procedure reports.
  • 🗂️ The dashboard report provides an overview of the data source, including the source name and the number of persons in the database.
  • 👥 The dashboard breaks down the population by gender, showing the percentage of males and females.
  • 📈 A histogram on the dashboard displays the age at first observation, with the ability to hover for exact numbers.
  • 📊 The cumulative observation graph shows the distribution of time observed in the database, with years on the x-axis and population percentage on the y-axis.
  • 🕰️ The 'Persons with Continuous Observation by Month' graph provides a timeline view of the number of continuously observed persons.
  • 📅 The data ranges from 2000 to October 2018, allowing for historical analysis of the population stability over time.
  • 🔑 For more information and usage details, the script directs viewers to visit the Odyssey website.

Q & A

  • What is the 'data sources' tool within the Atlas platform?

    -The 'data sources' tool is the first menu option on the left-hand side of the Atlas platform, allowing users to select a data source and a report to analyze observational databases configured within the Atlas environment.

  • How many data sources are available in the provided example?

    -In the provided example, there are two data sources available: source 1 and source 2.

  • What type of reports can be selected within the 'data sources' function?

    -Users can select from a series of standardized reports such as dashboard, data density, person visit, condition occurrence, condition era, procedure date, drug exposure, drug era, measurement observation, death, and Achilles heel.

  • What information is provided on the dashboard report for source 1?

    -The dashboard report for source 1 provides information such as the source name, the number of persons in the database, population breakdown by gender, age at first observation, cumulative observation graph, and persons with continuous observation by month.

  • How many patients does source 1 contain according to the script?

    -Source 1 contains 80.58 million patients.

  • What percentage of the population in source 1 are females?

    -Females represent 50.5 percent of the population in source 1.

  • What does the age at first observation histogram show?

    -The age at first observation histogram shows age on the x-axis and the number of people on the y-axis, with the ability to hover over bars to see the exact number of people in each age group.

  • What does the cumulative observation graph represent?

    -The cumulative observation graph represents the distribution of the amount of time observed in the database, with the number of years on the x-axis and the percent of the population on the y-axis.

  • How many patients in source 1 are observed for two years or more according to the cumulative observation graph?

    -According to the cumulative observation graph, 42 percent of the patients in source 1 are observed for two years or more.

  • What does the 'persons with continuous observation by month' graph display?

    -The 'persons with continuous observation by month' graph displays the calendar month on the x-axis and the number of persons on the y-axis, showing the number of people continuously observed within each calendar month.

  • What is the time range of the information available in the database according to the script?

    -The database has information from as far back as 2000 all the way through October of 2018.

  • Where can users find more information on Odyssey, including additional details on using Atlas and data sources reports?

    -Users can find more information on Odyssey, including additional details on using Atlas and data sources reports, by visiting the website odyssey.org.

Outlines

00:00

📊 Introduction to Atlas Platform's Data Sources Tool

This paragraph introduces the 'Data Sources' tool within the Atlas platform, which is accessible through the first menu option on the left-hand side. Users can select a data source and a report from a dropdown menu, revealing available observational databases configured in their Atlas environment. Two sources, 'source 1' and 'source 2', are presented as examples. The speaker selects 'source 1' and proceeds to explore standardized reports such as dashboard data, density, person visits, condition occurrences, and various other metrics related to medical data observation. The dashboard report for 'source 1' is then demonstrated, showing tables and graphs that provide insights into the data.

Mindmap

Keywords

💡Atlas platform

The Atlas platform is the central focus of the video, serving as a data management and analytics tool. It is a software environment where users can configure and access various observational databases. The script mentions it as the place where data sources can be selected and reports generated, indicating its role in facilitating data analysis and visualization.

💡Data sources

Data sources refer to the origins of the data that are being analyzed within the Atlas platform. In the script, data sources are mentioned as the first menu option, which allows users to select from different observational databases configured within their Atlas environment. The concept is integral to the video's theme as it sets the stage for the type of data that will be explored and analyzed.

💡Standardized reports

Standardized reports are pre-defined templates or formats that users can select to generate data summaries within the Atlas platform. The script lists several types of standardized reports such as dashboard, data density, and condition occurrence, which are used to present data in a structured and easily interpretable manner, enhancing the understanding of the data.

💡Dashboard

A dashboard in the context of the video is a type of standardized report that consolidates various data visualizations and metrics into a single view. The script describes how selecting the dashboard report for source 1 presents a series of tables and graphs, providing an overview of the data, which is crucial for quickly grasping key insights from the data.

💡Observational databases

Observational databases are collections of data that are gathered by observing and recording information, often without manipulating or controlling variables. The script mentions that these databases are configured within the Atlas environment, and they contain data that can be analyzed to understand patterns, trends, and behaviors.

💡Gender breakdown

Gender breakdown is a demographic analysis that categorizes data by gender. In the script, it is used to describe how the population in source 1 is divided between males and females, with different color codings in a donut plot. This helps in understanding the distribution and representation of different genders within the database.

💡Age at first observation

Age at first observation is a metric that indicates the age of individuals when they were first recorded in the database. The script describes a histogram that presents age on the x-axis and the number of people on the y-axis, showing how the population is distributed across different age groups upon their initial entry into the database.

💡Cumulative observation

Cumulative observation refers to the total amount of time individuals have been observed within the database. The script explains a graph that shows the distribution of the time observed with the number of years on the x-axis and the percentage of the population on the y-axis, providing insights into the duration of data collection for each individual.

💡Continuous observation

Continuous observation is the ongoing monitoring and recording of data over time. The script mentions a graph that shows the number of persons with continuous observation by month, indicating the stability and size of the observed population over a given period, which can be traced back to 2000 up to October 2018 in the example provided.

💡Odyssey

Odyssey is the organization or platform that provides the Atlas tool and additional resources for data analysis. The script ends with an invitation to visit odyssey.org for more information, suggesting that Odyssey offers further details and support for using the Atlas platform and understanding the data sources and reports.

Highlights

Introduction to the data sources tool within the Atlas platform.

Data sources is the first menu option on the left-hand side.

Selecting a source presents options for available observational databases.

Two data sources provided: source 1 and source 2.

Selection of source 1 for demonstration.

Availability of standardized reports within the data sources function.

Examples of reports include dashboard, data density, and various condition and procedure reports.

Dashboard report provides an overview with tables and graphs.

Source name and number of persons in the database displayed.

Population breakdown by gender with color coding.

50.5 percent of the population are females.

Age at first observation histogram with age on the x-axis and number of people on the y-axis.

Notable increase in database entries for individuals in their early 20s.

Spike in database at age 65.

Cumulative observation graph shows distribution of time observed.

42 percent of patients observed for two years or more.

5 percent of the population observed for eight years or more.

Persons with continuous observation by month graph.

Database information ranges from 2000 to October 2018.

Stability of the population over time can be analyzed.

Summary of the dashboard report and invitation to explore Odyssey for more information.

Transcripts

play00:01

[Music]

play00:08

today we're going to dive in to the data

play00:12

sources tool within the Atlas platform

play00:14

data sources is the first menu option on

play00:17

the left-hand side and if you click data

play00:19

sources you'll be presented with the

play00:21

option to select a source and select a

play00:24

report clicking on the drop-down for

play00:27

selecting a source will show you all of

play00:28

the available observational data bases

play00:31

that you have configured within your

play00:33

Atlas environment here we see two data

play00:36

sources provided source 1 and source 2

play00:38

I'm going to select source 1 from there

play00:42

we can select a series of standardized

play00:45

reports that are available within the

play00:47

data sources function including

play00:48

dashboard data density person visit

play00:52

condition occurrence condition era

play00:54

procedure date ex drug exposure drug era

play00:58

measurement observation death an

play01:01

Achilles heel let's take a look here

play01:04

I've selected source ones dashboard

play01:06

report and we can see a series of tables

play01:09

and graphs are presented on the screen

play01:11

let's walk through the information

play01:13

provided on the dashboard our first

play01:16

information provides us the source name

play01:17

and the number of persons in the

play01:19

database here we can see that source 1

play01:21

contains 80 5.8 million patients on the

play01:26

right hand side we can see that

play01:27

population broken down by gender we can

play01:30

see males and females in different color

play01:33

codings on this donut plot here we can

play01:36

see by hovering over that there are 43

play01:39

million patients who are females that

play01:42

represents 50 point 5 percent of the

play01:44

population the next graph on the

play01:47

dashboard shows us age at first

play01:49

observation in this histogram presents

play01:53

age on the x-axis and the number of

play01:55

people on the y-axis and if I hover over

play01:58

any of the particular bar x' we can see

play02:01

the exact number of people that belong

play02:02

to that group so in this particular

play02:04

database we can see that patients that

play02:07

are newly born represent 3 million

play02:10

patients in this database we can see

play02:12

that there seems to be an increase in

play02:14

the number of people who are entered

play02:15

this database in their early 20s and

play02:17

there seems to be a spike in this

play02:19

database

play02:20

age 65 the next graph down is the

play02:25

cumulative observation graph and here we

play02:27

can see a distribution of amount of time

play02:32

observed in a database with the number

play02:34

of years on the x-axis in the percent of

play02:37

the population on the y-axis hovering

play02:39

over any particular plot on this graph

play02:42

reveals information about what data

play02:44

point I'm looking at so here we can see

play02:47

amongst this database 42 percent of the

play02:51

patients in this database are observed

play02:53

in the data for two years or more and if

play02:56

I go further we can see that five

play02:58

percent of the population is in this

play03:00

database for eight years or more the

play03:05

last graph on the dashboard is persons

play03:07

with continuous observation by month and

play03:09

here we can see the x-axis showing us

play03:12

the calendar month and the y-axis

play03:13

showing us the number of persons so for

play03:16

any given calendar month if I hover over

play03:18

we can see the number of people who were

play03:21

continuously observed within that

play03:23

calendar month this database has

play03:25

information from back from 2000 all the

play03:29

way through October of 2018 and in any

play03:33

given month we can explore to see that

play03:36

the number of people with that belong to

play03:38

that month and the stability of the

play03:40

population over time so this was a

play03:44

summary of the dashboard report for more

play03:48

information on odyssey including

play03:50

additional details of using atlas and

play03:52

the additional data sources reports

play03:54

check us out at odyssey org

Rate This

5.0 / 5 (0 votes)

Related Tags
Healthcare DataAnalytics ToolAtlas PlatformData SourcesObservational DatabasesPatient AnalysisDashboard ReportGender BreakdownAge DistributionObservation TrendsContinuous Monitoring