BW Training Overview
Quite often when I teach a BW course, students ask what the different courses cover. While this information is available on SAP’s training website, http://training.sap.com, I would like to briefly outline the courses.
Which course should I take first?
Typically, the BW305 and BW310 courses are the first course an individual should take. The BW305 course covers the all aspects of the Query Designer as well as execution and navigation of the queries on the BEx Analyzer (Excel with an Add-in) or the BEx Web Analyzer (SAP’s delivered Web Application). You can think of this course as 5 days of getting the data out of the BW Data Warehouse. The BW310 course on the other hand is the first exposure to the Administration side of the BW Data Warehouse. We cover building various InfoProviders such as InfoObjects, InfoCubes, DSO’s, and MultiProviders. Additionally, we cover the Data Flow, typically known as the ETL process. So you can think of this course as 5 days of getting data in to the Data Warehouse.
If your job requires knowing how to create queries, you want the BW305 course. If you are going to be responsible for loading data to BW, you should take the BW310 course. However, if you have the ability to take both courses, it would be very beneficial. No matter your job requirements, it is a good idea to get a well rounded view of both getting the data into and out of the BW Data Warehouse.
Additional BW courses on the Reporting Side
The BW307 course is a new course as of Q4 2011. This is a 2 day course which covers developing sophisticated Web Applications. While the BEx Web Analyzer is a delivered template which can be used to execute BW queries on the Web, some customers prefer to create their own Web Applications. If so, the BW307 course is for you.
If you are using the Business Objects suite of products to present your data, there are various courses you can take as well. To see the offerings for Business Objects, please follow the path at the bottom of this blog.
Additional BW courses on the Administration Side
BW330 – Modeling: In this course we cover the more theoretical nature of how to model the layers of your BW Data Warehouse. Things like: How do I know what characteristics should go in which dimensions? Should I use DSO’s or Cubes to store my transactional data? Should I use display or navigational attributes? Time Dependent attributes vs. not? We also cover all the tables that store the master and transactional data.
BW350 – Acquisition: In this course, we cover the Data Acquisition layer in greater detail. We cover the concept of Deltas for both the InfoPackages and DTP’s. We also cover the Error Handling capabilities on the DTPs, the LO Cockpit, and Enhancing a Business Content DataSource. We also cover the extraction of non-SAP data into the Data Warehouse. In the 7.3 version of the course we have an introduction to utilizing Business Objects Data Services to extract non-SAP data into the Data Warehouse.
BW365 – Security: The ADM940 course, which is the prerequisite to this course covers SAP Security. The BW365 course covers what is unique to SAP BW Security. It covers how to secure who can do what vs. who can “see” what on the reporting side (Analysis Authorizations).
BW370 – Integrated Planning: This course covers Planning within BW using the Integrated Planning Functionality.
Please note all of these courses under the Administration side have a prerequisite of the BW310 course.
The BW 7.3 courses have recently begun showing up in Q4 2011. If you are already trained in the 7.0 version of BW, the 3 day DBW73 delta course covers the differences.
For more information, or to see the current schedule, go to http://training.sap.com. Then click on Courses & Curricula, and under Curriculum Collections by Solution, choose NetWeaver. Under Business Intelligence (BI) (Project Team Training), choose:
SAP NetWeaver Business Intelligence – Overview for a general overview or
SAP NetWeaver Business Intelligence – Enterprise Reporting, Query and Analysis for SAP Business Objects related courses.
Here you will find the Learning Map with interactive links to the courses mentioned above.