Tuesday, May 24, 2011

Project Management of Business Intelligence

If you are looking for higher relative efficient projects of Business Intelligence then your energy and focus needs to comply with customer needs. To succeed in a Business Intelligence, term more modern, we better to have excellent business discovery phase or initial project in order to list the requirements of business analysis. It is also important to know about market segment for specific companies and balanced allocation of resources.

The knowledge of the team about phases and correct methodology collaborates to succeed in projects like that. This profile of Business Intelligence Project Manager is very important. The strategic of a lot of companies points to increase sales in this area of business.

The integration between customer side people and consultants should provide profound visions of the big picture in terms of architecture and connectivity. Please look the phases below:
a. Business discovery;
b. Data modeling (logical and physical);
c. Database parameterization of data warehouse, also sizing;
d. Connectivity across servers (database and OLAP);
e. ETL – Extraction, Transformation, and Load activities;

f. Security setup;
g. Development of reports and other objects;
h. Training of end users across business area.

Of course, we can go through other tasks and different names. It is depends of the project. But if you have someone with whole process in mind it will help a lot when going through execution. Under customer perception the confident communication supports the project. This confidence can make the project robustness, avoiding worries about time and cost forecast.

Tree profiles are vital in the execution these kind of projects. A data modeler of multidimensional schema (star, snowflake, and hybrid), also cube generation knowledge is required. The second one needs to know how the database works transforming un-integrated data into a data warehouse with historic and integrated data. Performance is required to be always on the table for people working in the Business Intelligence projects. The last one is a professional with skills to talk with customers, understand their needs, and supplies outputs that comply with the requirements. Simplified reports that fit those needs of decision making are an advantage. Maybe a professional with an MBA plus Computer Science degree will occupy this position with energy and focus.

Regular Trainings and academic are more important than websites due the biased content. However, I recommend some ones for Business Intelligence projects, please find below:

http://www.bi-verdict.com/fileadmin/dl_temp/5d57d42da6d781c96b949ac0b4e3edeb/market.htm

(Website from Germany)

Note: Hyperion and Cognos above of some tools and below Microsoft. Microsoft is the product supplier competitor to be beat in the Business Intelligence and Data Warehouse marketplace. However, time only until 2007. Accessed: 05/23/2011

http://imagesrv.gartner.com/pv_obj_cache/pv_obj_id_623AFBB90F102914DBED494D8651B4EA70790A00/filename/article4.pdf

(Website from USA)

Note: The Magic Quadrant of Gartner helps in identify who is able to implement solutions of Business Intelligence from now to the future in the corporations. Services of Business Intelligence are very important. Products of databases, ETL – Extraction Transformation and Load, and OLAP – On-line Analytical Processing reports are facilities for people working. Accessed: 05/23/2011

I mean choose the right professionals and consultancy company to develop your data warehouse and OLAP visions are more important than buy products. The tools are crucial point of BA project success since the project team develops business requirements with performance for end-users and integrated databases (data warehouses, cubes, and data marts).

No references today. Only some experience about Business Intelligence.

.

No comments:

Post a Comment