1 Get Started with Oracle Analytics Desktop

This topic describes the benefits of using Oracle Analytics Desktop, how to install it, and how to get started using the sample workbook.

About Oracle Analytics Desktop

Use Oracle Analytics Desktop to experience standalone data exploration and visualization as a desktop download.

Oracle Analytics Desktop enables you to visualize and explore your data from multiple sources or for analysis and investigation of your local datasets. Just upload data files or connect to Oracle Applications or a database, select the elements you’re interested in, and let Oracle Analytics Desktop find the best way to visualize it. Choose from various visualizations to look at data in a specific way.

Oracle Analytics Desktop previews the self-service visualization capabilities of Oracle Analytics Cloud and Oracle Analytics Server. Oracle Analytics Desktop is a free download provided under the Oracle Technology Network license. Oracle Analytics Desktop isn't intended for production use, and isn't covered by Oracle's support policy.

Install Oracle Analytics Desktop

Anyone can install Oracle Analytics Desktop on Windows or Mac.

You can install and use Oracle Analytics Desktop to learn more about Oracle Analytics functionality, or to use it as a stand-alone development environment where you can create workbooks and export them to share with other Oracle Analytics Desktop users or to import into Oracle Analytics Cloud.
Go to this page to find the installer and read about system requirements: Oracle Analytics Desktop Installation Download.
  1. Use the above link to go to the Oracle Analytics Desktop Download page to locate the current version of the installer.
  2. Click Download and in the Oracle Software Delivery Cloud page review and accept the license agreement, and click the Platforms drop-down button and select one or more platforms to install Oracle Analytics Desktop onto. Click off the field to enter your selection.
  3. Confirm your selection, click Download, and specify where on your computer to save the installer .zip file. If needed, enable your browser's popups for edelivery.oracle.com.
    This step adds the Oracle Download Manager file to your computer, which you use to complete the installer download.
  4. Go to the download location that you chose, locate and open the Oracle Download Manager file, confirm the installer's download destination, and click Next to start the installer .zip download.
  5. After the download completes, click Open Destination to locate the .zip that contains the installer.
  6. Extract the .zip file and launch the installer (.exe file for Windows or .pkg file for Mac). Follow the instructions provided on the screens to complete the installation.

Install Machine Learning and Advanced Analytics on Windows

Machine learning and advanced analytics are optional components that aren't included in the Oracle Analytics Desktop Windows installation. Install machine learning if you want to use Diagnostics Analytics (Explain), Machine Learning Studio, or advanced analytics.

  1. Go to the Windows Start menu, browse to Oracle, and click Install DVML.
    Terminal is launched and BiPython_Framework.exe downloads.
  2. The installer starts on completion of the download. Follow the displayed instructions to install machine learning to the selected install path.
  3. Click Finish to close the installer.
  4. When prompted, press any key to close the terminal window.
  5. If Oracle Analytics Desktop was running during the installation, then restart it.

Install Machine Learning and Advanced Analytics on Mac

Machine learning and advanced analytics are optional components that aren't included in the Oracle Analytics Desktop Mac installation. Install machine learning if you want to use Diagnostics Analytics (Explain), Machine Learning Studio, or advanced analytics.

  1. Double-click the application Oracle Analytics Desktop Configure Python in Finder under the Applications folder that contains Oracle Analytics Desktop.
    Terminal is launched and BiPython_Framework.pkg downloads.
  2. The installer starts on completion of the download. Follow the displayed instructions to install machine learning to the selected install path. Enter an administrator user name and password to run the installation.
  3. Click Close after the installation is completed.

    The Machine Learning Framework was installed in /Library/Frameworks/DVMLruntime.framework

  4. If Oracle Analytics Desktop was running during the installation, then restart it.

Open Oracle Analytics Desktop

You can open the Oracle Analytics Desktop application from a desktop shortcut or by locating it from the start menu (for Windows) or in Applications (for Mac).

This is the desktop shortcut icon:

Oracle Analytics Desktop shortcut icon

The shortcut icon is available on your desktop if you selected the Create desktop shortcut option when you installed Oracle Analytics Desktop, or if you manually created a shortcut on your computer after installation.

  1. To open Oracle Analytics Desktop from a shortcut icon, locate the shortcut on your desktop and double-click (for Windows) or click it (for Mac).
  2. To open Oracle Analytics Desktop from your computer:
    • If you're using Windows, click Start, browse to and open the Oracle folder, and click Oracle Analytics Desktop.
    • If you're using Mac, go to Finder, click Applications, and locate and click Oracle Analytics Desktop.

Get Started with Sample Workbook

Use the sample workbook provided to explore and discover Oracle Analytics Desktop's capabilities. Sample Workbook is designed to teach you best practices, which you can then use to create your own workbooks.

Sample Workbook uses the Sample Order Lines and Sample States spreadsheets as its datasets. The visualizations included in Sample Workbook illustrate how to create different views of the data and arrange them on multiple canvases to provide a comprehensive look at the data.

You can choose to download Sample Workbook during installation. If you didn’t download Sample Workbook during installation, then you can still get it by uninstalling and then reinstalling Oracle Analytics Desktop. Your personal data isn’t deleted when you uninstall and reinstall.

Oracle also provided examples designed to help you enhance your data visualizations. The examples are .dva files that you can re-use with your own data. See Oracle Analytics Examples Library.