5 ms·
Let's assume you're paying a developer $100k per year - not atypical in this day and age. As a business, I want that developer, who is likely making more than a
by memset 13y ago
Let's assume you're paying a developer $100k per year - not atypical in this day and age. As a business, I want that developer, who is likely making more than anyone else in the organization, to be working on "the most important thing" in our business at a given time. This might mean a new checkout flow, making sure the online shopping cart works, or scaling a website to accomodate 1000 users at once.
There are many tasks which engineers can easily do, and which most non-technically people are loathe to perform, but are not the most important thing that an engineer ought to be doing in a business. The easiest example is reporting.
A given marketing department will want sales information. They'll want charts and graphs describing conversion rates, customer acquisition costs, etc. There are far more ways that the marketing department will want to slice-and-dice data for analysis than a team of developers can possibly produce.
Engineers don't want to be relegated to creating reports. And anyway, the report you just asked your engineer to create may have just cost you $1000.
So if we were able to bring these marketing people to a level of proficiency where they could use SQL to generate reports, Excel to manipulate that data, and VBA to do analysis (which I believe could be accomplished with 80 hours of training - a drop in the bucket over the course of one's career), then we can let the engineers do the things they are good at ("make sure passwords are secure") and the marketing folks have the minimum proficiency they require to do their jobs.
This is common in companies like Amazon; "the engineers wouldn't help me run reports, so I had to learn myself."
Nowadays, business decisions are based on numerical analysis of behavior. (Click-through rates of advertisements. Conversion rates from campaigns. Number of lawns per high school student per summer.) This trend is unlikely to go away.
In practice, "numerical analysis" means "schlepping data into Excel and running the numbers." And that skill of "running the numbers" without having to ask an engineer (who is both expensive and uninterested) seems, to me, of great practical value.
Obviously I have cornered one specific example that I consistently deal with. But it is not too difficult to imagine that these tools of analysis can help automate any number of tasks, in many disciplines. It is not uncommon for linguistics (graduate) students to learn programming to better analyze the meter of poetry. Optimistically, I hope that "non-technical" will be able to use the tools of our trade in new and interesting ways that we never imagined - the same way a carpenter might use everyday materials in ways that are very innovative to laymen.
- analog31 13y agoPerhaps a side effect of "everybody" learning to program will be the demand for more programming tools that are easy to use. Excel and VBA both developed due to use demand. I've seen lots of people, from engineers to workers on the loading dock, use Excel to create convenient tools for their own use.
- easy_rider 13y agoMy client, he doesn't know what "FTP" is, and does not know how to upload his revised version of the current Excel calculation sheet which he designed, and is core-business, and coupled to an application form. He knows the ins and outs about Excel, from formulas to shortcuts, and i'm a total novice when he's explaining stuff to me. I'm interfacing with his Excel sheet through PHP, and he does not have to change the way he works, and I don't. I don't need to know all the ins-and outs, I just need to know which cell needs what data, and the cells that are calculated and need to extract data from. I'm now building a management backend for him in Rails, and it will work the same way. Maybe later those Excel calculations will be ported to the database, but for now there is no reason to bother my client with learning a new interface and changing the way he works.
- collyw 13y agoAs a counter argument to that, many of the non-technical users in my organization like Excel. We have wasted countless hours by sticking to excel as a data input / manipulation tool, as it is incredibly error prone. Non technical users don't see the difference between a 2 and "2" and a " 2". It looks right to them, and much of the time they seem incapable of reading a sensible error message and fixing it the problem themselves.
- hatu 13y agoI've also noticed this countless of times. If you leave data sets to be designed by a non-engineer - it will cost you hours and hours of parsing and changing the format constantly depending on who slapped the excel sheet together. Literally one of the worst experiences on a job was dealing with a big corporations excel sheets and trying to convert them into usable data.