cazh1: on Business, Information, and Technology

This post started off as an excuse to experiment with Google Docs, and this really neat feature I discovered - embedding a spreadsheet in a web page as a sharing method. However, it struck me as a potential way to cost justify the time, effort, and expense of implementing collaboration systems with the Most Cynical Among Us.

We've all been in large meetings, with tens of people from the project team, along with the expensive consultants, sitting around a table listening to the project manager read their slides to us. The meetings always get scheduled for a full hour (it's the default in our calendaring system!), and everyone feels the need to speak, if only to make sure their voice has joined the chorus of agreement.

However, many of the Most Cynical Among Us have observed the large number of people in the room, and asked the question "How much is this meeting costing me?" It's a worthy exercise to go through ... so I whipped up a little spreadsheet model to quantify the hard and soft costs ...

It doesn't take long to play with the model and see the dollars add up; even if you don't believe in tracking "soft costs", the amount of time spent in meetings can get really big, really fast.

Are status update meetings inherently a waste of time? Absolutely not - communication is critical, and most organizations typically don't do enough of it. An exercise like this just puts the potential cost, in time and money, in real terms - and reminds us to focus on maximizing that investment.

Can this meeting be avoided? Collaboration platforms (blogs, intranets, etc.) let us update the team virtually; people can get the information when it's most convenient for them.

Are we communicating effectively? Sometimes, face to face communication is required and preferred - especially when you need to monitor how the message is being received in real time. Hence the broad focus on effective presentations and impactful communications ...

Look at the cost of your last meeting - did you get your money's worth?

PS: I welcome any suggestions for improvements to the model -  to request edit access or to get a copy, send email to jpmacl_docs@cazh1.com.

Previously ...

• Corporate Web 2.0 is Spreading - Here comes the Blog (May 15, 2007)
• Hidden Gold in Automating Recurring Processes (May 28, 2007)
• Communication is the responsibility of ... (August 19, 2007)
• Success, Failure, and Insights after 12 Months of Internal Web 2.0 (March 10, 2008)
• RSS: Underappreciated Web 2.0 in the Enterprise (May 1, 2008)
• Low Tech SharePoint Hack: Project Status Indicator (March 14, 2009)
• Real Business Users and SharePoint (July 14, 2009)

Technorati Tags: business value of IT, collaboration, hands on, people management, presentations, productivity, project management, Web 2.0,

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

The short answer, as you know, is that it's impossible to tell you how to be insightful and imaginative in a single blog post. All I can do is point you in the general direction, and (hopefully) ignite a little spark.

What's the Goal? and, Where to Begin?

I previously talked about the growing calls for effective data visualizations; we have access to all this great information, and there are insights in there somewhere - but we need just the right point of view to rise above the cloud of data and see the real opportunity. It helps if you have experienced that rush of insight when looking at a particularly impactful graphic; not just a good looking slide, it calls out something important in a particularly effective way. Haven't we all watched that earnest TV lawyer pull the winning argument out of the blue [right before the final commercial break] and win the big case?

Of course, it's not enough just to want it - you have to have a little reverse-engineering in your soul. You need confidence & bravado (I can and should be able to create those killer pictures), hunger & curiosity (how did they do that?), and confidence to know that you can - with a little hacking. It also helps to have the blissful ignorance to assume that it's within your technical grasp.

Step 1: Find Someone who Knows - and Follow them Around!

I'm a big fan of the "follow him around" method for learning new technology - not classroom instruction, more like a series of specific examples of applied technology. I had seen plenty of examples of presentations that I thought were very effective, but I didn't understand what was happening, what exactly was making them so effective. I had to find someone that could talk about putting together effective presentations - and had the good fortune to attend a seminar by Edward Tufte. Sure, you get some nice books, great to page through - but like most technical manuals, they don't really make sense until you've watched Tufte deconstruct the graphics. I learned the importance of taking extraneous ink off the page, and how scale, color and shape can illustrate and/or obfuscate. I didn't walk away from that experience with specific skills as much as clarified ideas - and a hunger and curiosity for more.

Step 2: Find Lots of Examples - and Steal some Inspiration!

Over the past few months, I've been following a number of blogs dedicated to ideas around information visualization - more skilled practitioners to follow around! The links below to take you to particularly interesting examples; your task is to subscribe to them all and regularly scan for ideas ...

Information is Beautiful

• Great Visualizers: Mike Deal charts The Beatles - I don't know exactly what that graphic is that shows the keys of Beatles tunes, but it looks cool - I want to figure out what it's showing, and how to build one

Cool Infographics

• The Caffeine Poster, How Much Caffeine Are You Drinking? Made all the more interesting by this follow-on post, The Making of The Caffeine Poster
• 16 Infographic Resumes, A Visual Trend Resumes done in graphics? Well, maybe not for me, but these are great examples of packing a lot of information in a small area - and, making the message stand out in the crowd!
• Pink Floyd Timeline of Band Members
  

Flowing Data

• 11 Ways to Visualize Changes Over Time – A Guide It's not always about examples of applied data visualization - there are plenty of mini-tutorials gettin published, like this one
  

EagerEyes.org

• Understanding Pie Charts Another techniques post, this one deconstructing peie charts. I never knew why I wasn't a big fan of the pie, but this article points out a lot of stuff that's pretty obvious (now that you mention it ...)
  

Chart Porn

• Haiti This blog is just a non-stop source of interesting examples
  

New York Times

• Another common source of terrific information visualizations is the New York Times - many folks blog about the most effective examples, even our friends at Ask ET
  

Step 3: Get Your Coding Hands Dirty!

Remember, after you are done being wowed by the presentation - figure out how you could build one.

