Sunday, July 24, 2016

Professional email addresses... and other terminally flawed data

I'm sorry. That's a pretty bloody lame title. And I'll also forgive you if you didn't read my previous post on this subject... which had such a clever title that I can't find it either!

Every so often, though, I read something that makes me wonder: why did the writer go into business at all?

Last week we received a flyer from a realtor whom I'll call "John Doe". John obviously is pretty good at selling homes- after all, he's been in business for over 10 years with the same firm in the same office (we'll say he works for "Acme"). So, with a proven track record of solid business acumen and a professionally written and laid out color flyer, why would I do business with him?

I wouldn't. Why? He's got a winning smile, a good track record, and a really nice flyer.

Why? Because of his amateur, second-string personal email address- johndoe477@hotmail.com.

R U pulling my leg?

I'm sorry, but this is one of those things that just get me going. This IS the 21st Century, after all. And unless you're the only game in town, I'm not going to contact someone who has a throwaway email address- that's no way to run a business. So, my advice to the SOHO and SMB readers who may see this is this: get a domain that has your name in it. Give everyone in the firm a standardized email address, like john.doe@acme.com or jane.doe@acme.com. If your web presence is lame or nonexistent, hire a designer. Trust me on the website- believe it or not, I have "webmaster" in my list of credentials.

(Pause for effect)

Most readers will not know me personally, but on my best of days, I have trouble even spelling HTML. I'm kidding, of course. Just a bit. For example, if I see the tag <!DOCTYPE html> at the top of a page, I know I'm looking at an HTML 5 page. I also know how to recognize and change colors, as well as edit text and import or delete images. I told you that so I could tell you this: don't hire me or anyone like me to manage your online presence. There are pros out there who will do it better and for a fair price. If your business is your livelihood, you owe it to yourself.

But please do it.

Speaking of addresses, data and names, I'd like to share one more pet peeve. I don't consider pride to be a major fault of mine, but when it comes to business, please take the time to spell my name correctly... and get the city I live in right. The city I live in is a suburb of Chicago, with a population of approximately 60,000. It has three ZIP codes, one of which is shared by a village that is 1/15 our size and is strongly mob connected. I cannot tell you how INSULTING it is to get a piece of mail addressed to me, with the proper ZIP code and +4, but with that other village's name on it. Mail like this goes DIRECTLY to the garbage.

I work in an industry very closely associated with direct mail; most of our business is from folks doing direct mail. Every day, I look at mail data, and am constantly reminded of the old programming axiom GIGO (garbage in, garbage out). However, from a personal perspective, I tend to scrutinize the mail we receive at home... and Jennifer has also taken an interest in it. The USPS (United States Postal Service) depends on direct mail, but does not often see fit to enforce its own regulations. I see so much direct mail that is so out of spec that it really IS junk mail, and yet the USPS just accepts the money for the postage rather than enforcing its regulations.

That's not my beef, though.

Even though we live in a 24*7 world, take the time to get stuff right. Get the easy (data) stuff right- for example, it's spelled Coeur D'Alene. not Coeur Dalene. It's not <frigging> rocket science, folks. Then, when you get the easy stuff right, spell my name correctly- at least get my gender right! My name is a little long, and in an address block is often truncated. How about just truncating it to a standard, shortened (nickname?) name rather than just arbitrarily chopping letters off?

Okay, I'm putting the soapbox away now.

Data: 42 (my personal database project) is inching along. I got some data entry done over the last week, and did a few table upgrades. I think I'm currently up to seven complete CD entries, and quite honestly the last one was a bear!

I'm not a huge Elvis Presley fan, but I picked up a SEALED copy of his 30 #1 Hits CD from our local Goodwill store a few months ago for a buck (1USD). When I first built the table for CDs, I had included seventeen track titles. I knew I'd need more, as classical music tends to have LOTS of tracks. The Elvis CD, though, has thirty tracks, so I added thirteen tracks to the table, only to realize that there is one unnumbered track at the end! In unrelated database news, I added 885 pieces to my Lego collection, courtesy of the Amazon Prime sale on the 12th. As I was thinking about Lego and the database, I decided to only include Lego part numbers for parts that I actually possess.

That's it for now, fellow datacampers. As always, I am hochspeyer, blogging data analysis and management so you don't have to.

Wednesday, July 13, 2016

Big Data, Small Data, and 42 Data

Its been a bit since I've written, so a quick update is in order.

Work had not been particularly busy as of late; my reason for the delay in writing has more to do with software than anything else. I finally had the opportunity to upgrade my laptop to Microsoft Office Pro 2010 from 2007, which has been on my to-do list ever since the hard drive replacement a while back. With the installation of 2010, I've FINALLY gotten back to working on the database.

I seem to be unable to stop referring to von Moltke the Elder, and I'm not stopping now. I found an older, saved version of the database, and decided it was not usable, so I'm starting afresh (again!) with Forty-Two, with a much-improved (I hope!) design.

Before I got too deep into this database, I thought I'd do a bit of web scraping and see if I could find a "music template" for an Access database. After a fair amount of searching, I discovered that Access templates- generally speaking- do not exist... at least not in the same league as Excel or Word templates. The best explanation that I've found for this was on an Access board, and I paraphrase here: "Access is pretty much a sandbox developer's environment. You won't find many templates. Period."

So, I'm back to doing it the way I've always done it: making it up as I go. Well, LEARNING as I go.

I suppose I should take this opportunity to make once of my periodic disclaimers: I'm not an expert, but I have a deep interest in Big Data, the Internet of Things (sometimes referred to as the Internet of Everything), data analysis, databases, STEM and the Maker Movement. Okay, back to our regularly scheduled program.

Some time ago- not long after I'd discovered the joy of caring for and feeding databases- I ran into a statement which I thought was a bit curious. It was about database design, and the author stated that the best way to design a database is with pencil and paper. I eventually understood his premise and agreed with him up to a point. My personal perspective is that this can be a great starting point, especially if you're completely new to databases, are looking at a completely new database, or if you're designing with a certain goal in mind. I've built small databases, for example, that were for crunching data in a small project (<200 data points) of mostly text. I've used existing databases and added my own queries to provide quality and efficiency reports for ISO 9001:2008 (at least, I THINK that's the spec!). There have been others as well, but my project....

