HandsOn-Advanced Analytics™

    Prerequisite:   This course assumes basic understanding of the roles and uses of business intelligence and data warehousing technologies.

     

    One-Day Course

    You Will Learn

    • Real-time analytics
      • Human-Machine Intelligence
      • Establishing business rules engines
      • XML as an enabler
    • Data Mining
      • Enhancing the warehouse with in-database data mining
      • Exploiting SQL data mining extensions
      • Exploratory OLAP mining
      • Advanced ETL transformation with mining algorithms
    • Spatial analysis
      • Enhancing the warehouse with in-database spatial data
      • Exploiting SQL spatial extensions
      • Blending spatial analysis into typical BI technology
      • Incorporating Web services
    • Application development environment
      • Understanding the workbench technology trends

    Geared To

    • Solution strategists; data architects; consultants; BI/DW managers; and anyone who influences the decisions regarding the BI platform and/or those involved in its implementation

    Hands-On Advanced Analytics is a real-world course providing a rich learning environment of scale and scope. Using a select list of best-of-breed technology and techniques, the course examines a broad range of BI architectures and technologies. From this foundation, students will participate in hands-on lab exercises that evaluate advanced BI analytics. These labs are based on relevant case study problems.

    Examples of Lab Exercises Include:

    • Exploiting SQL for advanced BI applications in spatial analysis and data mining
    • Establishing spatial data to enhance your BI analytic landscape
    • Exploiting data mining for data quality and forecasting/prediction to enhance atomic-level and cube data
    • Establishing a near real-time analytics solution as part of the overall BI architecture.