Wednesday, May 14, 2014

SAS Global Forum Interview/Video

I forgot I was interviewed at SAS Global Forum back in April, I think the video came out pretty good, I stumbled a little bit and sad "you know?" a bunch of times (20?), but it's not too shabby for a data geek...

"Good Data, Smarter Travel
Charged with keeping track of travel assets, including employees, iJET International relies on data management best-practices and advanced analytics to keep its clients in the know on current and potential world events affecting travel, Rich Murnane, Director of Enterprise Data Operations & Data Architect, told All Analytics in an interview from the 2014 SAS Global Forum Executive Conference."

Until next time...Rich

Wednesday, February 19, 2014

DataGeek & RegEx Expressions...

DataGeek's not quite as smart as he likes to think he is....

Until next time...Rich

Tuesday, January 14, 2014

DataGeek & "That's Cute" #2...

DataGeek's is super excited about the "Internet of Things", but let's call a spade a spade, Google's purchase of Nest is really all about Google getting a footprint into your home!

Until next time...Rich

Related Post: "DataGeek & Refrigerator Data...", click here...

DataGeek & "That's Cute" #1...

DataGeek's is all about getting stuff done, and Microsoft Access is a great "single user" database environment, but do you really want to run your business on it?

Until next time...Rich

Monday, December 30, 2013

My "2013 Meh List" - Well, Sort Of...

I started off making a "2013 Meh List" (ala NY Times - Not hot. Not not. Just meh.), but it quickly turned into a list of things from 2013 which I'd like to forget about, and then some...

