Archive for February, 2009

Sports Data Is My Favorite Data

February 17th, 2009

Sunday’s New York Times Magazine had a fascinating article about sports and data analysis by Michael Lewis. Lewis is the author of the 2003 best-seller Moneyball, which profiled a new breed of baseball analysts who revolutionized how major-league baseball players were valued (or undervalued) in the 1990s. In Sunday’s article Lewis does the same thing for the NBA, focusing in particular on Houston Rockets forward Shane Battier.

Battier is mediocre at best in every traditional measure of performance: points, assists, rebounds, blocked shots, steals, and so on. He even lacks athletic ability. “He can’t dribble, he’s slow and hasn’t got much body control,” according to Houston general manager Daryl Morey. Yet he’s one of the most valuable players in the NBA, measured by the fact that when he’s on the floor, his team wins, and when he’s not, they don’t. The subtle reasons for this, and how the Rockets came to discover and measure them, make for a great read.

In one statistical measure of Battier’s effectiveness, he’s clearly in the same league as perennial all-stars. Lewis explains,

One well-known statistic the Rockets’ front office pays attention to is plus-minus, which simply measures what happens to the score when any given player is on the court. In its crude form, plus-minus is hardly perfect: a player who finds himself on the same team with the world’s four best basketball players, and who plays only when they do, will have a plus-minus that looks pretty good, even if it says little about his play. Morey says that he and his staff can adjust for these potential distortions — though he is coy about how they do it — and render plus-minus a useful measure of a player’s effect on a basketball game.

I won’t be coy. Here’s how I would extract the individual “plus-minus” metric for Player X (NBA teams, take note):

1) Put every point scored and every player substitution from all NBA games in a season into a online database. Make sure each score and substitution is recorded in order, with a time stamp.

2) Calculate the average number of points scored and allowed per minute while Player X is in the game. The difference between them is the net impact, or the plus-minus.

3) Subtract the contribution of the other players in the game, averaging them by time spent in the game. For example, if Player X’s team averaged a 1-point gain per minute while he was in, but the other four players have a combined average of 0.9 points gained per minute, then Player X gets credit for 0.1 point per minute. Similarly, subtract the contribution of the five opposing players. The result is Player X’s individual plus-minus.

This recipe contains a chicken-and-egg problem. To calculate Player X’s individual metric, we have to know the other players’ individual metrics, which in turn requires knowing Player X’s. The circular dependency can be solved by doing the calculation iteratively. That is, calculate each player’s metric by assuming all other players have a metric of 0 (a neutral impact on the game). Plug those results back into the formula to get a second, better set of results. Keep repeating the calculation until the numbers stop changing.

TrackVia doesn’t do this out of the box, of course, but it does have a very powerful custom logic capability. So if any NBA teams are interested in trading data analysis tools for season tickets, let’s talk! 

 

Presidential Data

February 16th, 2009

With today being President’s Day in the States, I thought it only appropriate to slice and dice some Presidential data. I know the day was established in 1880 to commemorate George Washington’s birthday; however I was curious as to whether or not February was the most popular birth month for Presidents.

It should be no surprise to those who follow our blog, that I uploaded select data via an Excel-import into TrackVia. As I’ve mentioned before, it is easier for me to analyze data in an online database.

Here are some interesting Presidential facts:

  • February is not the most popular birth month for Presidents. It is October with six, followed by August and November with five each.
  • Scorpio and Aquarius are the most Presidential Zodiac signs.
  • While many believe Barrack Obama is the youngest President elected, this is not the case. John F. Kennedy was the youngest President elected at 43, while Theodore Roosevelt was the youngest to serve as President when he took over at the age of 42 when William McKinley was assassinated.
  • The states of Virginia and Ohio are the states with the most Presidential births with 8 and 7, respectively.

If you’d like to see a detailed list of when our Presidents were born, click here.

The Hallmark Stimulus Package

February 13th, 2009

Hallmark Stimulus PackageWhy doesn’t the President look to Hallmark or Twitter for a little help with the Stimulus Package? After all, Hallmark has done a great job generating revenue through card sending occasions. Here is a look at the top card sending holidays in the U.S.:

Assuming on average a card costs $2.50, Valentine’s Day cards alone pump an additional $478 million into the Hallmark coffers. Why doesn’t the U.S. Government partner with Hallmark and agree to donate all proceeds to the Stimulus Plan? A new card giving occasion won’t cover all the $789 billion cost of the stimulus plan, but it will put a dent in it. The government could also partner with Twitter and create the twallmark card series. Just think if all of the 5.6 million Twitter users purchased one twallmark card at $2.50, an additional $14 million would be pumped into the stimulus plan.

