Thursday, October 9, 2008

IT as a companion to business process flow...

Typical an organization will have many business processes one for each purpose. Some of the main process are sourcing, customer relation management, finance, human resource management etc. Most of the ERPs provide these functionalities as a part of them. Not all vendors are good in all the processes. Some are leaders in some process. For example Oracle is good in CRM, Hyperion is good in Finance Planning etc. Apart from these processes, there are processes in most of the Organizations, that can be automated. It is for this reason we see many custom Java based applications that cater to each of these processes. All business processes follow a certain order. At every point there should be an application that caters to that business process. This application can be a ERP module or custom Java application. Such a seam less solution will allow the company to capture information at each point and leverage the data.

Once we have data in applications, it can be transferred from it to a data warehouse using standard ETL tools. A reporting layer on top of the Data Warehouse can allow users to see trends. For example a report on customer-related-data from a CRM, will show the customer trend. Reports can be a set of standard corporate reports available for all users or adhoc reports of each user. Value of information will reduce with time. To have more valuable information, Data Warehouse needs to be refreshed more frequently.

Tuesday, October 7, 2008

Man is the best imitator:

The reason for Man being the best imitator could be biological. This imitation determines the way world goes. When we're born, our mind is like a blank hard disk. As we grow we see, listen and experience many things. These form impressions in our mind which will influence  our reactions and decisions. Hence our personality is a sum total of all the conditions in which we're brought up.
As we grow, our elders teach us how to do things. Their elders taught the same to them. This is how how-to-do-procedure is passed on from one generation to another generation. If somebody tries to do things in a way different from the traditionally accepted way, they are criticized and their ideas are met with skepticism. And some doomsayers predict the end of the world. This is one major reason that prevents innovative thinking.

Wednesday, October 1, 2008

Business Intelligence... the life saviour

London Fire Brigade, the UK's largest fire brigade uses BI Solution for identifying potential spots, making decisions in allocating and deploying resources. This way it has reduced the number of Fire incidents. And hence reduced the number of causalities.

Fall of financial giants has put the world markets into a tail spin. This has caused a stress on minds of investors. They may not be aware of this. Research says this kind stress can actually shorten lifespan of a human being. Some experts opined that the crisis and its aftermath would have been avoided had there been a sound BI solution in place. Which means a better life for investors. A sound BI solution will guarantee better future for a company. Better future of the company will ensure better future for its employees. It is good that, of late, companies started realizing it.

Tuesday, September 30, 2008

SaaS in Business Intelligence...

SaaS... Software as a Service. The moment we say this, the name that strikes everyone's mind is Salesforce.com. It has revolutionized the way solutions delivered to customer. It provides the necessary hardware and support of hardware. All a customer needs to do is pay for the volume of resources used. This will take the responsibility of maintaining the hardware and human resources for maintaining it and instead the customer can concentrate on his core business process. The same rational has fuelled outsourcing as well. Salesforce.com's services are mainly related to the field of CRM.
Of late importance and potential of BI is recognized increasingly. We see BI is used in many fields which we never thought will. For example, Police department is using it in observing the trend in crimes. Experts feel that had all all big financial institutions in US (Lehman Brothers, Merill Lynch, America International Group etc.) used a proper BI solution, they wouldn't have landed in the current quagmire. In the current scenario, an organization needs to set up its own infrastructure its users' needs. It would be a dream come true for many business users if BI is delivered as a service. We see that there a paradigm shift is happening. Tools like Cognos are now delivering reports over Web.
Ideally a Bi solution should be user friendly. It should very easy to navigate and should be less complex in filtering and getting required data. In general, people are more comfortable in using portals. It would be good if we can have a BI solution that is delivered through portals. Such a solution will truly empower the frontend sales folks and help them in making judicious decision, which will bring in lots or returns for the investment by a company.

Monday, September 29, 2008

Custom BI solution vs Package solution:

These days there is a lot of talk about use of package solution like Jaros as a BI solution. This will save lots of effort needed in the analysis and design phase. Jaros provides BI solution on top of Oracle ERP. It uses the metadata of Oracle ERP in creating the metadata for ETL. Currently it supports 14 modules in ERP. Normally, a big organization will have lot of customization on ERP. This requires good deal of efforts in customizing the package to business. Jaros is not a feasible solution that use more than 14 supported modules and also for large ERPs with heavy customization.
When we develop a BI solution we will have the liberty to choose the ingredients of our BI solution. We can have the state-of-the-art tools in each phase of the Data Warehousing. Every problem in this world is unique. Each requires a unique way of addressing it. Ideally it suggested to deal it specifically rather than generalizing it and using a general solution available in the market.

Proper Project Management:

Research shows that about 47- 49 % projects are over run either in terms of schedule or budget. This could be because of various reasons like dependency on an external events, occurrence of unforeseen events. Good delivery of project needs competency in many areas. Technical competency is the foremost. Other paraphernalia like preparing project plan and updating it at regular intervals and Communicating effectively among the team and to customer are necessary.

There are many technically competent people who are bad in communication. These people did not feel the necessity of effective communication. Proper communication is necessary in a project. Messages we communicate will provoke feelings and these feeling influence the reaction and decision of the other party.
Every Project will have dependency on external forces. These forces are out of our control. So we should give proper lead time while making our project plan. We should be more watchful as the planned date approaches. Proper alerts should be raised if any delay is suspected. customer should be notified and alternate arrangements should be made.

Team motto should be placed above personal motives. Lots of times, we see that a person with lesser experience will leading a person with grater experience. In such case, if the manager fails to win the confidence of his/her subordinate chances are good that team members do not show commitment. Commitment should start from the manager. So is the manager, so be a team member. I read a sentence about importance of employee management. Quoted here for your quick reading.
"Employee and management stress costs companies billions of dollars annually through increased absenteeism, lack of enthusiasm for the job, and poor performance. According to several industry surveys, the following factors cause the most stress in the workplace: unclear policies and direction, failure to show appreciation, lack of communication, and lack of control."

Proper project management is a vast subject. However i tried to give a bird’s eye view of it.

Saturday, September 27, 2008

How to contain inflation?

Inflation is a common phenomenon experienced by every country in the world. This phenomenon is acceptable as long it is there in the limits. When it grows beyond the limits, it has serious implications on many things. Particularly millions of common people in developing countries are effected. Governments round the world should take proper measures to prevent this evil force from rising its ugly head.

Inflation in India is currently hovering around 12.5 %. Many times Government of India in unison with Reserve Bank of India has taken many measure to contain this. Even then, unfortunately it is growing. There are two types of indices in India used to measure inflation. They are Consumer Price Index (CPI) and wholesale Price Index (WPI).

Growth in inflation is attributed to availability of excess credit in the market. Government was under the impression that if the excess credit is removed from the market, Inflation will be contained. Increase of Reverse-Repo rate is one such measure to remove excess credit from the market (For definition of Reverse Repo rate, go to comments). There are many instances where RBI has increased this Reverse-Repo rate during its periodic review. In the name of this, every bank has increased the interest rates on the money lent by them. As a result of this, one thing that has happened for sure is the EMI of the loans (particularly housing loans) has increased by 50 to 70 %. Inflation continued to rise. Does this mean that government does not know the root cause for inflation? or the quantum of increase in Reverse-Repo rate is not sufficient to contain inflation?