Icon

Export_​to_​PowerBI

KBL: Preparing data for Spotfire
Workflow: Export_to_PowerBI In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, on onebranch we calculate the money in budget for each year foreach one of the project and on the other branch wecalculate the money actually spent for each project eachyear.We then export the money allocated, the money spent andthe money remaining for each project each year to build aPowerBi report Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year renaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDProjects.txt filewith path relative to"current workflow"send data toPowerBI Column Rename Column Rename Remaining Money Sorter Sorter Pivoting Pivoting RowID RowID CSV Reader Joiner Send to Power BI MicrosoftAuthentication Workflow: Export_to_PowerBI In this workflow we prepare data to be displayed in areport.Starting from the accounting of a list of projects, on onebranch we calculate the money in budget for each year foreach one of the project and on the other branch wecalculate the money actually spent for each project eachyear.We then export the money allocated, the money spent andthe money remaining for each project each year to build aPowerBi report Calculating money spent for each project each year Calculating money in busget for each project each year Calculating money remaining for each projecteach year renaming"<year>+Sum(...)" intojust "used <year>"enaming"<year>+Sum(...)" intojust "assigned <year>"calculatingremaining moneyby RowIDby RowIDmoney assignedto projecteach yearmoney used by projecteach yearproject name as RowIDproject name as RowIDProjects.txt filewith path relative to"current workflow"send data toPowerBIColumn Rename Column Rename Remaining Money Sorter Sorter Pivoting Pivoting RowID RowID CSV Reader Joiner Send to Power BI MicrosoftAuthentication

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
On NodePit since: 2022-05-04
Last update: 2024-12-17
Created with KNIME version: v4.4.0
Tags: EducationKNIMEPressReportingAggregationPivotingSpotfire

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!