• The old stalwart Excel comes with an ever growing list of graph types. Can't find the one you want? Try to hack at the standard stuff using VBA!
• Sometimes a blog post will point you to some utilities. No, I never heard of Gource, but you can bet I'm looking for a project to use it with!
• Open source has a lot of interesting tools out there - from jQuery addins to full-blown BI suites - lots of tools to load up with your data.
  

Remember - get inspired, find some starting points, and get building! the only way to really understand how to create insightful, impactful visualizations is to do a lot of experimentation.

Previously ...

• Stretching Your User Interface Design Muscles (April 16, 2008)
• Data Visualization: 'Life' of Open Source Projects (June 16, 2008)
• Another Take on Enterprise Open Source (February 18, 2009)
• Practical Innovation Lessons from Software Vendor R&D (April 16, 2009)
• A Company is like a Sphere (September 15, 2009)
• Why Corporate IT Fails when Competing with Consumer Tech ... and How to Change the Game (January 5, 2010)

Technorati Tags: data visualization, design, development, hands on, innovation, presentations

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan,

Between business requests and breathless vendors, I am getting caught up in the growing tide of interest in "data visualizations" - managers requesting highly interactive, highly graphical, highly intuitive analytics interfaces (think Minority Report). But what are we trying to accomplish here? We keep on hearing about "executive dashboards", a heads-up display of in-my-face KPIs, or statistics and exceptions delivered automatically to my e-mail and/or Blackberry. However, when I ask management folks to get a bit more specific - how would you actually use this information? Is there an interest in doing the drill down, the click through, the hand waving? Not so much - basically, I've heard that folks are satisfied with what they have (ex. daily sales reports or customer service metrics), and are not necessarily interested in micromanaging through their staffs (by drilling down through graphical views on their desktop).

The real interest is in giving the right "stuff" to middle management and team leaders ...

1. Data Sets - access to transactional data in enough detail to permit mixing, matching, slicing, and dicing, to identify and target hidden opportunities for business value (growth and/or savings)
2. Data Access Tools that provides fast and flexible manipulation of the figures
3. New and different Data Visualizations to enable insight and help target opportunities

... and we can iterate on these already:

• The first item - access to data - is getting easier over time. Projects like data warehousing and ERP implementations have taught companies the value of clean transaction data and correct & complete master data. We are also expanding the number of folks that know how to do basic query and extract operations, from all sorts of transaction systems (on premise and in the cloud), into data sets that can be manipulated off-line.
• Next - most folks can and should be happy with Excel and pivot tables - especially with the improvements in Office 2007 and beyond. It's becoming easier to specify filters, cross tabs, and aggregate operations, and Excel can also handle reasonably large data sets - tens of thousands of rows.

We are certainly not "finished" with #1 and #2 - still plenty of work to do in terms of data cleansing, data access and basic manipulation. However, the biggest opportunities for improvement in 2010 are in the area of visualizations - new and different ways to display multidimensional data.

Here's a simple example of profitability analysis using a visualization that is not available in Excel:

Click on the picture for a full-size image!

This type of graph is called a tree map or heat map. It's a basic query - show gross sales by customer for a number of product families, but this clever picture shows a number of things in a two dimensional view:

• Area in the graph represents sales - represented in dollars
• White borders denote product families - like Cookies, Diet Snacks, and Organic Food
• Red borders carve out specific customers
• Color represents degree of profitability - the most profitable are bright green, and the least profitable are bright red.

With a quick explanation of what you are looking at, targets of opportunity jump out at you - go for the big red boxes (like C) to cut the non-profitable stuff, or the really green boxes (like A) to sell more of the really profitable stuff. You can also get a bit more imaginative, looking for the right blend of size and shade to find customers "on the edge" of going really green (how can we make B as green as their neighbor, A)?

Creating Opportunities for Insight - Playing with Visualizations

To really get at #3, we may need better tools, but we also need some new and different communication design ideas. What types of data visualization are possible, given the dimensions of the data we have? Which visualizations might lead to some interesting insights? Or, take the opposite view - given a particular data set, what truths are in there, and how might we draw a picture of that (to clearly illustrate these truths for the interested observer)?

Clearly, there is no cookbook approach to something like this. It takes a certain amount of insight and imagination, and that is a critical skill combination that most IT departments, by nature, simply do not have. IT and Finance are two areas where structure and process typically trump design sensibilities.

No, I'm not saying that there is no artistic ability anywhere in IT; it just doesn't come out very often as we labor away on our project deliverables. As previously noted, corporate IT is typically not rewarded for design - just results (done = good, "good" = meh).

I don't think that the business is asking for fancy tools as much as creativity and new ideas for ways to represent business questions and answers. Instead of the same old bar charts and tables of color-coded numbers - is there a better way to visualize this data to facilitate insights?

Next … sources of inspiration ...

Previously ...

• Stretching Your User Interface Design Muscles (April 16, 2008)
• There ain't much IT in IT Management (May 7, 2008)
• Data Visualization: 'Life' of Open Source Projects (June 16, 2008)
• Excel 2007 is a BOB system (Bag'O'Bugs) (October 5, 2008)
• Hacking the Google Chart API from Excel (January 17, 2009)
• Practical Innovation Lessons from Software Vendor R&D (April 16, 2009)
• Who owns Master Data in your company? (May 30, 2009)

Technorati Tags: data visualization, innovation, presentations

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

I've been working with internal developers over the past few weeks, experimenting with a treemap / heatmap-style visualization that is quite interesting / insightful when loaded up with data, but very tough to configure and manipulate. We are also struggling with a presentation layer (surrounding this data control) that doesn’t adapt to the size of your browser screen, or behave well when placed inside a frame set or table.

I suspect our primary challenge - typical thinking for most corporate IT departments - is that we only work with the tool we know. The only way to display information in a browser from XYZ's data warehouse is to use their particular Web portal platform. We need to switch focus; let the data warehouse provide beautifully aggregated and accessible data, but go elsewhere for the presentation layer.

