Big Data. Big Decisions
InformationWeek
Special Coverage Series

Commentary

Marianne Kolbasuk McGee

Marianne Kolbasuk McGee

Senior Writer, InformationWeek

CRM Platform Can Churn Out Customized Health Apps

Los Angeles County Department of Public Health uses Microsoft's customer relationship management platform to rapidly develop niche health-related apps when off-the-shelf doesn't fit.

10 Top Medical Practice Management Software Systems
10 Top Medical Practice Management Software Systems
(click image for larger view and for slideshow)
Most healthcare organizations, including public health departments, have a lot on their IT to-do lists. The Los Angeles County Department of Public Health (LADPH) is no exception.

The agency tries to purchase commercial off-the-shelf software whenever possible. The problem is that off-the-shelf apps often can't meet the agency's specialized needs. Custom development efforts, on the other hand, can be time-consuming and costly--and still often miss the mark in meeting users' needs, said Jim Green, CIO of LADPH in an interview with InformationWeek Healthcare.

More Insights

Webcasts

More >>

White Papers

More >>

Reports

More >>

So the department two years ago began taking an innovative approach to developing specialized tools. It began using Microsoft's Dynamics CRM platform for custom application development, a strategy also known as extended relationship management (xRM).

Green is using Microsoft 's CRM xRM framework to create customized applications instead of building custom .Net applications or purchasing expensive commercial systems, such as a pharmacy inventory management app that likely would have been overkill.

[ Take more control over your own health. Read 9 Health IT Tools Patients Should Understand. ]

"When we first dipped our toe in CRM two years ago, we developed an environmental application for our vehicle inspection program," said Green. The application enabled the LADPH's environmental department to track and manage cases related to the safety of food sold from vehicles in Los Angeles, such as fruit carts. That included food vendors with the required permits, as well as those mobile vendors operating unlawfully without permits.

The environmental department had a Microsoft Access database, but no reliable way to track and manage cases. Tapping the capabilities of Microsoft Dynamics CRM xRM, it took only a few weeks for Green's team to develop a special vehicle inspection tracking app, he said. "The previous application was an amateur database application. We created a more cohesive application for the department."

"The [CRM] platform accelerates development dramatically by taking care of a lot of the plumbing and providing many built-in capabilities," said Green. "We still have requirements analysis and specifications, writing a significant amount of Javascript code in the user interface, building the screens and reports, building system interfaces, and testing. But on the other hand, there is no database code to develop, all the basic user interface elements are there, basic reporting --including dashboards--is available with no coding, and auditing capabilities are built in too," he said.

Besides assessing environmental factors in the air, water, and food that might make people sick, among many other duties the LADPH investigates communicable disease cases and outbreaks and treating affected individuals.

Still, "there's a fairly narrow range of clinical services we provide," said Green, so purchasing a third-party pharmacy system to comply with California mandates about pill container labeling and patient drug information would have been going overboard. Most of the drugs prescribed by public health clinicians are related to just a handful of communicable diseases--including tuberculosis and sexually transmitted diseases-- that are screened for and treated at the department's 14 community health centers.

"We have a small formulary of drugs we prescribe, yet we still have to comply with state prescription labeling requirements, which have the goal of improved patient safety," he said.

Those requirements include dispensing medications that are labeled with information such as the drug name and instructions for taking the med, and also a picture or description of what the drug looks like. "We used CRM to create an application for generating prescription labels, and integrated it with our legacy patient registration and scheduling systems," said Green. Before that, labels were handwritten by public health workers.

 1 | 2  | Next Page »


Related Reading




Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

BYTE encourages readers to engage in spirited, healthy debate, including taking us to task. However, BYTE moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing/SPAM. BYTE further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.

Follow InformationWeek

By The Numbers

What Are Your Primary Concerns About Using Big Data Software?

Base: 417 respondents at organizations using or planning to deploy data analytics, BI or statistical analysis software
Data: InformationWeek 2013 Analytics, Business Intelligence and Information Management Survey of 541 business technology professionals, October 2012

What Do You Think?

What's your attitude about SQL analysis on top of Hadoop?
We want fast, standard SQL analysis capabilities on Hadoop ASAP
Hadoop is for unstructured data; SQL is for relational databases
We'll give SQL on Hadoop a try, but relational DBs will remain the mainstay
Given strong SQL support on Hadoop, we'd nix the data warehouse
We're not interested in Hadoop
No opinion



Related Content

From Our Sponsor

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Five Big Data Challenges and How to Overcome Them with Visual Analytics

Business leaders often need a visual snapshot of data to quickly grasp and use it. This paper identifies five challenges in presenting data and how visual analytics can resolve them. Solutions are suggested to overcome the challenges of: speed, data clarity, data quality, displaying meaningful results, and dealing with outliers.

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Game-Changing Analytics: How IT Executives Can Use Analytics to Create Innovation and Business Success

Today's competitive advantage requires a deeper understanding of your business, your market and your customers. As an IT executive, you can drive that knowledge transformation. In this white paper, learn how to make decisions as a strategic business leader and three steps to begin an analytics initiative within your enterprise.

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

Data Visualization Techniques: From Basics to Big Data with SAS Visual Analytics

High-performance data visualization turns sophisticated analyses into meaningful graphics, leading to faster and smarter decision making. In this white paper, learn how visual analytics can transform big data, with additional features such as real-time functionality, mobile compatibility, robust applications for technical groups and accessibility for nontechnical users.

Big Data: Lessons from the Leaders

Big Data: Lessons from the Leaders

Financial performance, competitive advantage, operational efficiency, strategic decision making - every business goal can extract value from big data, and the time for doubt or inaction has long passed. In this Economist Intelligence Unit report, in-depth interviews with data pioneers reveal the link between the effective use of big data and the bottom line among other results.

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Decision-Driven Data Management: A Strategy for Better Decisions with Better Data

Which came first, the data or the decision? This white paper makes the case for having a decision in mind, then tailoring big data's volume, variety and velocity to achieve business results such as overcoming customer dissatisfaction or creating well-informed strategies in real time.

Informationweek Reports

Research: The Big Data Management Challenge

Research: The Big Data Management Challenge

The challenge of big data is real, but most organizations don't differentiate 'big data' from traditional data, and nearly 90% of respondents to our survey use conventional databases as the primary means of handling data. We'll help you understand what constitutes big data (it's not just size) and the numerous management challenges it poses.