What is referential integrity? Referential integrity (RI) is a set of rules to ensure that data makes sense when it’s spread across multiple tables. For example, in a referentially correct database, you’d never be able to record a sale in your sales table for a customer that doesn’t exist in your customer table. How relational […]
How Referential Integrity Protects Your Credibility Read More »
OK, so here’s one reason why it’s important to interview candidates via video rather than just voice. There are other reasons, but this one is fun! It centers around one of our Python interview questions. It Starts with a Python Interview Last week we interviewed a candidate for a data engineering position. In this case,
Before our recent presidential elections, many polls showed Joe Biden winning (for those not in the US, we recently had an election, although I suspect you know that). And, he did, in fact, win. But, pollsters are taking a lot of heat for overstating the magnitude of that win and for expecting Biden to be
Pollsters Should Take A Hint From the CIA Read More »
Data Science / Predictive Analytics / Artificial Intelligence Is Largely About Extrapolation At its heart, predictive analytics is about making educated guesses regarding the future based on things you know about the past. Thus, the field assumes that the future will work like the past did. But, what if the future doesn’t look anything like the past?
Will Covid Break Data Science? Read More »
So, this line appeared on a candidate resume I was reviewing today… Migrated the Django database from SQLite to MySQL to PostgreSQL In fact, it appeared on resumes for two different people I reviewed today. And, a quick search of our past candidates database indicates that it appears on at least five other resumes! Let\’s
For those who think there’s a lot of fraud in resumes today… you\’re right! We\’ve seen thousands of resumes over the years and, undoubtedly, we’ve seen a lot of fraudulent ones. With resume fraud being so rampant, separating out fraudulent submissions is a critical piece of what we offer our staffing and recruiting customers. Spotting
Resume Fraud: Would This Company Use This Software? Read More »
As you move your infrastructure to the cloud, it’s important to consider how to not become beholden to a single cloud vendor. In other words, to attain cloud neutrality. I’m afraid that I don’t have all the answers on how to do this, but I do have some thoughts. In any case, I recommend that
Why you need cloud neutrality Read More »
The last edition of our newsletter focused on some very creative applications of data science tools and methods. Most of these were lighthearted, merely reflecting the interest of the creators in their subject matter – like true scientists, they applied their skills to the questions that interested them. In contrast, today’s newsletter delves into some
Technology, progress and ethics: a balancing act Read More »
Tools and techniques for management reporting and analysis have evolved since computers first came out. One can argue that the first management reporting tool was COBOL (COmmon Business Oriented Language). It allowed business people to get data out of systems created by computer people. COBOL was eventually replaced for reporting by tools like Information Builders
What’s The Difference Between Business Intelligence and Data Science? Read More »
What is Hashing? Hashing is simply passing some data through a formula that produces a result, called a hash. That hash is usually a string of characters and the hashes generated by a formula are always the same length, regardless of how much data you feed into it. For example, the MD5 formula always produces
What does it mean to hash data and do I really care? Read More »
