Data Model Fluidity in Analytics

The world of data, intelligence and analytics perpetually evolves, so too will the data structures we work with. With the rising popularity of data lakes, there’s a steadily increasing need for developers, consultants, and vendors to work with all kinds of data, be it structured, unstructured, or semistructured.

Continue Reading

Writing Short Blog Posts is Difficult and That's OK.

How long should my blog posts be?

I’ve got several drafts in progress right now on various topics.

It turns out it’s really hard to write short blog posts, at least on relatively technical subjects. From some quick research though, maybe that’s OK.

Neil Patel suggests that writing 3000+ words in a blog post is OK, and while shorter posts may gain some immediate popularity, longer-form content also has longer-term value, provided it’s oriented to “evergreen” topics and formats.

Joe Bunting also remarks that content should have a purpose, the goals of which should dictate the resulting format.

As a quick guideline, based on your goals,

Neil’s remarks on “evergreen” content align nicely with the goal of organic search, highlighting longer formats based on:

  • How-to Guides
  • Resource Lists + Reviews
  • Unchanging stances on industry issues
  • Frequently-asked-questions collections
  • Industry definitions

So I think I’m OK: my content tends to be fairly technical in nature, and I naturally tend to longer-form, lending to more advantage in the organic search category. I’ll continue to train myself to the thresholds above, based on content goals, when needed.

The Agile Data Warehouse on Amazon Redshift

Redshift is a great OLAP database environment, though its limitations may surprise you. Many of its benefits are derived from its simplicity, belied by these limitations. Provided these techniques and design considerations can be applied, Redshift offers the flexibility needed for growing, evolving organizations to leverage their data at massive scale. Overcoming these limitations requires a tooling ecosystem surrounding Redshift, whereas Redshift must be respected for the simple, efficient, and yet robustly queriable datastore that it is.

Continue Reading