What Hallmark or Twallmark occasion would you create to help stimulate the economy?

Tech Layoff Trends

February 12th, 2009

Sports and weather are two things you expect to find on news sites, and I hate to say it but layoffs have joined the lineup as well. I’ve always heard that most companies designate Fridays as the day of the week to hand out pink slips, and I started wondering if there is any trend related to the day of the week companies announce layoffs.

I took the data from CNet’s technology scorecard and uploaded it into an online database, so I could easily slice and dice the data. I may be biased, but I find that it is easier to understand data viewed through a powerful database.

Some of the results may surprise you:

There are many theories as to when companies should begin a layoff and often times it is suggested that it take place at the end of the week close to the end of the day.

However, by dropping layoff data into a TrackVia database, I found Wednesday to be the most popular day for tech companies to announce layoffs followed by Monday. Friday ranks fourth. If you want to avoid depressing layoff news, don’t read the paper or watch the news on Wednesdays. View calendar displaying layoffs.

I also was curious to see which tech companies made the most layoff announcements in recent months and found Lenovo and AMD topped the list with three rounds of layoffs. Additionally, October 17th was the date with the most companies (9) announcing layoffs in the past quarter.

Perhaps the British have it right with the 3-day work week scenario. In this case, reducing overall unemployment but wouldn’t that also mean that Wednesday would be the new Friday? If you were put in the tough situation how would you go about the layoff process and what day would you pick? Would you prefer to mandate a 3 day work week vs. layoffs?

TrackVia Video: Taking a Page From…Dave Taylor

February 11th, 2009

Today we kick off our video podcast series “Taking a Page From” with a special guest, Dave Taylor, to talk about how companies can build awareness online.

Dave Taylor is widely recognized for his writing and speaking engagements on both technical and business issues. He has written over twenty business and technical books including The Complete Idiot’s Guide to Growing Your Business with Google and maintains several weblogs two of which are the The Intuitive Life Business Blog and Ask Dave Taylor.

We invite you to watch our video and enjoy the advice Dave Taylor shared with TrackVia CEO, Chris Basham.

Some key takeaways:

  1. For any company, there is already a conversation going on about you – monitoring what people are saying about you is the first step (LinkedIn, Twitter etc.).
  2. When you are looking at your add words, look at your stop words as well
  3. Monitor your key words and refine your ad words on a regular basis.
  4. Look at the data as frequently as possible – divide the responsibility for analyzing your traffic data.
  5. Pick two or three trade shows that you want to go to and that your customers will attend. Host a dinner and get social with your customers.
  6. Look at your organic results – to get more organic results, you must give more than you take. Goodwill generates good traffic.
  7. Incentivize your customers to talk about you.
  8. Do what you can to be in front of the opinion leaders at events, in the office and networking etc. – Just don’t spit on them
  9. Marketing takes focus, attention and persistence.
  10. You can’t always control what people say about you – embrace it, be aware that it exists and respond.
  11. Look at what you can give to the online community i.e. good content. Focus more on what you give and less on what you will receive.
  12. Get your engineers involved in the discussion and in relevant forums.
  13. Consider developing free informational videos and eBooks on your key topic.

I Need to Know. Everything. Immediately.

February 10th, 2009

One advantage of using an online database is the visibility it provides into one’s data. Custom views, statistics, and powerful search features make it easy to see what’s happening with customers, orders, inventory, and nearly everything else.

Sometimes, though, that’s not enough. If a customer logs a critical bug, I want to know about it right away, not the next time I log into TrackVia and look. If our sales group has a time-sensitive opportunity that requires senior management involvement, our CEO wants to know about it immediately, not the next time TrackVia emails him a pipeline report. In fact, come to think of it, I want to know about all bugs, and our CEO wants to know about all sales opportunities, as they happen. We have a high need to know.

Now we can know. Last week TrackVia launched a new alerts feature. Alerts allow TrackVia users to be notified by email whenever their data changes in ways they’re interested in. This could be an added record, a deleted record, or any change to a specific record. It could also be a change to one or more records that meets very specific criteria.

TrackVia Alerts

The specificity of those criteria make alerts great for workflow applications, that is, using TrackVia to manage a business process. For example, an alert can notify a claims processor that an investigator in her region has approved a claim and it’s now ready for payment.

If you have a high need to know, and you’re not getting it from your current database, you might try a better database.

Errors in Aggregate

February 9th, 2009

