3 Synopsis for Android

Manage Data

• How do I load data from a spreadsheet?

• How do I load data from a data set from Oracle Analytics Cloud?

• How do I load data from the Google Fit app?

• How do I load data from an image of a table?

• How do I change the format of the loaded data?

• How do I change the data type for a project in the app?

• How do I select specific data for analysis?

• How do I add a calculated numeric column in a data file?

• How do I add a chart to my charts list?

• How can I view insights about a chart?

• How can I view insights about a project?

• How do I rename a project?

• How do I delete a project?

• How do I merge charts in a project?

• How do I merge multiple projects?

• How do I back up the project data?

• How do I restore the project data?

Manage Visualizations

• How do I change the initial visualization provided by the app?

Share and Export

• How do I share the analysis?

• How do I export a project?

How do I load data from a spreadsheet?

1. Ensure that the data file (such as xls, xlsx, or csv) is available on your mobile device.
2. Open the app.
   You see a list of projects.
3. Tap available at the bottom of the Projects screen.
4. Tap File Explorer.
5. Select the location of your data file; for example, Dropbox.
6. Select the data file.
   You see a preview of the data.
7. Optionally, you can tap Text or Number attribute for a data column to modify it. For example, if Customer ID is displayed as Number, then tap Number to change it to Text.
8. Tap Load.

The app opens, loads the file as a project, and presents the initial analysis as a visualization that contains numbers and text values.

How do I load data from a data set from Oracle Analytics Cloud?

1. Ensure that you've subscribed to Oracle Analytics Cloud.
2. Open the app.
   You see a list of projects.
3. Tap available at the bottom of the Projects screen.
4. Tap Oracle Analytics.
   • If you use Oracle Analytics Day by Day, then the app asks if you want to connect to Oracle Analytics Cloud using your Day by Day account. Tap CONNECT.
   • If you aren’t using Oracle Analytics Day by Day or want to connect to a different server, then enter the server information and tap CONNECT.
   • Optionally, select the Enable secure connection check box to log in securely.
5. Select a data set that you created on the cloud service.

The app loads the selected data set as a project and presents the initial analysis as a visualization that contains numbers and text values.

How do I load data from the Google Fit app?

1. Open the app.
   You see a list of projects.
2. Tap available at the bottom of the Projects screen.
3. Tap Google Fit .

If the Google Fit app isn't installed on the device, you're prompted to install it (a one-time installation). If the Google Fit app is installed on the Android device, then the app asks you to allow access to your fitness data. If you allow, then it loads the Google Fit data as a project and presents the initial analysis as a visualization that contains numbers and text values.

How do I load data from an image of a table?

1. Open the app.
   You see a list of projects.
2. Tap available at the bottom of the Projects screen.
3. Tap Lens .
4. Point the device camera at a table of data and click .
5. Optionally, wait for the augmented reality chart to appear over the data in the table and then on the device, click the button that increases volume to import the data from the table.

The app loads the selected data as a project and presents the initial analysis as a visualization that contains numbers and text values.

How do I change the format of the loaded data?

1. Tap the initial visualization to view the analysis data as a list of number cards.
2. Tap on the number card to open the format options.
3. Select the format options.

   You can format the number with a currency symbol, the number of decimal places, and a number separator. Optionally, you can format the data as an aggregate of sum, average, and count. The Abbreviate check box enables you to display the number in an abbreviated form. For example, abbreviate 1,234,567.00 as 1.2M

   Note:

   If you select percent, then you can evaluate the value as a percentage of the total numbers.
   You see the modified format.
4. Tap on the number card to close the format options.
5. In tablets that are 7 inches or larger, tap available for the selected number card to change the format of the numbers.

How do I change the data type for a project in the app?

1. Tap the project.
   You see the list of number cards and your charts.
2. Tap .
3. Tap for an item to change the value to a number or text.
4. Tap for an item to show or hide it.
5. Tap to apply the changes.

How do I select specific data for analysis?

1. Tap a number card.
   You see the charts for the selected number and its available text values. For example, in a chart, you might see product names as text values that each have a corresponding manufacturing price in the form of a number.