The things from 2013 I'd like to forget about...
  • The US Government: mining "our" data & metadata (all of it), contractors going "rogue",, shutdowns, sequestrations, and budgets
  • Organizations ignoring their data - data quality and billing issues are sooo 2012, figure it out already...
  • The lackluster response of corporations to data breaches and data privacy concerns
  • Microsoft asking us to "be brave", Windoz 8, and Ballmer's Retirement
    (Microsoft was kind of "meh" for me this year)
  • The Yahoo! mail upgrade was possibly the most annoying software upgrade in my entire life...
  • Blackberry continuing to fail
  • Airline fees and the overall lack of consumer advocates for continually feeling like every company is "nickel and diming" us to death
  • Celebrities misbehaving, people twerking, and people doing the Harlem Shake...
  • Whatever the fox is saying!!!

    It wouldn't be cool just to vent, so here are some things I did like about 2013...
  • Increased visibility for data management in organizations (Chief Data Officers, Data Scientists, etc.)
  • Data Visualization and Infographics (I'm obsessed with these two things lately)
  • "Feel good" stories like the San Francisco "BatKid"
  • The fact that someone figured out that the 2013 Country Music all the same
  • Electric cars with style, like the Tesla
  • Oracle won the America's Cup, but otherwise they were a bit "meh", right?

    Some things to watch out for in 2014...
  • Data, data, and more data (I WILL NOT INCLUDE THE "Grandes Datos" TERM IN THIS POST ONCE!!!)
  • BitCoin
  • Amazon: it's products, and leading position in the "cloud", but the delivery drones are kind of "meh" to me right now
  • Companies going global, it's a must-do for 2014 and certainly includes "cloud" technologies. Imagine small to midsize companies having zero IT footprint (BYODevice, BYOLaptop, etc.), is it possible?
  • "Internet Of Things" gaining traction
  • Someone figuring out how Google Glass (or "similar" devices such as "iWatches" and sensor devices) might add significant value to us normal people, every single day
  • Technology in education (A laptop or tablet for every student!)
  • Open Data, leveraging it and publishing your own

    And last but not least, here are a couple things I'm hopeful for in 2014...
  • I'm hopeful that a few more people like Nate Silver pop up and make some positive/exciting advancements in data and statistics. Silver significantly raised the visibility for "doing cool stuff" with data in the last US presidential election, I'm hoping some other folks can do something similar in different domains.
  • I'm very much hopeful for some organization to step up and become an advocate for personal data privacy and data security. Here in the US we have a federal government organization (the FDA) who are supposed to be ensuring the food and drugs we are sold are safe. We also have the non-government groups who are watchdogs for other types of things. I can't help but think we need someone out there helping us watch our digital backsides (data privacy and security), and the scope/reach has to be global, it can't be "just another US federal organization".

    All this said and done, I wish you a "Happy New Year" and continued success in 2014.

    Until next time...Rich

  • Tuesday, December 17, 2013

    And We'll Never Be Royals...

    In the comments section of the YouTube video of Royals, Ella Yelich-O'Connor (a.k.a. Lorde) writes:
    "...a lot of people think teenagers live in this world like 'Skins' every weekend or whatever, but truth is, half the time we aren't doing anything cooler than playing with lighters, or waiting at some $#!**^ train stop...".
    As of late there are a lot of people out there who are beginning to think being a data management professional (a.k.a. DataGeek) is somewhat glamorous. While some Data Scientists are getting called sexy, I've got to tell you, most of us in the data trenches aren't too worried about the sexy, we're just doing what we do and doing it right. So, what are we doing more than "half the time" (we...just...plain...don'

    We're doing things like:
  • answering questions, teaching, and mentoring people about data
  • speaking with internal and external clients about our data
  • requirements gathering and analysis, data architecture, data modeling, and database development
  • database administration tasks such as making sure the databases are safe, secure, performing well, and are generally in a healthy state
  • working and collaborating with product people, project managers, software developers, etc...
  • operational data quality tasks including data cleanups, data profiling, and data monitoring
  • data governance tasks such as determining and negotiating policies for our data
  • data and database change management
  • planning for new data to support our business missions, determining the best sources of data to meet the mission objectives and then acquiring the data
  • data loading, which I generically call "ETL"
  • drawing pictures on whiteboards and in tools like Visio, ERWin, and XMind
  • attending lots of meetings and doing a lot of internal and external marketing
  • doing data analysis, creating reports and data visualizations, which can sometimes be a little bit sexy
  • thinking about the future and all the sexy stuff which could be...

    So, no days of "jet planes, islands, tigers on a gold leash". I can't say for sure "we aren't caught up in that love affair...", but just like the teenagers that Lorde is singing about, there's no doubt that we're still going to show up and do our thing every day, sexy or not.

    Until next time...Rich
  • Thursday, November 07, 2013

    From the archives: The Most Interesting DataGeek With Illustrations...

    I had to go and figure out a way to save all my old DataGeek illustrations today and while digging around I found some which were never published.

    Until next time...Rich

    He is...
    The Most Interesting DataGeek...

    He once had some bad data in his database, just to see how it feels...

    He once punched his #DBA in the nose, and the DBA apologized...

    His data tells him when something is wrong, and also apologizes...

    His data smells like cologne...

    If he were to send an email without recipients, it would still go to the right people...

    He's been known to cure #DataGovernance politics, just by walking into the room...

    His organ donation card also includes his #SQL skills...

    He can speak Oracle, in DB2...

    His data is expanding faster than the universe...

    His indexes ask him if they should perform faster...

    His thoughts on #MongoDB... "No"...

    He'll talk about data to senior executives and they will ask for an encore...

    He is, the most interesting data geek in the world... He doesn't always make data cry out in happiness, but when he does, he does it at the keyboard... #MostInterestingDataGeek #DataGeek

    Thursday, May 09, 2013

    It's Five O'Clock Somewhere...

    Is it Friday Five O'Clock Yet???

    Here's a little way you can do a countdown to Friday Five O'Clock using a simple little Oracle PL/SQL function and query.


    Until next time...Rich

    CREATE OR REPLACE FUNCTION fx_elapsed_string(
        p_start                 DATE,
        p_end                   DATE)
        lv_big                  DATE;
        lv_small                DATE;
        lv_string               VARCHAR2(120);
        IF      p_start > p_end
        THEN    lv_big := p_start;
                lv_small := p_end;
        ELSE    lv_big := p_end;
                lv_small := p_start;
        END IF;
        SELECT (extract(day from ((lv_big - lv_small) day to second))*24) +
               extract(hour from ((lv_big - lv_small) day to second))||':'||
               extract(minute from ((lv_big - lv_small) day to second)), -2)
              extract(second from ((sysdate - lv_small) day to second)), -2)
        INTO    lv_string
        FROM DUAL;
        RETURN lv_string;
    WHEN others THEN RAISE;
    show errors
    SQL> SELECT fx_elapsed_string(sysdate,  
           trunc(NEXT_DAY(SYSDATE, 'FRI')) + 17/24) "HH:MM:SS until Friday 5pm"
         FROM DUAL;
    HH:MM:SS until Friday 5pm

    Note: This assumes your database server is in your same timezone!!!