Icon

FinancialModelling_​Part3

App Design

  1. Load Input data from Excel for:

    1. Plan values

    2. Actual values

  2. Focus: Revenue / Income for Minimal Viable Product

    1. Plan / forecast over time

    2. Actual over time

  3. Key features:

    1. Upload new excel file to create new plan version

    2. Plan version comparison

    3. Plan version vs. Actual comparison

    4. Accommodate different Products

    5. Neat data viz for quick insights in Data App

2. Load data and establish planning (revenue, dir/indir expenses)

1. Upload Excel and Define Version

3. Save Version

4. Visualize Plan Differences

  1. Revenue/Dir. Expenses

  1. Indir. Expenses

Plan Data
Excel Reader
create date rangewith correct frequency
Create Date&Time Range
Iterate over everyProduct and create variables
Table Row to Variable Loop Start
frequency to period Map
Excel Reader
Lookup Period Value
Value Lookup
add in Revenue,Expensesand product
Column Expressions
collect results
Loop End
Unpivot
Table Manipulator
Rename,FilterChange data types
Table Manipulator
Add ValueType Column
Column Expressions
Concatenate
Missing Value
Merge Variables
Indir. Expenses
Excel Reader
Table Writer
Date columns to rows
Unpivot
Select File
File Upload Widget
String Widget
Load existingdata
Table Reader
Add new data
Concatenate
WaterfallandPandL
Data Viz

Nodes

Extensions

Links