SAP BW certification: Tips, advice and skepticism

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT DBMS and data warehousing How to get data/database independence with a three-tier architecture How to select an MPP database: DB2 vs. Teradata What comes first — the data mart or the data warehouse? What are the top database management systems (DBMS)? What is the role of DBMS in RDBMS? Is an Inmon-modeled BI system, like Madison, the future of data warehousing? What are the benefits and disadvantages of a RDBMS? Are there benefits to using both Teradata and a DB2 database? What is the main use of a DBMS and what is the main use of a data warehouse? Tips for evaluating top database management systems and choosing a small DBMS Data warehouse software Greenplum brings data warehousing in the cloud indoors SearchDataManagement.com product directory library In-memory technology promises faster, more flexible BI and data analysis Should you stick with SAP Business Information Warehouse? What is the main use of a DBMS and what is the main use of a data warehouse? Operational BI gets a boost from real-time data loading Definition of operational data store vs. persistent staging area How to choose between the Inmon vs. Kimball approach for data warehouse design IHG swaps out Oracle data warehouse with Teradata's new data warehouse appliance Data warehousing now ready for beginners, according to Gartner rankings

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary data modeling  (SearchDataManagement.com) extract, transform, load  (SearchDataManagement.com) OLAP  (SearchDataManagement.com) tree structure  (SearchDataManagement.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Well, the best way to be able to pass a certification exam is to have been engaged in the practice of whatever it is that you are testing for. For example, to pass the Microsoft Certified DBA exam you should have experience working as a SQL Server database administrator. Same goes for SAP BW. If you have been working with SAP BW then passing the certification exam becomes easier because you have gained on-the-job knowledge and experience that will serve you as you take the test.

I know you asked for help, and I'll give you some in a moment, but I want to use this opportunity to rail against certification for a minute. Before I continue, let me state that certification clearly can be a laudable goal. But the biggest problem with the concept is that passing a test is not really a viable indicator of being able to perform a complex IT job. Some things you just have to learn by doing. I am not saying that certification is useless. Indeed, taking the tests and focusing your subsequent practice and study on those areas where you performed poorly can help you to improve your skills. It is easier to better yourself when you know your areas of weakness. But does anyone really believe that someone passing a formalized test will be as capable as someone with several years of experience on-the-job? Organizations should hire based on past experience that indicates a level of capability. Of course, someone with both experience and certification is better than someone with only one of the two, right?

OK, now for the help part. Keep in mind that certification tests sometimes ask arcane syntax questions that are not really good indicators of skills. Getting the syntax 100% accurate is what manuals and design tools are for. There is no reason to memorize syntax because it tends to change quite often. It is better to know where to find the syntax, parameters, and answers to your questions when you need them -- That is, which manuals and textbooks contain the needed information. That being said, to pass a certification test you will need to have very good knowledge of syntax.

So how should you proceed? Well, start with the online material at sap.com, but do not stop there. Do you know anyone who currently works with SAP BW? Can you get them to let you sit down with them and observe as they do their job? Can you use your current skill levels to help that person in their job? If so, perhaps you can volunteer to work with them on a project to gain some experience.

And make sure you purchase several books on the topic so that you can keep fresh on the subject. Put them by your bedside and read them as you go to sleep. Take one with you on the bus each morning. In other words, immerse yourself in the topic. The more you read, the more you retain. The more you retain, the better you chances of passing a certification exam.

Here are several books that could help you:

• 201 Interview Questions: SAP Business Warehouse Information, by Raj Mani Thiyagarajan and Kevin Wilson
• Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver, by Kevin McDonald, Andreas Wilmsmeier, David C. Dixon and W. H. Inmon
• SAP BW Reporting And Analysis, by Norbert Egger, Jean-Marie R. Fiechter, Jens Rohlf and Jorg Rose
• Modelling and Reporting with SAP BW, by Peter Lehmann, Klaus Freyburger and Andreas Seufert

Best of luck to you in your quest to pass the SAP BW exam.