Data Science, pt 1

I'm calling this "Data Science, pt 1" because it's the beginning, and to be honest, I'm not sure where it end.

To be honest, if you're not interested in Twitter or data, you probably won't be interested in this post. One of my coworkers and I often have discussions about Twitter, partly because I'm a regular poster there and partly because he does not post there. Our inside joke about Twitter, though, is about my posting.

If you follow my twitter posts (hochspeyer@CJoelHarrison), you'll see an account that is focused primarily on Big Data, IoT and programming. We have some good-natured interplay about this-

"You're a fraud," he says.

"I tell the truth," I reply.

This can, and sometimes does- go on all night. I'm not mentioning his name because of my personal blogging rules: if I don't have permission, then I don't have permission.

In the end, we agree to disagree. So, why the Big Preface?

Well, mostly because this blog is about data. And, although data seems to be the furthest thing from a theme, I try to keep data as the unifying theme.

Believe it or not, Twitter is a two-way street. As with all other social media, marketing is important. In the world of social media, I have this blog. I have a Facebook account with many friends. I have a LinkedIn account with many connections. I have Google+ and a Pinterest account. I used to be active on a few forums. I even had a mySpace account. Of all of these, I regard Twitter as my primary and most premium e-presence.

Why? Chicago's own Ides of March really expressed it well: it's my vehicle. More precisely, it's my e-vehicle: it puts my name where I want it to be on the internet. I don't remember exactly how the old truism about publicity went, but it was something like this: "Any publicity is better than no publicity." This is largely (but not entirely) true for someone who is trying to find a job or build a reputation on the internet: almost 100% of the time, any internet presence is better than none. If you're looking for  job, you should have an established social media presence, and probably on at least LinkedIn and Twitter- and it had better damn well be squeaky clean. Please make no mistake: I very seldom (that is, exceedingly rarely) use a word such as "damn" online- and this is HIGHLY intentional. Any reputable firm will probably be have at least a concern about online vulgarity or profanity.

But I digress... back to me and Twitter. I have more than one Twitter account- I don't think this is unusual: one is fairly general, and the other is pretty tightly subject focused. I really don't do too much on my "general" account, and I have no special reason for the lack of activity there. My primary account, though, currently has a few hundred followers, and I follow a few more. What's interesting about this account, though, is my relative level of education to that of my followers. Here's where the ride gets interesting, so buckle up, kiddos!

The subject matter that I generally tweet about is Big Data, Internet of Things, Programming and, to a lesser extent, Technology (Computer, Electronic and Otherwise). I researched this a bit- probably at least thirty minutes on Google (this is the equivalent of 1.21 eternities in Internet time) and could not come up with a definitive answer. However, I know that I have no fewer than five PhD's and one PhD candidate in a population of ~225 followers, which means that ~2% of my FOLLOWERS have doctoral degrees. As best as I could tell through my "extensive" research, approximately 1% of ALL college students in the United States of America complete a doctorate. So as far as my followers are concerned, I think I'm pretty top-heavy in the academic department, even though I'm a card-carrying member of the unwashed masses that check the "some college completed" box.

In fact, in some circles I may even be classified as a "savant".

In any event, I'm going to leave "this" alone for now. When (and/or if) I gain further insights, I will continue this train of thought.

Until then, I am hochspeyer, blogging data analysis and management so you don't have to.

A Tale of Two Databases

Every so often I have both the opportunity and inspiration to write. I've been quick to lament virtually all summer that I haven't had much time for anything except for work. I've also mentioned that it's not the end of the world, as I do get overtime pay these days. Still, a part of me laments the lack of balance... I had copied a number of photo folders the other night, and was quite honestly shocked to see the date stamps of my last two folders from my camera. The first was dated  July 6, 2014, and the latter was dated September 22, 2014. In other words, ~2.5 months where I did next to nothing with my DSLR. I made up for it a bit this past Sunday, but photography is something I'm fairly passionate about, so I should be doing more- like getting into Lightroom and Elements, and trying to get some of my work published as photostock. In any case, I'm quietly working to get some balance back.

I hope the photos I've shared over the past few blogs were enjoyed. Tinka and Schwarz have been seen in China, Germany and the U.S. as of this writing. I think they're both on Pinterest as well. As far as I can tell, neither is impressed.

Besides the cats, I've published a few photos of the local flora. Still, this blog is about my adventures in the wonderful world of data- my data, to be precise. I've been doing a bit of work in the Media_Title table. This table currently has 950 records, and what I've been doing recently is updating the Media_listed_as column. Quite honestly, this column doesn't do much right now, and partially duplicates data on another table (but not really), as this column and the Format column from the Media table both pull data from the Format table. What I can do in the future, however, is query against the Media_Title table and find out specific information about movies- specifically, I can see all of the media which is associated with the a title, such as a movie, soundtrack, game or book. The other table, Media, lists the boring details associated with each piece of media- UPC, ISBN, publisher, format, etc.

I had a bit of a watershed moment at work last night... a pretty "watered down" watershed- if that is possible. Maybe an epiphany is a more appropriate description; perhaps in the end it was just an "A-HA" moment. Here's what happened.

Thursday nights at my office are the busiest time of the week for my fellow Nightstalkers and yours truly. I pulled into the parking lot and had to flash Meerkat's headlamps before Anna recognized me. She was all smiles and said, "You have to read your email- we have a new supervisor." We exchanged a few more words, and then she was off to her home and I was off to the double-wide in the sky (E-Man's quaint nickname our office). I climbed the nineteen stairs, swiped my badge, and I was back in action. Not surprisingly, the data for the big job was not yet in, so I grabbed another job and checked email. I found out who the new supervisor was and fired off a quick congratulatory note, and then dove into my job. As it was a variant of one I had tackled on Wednesday, it took relatively little time to complete, as I didn't need to keep on referring back to instructions. I signed off on it, and checked email again. I generally get between 50-100 or more emails per day, and I am happy to report that as of 0630, I have a Zero Inbox: absolutely NOTHING in my inbox- everything has either been relegated to folders or deleted. Nice. While I was waiting for the evening's main event to commence, I decided to open up the database. This database is very much a work in progress, and I am only in the beginning stages with three tables. At this juncture, I don't foresee too many other tables being added, primarily because the primary reason for this database is to be a quick and dirty way of getting some basic information about previous jobs related to what someone is currently working on. Last night's "A-HA" involved a simpler and more comprehensive way of finding and classifying jobs.

Two databases. One post. Excellent.

As always, I am hochspeyer, blogging data analysis and management so you don't have to.