That's a SEO-approved headline if I've ever seen one.

Thought it'd be good to share a research project I did about 8 months ago for my Data Analysis class.  Maybe someone else can duplicate it in another industry and benefit from it.  The basic instructions for the project were to use exploratory data analysis to gain a business insight; it was an introductory class for business professionals so it didn't involve very heavy lifting but it was challenging nonetheless.  Well since I concurrently was working (and still am) for SolarCity, I thought it'd be good to incorporate it because there might be benefits that emerge throughout the process.  Of course, I won't disclose any business information.

My goal was to pick a regional warehouse and be able to find the most "attractive" areas in which we should focus our sales efforts on.  First I picked the smallest area that the US Census gave open data for (which was the zip code) and found the top 50 zip codes that we have current customers in.  My theory was that our future customers would more likely be similar to our current customers than not, so I decided to focus my data analysis on describing our current customer base.  The US Census will give you a shitload of data, as long as you painstakingly gather it in little chunks.  So that's what I spent most of my time on.

Below is an example of the finished product of collecting the data individually and organizing all of it.  I'd say this took about 2/3 of the total project time:

First I just played around with a portion of the data, to make sure it made sense before proceeding.  To do so, I did a X-Y scatterplot of each Census data column against the total count of customers in each category; thus a positive correlation would mean you would expect more customers in a zip code the higher it is in that certain Census variable.  I only used the relative percent of some of the Census data columns, since this would paint a better picture than total numbers for certain ones.  Below is an example of linear regressions of some, with neutral, positive and negative correlations:

This yielded some interesting patterns.  I wanted to further analyze it and divided each variable (column of a particular statistic from the Census) into similar groupings.  Yes I added some personal bias to this analysis, but rarely was it hard for me to pick a particular grouping for each variable, so I'm confident I didn't inject too much bias.  Below are the groupings of the categories of different Census data:

Then I found the correlations by grouping, this was particularly interesting to see what had the highest positive and negative indicators of more customers.  Below is the graph by grouping:

I just started reading "Empires of Light:  Edison, Tesla, Westinghouse, and the Race to Electrify the World" by Jill Jonnes and I'm already enthralled in it.  Although she can be superfluous at times (and so was using that word), she paints an exciting story about the battle a century and a half ago to bring electricity to the masses.

We all know the ending (Tesla/Westinghouse and AC power won out, even though it was more dangerous because it could travel long distances more efficiently) but that's what makes it so interesting.  Solar is going through a similar battle right now, and it is on the Edison and DC side (solar panels produce DC energy, and right now that has to be converted back to AC power to power things in your home -- hysterically it is actually converted back to DC power to power a lot of electronics) but updated to today's technology.  He was an advocate of a distributed system of power generators; unfortunately due to the technology of the time there had to be a toxic, noisy generation station every couple city blocks.  But in today's time, that is just the same exact thing as quiet, clean energy producing solar panels on your home's roof.  They don't put off any toxic fumes, they don't make any sound, all they do is just sit on top of a small area on your roof that was previously just occupied by dirt buildup and bird shit.

Anyways, I'm sure this won't be the only post I write about solar and the "War of Currents", but it hit home when I just read about Edison's inspiration for his invention of the lightbulb.  Jonnes writes, after Edison had just been introduced to arc lights:

"Then Edison rushed back to quiet, bucolic Menlo Park, his research workshop in backwater New Jersey, to throw himself into creating a better and more practical electric light.  He worked feverishly, thrilled at the possibilities of this new field."

"It was all before me.  I saw the thing had not gone so far but that I had a chance.  I saw that what had been done had never been made practically useful.  The intense light had not been subdivided so that it could be brought into private houses."

"Edison always liked to go after 'big things.'"

The man who came up with the best arc light system might well make a fortune stealing away even that 10 perfect of the gas lighting business -- that of streetlights.  But the man who could subdivide the light -- to take it indoors and tame it into a gentle glow -- and power it with a dynamo, he would be the true Promethean, the blazing electrical pioneer, the hailed benefactor of humankind (and wealthy to boot).

Obscure title yes but it'll do for right now.  

Often we go through life wanting to do a lot of things:  we want to be successful in school and our careers, we want to have a loving family, we want to maintain our health and exercise, we want to give back to our communities/religion, etc.  But rarely do we have time for all of them on a consistent basis.  All along, we also have a lot of ideas of different ways we think the world can improve but again lack time and the resources to fulfill the execution needed to bring said ideas to life.

Sometimes we tell these ideas to others to seek external support; sometimes we keep them a secret because we're scared of external judgment.  But for every idea we don't let be known, there exists the possibility that the world never got to benefit from a possible "missed connection" of mutually beneficial or associated other ideas.  

I've never been shy about sharing my thoughts if I think they can help improve things in any way.  Often this information has already been brought up and discussed or dismissed but that doesn't mean it shouldn't be shared.  You either show that you are on the same page as those who you are presenting the topics to or you show that you need to learn more about the topic.  But that shouldn't deter you from potentially sparking another person's interest to continue where you left off.  It's a pretty high risk, low reward process as long as you have vetted the idea internally as well as externally with trusted friends.

So that's why my first idea after introducing my introduction to them is for someone to create said idea-curation-then-creation website; someplace that builds off of the positive purpose behind message boards and serves as a melting pot of associated ideas with simple UI and transparent philosophy.  After allowing for ideas to be connected, the best solutions will bubble to the top through Reddit-esque upvotes/downvotes then a representative can be chosen and the project can be paid for through crowdfunding.

That's got to be a net positive for the world.

I've been using this music streaming service called Hype Machine for a little over 5 years now and my account and all the songs I've hearted ("liked") over the years is easily one of my top 5 online possessions.  It's become a daily part of my life; the process discovering new music throughout the week is enhanced by always having one place where everything can be found.  This is going to make me sound dated to any other hypem users (cue the old grandpa voice) but I remember when top songs on their popular page only had a couple hundred likes, now their #1 songs (such as the Odesza remix of Zhu's "Faded" mentioned below) routinely have 5,000+ likes.

It's free to join and they're not very obtrusive.  You "pay" by having ads pop up all the time when you open your page as well as some tricky border ads; annoying but again, it's totally free, so it's worth it to me.  I'm sure they also get some revenue from referring people to buy concert tickets on songkick.com (which I've done many times over the years).

Soon they'll have an official Android app and it'll only increase my use of the site I'm sure.  They are pretty aware of their product niche but are always rolling out new features with an eye towards the future.  One reason why I originally liked them is because their popular page had a shelf life of 3 days so it always kept recent hot songs coming through.  Recently they rolled out the ability to create "lists" of different styles/energies of music, they are "Up", "Down" and "Weird".  I'm still figuring out the feel of each but this is brilliant on both the customer's and the company's ends; I get to have a quick way to play a similarly styled playlist and Hype Machine gets users to crowdsource genre-definition of all their songs.  Once again the wisdom of the crowds will prove to be very useful.

Check it out particularly if you enjoy electronic/techno/EDM/whatever you call it and indie, as those are primarily the genres I see represented.  I suggest when you begin to regularly use it that you curate a followed list of some blogs that you see playing the specific type of music you enjoy at the moment.  If the blog's new song isn't exactly your flavor, a lot of times there will be another song in the post that you will like.  

I've heard a lot of good music recently but this one really stands out.  Partly due to timing as it's the beginning of summer, it's mostly good because it retains just enough of the original to bring back memories of summers long ago.  That and everything it adds is perfectly placed.  Would make a great song choice if you happen to be cruising down A1A in the bright Miami sun, just saying.

Baby Bash - Suga Suga (Royal Refix)