VHA Budget Analysis Power BI V4 Ep04 – Add IFCAP and Budget Workbook (The Right Way)

In this video we once again get data from the CSV formatted IFCAP.txt file. We use Power BI’s power query editor to pull text using delimiters, creating an IFCAP file that is column-separated, versus comma separated. We also introduce the Budget Workbook tab, which is inside of the Version 4 Big Spring Budget Analytics Excel workbook, and we take a look at how to set up each column needed for some functionality we will be adding to our new Power BI model.

Facebook Comments

Published by Adrian Rendon

Supervisory Budget Analyst, GS-12 | Veterans Health Administration | Big Spring, Texas