|
|
|
9. Manage dimension and cube processing. 10. Create partitions in cubes. 11. Implement simple calculations by using MDX and calculated members. 12. Develop and understand virtual cubes. 13. Use Excel 2000 as an OLAP front-end application. Employ actions, drill-through, and write-back for data analysis. 14. Design and implement cube and dimension security. 15. Automate the processing of dimensions and cubes through Data Transformation Services (DTS). 16. Understand how data mining fits within OLAP and the Microsoft data warehousing framework. Create dimensions, cubes, and virtual cubes based on user requirements. Student Prerequisites: This course requires that students meet the following prerequisites:Understanding of basic database design, administration, and implementation concepts. Experience with Microsoft Windows® 2000. |
||