We use cookies, including third-party cookies from Google to serve personalized ads through AdSense, to operate this site and understand how it is used. By continuing to browse, you accept this use. See our Privacy Policy and Terms of Use for details, including how to opt out of personalized advertising.
Accept
SmartData CollectiveSmartData Collective
  • Analytics
    AnalyticsShow More
    Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
    Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
    23 Min Read
    Flat editorial illustration: The article is about automating the collection, preparation, and delivery of marketing data across p
    From Data to Dashboards: 5 Marketing Reporting Automation Software Picks
    12 Min Read
    Flat editorial illustration: The article contrasts passive follower totals with a behavioral path from attention and trust to cli
    Creator Analytics Beyond Follower Count: Seven Metrics That Measure Audience Behavior
    11 Min Read
    Flat editorial illustration: The article connects AI and marketing analytics with managerial judgment grounded in consumer behavi
    How an Online MBA in Marketing Connects AI and Data Analytics
    11 Min Read
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers -- AI-generated illustration
    What Kind of Problem-Solving Distinguishes Data Analysts From Software Engineers
    7 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-25 SmartData Collective. All Rights Reserved.
Reading: Using Link Analysis to Plan the Healthcare System
Share
Notification
Font ResizerAa
SmartData CollectiveSmartData Collective
Font ResizerAa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Business Intelligence > Using Link Analysis to Plan the Healthcare System
Business Intelligence

Using Link Analysis to Plan the Healthcare System

vincentg64
vincentg64
5 Min Read
Using Link Analysis to Plan the Healthcare System
Photo by qimono on Pixabay (https://pixabay.com/photos/bacteria-microbiology-organism-3658992/)
SHARE

Link Analysis can be used to understand where patients go to receive healthcare treatment and to identify bottlenecks in service that must be addressed. It is an interesting form of datamining that involves tracking populations as they move from point to point in a system. This analysis requires an ability to create hierarchical buckets (population segments) so that analysis may focus on the ‘% of the population’ as it moves from point to point in a system. At one point, I know that SPSS and SAS datamining software had modules that automated this datamining process, and I once used a DataMart (Analytix) with a ‘Segment Manager’ module that was great for hierarchical programming.

Every Canadian has a Health Card that he or she must present when visiting a family physician, healthcare specialist (eg, Neurosurgeon), MRI or X-Ray clinic, hospital, medical centre, or other healthcare provider treatment. Data warehouses store details of every visit including a unique identifier code for every healthcare provider who was involved in the treatment. The healthcare provider who made the referral, the date on which the referral was made, and who the patient is scheduled to see next are also captured. With this data, a patient may be tracked as he or she moves from one healthcare provider to the next in the system.

As an example, let’s assume that there are the following fields of information about healthcare visits for 100 patients in a given month:

– patient identifier (HEALTH CARD #)
– date/time stamp of visit (VISIT DATE/TIME)
– code of the healthcare provider visited (PROVIDER VISIT)
– reason for visit (VISIT REASON)
– code of healthcare provider to whom patient is referred (PROVIDER REFERRAL)

More Read

How to Use Big Data to Increase Social Proof
How to Use Big Data to Increase Social Proof
How Data Analytics and BI Professionals Used Twitter In October
Social Blog Carnival: Getting the 411 on Social ROI
AI Chatbots Can Help Retailers Convert Live Broadcast Viewers into Sales!
How Data Analytics and BI Pros Used Twitter in August

Data exploration reveals that one or more of the following healthcare providers (PROVIDER) were visited by at least one or more patient during the month in question:

– Hospital (1111)
– Medical Centre 1 (2345)
– Medical Centre 2 (2346)
– Physician 1 (0023)
– Physician 2 (0024)
– Laboratory 1 (3346)

A preliminary analysis of the raw visit data may indicate that several patients have visited more than one healthcare provider, while others may have visited multiple providers on the same day.

Before a Link Analysis may be conducted, the PROVIDER VISIT and PROVIDER REFERRAL variables must be transformed from row to column format for each patient. For example, ‘Medical Centre 1’ must change from being a value in the PROVIDER variable to a boolean variable, and multiple visits to Medical Centre 1 require matching variables to capture this activity. ‘Medical Centre 1a’ and ‘Medical Centre 1b’ variables will capture that a patient made two visits to Medical Centre 1, whether on the same day or on different days. It is critical that the VISIT DATE/TIME variable be used to order the multiple provider variables from first to last date/time of visit. The process must be followed for each of the other 5 healthcare provider values in the PROVIDER variable.

Once this datashaping has been completed, the newly-created boolean variables must be rolled-up to reflect the ‘% of the population’ as it moves through each healthcare provider for treatment. SAS and SPSS had a tool that would present results in the form of a web: a thicker line connecting two healthcare providers reflecting a higher ‘% of the population’ that traveled between them. Viewing Link Analysis results graphically might lead us to conclude that there are bottlenecks in the healthcare system or providers who must have their patient load reduced and shared withy others.

Share This Article
Facebook Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Data-Driven Pultrusion: Best GFRP Rebar Machines & ROI
Big Data Exclusive
Flat editorial illustration: The article contrasts tools for gathering fresh interviews with tools for analyzing existing qualita
10 AI Market Research Tools That Turn Qualitative Data into Insights
Artificial Intelligence Big Data Exclusive
Flat editorial illustration: The article compares proxy MCP servers by what an AI agent can do through them: manage proxy account
Proxy MCP Servers: 7 Options and What Each Lets an AI Agent Do
Artificial Intelligence Big Data Data Collection
Flat editorial illustration: The article is about joining public web signals with internal business metrics so BI teams can inter
Alternative Data in BI: Bringing Public Web Data Into Your Dashboards
Big Data Business Intelligence Exclusive Web Analytics

Stay Connected

1.2KFollowersLike
33.7KFollowersFollow
222FollowersPin

You Might also Like

Why Business Needs Public Data
AnalyticsBusiness IntelligenceData ManagementData MiningData QualityDecision ManagementSocial DataWorkforce Data

Why Business Needs Public Data

11 Min Read
The Social Web as a Customer Support Channel
CRMSocial Data

The Social Web as a Customer Support Channel

4 Min Read
Why the Future of Social Media Will Depend on Artificial Intelligence
Artificial IntelligenceSocial media

Why the Future of Social Media Will Depend on Artificial Intelligence

9 Min Read
AI Creates New Trading Opportunities for Investors Buying Real Estate Stocks
Artificial Intelligence

AI Creates New Trading Opportunities for Investors Buying Real Estate Stocks

7 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

How To Get An Award Winning Giveaway Bot
How To Get An Award Winning Giveaway Bot
Big Data Chatbots Exclusive
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
From Bolts to Bots: How AI Is Fortifying the Automotive Industry
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US
© 2008-26 SmartData Collective. All Rights Reserved.
Welcome Back!

Sign in to your account

Username or Email Address
Password

Lost your password?