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.