BI Data Analytics

This Post contains quick tips for various tools used in Project work. Database:  DB: Oracle 11g How to Extract Year from Time Stamp: Select   extract(YEAR FROM A.DW_CRTE_TS) from  table  A How to Extract year of previous day from Time Stamp: Select   EXTRACT( YEAR FROM A.DW_CRTE_TS -1) from  Table A Note: The page will be updated for more tips based to help in BI implementation and Data Analysis

As number of product increases and provide features almost same but doing things differently, other than cost one critical question comes is skill set. Most of the time you would need to train your employees to work on it as hiring specialist may be costly and short term affair.  One thing I would think, organization or company should start looking is which type of people they have more (Left Brain Vs Right Brain). As top executive, you would need to see if a tool fits in mind set of people who would actually work on it. If a tool is associative ( Example), analysis requires people to be Right Brain oriented whereas if tool is based on relational or require programming, people using it for analysis should be Left Brain and you would see immediately difference. Either people can be trained or hired based on which way company decides to go in terms of tool selection.