DeepSee Education & Training

DeepSee Fundamentals

Overview

This three day course teaches developers and business intelligence users how to embed real-time business intelligence capabilities in their applications. The course presents the basics of building data models from transactional data using the DeepSee architect, exploring those models and building pivot tables and charts using the DeepSee analyzer, as well as creating dashboards for presenting pivot tables, meters, and other interactive widgets. The course also covers securing DeepSee models, tools, and elements (dashboards, pivot tables, etc.) using the Caché security infrastructure. Finally, the course presents topics such as customizing the DeepSee user portal, querying a DeepSee model programmatically as well as from the DeepSee shell, and importing and exporting DeepSee dashboards and pivot tables.

Prerequisites

No prior DeepSee or Business Intelligence experience is required.

Agenda

  • Overview
    • Real-time and Embedded BI
    • DeepSee Tools and Architecture
  • Pivot Tables
    • Orientation to Analyzer
    • Creating Pivot Tables
    • Using Detail Listings
    • Adding simple and complex filters
    • Using conditional formatting
  • Dashboards
    • Orientation to User Portal
    • Creating a Dashboard
      • Adding Table and chart Widgets
      • Adding dashboard filters and actions
      • Adding Scorecard Widgets.
  • Models
    • Defining Cubes
      • Defining dimensions
      • Defining measures
      • Defining detail listings
      • Cube-Cube relationships
      • Cube inheritance
    • Options for building and rebuilding cubes
    • Subject Areas
      • Filtering: Static and Dynamic
      • Overriding dimensions
  • KPIs
    • Building and testing a KPI
    • Using KPIs with various widgets
    • Defining filtering options
    • Defining custom actions
  • Security
    • Caché Security Review
    • Securing DeepSee tools
    • Securing DeepSee elements (dashboards, pivot tables, etc.)
  • Additional Features
    • %DeepSee.ResultSet API
    • DeepSee Shell
    • Embedding Dashboards in applications
    • Exporting and Importing DeepSee elements
    • Portal settings
    • DataConnector