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…

Agile Methods in a Waterfall World: Speaking In Code

Starting up a new project, and I'm definitely having fun with it. At first glance, it looks like a fairly small, departmental application, but it is actually part of a web of disconnected processes and local databases (ie. "a mess") that support some fairly important master data. Also, the folks I'm working with are much more comfortable in a "waterfall world", with formal requirements followed by code, test, and deploy. Lots of opportunity for process coaching and new methods -…

PMO Prioritization – Project Descriptions should be Effective, Relevant … and Short!

9 December, 2007
PMO, Project Management
0 Comments

Next year, our PMO will be taking a run at improving "transparency" for project prioritization - a clearer process for getting projects approved and scheduled. Here's a key building block - what is the most effective way to describe a project? There is a certain amount of art and style in getting this right; most PMOs feature some sort of central database listing candidate projects; typically, the various screens, views, reports, etc. are designed for "short and sweet" descriptions. Note…

Excel vs. RDBMS: Choosing the Technology, Winning the Arguments

Businesses large and small, private and public, for-profit and not, commonly control critical business processes using the EIE platform (which means Everything in Excel - always good for a laugh in your next PowerPoint - jpmacl). Folks in the business get used to the power and control they have with spreadsheets, and who can blame them? Excel is … … fast and flexible … easy to learn Everybody has a copy I don't have to go through IT Remember, most…

A great mission statement for Corporate IT

This is actually an old story, from a previous life, but I need to get back on the posting bandwagon. Way back in the day... ... there was a site on the public Internet with Company Confidential Information out there. The site was put together by an ambitious sales rep with some time on his hands, a few technical books, and a yen for something interesting to do. It was a nice little site, too - even had user ID…

Three Best TLAs of all time, the hegemony of Excel, and the Intuitive Front End

Everybody jokes about TLAs and the proliferation of consultant-speak. My favorites to date include: SPOC - Single Point of Contact: During integration meetings between two merging IT organizations, SPOCs were identified as the key connection points between groups. Panders to the trekkies, but sticks in your mind. WOMP - What's On My Plate: The name of a report we developed in a PMO, listing issues assigned, projects being managed, open programming requests, etc. - one page per person. The WOMP…

Misapplying the Pareto principle

8 January, 2006
Project Management, Business Value of IT
2 Comments

Here's an interesting phenomenon I've encountered before ... When analyzing a specific section of a business, people seem to naturally focus attention and conversation on the top two or three customers/products/vendors that together represent (say) 20% of the revenues/costs/contracts. Our objective is to look at the data and identify opportunities (increase revenues, cut COGS, aggregate contracts); unfortunately, processing the data for these customers/products/vendors is currently a 100% manual task. Of course; this is why there is apparently so much "opportunity"…