5 Creating Dashboards, Reports, and Notebooks with Autonomous Data Warehouse

Autonomous Data Warehouse includes built-in support for data analytics using Oracle Machine Learning (OML) a browser-based interactive data analysis environment for data scientists.

About Creating Dashboards, Reports, and Notebooks with Oracle Machine Learning

Oracle Machine Learning provides the following:

Collaborative Interface for real-time analytics:

  • Based on Apache Zeppelin

  • Allows creation of workspaces, projects, and notebooks

  • Provides a browser-based interactive data analysis environment to develop, document, share, and automate analytical methodologies

  • Notebooks execute in Zeppelin Servers and make secure (TCPS) JDBC connections to Autonomous Data Warehouse for data access.

OML Components:

  • OML User Administration Application:

    • Web based administrative UI for managing (list, create, update, delete) Oracle Machine Learning users

    • Oracle Machine Learning users map to Autonomous Data Warehouse database users

    • Access to Oracle Machine Learning User Management is limited to the administrator

    See Create and Update User Accounts for Oracle Machine Learning for more informaiton on OML User Adminsitration.
  • OML Application

    • Web based application for data scientists

    • Allows for creation of workspaces, projects, and notebooks

    • Notebook execution happens in Zeppelin servers

    See Work with Oracle Machine Learning for Data Access, Analysis, and Discovery for information on accessing OML user workspaces, projects, and notebooks.

Work with Oracle Machine Learning for Data Access, Analysis, and Discovery

You can use Oracle Machine Learning to access data and for data discovery, analytics, and notebooks.

To access Oracle Machine Learning:

  • Sign in to your Oracle Cloud Account at cloud.oracle.com.

  • Open the Oracle Cloud Infrastructure console by clicking the navigation icon next to Oracle Cloud.

  • From the Oracle Cloud Infrastructure left navigation list click Autonomous Data Warehouse.

  1. Select an Autonomous Data Warehouse instance and on the details page click Service Console.
  2. Click Development.
  3. On the Development page click OML Notebooks.
  4. Enter your username and password.
    The Administrator creates OML users. See Create and Update User Accounts for Oracle Machine Learning for details.
  5. Click Sign In.

This shows Oracle Machine Learning user application.


Description of dwcs_oml_top.png follows
Description of the illustration dwcs_oml_top.png

Oracle Machine Learning allows you to access your data in Autonomous Data Warehouse and build notebooks with the following:

  • Data Ingestion and Selection

  • Data Viewing and Discovery

  • Data Graphing, Visualization, and Collaboration

  • Data Analysis

You can also create and run SQL statements and create and run SQL scripts that access your data in Autonomous Data Warehouse.

Work with Analytics and Visualization

Gain insight into your data with Oracle Analytics Cloud and Data Visualization Desktop. These tools let you explore your Autonomous Data Warehouse data through advanced analytics and interactive visualizations.

Using Oracle Analytics Cloud with Autonomous Data Warehouse

You can use Oracle Analytics Cloud with Autonomous Data Warehouse.

Built on a high-performance platform with flexible data storage, Oracle Analytics Cloud provides a complete set of tools for deriving and sharing data insights.

  • Data preparation: Analysts can ingest, profile, and cleanse data using a variety of algorithms.

  • Data flow: Analysts can prepare, transform and aggregate data, and then run machine-learning models at scale.

  • Data discovery: Subject matter experts can easily collaborate with other business users, blending intelligent analysis at scale, machine learning, and statistical modeling.

  • Data visualization: Analysts can visualize any data, on any device, on premises and in the cloud.

  • Data collaboration: Large organizations and small teams can share data more simply, as you don't need to manage or consolidate multiple versions of spreadsheets.

  • Data-driven: Application developers can utilize interfaces that enable them to extend, customize, and embed rich analytic experiences in the application flow.

For information on connecting from Oracle Analytics Cloud to Autonomous Data Warehouse, see Connect with Oracle Analytics Cloud.

You can find out more information on Oracle Analytics Cloud in Visualizing Data and Building Reports in Oracle Analytics Cloud.

Working with Data Visualization Desktop in Autonomous Data Warehouse

Gain insight into your data with Oracle Data Visualization Desktop. Data Visualization Desktop lets you explore your Autonomous Data Warehouse data through interactive visualizations.

Data Visualization Desktop provides powerful personal data exploration and visualization in a simple per-user desktop download. Data Visualization Desktop is the perfect tool for quick exploration of sample data from multiple sources or for rapid analysis and investigation of your own local data sets.

Data Visualization Desktop makes it easy to visualize your Autonomous Data Warehouse data so you can focus on exploring interesting data patterns. Just connect to Autonomous Data Warehouse, select the elements that you’re interested in, and let Data Visualization Desktop find the best way to visualize it. Choose from a variety of visualizations to look at data in a specific way.

Data Visualization Desktop also gives you a preview of the self-service visualization capabilities included in Oracle Analytics Cloud, Oracle's industrial-strength cloud analytics platform. Oracle Analytics Cloud extends the data exploration and visualization experience by offering secure sharing and collaboration across the enterprise, additional data sources, greater scale, and a full mobile experience including proactive self-learning analytics delivered to your device. Try Data Visualization Desktop for personal analytics and to sample a taste of Oracle’s broader analytics portfolio.

Data Visualization Desktop’s benefits include:

  • A personal, single-user desktop application.

  • Offline availability.

  • Completely private analysis.

  • Full control of data source connections.

  • Lightweight single-file download.

  • No remote server infrastructure.

  • No administration tasks.

For information on connecting Oracle Data Visualization Desktop to Autonomous Data Warehouse, see Connect with Oracle Data Visualization Desktop.

To download Data Visualization Desktop, see Oracle Data Visualization Desktop.