Nathean Analytics supports Excel Spreadsheets in a number of ways depending on the use case

Using spreadsheet data for Reporting

You can import an Excel worksheet as a dataset which loads the data into a table in the datamart. This can be a once-off activity or the dataset can be configured to refresh itself from the content of an Excel file stored on a network folder on a scheduled basis. See here

Updating spreadsheet data and sharing with others

Using sheets, you can share a spreadsheet with other groups or individuals who, depending on the permissions granted can view or edit the data. The built-in audit server will record any changes made. See here

Updating database data using the spreadsheet as an interface

Using dataset-linked spreadsheets, users can concurrently update the data in a database table via a spreadsheet interface. See here

Revision: 7
Last modified: Jan 14, 2021


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment