Most Recent Articles

KM Overcomplicates: Heisenberg Impact on a VBA Quickie

Got a simple request from one of the folks in Operations; we're sending out Excel spreadsheets for some quick data gathering, might we do a little basic input validation before they send in garbage that needs to be scrubbed? This person is very sharp, knows a decent bit about what is possible, and this is definitely not something that is worth a major project engagement; "throwaway technology", a particular fave of mine. His request was simple - just want to…

Read More ...

Is SharePoint WSS dangerous to SharePoint contractors?

Firing Up Internal Opportunity It was true last year, but even more so now; SharePoint is very important for corporate IT, both strategically (medium- and long-term) and tactically (short-term). Sure, it's a terrific way to iterate on collaboration, internal portals, document management, etc. - "enabling innovation" in every buzzword-compliant sense. But there is solid benefit for even short-sighted, plodding, tactical IT - and it's all about staff retention. SharePoint WSS represents a nice opportunity for folks in IT to get…

Read More ...

News for Wombats: Taming Unreasonable Requirements

I've heard from a couple of friends about some "classic" project requests - dilemmas they have recently faced. These unreasonable requests can be turned into something achievable and, potentially, more relevant / meaningful to the requestor, by approaching the problem from a different direction. Request for Data: the Analytics Project Classic scenario #1 arrives courtesy of the external Experts, analytic genii (sic) promising to reveal secrets of profitability and sources of revenue buried deep within our data sets. Their "simple…

Read More ...

Hacking the Google Chart API from Excel

a bit of code on a Saturday night ... I've written before about a simple way to measure and report IT value to the business - quantifying alignment with strategic initiatives  project spend in context. It all culminated with a single, simple slide - numbers, with some Tufte-esque Sparklines thrown in. Well, technologies come and go, and without going into the boring details, I've had to come up with a new way to generate the mini-bar charts along the left…

Read More ...

Zodiac of Knowledge Capture

The start of a new year gives me a rare chance to measure my knowledge capture output over time. I maintain electronic journals for the various projects I am driving, business units and functional areas I support, and people I work with. This results in a hundred or so separate MS Word documents, with generally the same format - still, it would be quite tedious to take a word count each week to check my output. However, at the beginning…

Read More ...

Back to the Future: Twitter “microblogging”

"That's pretty good, Johnny, but that ain't the way I heerd it. . . ." I recall when all this "blogging" talk started, way back in 1999 or so (thanks to Hallett for a decent history). The idea was to post thoughts and feelings, observations about technology, society, or whatever - anything from a daily diary to a project notebook. Scoble and others became (in)famous for posting multiple times a day. Time marches on, and the medium has morphed over…

Read More ...

Best Practices for Requirements Gathering Sessions

It's been a while since I've led a requirements session for an interactive application - but no worries, I found it's like riding a bike. After a few minutes the old habits come back, and iterative ideas and cascading creativity starts to flow. What has changed, however, is the application platform, the office environment, and the various knowledge capture tools at our disposal. So, in the spirit of knowledge retention and sharing, here's a brain dump of ideas that I…

Read More ...

Field Notes: Lean Times for IT Services

I know it's lean times in IT, and product / services vendors are all beating the bushes. Some interesting patterns have emerged over the last few months ... My Boss Is In Town: This is far and away the #1 meme / structure of incoming cold calls; I get a (very) brief synopsis of services/value add, the caller and pushes for some face time with "their manager". Did some newsletter or web site suggest this novel approach last summer? I…

Read More ...

Dueling Collaboration Portals

I noticed an interesting phenomenon this afternoon; we are experimenting with SharePoint as our internal project management / collaboration portal. A nice platform to choose, because it's popularity is growing, and there are a wide selection of add-on products and development partners ready, willing, and able to help us spend our money to make it even better. The interesting part is that we are running into other companies who are also working with SharePoint. Specifically, third-party consulting firms that want…

Read More ...

I Think I’m Learning SAPanese …

Spent time at an industry conference last week (ain't Boston great!), and heard the term SAPanese - that special language SAP users learn when immersed in worlds of Walldorf and their ubiquitous software. It's not unique to SAP - lots of software companies develop their own vocabulary. Heck, IT "geeks" are famous for it - even the various functional units within the business develop their own shorthand, terms to help speed communication with "those in the know". Here are some…

Read More ...