In today's video, we dive into some exciting upgrades to my financial model in KNIME! I'll walk you through key changes, starting with a major update to the waterfall chart, which now includes both direct and indirect expenses as well as different options to slice and dice the data according to different dimensions. You’ll also see how I’ve added a simplified P&L (Profit and Loss) view, along with new interactive features that allow for flexible data analysis across dimensions like time and category.
We'll start by exploring the revamped dashboard and its powerful new capabilities, including the ability to filter data by quarter, date, or category. I’ll also show you how negative values are now handled more effectively in the waterfall chart, allowing for better comparison across different versions.
Lastly, we’ll get into the detailed workflow changes, showcasing how the new file structure enables you to manage both revenues and indirect expenses more efficiently. By the end of this video, you'll see how the integration of these upgrades makes the financial analysis process smoother and more dynamic. Stay tuned for the next episode where I’ll add a balance sheet view and more advanced cash flow tracking!
LINKS:
Workflow as presented in this video: hub.knime.com/...
TIMESTAMPS:
0:03 | Workflow Upgrades Overview
0:13 | Waterfall Chart Major Update
0:40 | Introduction of Direct and Indirect Expenses
1:05 | New Dashboard Walkthrough
1:37 | New Dimension Selection: Value Type and Time Period
2:54 | Profit and Loss View Simplification
3:55 | Changes to the File Upload Structure
4:26 | Introduction of Indirect Costs Sheet
5:47 | Visualizing the Updated Data Structure
7:16 | Upgrading the Waterfall Chart Interactivity
14:02 | P&L Mapping and Customization
19:02 | Future Plans: Adding a Balance Sheet View
Негізгі бет Supercharged Waterfall chart and adding expenses + P+L - Financial Modelling in KNIME
Пікірлер