Let your data shine: What is data scrubbing?

Let your data shine: What is data scrubbing?

Here’s a compliment sure to make any business blush: “I bet your database cleans up nice—what a great opportunity for data scrubbing!”

From my experience, this moment will resolve itself with either high fives or a puzzled look that says: “What is data scrubbing?”

I’m glad you asked: Data scrubbing, or cleansing, is the act of checking business data for inaccuracies, duplicates, and outdated and incomplete entries. Data scrubbing is the process of cleaning out all the things that make data dirty and unviable for use in business intelligence (BI) software and data analytics.
(more…)

Angels and devils: 6 data quality problems that drive your business down

Angels and devils: 6 data quality problems that drive your business down

Has your business gone to a fiery inferno? Not yet? Let’s keep it that way. I’m about to conjure up advice on one business pain point you might be agonizing over: data quality problems.

Today’s companies are vying to become data-driven using business intelligence (BI) software to analyze data insights to make better decisions. According to Forbes Insights, 84 percent of CEOs are concerned about the quality of the data they’re basing their decisions on. When the lights dim on your data integrity, who knows what records or variables have been tampered with, duplicated, deleted, or forgotten about.

Bad data leads to bad decisions.
(more…)

Death from above: Is the boss to blame for stalled BI adoption?

Death from above: Is the boss to blame for stalled BI adoption?

Has your BI adoption stalled or been slower than expected? Join the club. According to Gartner, 91 percent of organizations have not yet reached a “transformative level” for maturity in data analytics. In short, nobody’s using business intelligence software to its fullest potential despite it being one of the heaviest places of investment right now.

The picture is worse for small and midsize businesses (SMBs). Sixty-five percent of SMBs don’t use BI and dashboards to analyze business data, relying instead on spreadsheets, according to research by Software Advice. This puts SMBs firmly in Level 1: “Unaware”—the lowest possible position on Gartner’s BI maturity model (Figure 1).

So who is to blame for small businesses remaining in the stone age when it comes to BI adoption?

(more…)

I failed the ‘day without data’ challenge—here’s what I learned

I failed the ‘day without data’ challenge—here’s what I learned

Lay down your iPhones, Fitbits, and Google powered gadgets. It’s time to turn yourself on airplane mode. Today, we are going to live a day without data—or die trying.

I first heard about a “day without data” in this BBC feature. Back in 2014, writer, Rory Cellan-Jones, investigated how feasible it would be to live a day without creating a data trail.

The rules for his technology fast were simple:

  1. Hand over your phone
  2. Don’t access the internet
  3. Don’t interact with any machine, service, or entity that can share your personal data

(more…)

10 inspiring 404 error pages from around the world

10 inspiring 404 error pages from around the world

If the internet were a country, it would be the most cosmopolitan place on the planet. From the language to regional variations in UX, going online is a bit different depending on where you find yourself on a map. And yet, one devilish error code is always the same: 404 page not found.

The “404 page not found” error is one of the most common errors encountered on the World Wide Web. It means the page you requested wasn’t able to be retrieved, because it moved, the URL was mistyped, the link is broken, or, most commonly, the site is down. For example, catch us on a bad day and here’s what you would find:

Getapp 404 error page
(more…)