This page is intended for anyone wishing to make a quick start using Experian Pandora to analyse their data. This is only a quick introduction to the functionality available - the process discussed here should be just enough to get you started.
Comprehensive documentation is located alongside the Experian Pandora program files once you've installed your product.
Make your data available in Experian Pandora either by uploading a file or connecting to a database, ready to be configured and loaded.
Uploading is the process of getting your raw data files onto the Experian Pandora server, ready to configure and process. This step shows how to import flat file data (from .txt files, CSVs, .dat files with associated metadata, or Excel sheets).
If your data is in a database (SQL Server, Oracle, postgreSQL, Amazon Redshift, MS Dynamics, or any other data source) the chances are that Experian Pandora can connect to it using a JDBC driver. Experian Pandora can also upload data from Hadoop HDFS, and from cloud-hosted data storage systems such as Amazon S3. For more information, refer to the user guide (manual.pdf) and Hadoop configuration guide.
Right-click Files in the Explorer and select Upload Files to open the file chooser. Select the file you want to upload and click Open.
Configure the data file. Exclude or rename columns, choose standardisation options, decide how blanks or non-standard characters should be treated, and so on.
Here you specify how the file should be loaded as an Experian Pandora table, for example which field delimiter is used or whether the first row contains headers. Experian Pandora makes a guess by analysing the file, this you may want to over-ride the derived values. You may also want to rename or exclude columns, standardise values on load, set certain columns as keys or nullable, and so on.
In the Explorer, right-click the name of the file you uploaded Explorer and select Configure.
To configure settings for individual columns, click the Columns button.
Load the data file into the Experian Pandora repository. This will automatically profile it, discover relationships, and provide insight summaries.
The next task is to load the data into Experian Pandora, based on your configuration settings. Loading will create a new table version in the repository, and simultaneously profile the data and discover relationships.
On the Load File dialogue, select the Permissions tab to set Read, Modify, Delete, Export or Annotate permissions at the global, team, and user level.
You should then see a pop up in the lower right corner to say when the job (in this case Table Load) was completed.
Review the profiling and analysis information generated during the load. Discover new information about your data.
The process of loading data into Experian Pandora automatically causes it be profiled, with hundreds of pieces of metadata generated for each column. Here are three ways in which some of that profiling data can be used to quickly discover more about your data:
This report contains quality information for the whole table, such as column definition details (and where they differ from expected metadata definitions), and a per-column profile summary, including most frequent values and formats.
In the Explorer, browse to Data > Tables, right-click the loaded table, and select Quality Report.
View the Column Profile drilldown for a more in-depth look at over 200 pieces of metadata derived from each column in the table. View uniqueness and completeness, common and rare values, zero and null counts, and many more.
In the Explorer, browse to Data > Tables. Locate your table, select it, and click on the word Columns.
Because of the way the loaded data is stored, Experian Pandora makes it easy and quick to find out where a given value is used across all loaded tables.
In the Explorer, browse to Data > Tables, right-click the loaded table, and select Rows. This will display all values for the loaded table.
Create an expression using Experian Pandora’s extensive function library to transform the data in a column.
Now we have your data loaded into Experian Pandora we have the ability to manipulate it using expression, for example to using a function to prepare an alternative format for export as part of data migration, or adding a validation check.
A very simple transform would be to concatenate two columns and upper-case the resulting value, putting it into a new column.
Right-click a column header, and select Insert Column > Custom.
Drag functions from the list into the edit panel, and select the columns you want to operate on.
A very simple validation would be to check if the values in a column contain only alphabetic characters:
Drag in the Check If function from the list, and select the columns you want to run the check on.
Click Create to name the new column and add it to the drilldown. The resulting new column will contain true and false values.
This guide has taken you through some of the very basic aspects of Experian Pandora’s functionality.
Refer to the user guide (manual.pdf) and other supporting documents installed alongside the Experian Pandora program files as well as Experian Pandora YouTube videos for a far more in-depth review of capabilities including: