itron sessions
Excelerate Your Analysis: Accessing your MV-90 xi data in the Blink of an Eye
Preparing meter data for analysis and delivery to external reports in Excel can require multiple steps of exporting, organizing, and formatting. Using Power Query in the latest version of Microsoft Excel to tap directly into MV-Web (or ODBC exports from MV-90 xi) Central Iowa Power Cooperative (CIPCO) will demonstrate bringing data directly into a spreadsheet with no macros or special plugins. Code examples and build details will be shared to prepare data from multiple meters in a few simple steps in your own organization.
Presenters
-
Nathan Nelson
Central Iowa Power Cooperative
Business Intelligence Developer
Excelerate Your Analysis: Accessing your MV-90 xi data in the Blink of an Eye