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

  • Nelson

    Nathan Nelson

    Central Iowa Power Cooperative

    Business Intelligence Developer

    Excelerate Your Analysis: Accessing your MV-90 xi data in the Blink of an Eye