An article in Friday’s New York Times illustrates the perils of drawing conclusions from aggregated data. The article discusses scientific evidence that having children hurts the quality of a marriage. Over the last two decades, “more than 25 separate studies have established that marital quality drops, often quite steeply, after the transition to parenthood.” And when children leave, marital happiness goes back up.

Bummer.

I’m a parent, and happily married. Am I an exception? As it turns out, no. The article describes two researchers from Berkeley who realized that those studies failed to account for the different paths couples take toward parenthood. When the data was sliced a little differently, a different conclusion emerges:

The Cowans found that the average drop in marital satisfaction was almost entirely accounted for by the couples who slid into being parents, disagreed over it or were ambivalent about it. Couples who planned or equally welcomed the conception were likely to maintain or even increase their marital satisfaction after the child was born.

When the data was viewed in aggregate, it was misleading at best. When disaggregated, or filtered, a more nuanced understanding emerged.

This is more than just a curiosity. Half of all TrackVia users have a database in their account that tracks existing customers or clients. That database is a potential trove of insight. But drawing conclusions from that data without filtering it on important demographics can lead a company astray.

Said another way, averages can be misleading. Humorist Des McHale once observed that the average human has one breast and one testicle, but designing a product for that average consumer is not likely to succeed. Fortunately, TrackVia has simple and powerful filtering features that make de-averaging of data a breeze. If you can’t easily filter your customer data into demographic groups before computing averages, you might think about switching to a better database

What Happens In Vegas Is Shared Worldwide

February 6th, 2009

I just returned from Las Vegas, where I attended the Parallels Summit 2009. Parallels is best known for their software that lets Macs run Windows programs. But they’re also a leading seller of automation and control software for large data centers. These Parallels customers, who are website and server hosting providers, were our target audience. Our message: offer your business customers an online database, and all three parties (the customer, the hosting provider, and TrackVia) will benefit.

TrackVia at Parallels Summit 2009 in Vegas

We had a good time meeting new people, learning about hosting businesses from all over the world, and showing off TrackVia. We also drank a little too much and smoked a cigar or two. That part can stay in Vegas, but we hope our message about the value of reselling TrackVia will spread worldwide.

One highlight of the trip was a cocktail reception hosted on the 64th floor outdoor balcony of  THEHotel at Mandalay Bay.  We looked down on the Luxor and the rest of the Vegas strip. Awesome!

View of Vegas Strip from 60th Floor

If you missed us in Vegas but would like to learn more about reselling opportunities, please let us know!

 

 

Open Source Collaboration – Driving Your Business and Others

February 5th, 2009

Where else can you work on a piece of technology, set it free and find that it has evolved into something even better when you return? In the open source community of course.

As part of the development staff at TrackVia, I contribute to an open source software project called Spreadsheet::XLSX. This project is an open source Perl module that we use to parse Excel 2007 spreadsheets and import them into TrackVia. In collaboration with other developers around the globe, we all volunteer to maintain, fix, and enhance this software.

A couple months ago, I checked in some significant enhancements that I worked on to build up TrackVia’s support for different formatting in Excel 2007 spreadsheets. The open source community received the benefit of my full time effort for several days, and the features I added. TrackVia had the benefit of it taking me less time to add those features to the existing open source module than it would have cost me to build it all from scratch. Less time means it saved the company money, and allowed me to bring the enhancements to market faster. Recently, some other developers added more to the module, and, after I reviewed and tested those changes, I was able to add them quickly to our product. Our customers benefit because we now support those additional data conditions in our spreadsheet import feature.

As we go forward with new features in our product, we will continue to look for ways to use open source modules to reduce the time to market and the cost of development. We’ll also continue to contribute modifications and enhancements of those modules to the open source community so others can receive the benefit of our work too.

We believe it is important to give and receive in the open source community, which begs the question, how have you contributed to an open source project or perhaps benefited?

TrackVia News: New Alerts Feature and Partnership with Parallels

February 4th, 2009

During the Parallels Conference in Las Vegas, we announced the public launch of our Alerts feature and a new partnership with Parallels.

The Alerts feature allows database users to receive real-time email notification whenever data is added, removed or changed in a database.  Data Alerts support a wide range of workflow and business process applications.  For example, an alert could be used in a CRM database to notify a sales rep when they have been assigned a new lead.

Through our partnership with the Parallels SaaS ISV Initiatives Program, TrackVia gains access to Parallel’s 10,000+ Service Provider Channel.  Parallels VP of SaaS and Service Provider states, “The TrackVia SaaS database provides our hosting partners with a high value-added product offering that complements and extends their existing hosting solutions.”

For more information on our new alerts feature or our partnership with Parallel’s drop us a line at support@trackvia.com or call us at 1.800.673.3302.