Thursday, December 17, 2009

Finally have the time to look for a new home

As I mentioned in Not my permanent home I wanted to look around a bit before committing to a CMS.  I tend to see blogger as a great place to throw things together in a fast and temporary way, but if I want to make this blog into something really great, I want to move it to my own server. 

Here's the thing, though--I'm a perfectionist.  And a nerd.  Combined, it's a lethal combination.

So tonight I got sidetracked (which, btw, reminds me of Kevin Macdonell's excellent blog post "There's no such thing as wasted time"), and instead of putting together something for my research summary on the donor management tool we've been working on, I found myself pouring through a report from Idealware called Comparing Open Source Content Management Systems: WordPress, Joomla, Drupal, and Plone.

Yeah, I'm a real party animal in the off season.

Anyway, it seems as though I'll read a bit about WordPress and be sold on it...then I get swayed to Joomla, and then Drupal starts looking good.  I can feel this tingling sensation of perfectionism kicking in, and I know from experience that I could lose hours or days just combing through reviews, and available add-ins, and...well...overthinking things.

My solution to this is that I've saved the Idealware report, I'll download WordPress first, and test drive a set up.  I'll ask a couple people I know if they're happy with what they use.  But for tonight, I'm tossing this all up here on my blogger account and saving it as evidence of the journey.  It'll all still be right here when I want it, and it'll wait.

Monday, December 14, 2009

And the internship search commences....NOW

With my last final out of the way, it's time to seriously search for a summer internship.  I have a few applications out, but during this holiday break I need to sit down and find more leads.  Ideally, I'd like to find something in the Seattle area, since that's where I plan to settle after my graduation in December 2010.  On a preliminary search, I found a place I'd really like to contact and set something up: NPower Seattle.  I don't know how much (if any) analytics they offer for nonprofits, but I'd also be interested in their CRM project.  I've also applied for a Microsoft internship, since they're pushing a good amount of data mining (especially text mining) with their Bing projects.  However, MS internships are extremely hard to land (seeing as though they apparently compensate their interns quite well).  If I can't find something in Seattle, I'll have to look in the Waco-Austin area.

I believe that if I end up interning in the business analytics field, I can still use that to the benefit of nonprofits.  I just see too many similarities between private sector and nonprofits to say "oh no, I must find an internship in a nonprofit."

I wonder what the updated assumption is nowadays for internship compensation.  Back when I was an undergrad, everyone I spoke to had pretty lucrative internships, and it seemed as though full-time positions were pretty much implied in the package.  I doubt that's the case anymore, since the economy today is vastly different from 1999.  If I have to, I might be able to swing an unpaid internship by taking out the max student loan amount, and if it's a situation where I think the experience is worth it, I'd try to make it work.  Technically, I don't even need an internship for my degree because I'm told that my work experience more than fulfills that requirement...but like I've said before, I'm not doing this for another degree to hang on the wall.  I'm doing it to broaden my knowledge, to get my foot in the door, and to be put in contact with people that know more than me and are willing to mentor an eager person with a unique background.

Saturday, December 12, 2009

Helping smaller nonprofits afford the IT help they need

Well, yet another round of papers is done and out of the way.  I did a rather lackluster blurb about Gogo In-flight WiFi Service which, although it wasn't my best work, might come in handy for someone traveling this holiday season (especially if you're flying on American Airlines). 

The paper I enjoyed the most though, was Fundraising Analytics: What Nonprofit Organizations Can Learn from the Private Sector (yeah, I know, sounds thrilling).  This is the one that I'm hoping to refine and turn into something more substantial, and see if I can get it published.  Anyway, my basic premise is that nonprofits are behind the curve on using data mining to it's fullest extent, and text mining might be the next big thing.  I can picture taking all those reactive research reports and dumping them into a data warehouse, and just culling through it all (along with collected news articles and contact reports) for connections.

I'm putting together a quick and dirty powerpoint for my database prof to share some ideas I have about what can do in the future to improve the product we have, and make it more analytic-ready.  Mainly, I'm going to focus on what smaller nonprofits can do to mine the information they already have, without access to the tools that larger organizations have.  For instance, we've been using Tableau to aid visualization, but considering it's limitations, I was shocked when I checked into buying the full version.


(my reaction to their insane pricing)

So, my goal during this break is to look into what options a smaller nonprofit might have to reap the benefits.  I know there are macros for excel already out there that will do regression models, so if I find ones that are free I might start throwing that together with some other basic things (I know the newest version of excel  has a few rudimentary visualization tools for data mining so I'll see if that does what I'm envisioning), and if need be, making my own free tool.  It'll be a far cry from a CRM, but it'll be something.  It needs to be easy enough so that any person without a background in this stuff can just toss in the data, click a button, and get ready-to-use findings back, with possibly some charts to help sell the idea to the management-types.  I'll also check out the offerings already out there for open source things, and see what can be done.  

