Have you ever imagined a world where transactional systems were able to focus solely on the tasks they were built to complete? Have you ever…
Define and create a data layer. That was the task my team was handed a few weeks back, with minimal context. The client is a…
In my previous two blog postings in this series, I’ve covered the basics of the dice game Farkle and developed a simple way of modeling…
Data warehouses and modern cloud architectures go together better than chocolate and peanut butter. The “abilities” (scalability, flexibility, reliability, etc.) of the cloud allows one…
Automating Common Business Tasks with UiPath Outline Background of the Use Case – What are we doing? Automation Plan – How should this be done?…
In the first part of this blog series, I introduced the dice game called Farkle and explored some of its basic statistics related to the…
In the past six months, I prepared for and passed the SY0-501 certification exam. There were a lot of misconceptions I had going in, and…
Traditional data warehouses were often created as custom reporting data structures using on-site servers. These on-prem servers need to have a team of DBAs, storage…
My wife and I love to Farkle and it drives our kids crazy. Don’t be offended; Farkle is a dice game played with six dice…
In my previous Operational Data Store (ODS) blog, we discussed how to design an ODS. In this post, I will describe how to optimize the…
In my previous blog posting, I started to explore what it would take to teach a machine learning model how to throw a virtual football…
Operational Data Stores (ODS) are entity-centric and should only contain data about that specific entity. When designing an ODS, you will use relational database design…
With the Super Bowl just around the corner here in the United States, I recently found myself trying to think of a football-themed blog posting. …
I recently started my first position as a data scientist. On my first day on the job, I headed to the client site, armed with…
An Operational Data Store (ODS) is a powerful tool to help provide any company or organization operational reports with up-to-date 360-degree views of any and…
KNIME and the JSON Format The JSON data-interchange format is a widespread data format roughly comparable with XML. KNIME has excellent interoperability with data in…
I have been a full-time telecommuter over 18 years so when I am not on a conference call, I am usually listening to music while…
The definition of an Operational Data Store (ODS) is a subject-oriented, integrated, volatile collection of current data designed to support the tactical decision-making of an…
I believe that parents fall into two categories during the holiday season. Those who are buying Legos by the pound with the belief they are…
The three keys to warehouse project success are to quickly, efficiently and consistently refresh the data in the warehouse. Here are four ways to design…