Let me introduce (or reintroduce) everyone to my pet project, Forty-Two. It's called that quite simply because its ultimate function will be to answer the question, "What is the meaning of Life, the Universe and Everything?", which, for those who who are not immersed in in-print memes, is a reference to Douglas Adams' "The Hitchikers' Guide to the Galaxy".  And this was before I had even heard of Python, and Guido van Rossum's homage to Monty Python's Flying Circus. This is THE truth that I have found: I.T. and literature are strange bedfellows.

So here I sit writing about the database.

Once again back to von Moltke: the best plan can fail. Vis à vis my database. I had a grand thought for normalization: make a names table.The names table is as simple as it sounds: first name, middle name or last name- all are contained in one table.  The problem with this theory reared its ugly head almost immediately: music groups do not fit this model. So, there is a new- unplanned  table: music groups. Although the individual members of said groups may be part of the database at some shining point in the future, for now there is a groups table that just lists the names of groups- its the only way to make soundtracks and other compilations work.

That's it for now- I want to publish this entry.

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

.

Saturday, July 2, 2016

Music from The Boss- digital and otherwise

Just when you think you had something figured out, the economy throws you a curve ball.

Case in point: music. Specifically, digital music.

Like many folks of my generation, I have music on cassette or LP that I do not have a digital copy of. This leaves me a few options. I can try to find it on the resale market, or I can bite the bullet and purchase a digital copy.

I've gotten lucky on the resale market occasionally. However, when I'm in search of a specific album, I often hit the digital catalogs. Case in point:

Darkness On The Edge Of Town, by Bruce Springsteen.

I once had a manager (at Schaak Electronics, in the Brickyard Mall in Chicago) named Mike who was a HYUGE fan of The Boss.  Me... not so much. I've never been much of a fan of celebrities who espouse causes, and Bruce happens to be one of those. But... the guy has made some great music. Darkness On The Edge Of Town and Born To Run are probably his best albums (IMHO), and they deserve a place in any rock music collection. Born To Run is probably the "better", more "hit-worthy" of the two, but Darkness has an honest, less polished, raw quality, which is surprising as it came out after Born To Run. However, I digress.

I had some money in my Google Play account and I thought this would be a good thing to use it on. For $8.99 (USD) I could buy the MP3 from Google, or $9.99 from Amazon. However...

For $6.99, I could get the CD from Amazon, and because I have a Prime membership, I got the MP3 version for free. Born To Run cost me a bit more, and did not have the download option, but I'm pretty much set as far as classic Bruce Springsteen essentials go.

When I'm not buying music on Amazon or Google Play, I like to visit our local Goodwill store. Its a fantastic place to fill holes in one's music collection, if you don't mind wading through absolute chaos- a CD typically sells for a dollar.

That's all for now. To all of my readers in the U.S.A., have a happy and safe 4th. I hope to do some data entry and database work this weekend- with any luck, I should have some speeds and feeds to report soon!

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


Zombies!

Well, you should have expected this one.

After three and a half years, I finally have an excuse to go somewhat all-out "geek-pop" and be the geek writer society thinks I should be and talk geek pop culture topics. I need to start out by clarifying a meme I just referenced, and that is the "What (fill-in-the-blank) thinks I do" meme-



There are a ton of these out there, and some of them are so spot on they could almost be classified as infographs. This one is one of those. I've chosen this particular topic, however, because of a conversation that Mr. T and I had recently on our way to our local Shop And Save.

WARNING: GEEKINESS IS ABOUT TO ENSUE.

So, we got into Meerkat, our trusty Subaru Outback, and headed off on our short journey. We had barely gotten to the first stop sign when Mr. T announced that he had been mulling a fairly original concept (reinvention or tangent, perhaps) for a video game. He had a working title, Initial Z. Now, if this reminds anyone of a 1990's manga or anime, it should. Parody runs strong in our family. In Mr. T's reimagining of Initial D, the player is still a drift racer in the 90's, but you're pretty much drifting for your life, as you need to take out zombies with your car while racing. I found the concept interesting and suggested an even wilder variant: Initial B, in which a cloning experiment in Raccoon City goes awry, and as a result, a massive army of clones of a certain youthful Canadian pop entertainer becomes infected with the t virus, turning them into zombies which must be destroyed.  His next idea was for a 1950's-era zombie game. We agreed that it would need to be monochrome and have a cheesy 1950's monaural soundtrack, complete with hisses and pops. There were several other ideas put on the table, but they strayed off into the completely ridiculous, and do not bear repeating.

Although I don't have a deadline as a blogger, I do realize that more posts == more readers. My experience tells me that a post every 5-7 days leads to increased readership. However, that is a schedule which I'll more than likely never keep. After all, I am an artiste! At least, I tell myself I am.

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