Excel Reports with Data from Tableau or DataSelf Data Warehouse
Options for using Excel to report data from Tableau or your data warehouse
The big value of Excel is that it combines data storage with reporting in one, sharable file. Our Excel AD (automatic distribution)distributes fully formatted & configured Excel reports already loaded with the data. But Excel AD is one of several options for exporting data into Excel files and optionally distributing them.
Options
Each option better serves particular use cases and situations.
DataSelf API is DataSelf’s latest technology for secure, BI based reporting with Excel.
Pre-formatted Excel Report. Data is automatically emailed to you in a pre-formatted Excel workbook with the new data already loaded.
DataSelf’s Automatic Distribution for Excel. Populates ‘master’ copies of Excel reports with fresh data and emails out the Excel files to designated recipients.
Tableau Subscriptions. ? 🛠️ Ask your DataSelf contact for more information.
Data is automatically emailed to you in a Excel file with no special formatting.
DataSelf’s Automatic Distribution for Excel.
Data is automatically emailed to you in a .csv file which is easily opened by Excel.
(Many computers are configured to open .csv files with Excel.)DSA AD and DSA Cloud AD.
You open a Excel workbook on your computer and import data from DataSelf’s data warehouse.
Use the import options built in to Excel’s Data tab.
:note2: NOTES
ETL+ extracts data from Excel files. Excel workbooks can also download data from DataSelf data warehouse databases. Thus, with this framework, data can be both uploaded from and downloaded to, or refresh, Excel files and workbooks.
Related Pages
See Microsoft Excel for information on MS Excel itself
ETL+ for MS Excel – ETL+ can also import data from Excel
DataSelf API for our latest technology for secure, BI based reporting with Excel.
DSA Cloud AD Automatic distribution of Tableau reports as a cloud service. Distributes in .csv (crosstab), PDF and .png (image) formats.
DSA Cloud AD & DSA AD version 2 Automatic distribution of Tableau reports from your computers.
CSV ("crosstab") Output from Tableau’s Export option on Tableau workbook sheets.