How DMAIPH Uses Analytics > Doctor’s in Houston

I love public data mining projects like this…

Here is what we need:
A list of primary care, internal medicine, general medicine, and geriatric physicians in the Houston area who have written prescriptions for the atypical antipsychotic class of medications.


  • These physician specialties (primary care, internal medicine, general medicine, and geriatric physicians)
  • In these cities in the Houston MSA (Houston, Texas City, Pearland, Friendswood, Clear Lake, Missouri City, Sugarland, Katy, Cypress, Spring, The Woodlands, Tomball, Conroe, Cleveland, Kingwood, Porter, Humble, Baytown, Pasadena, Beaumont)
  • Can we get this mapped into an Excel spreadsheet with the following columns of data:
    • Separate columns for last name, first name
    • Specialty
    • Address
    • Overall volume of Medicare claims for all of the antipsychotic medications (quetiapine fumarate, Seroquel, Seroquel XR, risperidone, Risperdal, Abilify, olanzapin, and Zyprexa).

If you find research projects like this interesting, then DMAIPH is the place for you! 🙂


Analytics Outsourcing – DMAIPH has successful set up Filipino analytics teams for over a dozen U.S. based businesses. Offering both virtual and office based teams that specialize in problem solving using data, new technology and analytics techniques is our strength. Finding and empowering analytics talent is increasingly challenging, but we have it down to a science. Contact DMAIPH now at or connect with me directly to learn more about how to set up an analytics-centric team in the Philippines.


Analytics and Process Improvement

Had an interesting text conversation yesterday that I thought worth sharing as it brings up a good question… can you have process improvement without analytics?

I got a text randomly yesterday from a friend who is considering a new job as an analyst for a hospital.


Friend: Hi Dan, I got a question on analytics. If I wanted to increase the utilization of rooms in a hospital, what kind of data should I be looking at?

Me: Do you want a well thought out plan or a quick and dirty answer?

Friend: I suppose quick and dirty.

Me: Length of patient stay. % of special needs patients. Physical dimensions of space to see if space is optimized. Understanding of patient process flow to see where wasted time is. Then put it all together to come up with some current metrics and then track against optimal case metrics.

Friend: What exactly do I need to be looking for if I go look at length of stay? What are optimal case metrics?

Me: To optimize usage, you need to gather data for key metrics as they currently are. And then project the same metrics is everything was working at its most efficient state. Length of stay is a key metric as you need to determine what is causing longer than expected patient stays. This will help you minimalism things causing wasted time. Analytics will identify waste and then you use metrics reporting to manage the waste. Make sense? This sounds like as much a process improvement project as it does analyst work doing some new metrics reporting. It could be a very interesting project with both short-term consulting on the process improvement and long-term need for an analyst to monitor the data via metrics reporting.

Friend: Yeah, you are making lots of sense. So, if I were trying to shorten length of stay, I would look at current length of stay per case. Then look for all the factors impacting length of stay, and then improve the process flow for the ones where its taking too long.

Dan: Something like this is how I would start.

Based on my experience, when you are presented with a business problem and asked to help solve it. It’s almost always an issue of a process that is inefficient or wasteful that is the root cause, but you need plenty of data to identify that. A good analyst is just as much a process improvement guru as they are a reporting expert.


Analytics Consulting – As a founding member of Gloabl Chamber Manila, DMAIPH specializes in a variety of analytics consulting solutions designed to empower analysts, managers and leaders with the tools needed for more data-driven decision-making.

We have helped dozens of companies in both the U.S. and the Philippines, get more analytics in their business.

Contact DMAIPH now at or connect with me directly so we can tailor an analytics solution made just for your unique requirements.

13 Months in the Philippines – Lesson 7 – November 2012 – Flying Solo

Muntinlupa City, Metro Manila, Philippines

When I got back from the U.S. in early November, things were very different. And that’s and understatement. They weren’t just different everything was starting to fundamentally change. My partners and I split ways. The project in Clark ended. I no longer had an office to go to. My right hand girl left to get married and have a baby. My trainees all found jobs. Professionally I was flying solo for the first time and it was exhilarating. I decided to take what I had learned from BPO Elite’s short coming and apply the lessons to a new company that would become DMAI.


However, I also knew that even though I was charting my own course, I would need lots of help from people to be successful. I ratcheted up my networking and took on a new consulting gig with a medical transcription company. I started looking for marketing partners who can help me get my message to a broader audience and I started looking for better short term ROIs on my projects.

By the end of the month it was paying off. I was starting to make decent money and had a master plan to launch the new company in January.

From an analytics perspective, I dove deep into the needs of my new client. I did a lot of research on healthcare outsourcing to learn the players, the trends and the sweet spots. Gathering data and fashioning it into a marketing strategy was priority one. Determine which products would give the company the best ROI, updating the marketing message and focusing in on key markets was the plan. It was a well polished business strategy that was deeply grounded in my analysis. The sky is the limit!

Analytics Tool > Microsoft Access >

Analytics Concept > Needs Assessment >

YouTube Resource >

My Analytics Story – My passion is solving problems by bringing together the best talent, cutting edge technology and tried and true methodologies. DMAIPH is all about empowering people towards better Decision-Making through the use Analytics and business Intelligence. This is what I do best. Contact DMAIPH now at or connect with me directly for a free consultation about getting more analytics into your career and your business.