Fundamentals of Business Analytics

    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