Category: Data Warehousing

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

NYC Hands-On Snowflake Workshop

Don't miss our next hands on workshop of Snowflake at their New York offices Join Snowflake and Intricity for this 3 hour hands-on workshop. Snowflake is changing the way organizations perceive the limits of their data consumption. This new paradigm has many seeking to learn how this could be leveraged in their organizations. This workshop…
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

Intricity Wins a Snowflake Partner of the Year Award

Snowflake gave out awards at their annual partner conference for partners that matched the company's values. Intricity was nominated for multiple categories and won the "Get it Done" category. Jared Hillam and Glenn Hillam were in attendance to accept the award. "This technology has become a no brainier recommendation for our team of architects. The…
Read more

Physical vs Virtual DW

In many of my videos I discuss data warehousing under the assumption that the data warehouse has physical tables. Meaning, data gets loaded to a specific database structure which optimizes for querying. However, there is a virtual approach to data warehousing by creating databa se views. There are pros and cons to doing this, and…
Read more

Fort Lauderdale Hands-On Workshop

Intricity is excited to announce the next workshop on this coming September 7th in Fort Lauderdale FL at the BoatYard. In this workshop Intricity will be doing a hands on event with both Looker and Snowflake. Don't miss the opportunity to get real world experience! https://www.snowflake.com/from-0-to-snowflake-in-90-minutes-ft-lauderdale/?utm_source=intricity&utm_medium=referral&utm_campaign=0-to-snowflake-ft-lauderdale-9-7-18-intricity
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

Data Junkyard

Abdication of Responsibility... This is a term that has been circling in my head over the last few months. What it means is that despite a person's ability to perform their duty... they don’t. Unfortunately, we’ve been seeing an abdication of responsibility trend inside many organizations over the last few years. The story goes something…
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