The quality of any data analysis created to inform business decisions will ultimately be constrained by the quality of the underlying data. If the data is faulty, then the analysis will be faulty too. This is why data wrangling–the transformation of raw data into a format that is appropriate for use–has become such a ubiquitous task in most organizations. Unfortunately, the significance of data wrangling is still often overlooked. And this is where data-savvy business analysts can help save the day.

Thanks to infrastructure as a service (IaaS) and software as a service (SaaS) architectures, the utility of and business case for model-driven, no-code and low-code platforms have become more compelling than ever. More and more enterprises are entrusting their digital transformation, regulatory compliance, and business process management objectives to model-driven, no-code or low-code business application platforms.  These model driven platforms also raise the bar for the business process modeling skills of the business analysts, systems analysts and process owners who use them.

Many BAs struggle to produce ‘normalized’, function-independent data models (or don’t produce them at all). Very few business stakeholders can appreciate such models as “… a picture worth a thousand words.” This article describes an easy-to-create, simple-to-understand view data model. The view is of just those records involved in an information system capability supporting a specific business activity.

NOTE: This article uses the business-friendly terms record and field rather than the usual data modeling terms entity (or class) and attribute.

A crisis always highlights the need for specific managerial and leadership Behaviors (Behavioral School of Leadership). These behaviors of course are triggered by specific personal characteristics of the leader (Leadership Trait Paradigm), by the specific conditions (Leadership Contingency Theory) and by the willingness and devote of individual in continues practicing these behaviors any possible occasion. Although it is my intention to approach the leadership from a behavioral point of view, a synthesizing and integrating logic is more than necessary to have a holistic view that can lead to insightful conclusions.

In this fun piece, Ron examines the connection between rules and counts, such as KPIs. Ever wonder why different people can count the very same things and come up with different answers? Fear the numbers you’re going by aren’t telling exactly the right stories? In viewing a measure, how far the truth might have been stretched? Come along on this short travel story and let’s explore the matter together.