I have an uncle that runs a battered women's shelter in a fairly rural place.  He needs a quick and easy way to browse grants, to organize contacts, and to find interested donors.  He shouldn't have to spend lots of money to get this done; their funds are better spent on their primary mission.  Uh oh, I'm sensing some scope creep...but honestly, this is the stuff that I'm passionate about, and I'll do what it takes.   

Friday, December 4, 2009

Not my permanent home

Programming note:

No, I don't intend to keep this blog on the Blogger service, it's just a temporary home to store my posts until I have time to set up a more permanent home.  I promise, sometime in the near future I'll sit down and get something better up and running (do I really seem like a premade template kind of person to you?). 

Prospect Research and Data Mining

Just FYI: Anyone looking for a peer resource for fundraising data management should sign up for MIT's Prospect-dmm mailing list.  I've been on it for a couple years now and it's always thought provoking.

Text analytics course

According to a press release Baylor University recently put out, the text analytics course I've enrolled in for the Spring semester is "the first of its kind in the United States and possibly the world. According to the class' instructor, Dr. Theresa Edgington, "Current market trends indicate Business Analytics (which include traditional business intelligence, data mining, and text analytics) is the growth field for Information Systems (IS)."  Other classes of its kind have apparently been taught in engineering departments, but not in a business school environment.

Another interesting tidbit from the article:
"Edgington also noted an interesting trend among the early registrants for her course: so far they are all women. While she emphasized men are more than welcome, she is excited about the surprising demographics. Much has been made concerning the lack of women in IS. But this new class could represent an opportunity for Baylor to promote positive change by enticing more women to the field."
As of today, I see via the registration website that there are 3 people signed up for the class (myself included).  Unlike the data mining class (that was also first offered this year), text analytics is only open to graduate students or undergrads with special permission.  I'm excited that this course is being offered just in time for me to take advantage of it, since otherwise I would have formed an independant study for this topic anyway.  At least this way, I'll have at least 2 other people to bounce ideas off of.

Wolfram Alpha and statistics

I just heard about Wolfram Alpha's scary computational abilities from Lifehacker, and had to check it out myself.  I did a quickie search to see what it could do in terms of statistics, and it turned up some things that I'll have to give further attention to.  I'm betting it could do all the typical finance equations as well.

Noncompete clauses

Brent Ozar wrote a great article entitled "Top 10 Questions to Ask When Taking an IT Job", which brought up something I'll definitely need to remember...that pesky noncompete clause that keeps popping up.  I have no problem with nondisclosure, with conforming to the ethical standards of only accepting freelance work that in no way competes with my main employer, etc.  However, I like the flexibility to pick up work on the side so this will be a good question to keep in mind.

I want to thank the Academy...

A friend of mine, David Stein, recently wrote a tribute to his favorite high school teacher.  I was fortunate enough to have a good amount of teachers that taught the fundamentals, but the ones that I still remember are the ones whose enthusiasm just bubbled out of them.  People that are passionate about what they do have helped push me to follow my own passions, and I'm so glad to have come across them.  So, thanks to Dave's reminder, I'd like to thank the following people:

Mrs. Pfiefer, who in the 6th grade once wrote on a progress report, "I fully expect to see Jennifer's name on a book jacket someday"

Pamela Stanescu, who taught my AP US History class back at Warner Robins High School.  Once, during a school bomb threat that evacuated all the buildings to a nearby parking lot, she actually gathered our class around her and kept teaching.  Other classes were milling around just killing time, but there we were, listening to her every word because she knew how to make it come alive.  I still remember "the free and unlimited coinage of silver at the ration of 16:1."

Rachel Moore, who was technically an english professor at Baylor, but taught much more than that.  

David Sturgill, my favorite computer science prof at Baylor during my undergrad years when I had him for an OS class.  He knew his stuff, and (unlike a lot of profs) could effectively teach it too.

Gina Green, who has taken me under her wing as we collaborate on everything from grant writing to a custom CRM for nonprofits.

Betsy Willis, who threw me into the deep end of accounting this past summer, but whose teacher style got me back into the swing of things after 10 years away from the classroom.

I've recently been elected to serve as the MSIS rep for the Graduate Business Association (which is easy to accomplish when you're unopposed :)  ), and if I had to give a tearful acceptance speech (minus an interruption from Kanye West), it'd have been a lot like this.

When is a Masters not good enough?

This August article from the New York Times makes me wonder what the ROI is for a PhD in the stats field, since the only firm number the author gives is the $125K starting salary for doctoral statisticians.  What about some BBA kid with a concentration in quantitative business analytics?  More importantly (well, to me), what about people with a masters degree that load up on QBA and BI courses?  Is this going to become one of those careers where you can't even get your foot in the door without a "Dr" in front of your name? 

