Tag Archives: data modeling

The Future of Health and Human Services Data Modeling (Part 2)

May 23, 2017

This is the second half of my thoughts on the question “When will the IT industry provide reusable clinical and administrative data warehouses for the Medicaid enterprise?”  The first posting discussed the current models and systems, and enumerated some barriers to creating a common data model.  In this post I consider how to overcome the… Read More »

The Future of Health and Human Services Data Modeling (Part 1)

May 15, 2017

The question was put to me “When will the IT industry provide reusable clinical and administrative data warehouses for the Medicaid enterprise?” It was a thought-provoking question that was well worth considering. Currently the healthcare insurance and provider industries are guided to target reporting that is defined by government regulation and motivated by financial incentives.… Read More »

Let’s Be Clear: DevOps and the Agile Approach

March 2, 2016

If you are a curious individual then, like me, when you hear a new buzzword of occupational interest, you Google it and try to understand what it really means and how it fits into what you do. Right? More important, you want to know how you can apply this to your everyday work life to… Read More »

The Joy of Data Viz: The Data You Weren’t Looking For

December 8, 2015

“A good sketch is better than a long speech” – Napoléon Bonaparte I recently came across this quote on the opening page of Phil Simons’ book,  “The Visual Organization, Data Visualization, Big Data, and the Quest for Better Decisions.” It is available online. Data visualization, or Data Viz as it is often referred to, is… Read More »

Data Modeling Requires Detailed Mapping — Learn Why

November 30, 2015

Mapping is an important step to understanding your data and where the data resides in your ecosystem. Mapping takes us from the known to the unknown and is effectively accomplished by using mapping tools, adopting best practices, and having a common understanding of how the mappings will be used. But mapping does take a considerable amount… Read More »

The Revenge of the Schema: Why Structure Is Crucial to Success with Big Data

November 16, 2015

One way to look at progress in technology is to recognize that each new generation provides a better version of what we’ve always wanted. If you look back at the claims for Hollerith punch card-based computing or the first generation of IBM mainframes, you find that the language is recognizable and can be found in… Read More »

Pluralism and Secularity In a Big Data Ecosystem

August 25, 2015

Solutions around today’s analytic ecosystem are too technically driven without focusing on business values. The buzzwords seem to over-compensate the reality of implementation and cost of ownership. I challenge you to view your analytic architecture using pluralism and secularity. Without such a view of this world your resume will fill out nicely but your business… Read More »

Optimization in Data Modeling 1 – Primary Index Selection

July 14, 2015

In my last blog I spoke about the decisions that must be made when transforming an Industry Data Model (iDM) from Logical Data Model (LDM) to an implementable Physical Data Model (PDM). However, being able to generate DDL (Data Definition Language) that will run on a Teradata platform is not enough – you also want… Read More »

PARTNERS DataDive: I Put Agile on Steroids & Almost Went Back in Time!

June 17, 2015

I recently participated in a business analytics project for non-profits that, as the planning progressed, seemed like a perfect opportunity to implement an agile approach, except that the work was to be completed in two days! But all the developers would be co-located. We had three objectives that fit the profile of user stories. We… Read More »