Category: Videos

ETL vs ELT

If you’ve seen my video on ETL then you’re aware of the important role these kinds of integration tools play within an organization. However in that video I don’t spend a lot of time talking about ELT. So in this video I’d like to draw a distinction between these two options. ETL stands for Extract…
Read more

Where should logic live?

Raw data, to actionable information. That's ultimately a need in every organization. It’s why we have data governance programs, it's why we spend hours over databases, ETL tools, reports, and analytics. But how you set those processes up really matters. Just like the setting up the assembly line mattered for Ford. Before Ford’s assembly line,…
Read more

What is a Data Catalog?

There has always been a bit of a no man's land between IT and Business. IT is supposed to know, how to work with data, but the business is supposed to know what the data represents. So we often find that neither knows enough about the data to strategically use it. What we often see…
Read more

What is a Data Moat?

In 1999 Warren Buffett coined a phrase during an interview that became an “aha moment” for investors.  He said, “The products or services that have wide, sustainable moats around them are the ones that deliver rewards to investors.” In other words having a product or service which is hard for new entrants to replicate is…
Read more

Amazon BI Tech Talk

Jared Hillam presented to over 1000 people during an Amazon BI Tech Talk. Click here to see the recording of the presentation:
Read more

What makes data “yours”

I’m going to rewind the clock to the 7th century During the Tang Dynasty in China. Commerce at that time was done by exchanging coins which had holes in the middle of them. By stringing them together and simply measuring the stack of coins you could make big trades. But obviously this made trade a…
Read more

What is Low Code

For the last 20 years or so, organizations have bought complex applications to solve big business problems. These applications have driven everything from Sales all the way to Accounting. However, organizations are often forced to fit into the vendors box of described processes to adopt these applications. The alternative is an expensive customization effort. So…
Read more

Cloud Data Streaming

The other day I was cleaning out some old CDs and equipment. I found a CD titled Napster. This brought back many memories of the early 2000s. I remember back then that when you had Napster running it would make everything else on the internet super slow. I even remember networks banning its use because…
Read more

Data Lake VS Data Warehouse

I was recently listening to a clinical psychologist talk about the different kinds of people that run organizations. He described two traits, open-mindedness, and orderliness. People that run startups tend to be high in open-mindedness, but people that run  established organizations tend to be high in orderliness. As I was putting together my next video,…
Read more

Data as Plastic…?

For almost 2 decades I’ve struggled to draw an analogy to the data management space. However, data is its own animal, it has unique quirks like the ability to be copied perfectly. And you can move data at speeds that draw no parallel to things we can observe in the physical world. So there really…
Read more