The Stratum Connector for Excel add-in lets you securely download your Stratum data directly from the Stratum Data Hub into your Excel workbooks. Once downloaded, you can leverage the full power of Excel for further transformation, analysis, and presentation of your Stratum data. For example, craft new reports using Stratum dimensions, time ranges, and measures using Excel’s Pivot tables and Power Query over the downloaded data. Your reports are automatically refreshed to ensure you are always working with the most current Stratum data. Elevating the add-in to a full-circle data management tool is its Upload Data To Stratum command. The command quickly uploads spreadsheet data into the Stratum Data Hub utilizing Stratum Data Import functionality. The uploaded data can originate from Stratum or other data sources such as a forecasting application or budget spreadsheets.
To learn more, see the Stratum Connector for Excel Getting Started Guide.
The add-in can be downloaded from Microsoft’s AppSource, which you can get to while using Excel.
1. From the Insert tab in Excel, click Get Add-ins. Or, if your Add-Ins icon is on your Home tab, click it then click the Get Add-Ins button on the menu that displays.
2. Then, click the Store tab in the Office Add-ins window that opens and search for Stratum to locate the Stratum Connector for Excel add-in.
3. Click the Add button for the Stratum Connector for Excel add-in. When the add has been completed, a Stratum tab will be added to Excel. You can begin using the add-in. Click the Learn About Stratum button in the tab for getting started information.
