The IT Department Is Dead. Long Live the IT Department | Marcus Wohlsen

it-is-dead-660x508

Libin says there’s an even better way to keep employees happy: Give them the freedom to use the software they actually like. This, of course, flies in the face of the stereotypical IT department, which take a top-down approach that tends to forbid any unapproved gadget or app. Their knee-jerk response to any request is likely to be “no.” Libin wants to get them to “yes.”

That’s Paul Libin, Evernote’s CEO. And of course he’s all in favor of modifying the traditional functions of IT Departments. The more people use their preferred apps (*cough* Evernote?), the better. BYO App, anyone?

Nevertheless, I totally agree with this idea:

Instead of focusing on cutting costs and keeping their servers and networks secure, they argue, IT departments will act more as curators, providing tools that will make their workers happier, which translates to more productivity.

Continue reading The IT Department Is Dead. Long Live the IT Department

 

Johnny Cash’s Perfect, Semi-efficient To-do List

3021379-inline-johnny-cashs-perfect-to-do-list

 

Simple. Brilliant.

From a very interesting post about the history of to-do lists which also offers a jumpstart on how to begin writing to-dos to organize your life.

 

people > craft

Crucial insight that, based on experience, I totally support:

The person who gets the gig is the person who knows how to hang. Nobody hires you because you’re the best musician.
— Larry Legend.

Be sure to hone your people-skills, because 99% of the time you will need to work with a team and convince people that what you did, is what they wanted you to do.

 

Zoomdata: BI without ETL

zoomdata

This weekend I took a few minutes to test Zoomdata.

And when I say minutes, I literally mean minutes. These guys have done an amazing job to provide a quick mobile-ready demo that you can download as a VM, or as I did, install from an RPM package in a fresh Linux system.

After the install, I added a twitter data source and created the dashboard that you see above, linking it with the built-in demo sales data. With a little more work, you could build a sentiment analysis vs. sales dashboard in under an hour.

I know, I know. I used a pie chart. Don’t use pie charts!

Besides the built-in chart types, Zoomdata includes a “visualization studio“, in which you can import and use another JavaScript library –say, D3js– to create sexier charts. After a few tweaks, I managed to feed my twitter datasource into this bubble chart:

zoombubble

The product uses mongoDB in the back-end and –if I understood correctly– the Zoomdata server periodically stores snapshots of your data sources, painlessly building a sort-of-data-warehouse on the fly. This makes it ideal for building dashboards for trends and historical analyses. All the charts have  sliders at the bottom which allow you to go back in time and in some cases aggregate monthly or yearly data. You can see a sample of this behavior at the demo site.

Zoomdata comes with connectors to Cloudera Impala, JSON, CSV, Google Docs, Twitter and good-ol’ SQL databases. All with the promise of “no ETL”, which I don’t actually believe it’s completely true –I can think about one or two cases at work in which I would really, really, need to merge two datasources with ETL– but given that I was able to create a dashboard from different data sources without any kind of pain, I bet that in many cases you could do the same without a single transformation.

If you work in BI, I encourage you to download one of their pre-packaged VMs and give it a whirl.

 

 

How I fell in love with MongoDB

mongo-db-logo

I just finished the developer and DBA tracks of the two online MongoDB on-line trainings.

The courses are excellent, providing all you need to know to start working as a developer or DBA with MongoDB.

And, uh… they’re free!

I have taken several online courses and seen a lot of tutorials. One thing that always bugs me is the sound quality, or the lack of proper guided explanations, or the luminaries that expect you to know it all (but lack basic communication skills). But this course is really well done. Also, I’ve finally realized that taking a course with actual homework and grading is way better than watching tutorials. As the course progressed, I became super-motivated to finish it with a high score.

Of course, it helps that MongoDB is such a sexy product. Just for having schemaless design in your toolkit is worth learning it. Before this course, I disregarded NoSQL as a bunch of key-store nonsense with one cool application (Hadoop). A fad, probably. Then I started the developer’s course, I created my first MongoDB-backed REST service, then my first replicated shard.

I was so wrong.

MongoDB is perfect for data warehousing but also for the early stage of any software development project. It’s the perfect tool for creating a quick prototype backed by a very powerful database engine that can grow with the final product. If you’re a developer, you will save hours by adopting MongoDB now.

Migrating from SQL to MapReduce with MongoDB –Rick Osborne

Migrating from SQL to MapReduce with MongoDB –Rick Osborne

I’m sure that if I sit down with an Oracle DBA, the guy would probably destroy my assessments with things like “Oracle DB has that since the 80s” or “yeah, but the MongoDB way of doing it is insecure”. But there are workarounds for improving the security and, in practical terms, there are few databases that can offer zero-to-replicated-sharding in under two minutes, as MongoDB does.

I encourage you take one of these courses and try MongoDB in your next Software Development or Business Intelligence project. It’s an opportunity to be up to date with the latest (most hyped and coolest) database technology.

You can find the courses here: http://education.mongodb.com/

A great book on MongoDB: MongoDB: The Definitive Guide

Also:

RDBMS vs. NoSQL: How do you pick?

Infographic: Migrating from SQL to MapReduce with MongoDB