Corporate IT needs to develop a sense of adventure, a thirst for new and different ways of doing the same thing, and a curiosity about different presentation architectures (ie. there's more than one way to skin a cat). Manufacture some spare time, and get down to some serious "play", with CSS, HTML, and SharePoint (as previously noted, our target intranet platform); learn all you can about the level of control you have. Note that you probably have more flexibility than you think … but now we're playing with JavaScript, VBScript, or any number of client-side technologies.

Unfortunately, we all seem to get to the same creativity-killing question: "how do I charge my time?". Full disclosure: I'm a big fan of the timesheets and reasonable chargeback systems, quantifying IT alignment with the business - but therein lies the subtle yet significant difference with "the IT guys" and the iPhone / iPod / Kindle / Nintendo / Best Buy expectations of our business partners.

Rewarding Different Behaviors

Corporate IT is measured by and rewarded for projects - specifically, getting things done. In most organizations, that's where it ends; IT is usually not rewarded based on the ongoing use of the project deliverables; in fact, ongoing support ("maintenance") is expected ... a cost of doing business ... overhead ... part of baseline costs ... and, in a manner of speaking: free (no premium is paid).

It’s the exact opposite on the Internet and consumer IT; you are expected to build the stuff for free, and just give it away. You will get your rewards when people come to your website, click on your ads, buy your products, become sales leads. You’re rewarded after the build is complete – but (if you are good), you are rewarded over and over again.

• Corporate IT – metrics for success stop when the project is complete
• Consumer IT – metrics for success start when the development work is done

This also helps explain why Consumer IT delivers "stuff" that people like, that is intuitive, easy to use, and just works. Witness the apple iStore – developers earn cash only when they sell their apps, long after the build is complete. But it's not as simple as that - note that even though there are a huge number of apps out there, less than 5% are big successes (>100,000 users). Competition and market dynamics drive quality and innovative, creativity is rewarded when an app rises above the fray. Check out the disturbing collection below; how many different ways can you write the same, silly, popgun program? You'd be amazed ...



... yet five minutes of playing with each of these shooters, and you start to see the subtle variations and evolving methods that applications that get the most return visits.

Hope for Corporate IT - the Anti-PMO

The iGun story tells us about the darwinian action that comes with large amounts of repetition, duplication, and failure. Success can be quantified by your failures - how many failed experiments have you thrown out there, just to see what sticks? On the internet, preferably a lot - because that’s how you learn what works, and how to make the “really cool stuff”.

Corporate IT might stand a chance in an environment where experimentation and failure is encouraged (but not necessarily rewarded - we need to learn from our mistakes). In essence, we need to build an anti-PMO and give permission for folks to do stuff that has no apparent value.

What will it take for you to facilitate a more creative environment? For more ideas on establishing an innovation environment, check out this old post ...

Previously ...

• The Innovation Generation and User Interfaces (April 9, 2008)
• Stretching Your User Interface Design Muscles (April 16, 2008)
• Low Tech SharePoint Hack: Project Status Indicator (March 14, 2009)
• Five Stages of Twitter Relevance (April 21, 2009)
• Failing Faster (June 14, 2009)
• Real Business Users and SharePoint (July 14, 2009)

Technorati Tags: business value of IT, design, development, entrepreneur, innovation, PMO

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan,

Some block-and-tackle IT management stuff for today - taking a long, hard look at the IT budget, a task that is less-than-pleasant for many. Most of my peers have already cut any and all low hanging fruit - it's time to start thinking aggressively.

Software Maintenance for the Small Stuff

Most have concentrated on their ERP and other large, strategic vendors - but what about all of those little invoices that come every year - development tools, management utilities, network monitors, etc. After a while, it really adds up - but too often, we look at the relatively small amounts and just approve the dollars without a thought. It may be time to gather up these little guys, and take a good, long look.

• Why pay for something that we rarely use? Typically, I have purchased perpetual rights to use a product, but I pay annually to keep on support. Why not let the support / maintenance lapse, but continue using the product (on the rare occasion I need to)?

• Even if I use the software a lot - why pay maintenance if I rarely call support? Does the vendor offer support on a time-and-materials basis? Don't dismiss this option out of hand - I find it difficult to believe that a vendor will turn down an opportunity to start hourly billings in the event that something significant goes wrong.
• Do I really need to pay support if I have scheduled a project in the near future to get it decommissioned? Just looking to realize the savings a bit earlier ...

Alternatives and Duplicates

Are there alternatives available that would cost less on an annual basis?

• Do I have any point-solutions that can be replaced by unused, duplicate functionality in my ERP system? Something to consider, especially if the solution was implemented a few years ago. Perhaps the R&D group from your ERP vendor caught up to their competition?
• Is third-party support available? Rimini Street is the classic ERP example - possibly some consulting firms will offer support for the more mature, niche-stuff in your portfolio?
• Of course, there is always open-source; no acquisition cost, and [typically] no annual maintenance.
• Are there applications in your portfolio with similar / duplicate functionality? This is common for even mid-sized shops, especially as time passes and those pesky vendor developers keep improving and extending their core products.

Compare your Risk Requirements with Reality

As much as we grouse about vendors, IT departments often mimic their behaviors, especially when justifying software maintenance and infrastructure redundancy based on FUD (Fear, Uncertainty, and Doubt). How often does this stuff really fail? How bad is the software, how loaded with bugs, that we simply must have access to (and faithfully apply) every patch?

I'm not looking for a storm of protest here - I have plenty of "war stories", just like you, of timely support calls that provided just the right patch, and untimely hardware failures that went unnoticed because of well-engineered failover. However, it's time to think aggressively, and re-examine / revalidate all of your assumptions.

• How about reducing our level of telecommunications failover – can we get cheaper / slower backup circuits? 
  
• Consider sharing backup servers between multiple applications - where the first failover application takes over, eliminating the second apps safety net.
• How often do my techs end up solving the problem for the vendor - how much value am I really getting, especially for the really mature stuff?

“Risk” is always powerful word, especially when dealing with a conservative management group. However, for this exercise we can’t just accept the powerful but un-valued justification of “risk mitigation” – we must quantify risk on an historical basis. For example - if we talk about dropping support for a software product, we can and should quantify how often we had to call up the vendor for support / help, or how many bugs we’ve fixed by applying a vendor patch.

Here's the most important idea; we should be able to draw a clear line between cost and quality (where, in this discussion, "quality" = "risk mitigation"). If we want this level of quality, we have to pay this much money. If we want to save money, can we accept a lower level of quality (or, a higher level of risk)?

I always go into budget reviews with the idea that the business is asking for a thoughtful discussion of tradeoffs, and not dictating targets (no matter what the memo specifically says!) More often than not, the Finance group or the General Manager is asking questions like "how can we save $X ?", or "what would it take to reduce by Y% ?". The cost vs. quality/risk tradeoff is something that can and should be a joint decision between IT and the business.

Previously ...

• Measuring and Reporting IT Value (2 of 2) (November 20, 2007)
• Three Business-Case Arguments for Agile, & The Moose On The Table (January 14, 2008)
• There ain't much IT in IT Management (May 7, 2008)
• IT and the Business are Closer Than You Think (June 28, 2008)
• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• The Delicate Art of Pushing Back (July 5, 2009)

Technorati Tags: business value of IT, IT management,

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan,

I've received input from ten companies so far - large and small, with all sorts of ERP systems. If you care to add some information, I'll thank you in advance, and add it (sufficiently anonymized) to the summary results document (download from here).

Here are some of the findings / observations from the summary ...

Master Data Domains

The types of Master Data called out included the usual suspects - Customers, Vendors, Finished Goods, Employees. Others mentioned include Metadata, Packaging / Tooling (components), and Indirect customers (like Payors in managed care, or Buying Groups in B2B). The primary systems in scope included SAP, Oracle, JDEdwards, and QAD, joined by an eclectic mix of legacy systems and point solutions. Secondary systems called out included Siebel, JDA/Manugistics, and ADP (payroll) - plus more legacy / home grown / departmental apps.

Master Data initiatives varied, based on where the "current pain" is - R&D / engineering, CRM / Customers / Contracts / Pricing, and Finished Goods / Logistics were named by different companies as their particular focus areas. Other important considerations were things like geography (North America vs. ROW), and business structure (Enterprise vs. business unit vs. local plant).

A significant determinant of how folks thought about this problem was how their ERP is implemented - in a fully integrated "enterprise" (Finance, Order Management, Supply Chain, etc.) - and/or how the instances are divided (all enterprise, by location (geography) or by business unit).

Note, however, that relatively few respondents are concerned with synchronizing data across multiple instances - a popular callout / feature of some MDM solutions. they will speak of "integration", but a focus of the conversations were all around quality and process, not synchronization.

An interesting frustration from some of the respondees; the ERP system(s) do not capture all of the required attributes for an item, so these additional details are kept in a separate, siloed system. Easy examples would be specific attributes (like shipping material specifications), but there were multiple instances where [so-called] Master Data is calculated with complex formulas / rationale, so an Excel component is required (typically in the area of pricing / quoting details).


Size & Scope of Master Data

Predictably, there was a great variation in the responses - 100s to 1000s of customer, vendors, finished goods. However, the interesting trend was the notation that 10s of people (relatively large numbers, based on size of the company), were "responsible" (i.e. "did some of the data entry"). Could this be why there is interest in MDM and an MDM organization? Apparently, Master Data is often managed like a wiki - everybody is an editor.

Most organizations have no metrics in place; a few can speak to "data police", folks that actively monitor the data looking for issues. Best examples cited included "Health Check measures" (does data fit set of established guidelines / tolerances); vendor audits, and [results of] scrubbing (ex. Name And Address data against external sources).

When asked about the business benefits of a Master Data Management effort, most companies left this blank or said "none". I generally got the sense that hard benefits are difficult to quantify; notable exceptions seem to come from past pain. Some organizations spoke to inventory reductions and transportation savings - both derived from more accurate supply chain data, which is facilitated by clean, consistent, complete Master Data.

Master Data in the Organization

Many companies keep control / accountability at the functional area. However, companies with "enterprise ERP" implementations (full integration of Finance, Order Management, Supply Chain) typically call out ownership at the Enterprise level. It's not about the size of the company or the recency of their implementation - it's the degree of integration within the primary ERP.

Organizational specifics were tougher to get at - depending on how the company managed their master data. Generally speaking, companies that manage Master Data at a functional level (Customer Service, Purchasing, Finance) have organizational clarity. However, folks that say they manage at the Enterprise level had the wispier definitions for Title and Accountability

Of note: centralized MDM teams rarely manage the bigger projects (implementations, acquisitions, or special projects with large MD components) - but they will (out of necessity) participate. None of the respondents look to these organizations / people for project management skills. However, there were some good callouts for the communication / change management skills required for the role, especially where the group has to review implications of adds / updates [of Master Data items] with multiple groups that will/may be impacted.

Scope of Responsibilities

An interesting, consistent set of answers in this area; "Yes, we take ownership and accountability - but no, we can't measure it". To be fair, not all companies had that clarity of ownership, but the lack of sharp, clear quality metrics is noticeable. Content, Quality, and Governance are consistent in all of these companies … consistently not-well defined, not well measured.

Positives & Challenges

Funny how best practices in one company are challenges in another. There are two recurring themes throughout the responses; Quality and Complexity. The latter is interesting; this was the first point in the survey where the difficulties of Finished Goods Master Data were raised. Many companies call it out as a large challenge; all of them cite the complexity, the multiple facets (manufacturing, packaging, warehousing, transportation, pricing, costing) and the cross-functional nature

Full Results

The summary results document is available for download from here; I will add a version date on the page and keep it up to date as additional surveys come in.

Questions? Comments? Suggestions? Let me know ...

Previously ...

• Three Business-Case Arguments for Agile, & The Moose On The Table (January 14, 2008)
• Five More Realities for Driving Business Value from Technology (January 30, 2008)
• Success, Failure, and Insights after 12 Months of Internal Web 2.0 (March 10, 2008)
• Optimizing the Wrong Part of Knowledge Management (March 16, 2008)
• The Right Web2.0 Tool for the Audience (Twitter, LinkedIn, Facebook) (May 9, 2008)
• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• Location, Location, Location: Terminology Confusion in ERP Projects (April 11, 2009)
• Who owns Master Data in your company? (May 30, 2009)
• Bootstrap Market Research: Master Data Management (What, Who, How) (November 30, 2009)

Technorati Tags: best practice, collaboration, CRM, documentation, ERP, hands on, Knowledge Management, SAP, supply chain, tech management, wiki

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

As the new year approaches, debates over the "value" of IT and business projects intensify; it's not holiday stress, but the excitement of the approaching New [fiscal] Year. Lately, I'm hearing more about the struggle to quantify business value, especially when selecting those few projects that will "make the cut". We will definitely iterate on our scoring framework, adding a cost / benefit template to facilitate more apples-to-apples comparisons between projects (yes, don't scoff  - it is possible - more in a later post ...)

However, I think there's an interesting vision in some people's minds; a sort of value-optimization Utopia where, even with hundreds of project ideas on the list, the executive team has the insight and ability to select the best projects and fund them appropriately -  as long as they all have business values assigned.

I don't think assigning a value to every proposal is realistic, and certainly not something to aspire to - well, not directly anyway. There are a number of significant hurdles to deal with - the reluctance of people to commit to hard benefits, the lack of suitable productivity metrics for new technologies and methods, and the difficulty of communicating innovations to those who didn't think it up on their own (ie. close the patent office, we're done).

Yet, even if you did address all of those problems, and could easily measure impact and communicate effectiveness on 300+ terrific project ideas - how could anyone to claim the ability (or the time!) to rank such a list from "best" to "worst" (or, since I don't propose projects are bad to begin with - "most best" to "least best")? Truth is, they don't - most of the business leaders I've worked with have no interest in looking at 300 projects, and would be a tad perturbed if I tried to get them to peruse such a list. Do you appreciate it when your teams bring a thousand problems for you to sort through?

Rules of Thumb

Most people have a favorite way of eating their elephants. Yes, one bite at a time - but where to start? How to carve?

Deliver Small, Iterate, and Evolve: The agile among us would focus on short-term deliverables with small measurable steps to make incremental improvements. Speed and iterations will drive the quality and help focus on those areas of work that have the most short-term promise.

Focus on the Big Rocks:  The biggest and toughest problems - or the projects with the most benefit - are sometimes so daunting that they intimidate us into dealing with "the easy stuff". Clear your calendar and tackle these larger opportunities first, else you'll never get to them.

Focus on the Constraints: Understand which resources are keeping you from launching multiple projects at once. These are typically people - in key positions, with monopoly knowledge. Simplify things by prioritizing their projects first - but strongly consider launching efforts to remove the constraint, by having them document, train, or automate their knowledge.

Practical Problem Solving

As I proofread this post, it sounds like a checklist for common sense; no surprises, just a different level of detail depending on the organizational level you are speaking with. It's important to understand the fractal nature of business challenges; no matter where you stand in the organization, the number of items on your ToDo list (and/or the number of challenges you are juggling) is roughly the same. The sooner you can put yourself in the other person's shoes, and speak to them at the level of detail they (not you) need - the more effective your conversations will be.

Besides, they're paying you to solve problems, not define them.

Previously ...

• Measuring and Reporting IT Value (2 of 2) (November 20, 2007)
• Innovation That Matters - Substance Over Style (January 12, 2008)
• Three Business-Case Arguments for Agile, & The Moose On The Table (January 14, 2008)
• Optimizing the Wrong Part of Knowledge Management (March 16, 2008)
• The Innovation Generation - Communication Styles (April 1, 2008)
• IT and the Business are Closer Than You Think (June 28, 2008)
• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• A Plea for Empathetic Communication (November 16, 2008)

Technorati Tags: business value of IT, documentation, innovation, Knowledge Management, people management, PMO, project management

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

When I talk about having an "offsite strategy" meeting, I'm looking to get out of the office and have some good, "strategic" conversation over a cup of coffee or a beer. Back when I worked for a software development company, we did our best design work at a hot dog stand in Des Plaines, IL; since then, I've always found it more fun to conduct some "bidness" in the proper atmosphere ...

This was the germ of an idea that suggested a solid (simple, easy-to-remember) domain name and an interesting excuse to get some hands on with newer web technology. I've wanted to build a Google Maps mash-up for some time, and I've been seeing a lot of stuff about jQuery on Twitter - so as a break from a high-profile project at work, I hacked together something over the past few months that was both fun and practical (because, of course, it's important to be able to quickly locate a suitable meeting place ...)

Lessons Learned

Actually, the practical lessons learned from this project have to do with understanding modern web technology, understanding technology at a reasonable depth, and discovering a new value prop for Twitter ...

• If you are just starting out, try developing with web APIs, and augmenting your HTML and CSS with jQuery, mootools, Scriptaculous, or Dojo. Code not your style? You should be looking at Google Wave and the Semantic Web - two other things on my radar screen.
• If you are into code - well, this stuff is definitely getting more interesting. I found jQuery to be powerful yet complicated, definitely tricky. CSS for flexible layout is kids stuff - get ready to dive back into debug mode. The goal, however, is not to become an expert - just develop a healthy understanding of what is simple and what is difficult.
• Twitter and the real-time web took on a whole new meaning for me - I use Tweetdeck, and often set up searches to watch a keyword like "SAP", "master data", or "jQuery". This has become a great source for better plugins, but you can also get a quick sense of the market - the best code gets the most RT's!

If you are an IT leader, you simply must be getting in depth with this stuff as soon as possible. Your Sales, Operations, and Finance counterparts are desperately looking for the Next Big Thing in cost savings and/or competitive differentiation - grab a mitt and get in the game!

Besides, I like to be able to understand the subtle nuances - what's easy and what's difficult - when the business starts to talk about collaboration, the cloud, integrations and interfaces, and usability. (Primarily so I can set their expectations correctly after seeing breathless demos and presentations from well-meaning vendors ...)

A Work in Process

OffsiteStrategy.com is really best behaved in Firefox and Safari, but I have put a ton of time into the site to get it somewhat well-behaved in IE6 and IE7 (still a little quirky). I've still got a list of features to add:

• I'm not stuck on the Chicago area - check out Boston and Cincinnati, for example. I am working on adding a Search box to the map, so you can find _your_ location, then look for my fave in your area. Next time I'm in town ...
• I don't have as many photos as my daughters (14GB!!), but I have some that might be fun to share. Again, mostly just looking for a reason to mess with Picasa and the APIs available there
• I'm still hacking away here at the blog, and over on Twitter - and I've looked at some interesting scripts to pull data from those two platforms over to OffsiteStrategy.com, for some interesting visualizations.

Of course, if you have any feedback - or suggested locations - please let me know.

Credits / Further Reading

Like any self-teaching hack, I've constructed the site as a mix of original stuff plus techniques cribbed from demos and samples of work from other web developers. In particular ...

Google Maps

• I've used the Google Maps API V3 as the basis for my Maps stuff. I have an API key, no big deal, but I just like the default navigation features that come with this version (try the scroll wheel to zoom in and out of the map - just like the real thing).
• I got most of my ideas for the basic UI and map action from Marc Grabanski, but I had to augment a bit with stuff from this demo program to get the InfoWindows to work like I wanted.
• I also needed this handy Lat/Lon tool to get the markers positioned exactly where I wanted them to go.

jQuery

A very nice library of routines, plus I'm amazed at how fast the universe of plugins is expanding. The important ones used on this site include ...

• Rik Lomas' quickSearch plug-in, for the excellent filter action on the table of Locations
• Christian Bach's tablesorter - did you notice that you can sort the table by clicking the headers?
• I have made some progress dealing with the shortcomings of IE6 - thanks to Andreas Eberhard and his PNG-Transparency fix.
• The dropdowns underneath the icons come courtesy of jQuery Tools - good UI stuff. I think there is more there than tooltips, but that will be for another project.
• I used Mathias Bank's excellent plugin for parsing URL parameters - wanted to send nice-looking links in email to people, that would point them where we should meet.
• When I'm done with a plugin (or my own code), and I'm keeping a local copy, I have used Dean Edward's JavaScript Compressor web app. It works fairly well, although with some code I get quirky results with the compressed results - need to keep fiddling with that stuff.

CSS

This site got me back into practice with CSS - it's been a while since I've worked in this area. I did add Eric Meyer's CSS Reset to the site, another attempt at insulating the IE6 users from unfortunate look/feel issues.

Miscellaneous Tools

I also got a lot of mileage out of a couple of other web-based goodies:

• There are many color tools online, but Color Schemer Online v2 was the best for letting me quickly go from hue to hex.
• I got all of my icons from Iconspedia, a great source for free stuff. I did search a lot on the IconArchive site - good stuff, I just didn't find any that I needed from there.
• I've used the meebo chat widget before on my blog (up and to the right ...); it's pretty nifty, and I figured it would make sense to want to get a chat going while we are discussing where to meet up.

Source Code

Are you serious? Well, ok, look for the latest over here, let me know if I've forgotten anything ...

Previously ...

• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• Excel 2007 is a BOB system (Bag'O'Bugs) (October 5, 2008)
• Hacking the Google Chart API from Excel (January 17, 2009)
• Low Tech SharePoint Hack: Project Status Indicator (March 14, 2009)
• Five Stages of Twitter Relevance (April 21, 2009)
• Who owns Master Data in your company? (May 30, 2009)
• Real Business Users and SharePoint (July 14, 2009)

Technorati Tags: design, development, hands on, innovation, tech management, technology, twitter, Web 2.0,

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

New Collaboration Tools need Lead Time & Practice: Eight months ago, sharing files by e-mail and ad-hoc, unstructured meetings were the norm. To be fair, we were working smaller projects with teams of 10-20, and usually in no more than two locations. Over the past few months, as we were teeing up for Big Go-Live #1, we've been introducing the newer tools in small bits. For Go-Live Weekend, the team was already familiar with going to SharePoint for status updates, or recording a new Issue in the SharePoint list. The mechanics were old hat, and folks didn't need to think about it - which was nice, since we need them thinking about their Tasks. If we introduce new collaboration tools with little lead time before the Big Go-Live #2, Tasks will be interrupted with people struggling to remember how to communicate.

In the right setting, collaboration tools can clearly add value - even for the most conservative jaded technology users. However, you can't introduce something so new and expect people to "get it" in the short term. Better approach is to introduce the new tools early in the process, when there is no pressure. This lets the team build familiarity, understanding, and skills by the time you need to rely on these tools for critical communication.

Previously ...

• Dueling Collaboration Portals (November 23, 2008)
• Low Tech SharePoint Hack: Project Status Indicator (March 14, 2009)
• Location, Location, Location: Terminology Confusion in ERP Projects (April 11, 2009)
• Five Stages of Twitter Relevance (April 21, 2009)
• Over / Under Communication for Project Managers (June 29, 2009)
• Real Business Users and SharePoint (July 14, 2009)

Technorati Tags: collaboration, entrepreneur, innovation, Knowledge Management, people management, project management, SAP, Social Networks, twitter, Web 2.0,

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan,

Took some time today to work with the new communication meme - Google Wave. I wouldn't call it a fundamentally new way to communicate - well, not yet. I think Google is safe to continue with a "preview" label - clearly not even "beta" yet. No horrible bugs - at least on the Windows platform - but some obviously missing features. And, I am not all that impressed with the basic idea - it's just a mashup of Google Docs, instant messenger, and eMail.

Problems

All of my experimentation has been from a Windows machine - I am experiencing horrible performance issues with Firefox 3.5.3 on Ubuntu 9.04. I freely admit that this might not be a Wave issue - for the last two weeks, all of my Google sites (Mail, Docs, iGoogle, Reader ...) run brutally slow, timing out by graying the browser window. I know it's a weird issue because I can't Google for an answer (a disturbingly tight loop). Wave refused to even show me the stills from the introductory videos until I disabled Greasemonkey. Yes, I'm sure it has something to do with my setup, my installed plugins - I'm just surprised that the problems have been this stubborn.

So, to get anything done, it's back to Windows - still using Firefox, but no hint of platform troubles. Just an underwhelming experience with the fancy new toy.

I Am Legend

Interconnections on the internet are a wonderful thing; I put out a Tweet (sic) regarding my Wave invites, and a note in LinkedIn as well. Twitter generated the most responses, with folks I'd never met - great fun to connect like that. The following day, I got a note from someone looking to connect via Wave - I'm guessing from the information that I can see, this person saw one of my original notes via Friendfeed. Amazing how those copnnections were practically spontaneous ...

... while Wave feels like I'm in a walled garden. I still feel very cut off in the Wave world - a different domain from gmail.com means a new address to track, a new contact list to build. And it's difficult to find connections with folks you already know; I received another Wave invite from a friend, but since I didn't need it, I tried to figure out how to connect to him via Wave (I thought it a reasonable assumption that he, like me, has dived in). Unfortunately, I had to resort to an email message and some detective work to find out his Google ID - not something I could explain to most business users.

Yet Another Email Client

Yes, I am still at that opinion. Most of the opinions and articles I've scanned make it sound like we are working with a next-gen email client that does some of the basics right. I do note that the amplifiers tend to gush a bit, while the attenuators work hard to impress with wit.

Generally Pro

• Improves communications, reduce e-mail clutter
• First impressions
• A New Communication Platform For A New Web

Generally Con

• The Microsoft Bob of the New Millennium
• The moral equivalent of sliced bread
• Is Easier To Understand Than…

Maybe It's Just Me

One of my random invites went to this guy, who's review was a bit more positive than mind. Ok, maybe I'll jump into the with:public pool and wade around a while - it's probably the only way I'll really get it. However, I am very willing to be patient and continue the experiment - took me about 3 months to get Twitter.

Previously ...

• The Right Web2.0 Tool for the Audience (Twitter, LinkedIn, Facebook) (May 9, 2008)
• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• Hacking the Google Chart API from Excel (January 17, 2009)
• KM Overcomplicates: Heisenberg Impact on a VBA Quickie (February 8, 2009)
• Practical Applications of Twitter in Manufacturing? (April 5, 2009)
• Five Stages of Twitter Relevance (April 21, 2009)
• Real Business Users and SharePoint (July 14, 2009)

Technorati Tags: collaboration, hands on, innovation, Knowledge Management, Social Networks, technology, twitter, Web 2.0,

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

Thank you for signing up to give us early feedback on Google Wave. We're happy to give you access to Google Wave and are enlisting your help to improve the product.
To accept your invitation, sign into Google Wave at the following link ...

Well, maybe not the most exciting email I've received over the past few years, but it was nice to get the [sorta] early notice. I'm definitely in the second wave, but I'll not look a gift URL in the mouth.

Of course, no early impressions just yet - the interface upon start up is spare, looks like Yet Another Email Client. I will check out the introductory video(s) - I typically do my best learning by playing around a bit (without reading any manuals), then watch a demo or get an expert to give me a quick tour - and then I'll get serious. Something to do this weekend, or while waiting around during the Next Big Go-Live (project at work).

Like previous Google apps, this one came with invites - but this is 2009, man, and I've got Tweetdeck at the ready! Soon after receiving the invite, I put the word out (via LinkedIn, too), and got a number of responses from fellow adventurers looking for their own golden ticket.

I have no idea how long it will take to close the loop - my Wave page/inbox/site/thingie makes it look like I've added these folks to a List of Indeterminate Length, with no ETA on delivery. Still, I think it might be interesting to gather their feedback into a mini review of this newest communication technology. More to follow ...

Previously ...

• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• PMO Nirvana is a Conversation, not a Schedule (February 22, 2009)
• Practical Applications of Twitter in Manufacturing? (April 5, 2009)
• Five Stages of Twitter Relevance (April 21, 2009)
• Real Business Users and SharePoint (July 14, 2009)
• Training and Learning: A Different POV (August 18, 2009)

Technorati Tags: collaboration, design, hands on, innovation, Social Networks, technology, twitter, Web 2.0

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

Where do these great analogy ideas come from? Full credit - I got this one from a speaker at the SAP Research Center in Palo Alto, last spring.

A company is like a sphere.

As it grows, volume increases much faster than surface area, and the large a company gets, way more people get embedded and hidden from the end customer than are on the fringe, in customer-facing roles.

As a general rule, this is a bad thing. Well, maybe a less-than-optimal thing - what percentage of your corporate attention span is customer-focused?

Our Challenge is to poke some pockets into the surface, and get more surface area exposed to the outside air.

• Will this help a company go farther? It seems to work for golf balls ...
• Will this make the company more human? Perhaps, in a self-fulfilling / reverse fractal kind of way ...
• Will rough edges generate incremental profit? Some counterintuitive friction ...

Previously ...

• Heisenburg KM (July 13, 2004)
• Customer DNA - A Different Take on Understanding Markets and Networks (June 11, 2005)
• Misapplying the Pareto principle (January 7, 2006)
• Interesting How the Mind Works (October 1, 2007)
• Innovation That Matters - Substance Over Style (January 12, 2008)
• Failing Faster (June 14, 2009)

Technorati Tags: business value of IT, CRM, entrepreneur, innovation, Knowledge Management, marketing, people management, SAP, Social Networks, Web 2.0

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan

I think this is one of those fundamental concepts that, once it is pointed out to me, become self-evident and obvious (ie. why didn't I think of that). I'm curious if other people agree ...

I've seen these principles illustrated in different areas of business and technology; understanding this relationship can relieve frustration and provide hints on where to focus your efforts when working on a project.

Simple is Difficult

Simple Idea: My favorite example is the phenomenon of "smart part numbers", where organizations find it convenient to encode attributes about a product in the item / SKU number. This makes it easy for people to read labels and reports, find parts in the warehouse, and work with line items on an order. Unfortunately, implementing systems & processes that rely on "smart part numbers" can be problematic; reports and queries rely on multiple pieces of information embedded in a single field / column; SQL queries are tough to write, and reports & other programs become notoriously difficult to maintain.

"Lean" Process: Somewhat related is the phenomenon where business processes are rarely documented. Everyone in the group knows how to start with the Order, through Make-to-Ship, and back to the Cash. The problem usually hits when we experience turnover or some other staff change; our well-oiled machine starts to slip up, and performance gaps appear as the new team member doesn't fully understand know or understand everything that is required / assumed of them.

User Friendly: I've written before about documentation that insists on screen prints for every step of a process. I can empathize with the end-user on this; this level of hand-holding is extremely helpful, because it makes it easier to learn a new system or technique. Unfortunately, documentation at this depth is expensive and time-consuming to create & maintain - and is typically done best by folks whose primary job is documentation / communication (ie. not the folks who are asked to create this stuff).

Simple to Use; "Elegant": There is a related demand for software and websites that are easy to use, truly user-friendly and possessing intuitively obvious interfaces that everyone can just run with. These don't require complicated manuals, but they do require an awful lot of skillful programming to deliver such use and simplicity. I am working on a simple, small Web application (more on that later ...), where I'm trying to develop something that will elegantly solve a specific problem, yet be truly intuitive and obvious (dare I say fun?) to use. The challenge, however, is cross-browser compatibility; in the past few evenings, I've discovered some amazingly intricate problems with how CSS and PNG works with the Microsoft browsers - and have had to go to extraordinary lengths to make the website look the same on Firefox, Safari and Internet Explorer.

Difficult is Simple

The reverse argument can be behavioral and cynical; "time is money" drives some to oversimplify. However, "agile" design and development can be a practical tool when trying to maximize sustainable output.

Difficult Idea: I think the time-and attention-starved workday contributes to an unfortunate amount of oversimplification. If there is a complex project or difficult issue to deal with, get ready for the unending stream of peers, partners, subordinates, and "higher-ups" asking about status and root cause. Unfortunately, these people have limited time available to waste on active listening and understanding; typically, they will demand a short summary. They just want to know that the problem is in hand and getting handled.

Rapid Development: McConnell notwithstanding, some teams use "rapid development" as a convenient shorthand for "quick-and-dirty programming that relies on hard coding, flimsy structure, and a lack of testing".

• With some extra work, reusable logic can be modularized, interfaces can be abstracted, and simplistic, utility programs can be replaced with flexible, fault tolerant modules that can be reused and extended. This particular brand of good cooking takes time, and a bit of design foresight.

Hard to Use; Hard to Understand:  Of course, if you focus on Time to Completion, driving to get stuff done, focusing on deadlines over quality, it's not surprising that systems and processes are hard to use, and communication pieces are difficult to understand. As an old Army officer once told me, "if you want it bad, you get it bad".

IT's Challenge - Fighting the Good Fight

Of course, the "good cooking takes time" argument typically doesn't go over well with most businesses. The pressure on IT, really any business area, is to learn the local tools and techniques, and leverage work that has been already done. In addition, there has to be some points awarded for systems that don't require help desk support, processes that don't require handholding, and follow-up training in the weeks after go live.

Communication with management and the business is just as critical, just as difficult and just as rewarding when you get it right. Your counterparts in the business aren't dense - they just need things explained glibly yet completely. Master this, and Le monde est votre huître.

Previously ...

• Facilitating Innovation: Establishing an Environment of Possibilities (August 22, 2008)
• Best Practices for Process Documentation: Iterations (2 of 3) (September 17, 2008)
• Agile Methods in a Waterfall World: Speaking In Code (September 29, 2008)
• Low Tech SharePoint Hack: Project Status Indicator (March 14, 2009)
• Location, Location, Location: Terminology Confusion in ERP Projects (April 11, 2009)
• The Delicate Art of Pushing Back (July 5, 2009)

Technorati Tags: best practice, business value of IT, documentation, presentations

Invisible Technorati Tags: cazh1, James P. MacLennan, jpmacl, MacLennan,