I have come to the belief that Geographical Information System (GIS) is the next Excel – i.e. a tool that will become indispensable in everyday life, and most especially to an engineer.
My first exposure to GIS was in the mid-1990s. On a project for PacBell (now AT&T, again), we were building a revolutionary new, fully integrated Operational Support System (OSS) for their ‘new’ network that was going to replace POTS throughout California (I’ll write more about that project sometime soon). But we didn’t get very far with GIS then. A decade later, when Mary Anne was hired to teach Environmental Science at Ramapo College, one of the courses they wanted her for was GIS. She didn’t know much at the time, but with her background in CompSci, she dived in and learned it. She’s been teaching it semi-regularly for nearly 10 years, and continues to do so now at Georgetown. Last year, while on the Wi-Fi project that I mentioned last week, a super talented RF Engineer on the project came up with an analysis methodology using GIS tools. It is a really powerful way to analyze lots of data (and present it geographically), and greatly helped our clients to decide where and how much to build out their networks. I have always been intrigued, but never had the time to learn GIS myself – that is, until now.
I have had a great deal of fun these past 8 weeks, following along on some of the projects Mary Anne’s students are doing this semester (e.g. tromping through a remediated wetlands with a GPS recorder), plus diving into the textbook that she teaches from. I’ve learned a great deal, though somewhat specific to ArcGIS version 10 from ESRI, the company that has most commercialized GIS technology (and is still privately held!). If you’re interested, I recommend “Understanding GIS – An ArcGIS Project Workbook” by Harder, Ormsby and Balstrøm, and published by ESRI. They include a DVD of the software with a limited license and a reasonably complex project to work on over its 9 chapters. It includes discussion of the ‘fun’ parts of any technology project, such as uncertain or changing customer requirements (noooo, I’ve never had that challenge), how to make an analysis easily repeatable and flexible, and even a whole chapter on creating the presentation with the results of analysis. It is a little overly scripted for me, but that likely makes it easier to teach to a general audience (without a computer software background).
When I was a young engineer and anxious to get that first promotion, I looked closely at what others were doing when they got promoted. In those days, business skills were still rare in Bell Labs/AT&T Network Systems, and were ever more important than prior to the 1984 Divestiture. So I focused on developing those more (a.k.a. I turned to the ‘dark side’). For me, that included a rotational program into our sales force (more about that sometime, too), and then coming back to a role in product management. It was there, that I first started using Excel regularly. I developed spreadsheets to track our budget verses actual expenses, our software R&D capitalization/amortization schedule, another for our sales opportunity funnel and revenues, and then put it all together in a product-specific income statement. At the time my peer product managers had no similar insights into these details, as very limited financial information was computerized (and mostly on mainframes). But I could run all kinds of ‘what-if’ business cases or probability assessments, and see the profitability impacts instantly. Since then I’ve used Excel for lots of non-financial things too: engineering performance modeling, net zero energy (NZE) analysis, requirements tracking, contact lists, uncountable charts for presentations, weather analysis, and even a game or two. In 1992, I got that first promotion, and I have always attributed it to my abilities with Excel, bridging technology with business skills. But now that I’m learning GIS, I am wondering, how does an independent consultant earn a promotion…? 😉