Case in point: my focus so far has been on nonprofit fundraising, specifically for higher education institutions.  I come from a family where one of my grandfathers didn't graduate high school, but taught himself advanced math concepts out of books likes "Calculus for the Common Man", and did it solely because he had that curiosity and interest in it.  He instilled that into my father, who without a 4 year degree, has gained more experience and know-how than most people will ever have; at this point, my dad could teach computer science and electronics better than any prof I've ever met, bar none, and he's learned quite a bit of that just because he likes to experiment and learn.  Anyway, we have this family tradition where education is a big deal to us, and we get as much of it as we can, from whatever avenues we have.  When I got my BS in computer science back in '99, I had a slew of financial aid helping me out, mainly in the form of student loans that I will be paying for the rest of my natural life (or, until 2012 wipes out humanity.  I should be so lucky). In addition to those loans, though, I received scholarships from my university.  People had gone out into the world, become successful, and then turned around and endowed scholarships to my school; their remembrance of where they got their start and their gratitude gave me a chance that I wouldn't have otherwise had.  I want to do my part, too.

So that's why I have this passion for working in the educational sector.  Nonprofits in general interest me, because it's one way to help a charity even when you can't afford to personally cut a check.  One of the clients I was most proud to work for (when I was more actively doing freelance prospect research consulting) was the International Center for Missing and Exploited Children, just because it was my tiny contribution to their mission.  This is what I'm passionate about, it's what gives me that "I did something meaningful today" feeling, and it's where I want to steer my career.

That being said, there's the lure of the private sector that I have to consider.  There job availability, for one thing; finding a university job in this field would have to be a nationwide search.  Another reason is salary, since the fact of the matter is that nonprofits simply can't pay as much as a for-profit.  Granted, there are usually other benefits to compensate for that, like tuition remission.  Do I see a private sector job as selling  out?  No, because what's stopping me from then turning around and using some of that higher salary to make a monetary contribution directly to the foundation/university? 

I bring this up because in my experience (and there is no good way to put this), universities are snobbish about hiring the highest degree they can find.  Whereas 10 years ago it was fine for a prospect research position to be listed as "bachelors required, masters preferred", it's now "masters required" and the preference is "sky's the limit".  Perhaps this is how universities atone for pumping out a glut of overeducated people that the society just can't help but underemploy.  Whatever.  All I know is, it's getting harder and harder to even get your foot in the door of a large university's development office if you don't already have a masters under your belt.  If you have aspirations of climbing the ladder into VP positions, assume the PhD is a requirement.  Contrast that with the private sector (and nonprofits without an educational slant), and I see much less of that going on.  Those are positions that ask for a bachelors plus experience, but the emphasis is on your skill set and not your thesis.

This begs the question of why would you spend the additional time and money going after multiple advanced degrees just to become a legitimate contender for a job in educational fundraising that won't come close to paying what you could be earning elsewhere.  Sure, the woman mentioned in that NY Times article has a PhD from Harvard, but I assure you that Google is compensating adequately enough to make a decent return on that educational investment.

Up until now, the business intelligence field in the private sector made the pioneering strides while the nonprofits watched, learned, and adapted.  What if we're starting to see more private sector jobs requiring higher levels of education?  Remember when all you needed to get a decent job was a high school diploma and good work ethic?  Then you needed to have an associates, then a bachelors, and I'm scared of where this trend is going.  Sure, it'd be nice to be Dr. Jen, but at some point I'd really like to get out there and concentrate on...I don't know...real world experience. 

Thursday, December 3, 2009

The art (literally) of data mining

Thanks to Amanda Jarman's great "Fundraising Nerd" blog, I stumbled onto a fantastic way to procrastinate on my latest paper.  At this stage in the semester, any brief diversion is a breath of fresh air.

The Personas Project, as described by their website, "shows you how the Internet sees you...Enter your name, and Personas scours the web for information and attempts to characterize the person - to fit them to a predetermined set of categories that an algorithmic process created from a massive corpus of data. The computational process is visualized with each stage of the analysis, finally resulting in the presentation of a seemingly authoritative personal profile."

"Seemingly authoritative" would have been a great name for this blog, come to think of it.  Anyway, for kicks I ran both my full name and nickname.  Now, keep in mind that this isn't accurate at all for most people.  Using myself as an example: (click to enlarge)


I can say that the hits for politics, music, books, family, and education are think are fairly "me".  But sports?  Ha.  And what in the world is that "illegal" category?  I'm not that interesting.  Apparently, Google seems to think that I'm likely to enjoy driving my well-educated family to sporting events in a car covered with Obama bumper stickers and, while there, scalping tickets.  Good times.

So obviously, there are things like misidentifications, limited search results, algorithm limitations, and on and on.  But, that's the point.  We may hear a lot of promises from the analytics field, and there are very tangible ROIs to be had from wisely using the data you've collected, but there are also limitations.  The Personas Project is a great way to show that (perhaps more often than we'd like to admit) data/text analytics is more of an art than a science.