Oracle Analytics Cloud Synopsis provides instant analytics on a mobile device. With this app, you can quickly and easily turn data into meaningful data visualizations, without any detailed knowledge of data exploration or data science.
With Oracle Analytics Cloud Synopsis, you can:
Import spreadsheet data and receive instant data visualization.
Change the initial visualization; for example, from a donut chart to a bar chart. Based on the complexity of the data, the app displays the data in an appropriate chart; however, you can easily change the chart format.
Select specific data from your spreadsheet for the analysis.
Change the format of the data; for example, you can change the preferred currency, opt to display the number data as percentage, and specify the decimal character and number separator.
Transform data from a number value to text value; for example, you can change the month value to display as text rather than as a number.
Share the analysis using the apps on your mobile device.
Export the project to destinations of your choice.
Additionally, on Android devices, you can:
Import data from Oracle Analytics Cloud data sets and your fitness data from the Google Fit app.
Scan printed tables with the device camera, view real time chart visualization atop table data, create a project instantly, and spot trends in the printed data.
Scan the nutrition label of your favorite foods to store and analyze the nutrition data.
Expand the data set in a project by merging two projects; for example, add data across time periods or regions.
View project and chart insights for a predictive analysis.
Add a new column of calculated numbers in a data file; for example, create a new Profits column in the data file by subtracting Sales values from Cost values.
Change the initial visualization; for example, from a donut chart to a word cloud chart in which the size of the word represents the size of a measure.
Add multiple text elements such as month and year to charts; thereby use time specific controls to select date ranges and times when manipulating charts with a time dimension.
Combine charts to create a chart.
Back up and restore projects.
You can import data as numbers (for example, gross price = 1000) and text values (for example, country = Canada).
A number card displays the important number from the number values in your spreadsheet data; for example, the sum of sales price or manufacturing price.
On both Android and iOS, the app is limited by the processor power, memory, and storage on the device. The app performs well on most modern devices (those manufactured in the year 2015 and later), but older devices or devices with limited storage may perform slower, have issues loading large files, or experience other issues that cannot be addressed.
The app supports XLSX, XLS, and CSV file types. Here are the recommended file sizes based on the number of rows:
| File Type | Android | iOS |
|---|---|---|
| XLSX | 250,000 | 25,000 |
| XLS | 250,000 | 25,000 |
| CSV | 250,000 | 250,000 |
Large files can take longer to load and are not recommended. Files that have more that 20,000 unique values in a single text column impact chart and project performance. The app (for Android and iOS) can load files while in the background, so files that take longer to load can process while you work on other tasks on the device.