Prerequisite:   This course assumes understanding of relational database terms.

 

One-Day Course

You Will Learn:

• Best practices, in both data and technical architectures, for implementing a successful BI strategy
• The core components of effective query and reporting, OLAP, BI portals, data mining, metadata, spatial analysis, real-time DW, and more
• The right application of atomic-level data, star schemas, and the following OLAP structures and techniques:
• MOLAP
• HOLAP
• ROLAP
• How to effectively apply leading BI tools, including Hyperion Essbase, Cognos, MicroStrategy Intelligence Server, and Microsoft Analysis Services
• The application of data mining, including pure-play technologies like SAS as well as indatabase data mining from Oracle, Microsoft, and DB2
• The application of advanced visualization tools and techniques
• The application and importance of spatial data and spatial analysis
• Understanding the implications of zero-latency (ZLE) and real-time data warehousing

Geared To:

• DW project planners; data architects; and anyone involved in the design and construction of a BI solution for an enterprise