Thursday, November 6, 2014

Dig a Little Deeper

Be sure to separate symptoms of a problem from the problem itself.  This can sometimes be harder than it seems.  Sometimes the problem is a few layers below the surface.  For example, assume you get the following issue reports and feature requests:
1.     Please add a button to all list screens to export data to Excel.
2.     Whenever running a query that returns a lot of data (e.g. 10K rows) the list screens take a long time to return.
3.     We’d like to be able to run very basic (read-only) queries by linking to some tables through MS Access.  But in order to do that we need an Oracle client installed on our machine.  We also need a username/password for the database.
4.     Please add “week ending” and “month” to the return fields for all list screens.
On the surface these seem like simple, disparate problems to be solved.  So you might come up with solutions like this:
1.     “Sure – we can add an export button”.
2.     “Hmmm – we’ll have to look at the query – maybe it can be tuned.”
3.     “A little unorthodox.  We’ll have to get approval from IT management that this is ok but this is not technically challenging”.
4.     “Sure – easy enough”
But if we look a little deeper we can see that these are symptoms of a deeper problem: the users do not have an easy way to perform management reporting and data analysis.  Neither this system nor other systems (e.g. a data warehouse) are addressing these business needs.  Think about it.  Here is a different way of looking at each of the issues:
1.     Adding an export button is fairly harmless but the reason they need it is probably because they are doing analysis in Excel that the system is not helping them with.
2.     There’s no way they’re reading through 10K lines of data line-by-line.  The reason they’re doing this is probably because they’re analyzing the data in ways that the system does not support.
3.     There’s no way they’d be desperate enough to navigate the oddities of our back-end if the system better supported their analytical needs.
4.     Hmmm.  I am guessing they want those fields for time-trend reporting or filtering.  This suggests that they’re doing their analysis off of large report results which is another symptom of the fact that the system does not support their analytical needs.
Whenever possible focus on ideas to treat the problem not the symptoms.  Treating symptoms is ok as a short-term alternative but it is rarely the way to go in the long-term.  To use a medical analogy cough syrup is useful and may effectively treat the symptoms of an infection but antibiotics have the capability to address the root cause.  Dig a little deeper and be sure you get to the underlying problem.


  1. I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
    Best Informatica Training center In Chennai|Informatica training center chennai

    1. I am technology Enthusiast. Your blog is really awesome, attractive and impressive. I like the way you think. it is very useful for Java SE & Java EE Learners. Your article adds best knowledge to our Java Online Training in India. or learn thru Java Online Training in India Students. or learn thru JavaScript Online Training in India. Appreciating the persistence you put into your blog and detailed information you provide. Kindly keep blogging.

  2. too good piece of information, I had come to know about your site from my friend sajid, bangalore,i have read atleast 7 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, informatica mdm training in hyderabad,informatica training in hyderabad

  3. Thank you for sharing this knowledge in a blogpost.Really simple and even more effective and this worked great, very useful tips
    Informatica training in Hyderabad

  4. Wow! In the end I got a webpage from where I be capable of truly get useful information regarding my study and knowledge.

    Informatica Training
    Hadoop Training
    Tableau Training
    Angularjs Training
    SAP Success Factors Training
    Unix Shell Scripting Training

  5. I have been reading out a lot of your articles.
    I will certainly bookmark your Blog.
    Hybris Training

  6. Awesome blog! I gained some knowledge with the help of your blog so, I am suggesting your blog to my friends. Keep updating. Software Testing Training in Chennai | Java Training in Chennai

  7. Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
    Selenium Training in Chennai
    Selenium Training Course in Chennai

  8. Nice post. Very interesting to read. Thank you for Sharing.
    erp software in chennai

  9. This post was quite awesome and interesting to read. Congrats for your work. Thanks a lot for providing this with us. Keep on updating this with us regularly.
    Film editing course in chennai

  10. wow! what a excellent topic "Dig Little Deeper"., Really nice to read. Thank you for share such a new post. Dot Net Training in Chennai | Java Training in Chennai

  11. Awesome Blog, you have provided the right information that will be beneficial to us. Thanks for sharing your valuable Ideas to our vision... Automation Anywhere Training in Chennai | RPA Training Institute in Chennai | UI Path Training Institute in Chennai

  12. Hi Buddy,

    Great post.
    Can’t get any more
    straight forward than this article. Thanks!

    Does informatica metadata manager 10.1.1 support cognos analytics resource version 11.?

    if yes, how to add Cognos analytics resource to current meta data manager.?

    Anyways great write up, your efforts are much appreciated.

  13. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    aws training in Chennai

  14. Hi There,

    You make learning and reading addictive. All eyes fixed on you. Thank you being such a good and trust worthy guide.

    We are working on integration of SFDC (SalesForce CRM) with Exact Target(ET) (SalesForce Marketing Clound) through Informatica PowerCenter 9.5.1.
    But facing below issues:
    1) While importing SalesForce object into PowerCenter : Getting an error "timed out"
    2) How to connect to Exact target from power Center using API (we tested this from Java by passing proxy to webservie but not sure how to pass proxy to webservice in power Center)

    Awesome! Thanks for putting this all in one place. Very useful!

    Many Thanks,

  15. Awesome Blog with Smart Content, really I enjoyed while reading your blog. Thanks for sharing such a nice blog.
    Summer Course Training Institute in Chennai | Summer Course Training Institute in Meenambakkam

  16. Terrific post but I was wanting to know if you could write a title more on this subject? I’d be very grateful if you could elaborate a little bit further. Many thanks!
    Good Vecation classes in Chennai | Best Summer Course in Guindy