2. Tap the chart for the selected number and required text value.
3. Tap to modify the chart.
4. In Numbers, Text, and Charts, select the values that you want.
5. Optionally, tap to filter the numbers and text values to use in the analysis.
6. Optionally, tap to add more than one text element to a bar chart.

Based on the data selected, you see the analysis in a chart that is appropriate for that data.

How do I add a calculated numeric column in a data file?

1. Tap the project.
   You see the list of number cards.
2. Tap . You see the numeric columns available in the data file and the options to perform basic mathematical calculations; for example, , . You can swipe to open the numeric keypad to perform complex mathematical calculations.
3. Select the columns and the mathematical operation that you want to perform; for example, select Sales and Cost numeric columns; then select .
4. Tap and name the new column, for example, Profit.

The app adds the new Profit column with the calculated profit values to the list of number cards.

How do I add a chart to my charts list?

1. Tap a project.
   You see the list of number cards and your charts.
2. You can add a chart to your charts list in two ways:
   • In My Charts, tap <plus icon> to add a chart that the app generated based on the number cards in the project.
   • Tap a number card to see the various charts.
   • Tap a chart to view it in full-screen mode.
   • Tap and then tap Add to My Charts.

How can I view insights about a chart?

1. Tap a project.
   You see the list of number cards and your charts.
2. Tap a number card.
   You see the charts for the selected number and its available text values.
3. Tap a chart.
4. Tap .
   You see insights about the data in the chart based on logic and common sense. Use this machine learning for a predictive analysis of the data in the chart.
5. Tap to share the insight using an app on your device.

How can I view insights about a project?

1. Tap a project.
   You see the list of number cards and your charts.
2. Tap .
   You see insights about the data in the project based on logic and common sense. Use this machine learning for a predictive analysis of the data in the project.
3. Tap to hear the insight.

How do I merge charts in a project?

1. Tap a project.
   You see the list of number cards.
2. Tap a number card; for example, Units Sold.
   You see the various Units Sold charts such as Units Sold by Segments and Units Sold by Country.
3. Tap, hold, drag, and drop one chart on top of another to merge the two charts.

   Note:

   Prior to merge, you can predict if the merge will be successful. If a merge is going to be successful, then you see a green background color for the drop target; else, you see a red background color for the drop target.
   You see a new combination chart to work with like other charts.

How do I merge multiple projects?

You can only merge two projects that share the exact same structure; for example, projects that are based on the same spreadsheet. Prior to merge, you can predict if the merge will be successful. If a merge is going to be successful, then you see a green background color for the drop target; else, you see a red background color for the drop target.

Tap, hold, drag, and drop one project on top of another to merge data of the two projects; for example, projects such as Order Activity of 2017 and Order Activity of 2016. You see a new project that you can work on like other projects.

How do I rename a project?

1. Tap the project to open it.

   Note:

   You can't rename projects when using a tablet.
2. Tap beside the project name and tap Rename.
3. Change the name and subtitle as required.
4. Tap Save.

How do I delete a project?

1. Swipe left to right on the project.

2. Use Undo to reverse the delete action.

How do I back up the project data?

1. Open the app.
   You see a list of projects.
2. Tap next to Projects.
3. SelectSettings.
4. Select Backups.
   The app connects to your Google drive.
5. Select .
   The app backs up the projects and configuration data to your Google drive.

How do I restore the project data?

1. Open the app.
   You see a list of projects.
2. Tap next to Projects.
3. SelectSettings.
4. Select Backups.
   The app connects to your Google drive.
5. Select adjacent to the desired time-stamped backed-up data.

How do I change the initial visualization provided by the app?

1. Tap a number card.
   You see the charts for the selected number and its available text values. For example, in a chart, you might see product names as text values that each have a corresponding manufacturing price in the form of a number.
2. Tap the chart whose type you want to change.
3. Tap .
4. Tap Charts and select a chart type.
   You see the chart in the selected type.

How do I share the analysis?

1. Tap a number card.
   You see the charts for the selected number (for example, units sold) and the available text values (for example, country, region, segment).
2. Tap beside the chart that you want to share. For example, you might want to share the chart called Units Sold by Country.
3. Select the app you want to share with.

How do I export a project?

1. Tap .
2. Tap Export Project.
3. Select the destination folder on your device.
4. If required, tap to create a new folder.
5. Tap OK.