Syllabus for Business Intelligence
1. Data warehouse fundamentals
2. Introduction to SAP R/3, ECC and BW
3. BW architecture
4. Multi dimensional Modeling
5. Star Schema, BW extended Star Schema
6. Administrator Work Bench
7. InfoObjects ( attributes and texts and hierarchies)
8. InfoCubes, Transactional ( Real-time ) InfoCubes,
9. ODS ( DSO) – Standard, Transactional and Write Optimized
10. PSA, Source Systems
11. InfoSource
12. InfoPackage
13. Transfer Rules
14. Update Rules
15. Transformation
16. Data Transfer Process
17. Loading transaction data using flat files
18. ODS - Change Log, Active Table and New Table
19. MultiProviders
20. Process Chains
21. Open Hub service
22. Data Marts
23. InfoSpokes
24. Open Hub Destination
25. Aggregates
26. Activating the Business content
27. Loading Master data from ECC
28. Delta Management
29. Various types of R3 Extractors
30. Extraction from LO Cockpit
31. SAP landscape and Transports
32. Real Time Data Acquisition
33. BEx reporting – BEx Query Designer, Calculated and Restricted Key
34. Figures, Variables ( Characteristic, Formula and Text Variables )
35. Query properties, Exceptions and Conditions, BEx Analyzer
36. Report Designer
37. Generic Extractors
38. InfoSets