Economies of Scale

Or how to design your database so it can be expanded, or scaled, in the future. Let's say your firm's data record is the owner, or the root, of your table hierarchy. There are two things you can do. First is to put a field into your primary table that points to the record indicating... Continue Reading →


The New Normal

Here's another reason why spreadsheets don't make the grade. Normalization. This is the practice of analysing sample data to determine whether or not a particular column or field should be 'off-loaded' to what we call a lookup table. I'll provide examples, but don't confuse this with our discussion of Relational. Relational is addressing the parent-child... Continue Reading →

If not Reactive, be Proactive

So let's say you are in denial about needing to replace your spreadsheets for your business. You want to take a pass on my free one hour assessment. That's cool, no worries. Or are there? Do some investigation for yourself. First, identify all of the spreadsheets you use in the course of a week and... Continue Reading →

Grow up to be a Big Boy

Or act like a big boy now. A bigger company. Think for a moment of some of those tech-like data exercises that big companies have but you don't. Larger companies collect information on some aspects that may seem needless, but they do it to keep employee needs and safety in mind. Have you considered a... Continue Reading →

Using a Fish Eye Lens

Which would you rather be? A big fish in a small pond or a little fish in a big ocean. The average business owner might go for the big fish, but I would not. The big fish might be comfortable now but any further growth is severely limited. The pond cannot sustain its growth. Of... Continue Reading →

We have our Ups and downs

Have you ridden a roller coaster lately? The exhilaration of the descent is amazing, but the anticipation and trepidation of the climb is not overly pleasant. This is somewhat reversed in business. As you climb to success the excitement builds, but a fall from grace can be painful. The problem is that many companies do... Continue Reading →

They are so intellectual

Let's examine two small businesses in Niagara Falls Ontario. What might distinguish one from the other? The factors we find may tell us how they compete. OK, they each have a small unit, building or storefront. Hmmm, nothing different there. How about vehicles? No, they each have a small cargo van. Big deal. Staff size?... Continue Reading →

A different perspective

Aside from training in computer science and data management, my career has given me the opportunity to witness many companies and their underlying information. This affords me the ability to consider additional data items that would prove beneficial as well as others which are simply clutter. I can orchestrate capturing data input in a way... Continue Reading →

Funny thing about a CRM

That is at least when it comes to my wish for your business. You see, I have been writing about elevating you to a Relational Database, and I bet your company already uses one and you didn't know it… a CRM. After-all, the acronym stands for Customer Relationship Management. In this case, it helps you... Continue Reading →

Powered by

Up ↑