Your Sheets are all Spread out

Wouldn't it be fitting if the term "spreadsheets" was derived from the notion of having sheets of rows and columns and important data strewn all over your desk? In many ways I already think of them in that way, mostly because spreadsheet users don't have database training. Such training is key to future uses and... Continue Reading →

Advertisements

Here’s a Random Thought

Computer Science and numbers go hand in hand, so it should be of no surprise that I look at things and see angles, counts, averages, probabilities and order. I also spend some time playing games of chance and slots, more as an escape than anything else. It amazes me how many superstitious players waste their... 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 →

It’s my Field of Work

As a designer of database applications I have plenty of tools and techniques at my disposal. One such item is the field. One might think of it as a spreadsheet column, only far more. Columns have several data types, but a database field has those and so much more. Though they may have text and... Continue Reading →

A Bit about Computers

Many non-computer types may think that computers are mysterious, evil or incomprehensible. This is where a little bit of information can go a long way. The smallest item of data in a computer is the Binary digIT or BIT. It is handled nicely by a transistor or voltage level signifying on and off. It is... Continue Reading →

Simple is better

It's one thing to go nose to the grindstone building a data repository, but it's another to make something that no one can understand or even maintain. One of the first steps a professional developer takes is to simplify what once appeared complex. We have an advantage here because we come from the outside. Your... 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 →

Many to many, A Data party!

The Relational Database structure has a certain elegance about it. When performing data modelling, you do not want to run into a many to many relationship. Thankfully, in my 20 years of building databases for businesses of all types, I never ran into a relationship I couldn't tame. Most every collection of data can be... Continue Reading →

Powered by WordPress.com.

Up ↑