Install Python

Contents[Hide]

1. Overview

Python is a popular programming language that can be used for advanced analytics and data modelling. Dundas BI integrates with Python at the data cube level via two transforms, which you can use to perform data generation and data processing/analysis

2. Install Python

Download and run the installer for the 64-bit version of Python 3.6.x on your Dundas BI server.

Install Python
Install Python

Select Customize installation and click Next on the Optional Features page.

Select Install for all users on the Advanced Options page and click Install.

Install Python for all users
Install Python for all users

3. Install packages

Packages must also be installed by the server administrator before they can be used in Python in Dundas BI.

To install the common pandas package, which includes other packages such as NumPy:

  1. Open the Windows command prompt on the Dundas BI server as an administrator (e.g., right-click on Command Prompt in the start menu and choose Run as administrator).
  2. Navigate to the Python scripts folder. For example:
    cd C:\Program Files\Python36\Scripts
  3. Enter the following:
    pip install pandas

4. Notes

  • The Python-related transforms in Dundas BI require a result to be returned by the Python script, which can be represented as a table. This includes results generated using the NumPy and Pandas packages for data analysis.

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri