I was recently tasked with ingesting several large zip files (over 5G) into our Anticipatory Intelligence tool workflow. When processing files for our tool we…
As someone who has generally only used Amazon Web Services (AWS) in the past, I recently had the unique experience to leverage Microsoft’s Azure Cloud…
Comparing CSV Files Using KNIME I was recently tasked with retrieving a file from a website for use in our anticipatory analysis tool. The file…
Manual data entry from PDF forms is a common business process. While there are ways to use Adobe technology to automate data collection through fillable…
Not all cloud providers offer similar solutions. In fact, the differences between the leading cloud warehouse offerings can be quite drastic. So, what should your…
Data warehouses are moving to the cloud at an increasing pace. Each year the technology gets better and better and the costs become more affordable.…
I recently hit my fourth year working for my current company, and when evaluating my goals for the upcoming year, my advisor suggested I look…
Recently, while working on the next generation of the middleware for our advanced predictive analytics platform, I repeatedly found myself encountering situations in our business…
Today it feels like everything is moving to the cloud. Even large enterprise data warehouses that many people thought would never leave the on-premise data…
In our advanced predictive analytics platform, we’ve built some very innovative techniques that let users model aggregated data using arbitrary grouping of target entities and…
There are a lot of definitions of Master Data Management out there today. “Master data management (MDM) is a technology-enabled discipline in which business and…
The transition from working daily in the office to the comfort, or sometimes discomfort, of our own homes, has presented many of us with some…
App GUIDs in Qlik Sense are unique for each environment. Different environment, different GUID. Different URL for the app. That is life in Qlik Sense.…
This is the third and final blog a part of my deep dive series for dimensional modeling. Today, I will focus on Bridge Tables in…
In our advanced predictive analytics platform, we rely on KNIME for virtually all of our ETL needs and large portions of our modeling. A single…
In this blog post, a part of my deep dive series, I will focus on Degenerate Dimensions in this post. When introducing the concept of…
As many organizations undergo the latest modernization cycle, many companies and agencies are turning towards cloud storage as a partial solution to help become a…
Agenda Introduction Part 1: Github setup and first commit Part 2: Clone repo to start a new local project References Introduction Some time ago, my…
When developing stand-alone workflows for my past KNIME related blog entries, I’ve often distributed their associated source data files by embedding them right in the…
In my previous post about Slowly Changing Dimensions (SCDs), I provided you an overview of the four most common SCDs types and how they are…