Posts Tagged ‘data management’

The other day I was at the bank where they told me about the new tracking sheets the sales people fill out.  Their biggest complaint was what a pain the forms were to fill out.  Then I remembered what makes such forms easy to complete.  HOT KEYS!

That’s right, hotkeys.  With the right combination of keystrokes, filling out an Excel form is quick and easy!

Here, let me show you:

Need to copy the entry from the cell before?  Use CTRL and ”.  Add today’s date by pressing CTRL and semi-colon. Need to enter the current time?  Use CTRL and colon.

Below is the link to the Microsoft help page that lists all of the shortcuts!



Read Full Post »

The advantage of a dashboard is that it’s easy to use, provides timely data and, most importantly, gives an idea as to how to go about implementing potential improvements and solutions. It helps explain your marketing metrics visually, making it a lot easier for people to understand the information… without geeking out on them.

Marketing DashboardFor example, you can use a dashboard to compare marketing expenditures to revenue earned. Unlike reading bar graphs and spreadsheets, a dashboard makes it easy for you to quickly see where the marketing money is going, and, more specifically, which activities are leading to sales. Many people love this because it allows you to measure marketing ROI. Even better than that, is it allows you to make changes to your tactics and rapidly notice the impact.

Now that you realize how great it would be to have a dashboard, let’s talk about a few best practices for creating one.

1. Use Clear Labels
Depending on who’ll be looking at your reports, be sure they’ll know what each graph means. Consider, Jersey, Jamaica Red, Caucasin and Florida.  These words all come from the same category, but if you didn’t know I was listing breeds of cattle you might think I was having a problem with Geography.

2. Avoid Acronyms
While an acronym might be convenient and easy to read, it could lead to confusion, especially if your data is shared with people outside of your field. In a recent meeting I was in, people were throwing around the term, “QSR.” This could mean Quick Service Restaurants, Quasi-Stellar Radio or Quality System Regulation. I thought they meant Quality Satisfaction Rate. Imagine my confusion until I realized they were meaning Quick Service Restaurants. (Click here to see what else QSR means).

3. Use Legends or Keys
Don’t just make sure your reports show your information well, but that they define and describe it well, too. A legend will allow you to use colors and abbreviations to your advantage, while making sure your audience knows what they’re looking at.

4. Use Color Wisely
I’m colorblind, so the use of colors on graphs sometimes is a problem for me. When making graphs with colors use the options that have a marker with the display.  It also helps when you print the graph with a black and white printer.

Read Full Post »

Baby chick and eggHow many chickens are hiding inside those eggs? Without tracking performance data, we’d have no way of knowing. Getting good information is about knowing what data to track. If you don’t have the right data, you won’t get the right information. Without that, are you well-equipped to make sound business decisions?

As with anything what you get out of something is only as good as what you put into it.  Data is the number one ingredient for information.  It’s the building blocks of good reporting.  For instance, if you only track weekly data, you won’t be able to have a daily report.  If you only track category-level data, you won’t get item-level reporting.

Before collecting your data, it’s critical that you ask yourself two questions:
1. What information do I really need?
(This is so you look at the right data)
2. What do I plan on doing with the info once I get it?
(This helps you take action, rather than collect information for no real purpose)

These and other considerations go into data management to provide reporting intelligence. To run your business most effectively, you should regularly review sales, departmental revenue, costs, operational efficiencies and more. You’d be amazed at how closely this information ties to sales and marketing.

For one of our food & beverage clients, Holy Cow did an analysis of their labor and cost of goods sold. They were able to make decisions about which high-margin items made the most sense to promote in their specials, as well as when to ramp up their staff. Fully trained staff at the onset of the busy season meant that customers were happier, ensuring repeat business, and operations went smoothly. But that’s not the big winner. The client increased their profitability by tens of thousands of dollars. Now that’s smart business!

Written By Reuben Gradsky, Data Specialist

Read Full Post »