Skip to content

ON - Self-Service Reporting Discovery - 2025-09-02

Metadata

  • Date: 2025-09-02
  • Company: ON
  • External Participants: Rodrigo Cabrera (Treasury), Amanda Mitt (Treasury Analyst)
  • Palm Participants: Emma
  • Type: Customer Call
  • Domain Areas: Reporting, Cash Visibility, Cash Forecasting, Investments & Debt
  • Recording: https://tldv.io/app/meetings/68b6ea9010091700139b3ebb/

Summary

Context

Customer discovery call with ON Treasury team to understand their self-service reporting needs. Emma gathered requirements for what ON would want from a self-serve reporting/dashboard builder in Palm.

Key Discussion Points

  • Current dashboards built by Palm - want ability to build/edit themselves
  • Need pivot tables and data tables, not just graphs
  • Quick filter buttons for regional views (Global, APAC, EMEA, Americas)
  • Drill-down capabilities from summary to individual accounts
  • Report sharing: scheduled snapshots + interactive links for regional teams
  • Actuals vs forecast combined views with variance analysis
  • Top N views (top 10 bank accounts, top 5 entities)
  • External data integration wish (Anaplan liquidity planning, FX rates) - not urgent

Pain Points

  • Must wait for Palm to build dashboards - want self-service
  • Looker lacks bank account details they have in Palm
  • Loading issues with graphs ("problem loading data")
  • Can't easily modify existing reports (filters, dimensions)
  • Regional teams (APAC) can't access Palm directly

Feature Requests & Needs

  • Pivot tables - slice and dice data in tables, not just graphs
  • Quick filter buttons - like Power BI, for regional filtering
  • Duplicate/copy reports - edit existing dashboards as starting point
  • Drill-down - click chart → see underlying data → drill to account level
  • Scheduled reports - PDF snapshot + link to interactive view
  • Filter scope control - exclude specific charts from global filters
  • External data connection - connect Anaplan/CSV data (future wish, not urgent)

Jobs & Desired Outcomes

Job 1: Build and customize dashboards without waiting for Palm Desired Outcomes: - Minimize the time required to create new dashboard views - Reduce dependency on Palm team for report modifications - Increase flexibility to adapt views based on changing priorities

Job 2: Share treasury insights with regional teams Desired Outcomes: - Minimize the time required for regional teams to access cash position data - Reduce the frequency of outdated data being used for decisions - Increase stakeholder confidence in treasury reporting

Job 3: Quickly sanity check data for decision-making Desired Outcomes: - Minimize the time required to identify cash concentration issues - Increase the speed of spotting anomalies in entity balances

Domain Insights

  • ON uses Looker for current reporting but it lacks bank-level detail
  • Regional teams (APAC, EMEA, Americas) need visibility but don't have Palm access
  • CFO ("Christoph") receives monthly cash position updates
  • They compare Palm data with Anaplan liquidity planning data
  • Standard chart types sufficient: bar, line, pie - no complex visuals needed
  • Report scheduling example from Looker: PDF snapshot + "view in Looker" link

Action Items

  • [ ] Continue iterating on self-serve reporting scope
  • [ ] Follow up on batch uploads feature

Notable Quotes

"Instead of doing that and for the future, if we have more similar requests... just putting it ourself. It makes life easier for you instead of waiting a day building a dashboard for us." - Rodrigo

"Sometimes we just want... a quick fix that would already help would be already the report and the visuals that we already have but we can maybe edit them a bit or like filter them a bit better." - Amanda

"If we could duplicate this one, for example, this page, with cash, and then edit... that would be super cool." - Amanda

"That ability to drill down. I think it's quite good. It's quite important." - Rodrigo

Full Transcript

Date: 02/09/2025, 15:01

00:02 Emma Sjöström: Hey, Rodrigo.

00:16 Rodrigo Cabrera: Maybe, I'm not where you.

00:18 Emma Sjöström: Hi, I'm good. Thanks, and you Seems maybe the connection is a bit shaky.

00:47 Rodrigo Cabrera: Well, hello.

00:48 Emma Sjöström: Hot. Hello.

00:50 Rodrigo Cabrera: Here. Yeah, no.

00:52 Emma Sjöström: There. Oh nice. That looks good.

00:55 Rodrigo Cabrera: Yes, I was outside in the Wi-Fi was not great. So, I connected somewhere else, I don't know. We'll see if it works.

01:03 Emma Sjöström: Gotcha.

01:03 Rodrigo Cabrera: How is it going? Oh good.

01:06 Emma Sjöström: Oh good, thanks for asking intense last week. Coming back from vacation but it was fun. So,

01:13 Rodrigo Cabrera: I can imagine.

01:14 Emma Sjöström: Yeah.

01:15 Rodrigo Cabrera: Nice. Where you somewhere? Nice or

01:20 Emma Sjöström: Yeah, we went to Shamani.

01:23 Rodrigo Cabrera: Right.

01:24 Emma Sjöström: Yeah. I tried a paragliding.

01:29 Rodrigo Cabrera: How did it go?

01:31 Emma Sjöström: It went well. A bit nervous jumping off the cliff but nothing else. It was kind of nice.

01:35 Rodrigo Cabrera: I, of course. Nice. Nice time. Yeah, I think I'm, I will be 12 straight to do it even, try it. So maybe not my thing.

01:48 Emma Sjöström: That's totally fine, totally sensible.

01:53 Rodrigo Cabrera: Yeah.

01:54 Emma Sjöström: Hey, Amanda.

01:56 Amanda Mitt: Hey, Emma here. Did you go? Sorry.

01:58 Emma Sjöström: Don't worry, how are you?

02:00 Amanda Mitt: A perfect.

02:01 Emma Sjöström: How have you been?

02:03 Amanda Mitt: Nice summer. How are you? You had nice. You had long holidays. No like yeah.

02:11 Emma Sjöström: Yeah, hello. Run this this summer. It was nice. Yeah.

02:17 Amanda Mitt: Good.

02:17 Emma Sjöström: When? For some trips and then chilling.

02:20 Amanda Mitt: Yeah, yeah. Nice.

02:23 Emma Sjöström: you use and like and we could out. Also maybe do a bit of a, contextual deep dive on things. and if that's helpful to show and tell kind of what you mean, what you would like to have in terms of also features Okay.

03:25 Rodrigo Cabrera: A perfect.

03:26 Emma Sjöström: Nice. So bear with me, it's gonna be a bit open mind, like open-ended. And I know we've gone through some of these things before, but it's also to help the team a little bit. Understand the whole context of reporting. So the first question is just kind of What kind of reports a dashboards? Do you currently need to create?

03:49 Rodrigo Cabrera: lot of them they are already in or some of them are already in different, A dashboards or or visualizations that we have that, you have a in that in the Unifitual call in the pool. I don't know how you guys call it in the tool, or in the I don't know.

00:00 :

05:26 Emma Sjöström: Yeah, really engage maybe. I don't know.

05:28 Rodrigo Cabrera: ourself, right? Not, that's not they go, but some yeah, self-service, whenever we see feed a this, especially this, like top five calculations or something, that I think will be will be good. Sorry not hey Amanda, I'm not sure.

07:28 Amanda Mitt: Yeah, I think. Yeah, this is excited like that. Sometimes we just want one. Yeah, like maybe even what we have. Like we something that maybe quick like a quick fix that would already help would be already the report and the visuals that we already have but we can maybe Edit them a bit or like filter them a bit better.

07:52 Amanda Mitt: Like I will be ready, much. super helpful, and I think for me, Like the possibility to maybe. Yeah, people data would be really cool as well, transactions.

08:05 Rodrigo Cabrera: Yeah not yeah true not like only in graphs but also like tables. Yeah, sure.

08:10 Amanda Mitt: Yeah. Deep

08:12 Emma Sjöström: I pivotal groupings, all of that. Yeah.

08:13 Rodrigo Cabrera: We just fight.

08:15 Emma Sjöström: Yeah.

08:17 Rodrigo Cabrera: and a Of course, it's it's not the The business or anything, but a lot of times and I was just logging it and it happened again. If I try to load any graphs or something in time, it's just as problem loading data. So it never it doesn't work a

08:35 Emma Sjöström: I'm, I noticed the cash balance was I know where and We were working on them. It's like a technical optimization that we're working on and I suspect I reached out to the team, I suspect we just need to like remap some value somewhere. Will fix it. I agree. Yeah.

08:57 Emma Sjöström: Your your early beta testers. So,

09:01 Rodrigo Cabrera: yeah, of course, of course really

09:02 Emma Sjöström: whole self-serve product as well to now, we've tested it iterated. So now we're just kind of cleaning it up and making it more stable and reliable for you guys as well. But yeah, keep keep telling us whenever something is off for broken. You know, don't be shy. Just like what is happening? Just let us know.

37:06 Emma Sjöström: It's, it's only good.

09:29 Rodrigo Cabrera: Yeah. Okay.

09:30 Emma Sjöström: but so what I'm hearing is, like, you have some different use cases, right to have like, the more like Dashboards, if you will and then you have like some needs to just quickly look up some sort of data. And what I'm kind of interested is also like kind of what type of decision.

09:48 Emma Sjöström: So you're looking to drive looking at this data or finding this data. just,

09:57 Amanda Mitt: no, I'm thinking about like

09:57 Emma Sjöström: I bet it's anything from like day to days.

10:00 Rodrigo Cabrera: Yeah, yeah, I think so. Like, if we see the quickly balances, I don't know, in

10:01 Emma Sjöström: Yeah.

10:07 Rodrigo Cabrera: in USD we quickly see investments and or if we see that we have it too much, a cash filing up in a specific entity. We can push the teams and in we already have a few, a few reports like that or visuals in Palm but we we requested them at some point but instead of doing that and for the future, if we have more similar requests like that or we want to view it from from a different point of viewer from a different currency a just putting it ourself.

10:48 Rodrigo Cabrera: It's I think it

10:47 Emma Sjöström: Yeah.

10:47 Rodrigo Cabrera: makes life easier for for you to instead of waiting a day.

10:51 Emma Sjöström: Yeah.

10:52 Rodrigo Cabrera: Building a dashboard for us.

10:55 Emma Sjöström: Of course and yeah. Sorry Amanda.

11:01 Amanda Mitt: Yeah, I think it would be cool. We use usually use some sort of Google tool,

11:04 Rodrigo Cabrera: 3.

11:05 Amanda Mitt: right for the rip for the reports. No, it's not from Google, like the no. Okay. Like how which, I don't know because we use looker.

11:17 Emma Sjöström: Yeah. So our you mean like the

11:22 Amanda Mitt: Yeah.

11:23 Emma Sjöström: Bit. So we it's we use Bigquery that's our database that writes the data and

11:28 Amanda Mitt: Okay.

11:29 Emma Sjöström: balances status there, we have transactions data, we have forecast data set, right within all these. As you know, using Luca this all these names of fields and stuff that I also would love to make sure make sense to you. So that would probably be another session later on just going to that a little bit together.

00:00 :

12:25 Amanda Mitt: Yeah, because I've even think all our reporting is on actual date, right? So I think we don't Could we even do reporting on forecast data? Like for example We check. Yeah, like that would be cool as well. I don't know how

12:38 Emma Sjöström: Well I don't know like right let's slice and dice it in various ways, maybe it's interesting to we've heard feedback coming in. We don't have it now but like forecast over forecasts and comparing you know last year's forecast for the period with this year and so stuff like this.

00:00 :

12:54 Amanda Mitt: And it's yeah, would be interesting. For example, if Rodrigo created

12:55 Emma Sjöström: Is something that we're quite aware or we're getting feedback that would be

12:55 Rodrigo Cabrera: Yeah. Yeah I think that the on that same topic. Hey we were having a cold this morning with a team in Apac and they were really interested in in the in the caste a short-term and long-term forecasts that we have in in For example, right now it's of course basic just our open, AR open AP.

25:52 Rodrigo Cabrera: But once we are able to integrate those in palm plus all of the AI machine learning from Palm that it will make that forecast, much more accurate. I think it will be quite good. If, of course, a team is not going to have access to pump but if I don't know, once a week on a Monday, they will receive an email with the dashboard and how it looks for the next month or or.

00:00 :

12:59 Emma Sjöström: So if you also have like thoughts on data or anything like that, that's super valuable for us as well to be aware of. But I reckon they're a bit like different. There's one what data is available? And the other is like, okay, what can we work with? Like what, how can we slice and dice it and view it and report on it?

13:30 Amanda Mitt: A dashboard. Could he make it like just for him and share it? Or yeah.

13:36 Emma Sjöström: That's I guess. Perfect. That's not we're going forward so fast. This is nice. Yeah. What's gonna ask about that as well, right? Because who needs access do

13:44 Amanda Mitt: valuable to you guys. Because like I I'm just now I'm Assuming right to stop me if I'm wrong but I'm assuming right if I just want the playground for quick. Well, knobs to sanity checking stuff, looking at data playing around, maybe, you know. I want it. For me personally, or at least within the Treasury team.

38:09 Amanda Mitt: So, just yeah. That's another dimensity. Now we're going fast, but this is cool.

14:32 Rodrigo Cabrera: AI machine learning from Palm that it will make that forecast, much more accurate. I think it will be quite good. If, of course, a team is not going to have access to pump but if I don't know, once a week on a Monday, they will receive an email with the dashboard and how it looks for the next month or or.

00:00 :

15:23 Amanda Mitt: If has access but I think for the regions. Yeah, just a view for now would be so helpful even if it's just naturals not even they. Yeah.

15:23 Rodrigo Cabrera: Yeah, once a month, they receive the the projections for the next three months or something like that. I think that will be a It really helpful. And and the yeah, also, I don't know, sometimes the crystals like the boss wants to see the where we stand on cash. And, and he, instead of going to to outdated data from from looker, he can just receive once a month.

15:56 Rodrigo Cabrera: A, How did we close in terms of cash last month or something that I think, yeah, that sharing or automatic publishing of reports, it will be really interesting.

16:11 Emma Sjöström: So would it be valuable to? So one thing is standing a summary or like a static

16:14 Rodrigo Cabrera: that's,

16:16 Emma Sjöström: snapshot would it be valuable to? I'm just curious about sharing a link to the actual interactive dashboard. No editing, right? But just viewing rights. So, like a link so that they can look in the browser and start valuable.

16:31 Rodrigo Cabrera: Yeah, I think both help their snapshot and then here's a link for more details

16:32 Emma Sjöström: Yeah.

16:38 Rodrigo Cabrera: or something that I don't know if that, I don't know how it is with a with users and licenses. I don't know what's a Was aligned there. but,

16:49 Emma Sjöström: Let's talk about that now. Just trying to figure out what we like.

16:53 Rodrigo Cabrera: Yeah.

16:54 Emma Sjöström: Valuable in general. Yeah.

16:57 Amanda Mitt: If has access but I think for the regions. Yeah, just a view for now would be so helpful even if it's just naturals not even they. Yeah.

17:02 Emma Sjöström: Yeah.

17:05 Amanda Mitt: Like, first thing would be already helpful. Then forecast eventually just a view. I think it's fine.

17:11 Emma Sjöström: And then you say just a view just like the snapshot or like actually seeing the Link or Sorry, link.

17:19 Amanda Mitt: there's nothing because I feel like Yeah, I don't know, we want them to be responsible for the forecast as well,

17:22 Rodrigo Cabrera: I, I

17:26 Amanda Mitt: right? In caliber they will input forecast. So if you want to Yeah.

17:33 Rodrigo Cabrera: I think ideally, I think ideally that. Forecasts from From Global into Pump somehow, we'll figure it out but maybe,

17:41 Emma Sjöström: Yeah.

17:43 Rodrigo Cabrera: okay. They have they receive a snapshot of the forecast. And if they want to go into more detail on, okay, I don't know that. The forecast looks weird and they can go into that link and have the the details of all of the transactions that are impacting. That somehow, I don't know.

18:02 Rodrigo Cabrera: Hey,

18:03 Emma Sjöström: Just read and they could filter. They like use filters. They can do stuff, but

18:08 Rodrigo Cabrera: it's

18:09 Emma Sjöström: they can't really edit the dashboard or change anything.

18:12 Rodrigo Cabrera: Yeah. Yeah.

18:13 Emma Sjöström: Yeah. Something like that. I'm just trying to understand, like, We have options, right? So trying to just narrow out, what would be valuable To you guys in terms of the collaborative, aspect of it all.

18:31 Amanda Mitt: Yeah, I'm thinking like yeah.

18:32 Rodrigo Cabrera: Eventually. Yes.

18:34 Amanda Mitt: I feel like, For now that would be fine. But in the future, if like, Wow, we continue with Discoveration and then of course, I know we like things. Yeah, I'm not, I don't know, I'm just talking about needs. I feel like we would want them to even have full full access your palm like and edit stuff.

00:00 :

18:53 Emma Sjöström: Oh yeah, yeah.

18:55 Amanda Mitt: Yeah.

18:57 Emma Sjöström: That's super interesting would love to speak more about that.

19:00 Amanda Mitt: not everyone, it wouldn't be like, it wouldn't be like

19:00 Emma Sjöström: Like yeah.

19:04 Amanda Mitt: Thousands of users, but at least one from each region. So, let's see. Maybe 10 maximum.

19:08 Emma Sjöström: That would be. Super cool. Yeah, that's definitely doable. And in the future for yeah. 100%. So if if you just look a little bit like yeah, so you mentioned look right. So what do you like and dislike about looker? and the way how you pull data and how you can use, The result sort of to convey.

19:44 Emma Sjöström: Yeah.

19:46 Rodrigo Cabrera: example, we don't have the bank accounts details. So, okay, we know it's in in the US non-aging in USD, but we don't know in which bank. So that's a big

20:17 Emma Sjöström: Approach. Yeah.

20:18 Rodrigo Cabrera: Yeah it But if in Palm of course, we already have all of that data. So somehow leveraging it A I don't want to bring up the indifference again a but that's also I a good one like that investment the interest and not that it's it's also quite Quite good as a possible dashboard.

20:45 Rodrigo Cabrera: A course, we don't have the data yet, but It's yeah.

20:52 Emma Sjöström: It can be done.

20:56 Amanda Mitt: Yeah, for me, it would be cool like to. For example, I if I could Yeah, just dreaming big. I could add the liquidity planning to practice, I didn't even need to ask you anything. I want to just do yeah, add this new data set for Liquidity planning Palm, and then I can play more with different.

21:14 Amanda Mitt: Yeah, not just with data from Pound. But for example, adding the plan,

21:20 Emma Sjöström: So, what?

21:21 Amanda Mitt: That I'm doing looker as well. We cannot. Yeah.

21:24 Emma Sjöström: Yeah, and the plan like well that come from just you you playing around.

21:28 Amanda Mitt: Yeah, it would be like, CSV, for example, from Annaplan. Of course, we could do it direct connection eventually. I think it's not really the goal for now, but that's something that would be cool. and I think yeah, like for example just having yeah, like yeah when you think about looker power bi, I think, What annoys me now in lucre is that we cannot connect to external data, but we will have this functionality soon.

21:55 Amanda Mitt: So for example, it's just yes. Internal data, let's say. But for example, if I wanted to connect with a website, I don't know. could I do that, you know with for example FX rate or news, something like this because for example, with power bi I know that we can Connect even with.

22:13 Amanda Mitt: Yeah, we can you can connect it with internet, for example, or Really. Customize a lot. And look at yourself but I think it depends on your license.

22:21 Emma Sjöström: Go.

22:21 Rodrigo Cabrera: if we wanted to comment like the effect,

22:24 Emma Sjöström: Gotcha, gotcha.

22:30 Rodrigo Cabrera: A. How is it called? A website or whatever. We get, our FX rates, everything ever, something like

22:38 Amanda Mitt: that. And just to have that development or of the effects that will be a really good dashboard. And I think you, you guys could probably already do it with the date that you have. No, because somehow you're getting that effects somewhere.

22:55 Emma Sjöström: Yes.

22:56 Rodrigo Cabrera: so that I think that will be Quite good to see that development of the different currencies of the different level of the currency pairs would be quite nice.

23:10 Emma Sjöström: Yeah, gotcha. Make sense. So I'm just gonna jump back a little bit to just like visually or what's helpful. Very open-ended bear with me. But like what would make a great report or dashboard for you? Like, what would you expect to be able to see or do If you so take one of the reports you have already, for example.

00:00 :

23:38 Amanda Mitt: No.

23:39 Emma Sjöström: What would make it like, amazing?

23:47 Rodrigo Cabrera: and I think, Yeah, a lot of what we have, like balances by currency by entity by bank. And adding that to that like the the forecast on on those balances, where we expecting them to be in the next the week in the next month and the next three months or however long we have data.

24:14 Rodrigo Cabrera: A And then I don't know. They exposure by bank. For example, that it's basically the same view but then in percentages and if we call that to that, the the Investments, for example, in how that affects the exposure by bank or something that I had, I want to share, let me see.

24:39 Rodrigo Cabrera: I can pull up a report that we already have.

24:44 Emma Sjöström: Yes.

24:59 Rodrigo Cabrera: For example, this is a report that we have on on looker.

25:04 Emma Sjöström: Right.

25:07 Rodrigo Cabrera: If it wants to load, like a the Bad part of this one is that it's not live data. It's usually at the end of the month and we are missing a lot of of the details, for example, but here we have like, the, the liquidity development. How much are how much are cash has changed in the, in the, I don't know us.

25:33 Rodrigo Cabrera: I think 13 months. It's it's this one here. It involves not only cash but also investments. A, how like that split by currency. So we have all of the like, like the main currency. Like, for example, here we have the top four, current it's plus others. Instead of having, I don't know, 35

25:49 Emma Sjöström: Yeah.

25:54 Rodrigo Cabrera: currencies. So this is also like I still there that we can add a, These ones are for investments. For example, the the interest that we have how much we are investing a Yeah, these are other like calculations that we can have on fx, that's something else. But different, for example, how is it here we have the the balance that by the main ones, but also we are interested in all of that smallest ones, right? So, how are the other currencies or the smaller experiences developing here? We can quickly.

26:31 Rodrigo Cabrera: See that something is going on with China. The balance is to be. We got a decrease in somehow. In this, for example, I was working on this one. Still I, I couldn't manage to, but it's like every currency. Of course you will be nice very cheap in in a graph or something, but it includes the actuals in

26:45 Emma Sjöström: Mm.

26:51 Rodrigo Cabrera: the bank account lost the forecast. So, this is where we stand today and there's, this is where expecting to be in the next and now five, six one. So having these one, also as a graph or as whatever will also be Will also be nice for for every currency.

27:13 Rodrigo Cabrera: Not only the main ones, but having that difference on the top, I don't know. Four, five and in all of the smaller ones, I think. Something that we can quickly see and understand where we stand and take decisions from there. Here, probably you're missing the cash by by entity.

27:35 Rodrigo Cabrera: That it's something that Yeah, it's here. Somewhere a balanced by currency by bank. It's also by entity.

27:40 Emma Sjöström: Yeah.

27:44 Rodrigo Cabrera: It's also that here different. I think it's the development development of the entity which is quite good and this one of today which is nice. So a lot of them are already building somehow A But of course we had to go through you and it's not something easy, maybe we got to change something or we want to maybe have by account of top or something else.

28:13 Rodrigo Cabrera: So it's a quick thing that we can we can change a Then I don't know. I again, I'm going back to investments but also we have this investment like, summary for example. So we can see how, how many investments do we have. The projector interest that exposure by bank, the different products that we have a how that they development of the day of the rate of the investment, just follow.

28:43 Rodrigo Cabrera: So be quite nice for for effects, I think, and Just different different ways of viewing. When is it maturing in which week? And maybe that's something that that we we didn't have in, We included it yesterday because this became a priority for example. So now maybe in the next in the next month this will change and we will have a different project priority and I can quickly just add another graph here.

29:15 Rodrigo Cabrera: And and I think it will be really nice if you installed it's something like that. So build like our own depending on on the on the requirements on a specifics day week Of course the the quarterly reports will also be good to have from there that it's basically the same data, just looking it from from a different perspective.

29:40 Rodrigo Cabrera: A. Yeah, sorry Amanda. I don't know, maybe I'm just talking that. We don't know if you have any

29:50 Emma Sjöström: I think it's great.

29:50 Rodrigo Cabrera: other reports, or

29:50 Amanda Mitt: I think from my side is a lot of those reports that we We thought that week we're here. For the yeah. It's quite similar, she would really go set but I think a cool one. so, of course, this is Yeah I think this is really with external data but I think a cash.

30:19 Amanda Mitt: Yeah. The cash by bank concentration, like Rodrigo said, and then I think what would be cool is if we could see for example in All the entities. Maybe not all of them, like Top 10 entities and the forecast like which one is coming up. Which one is coming down, you know?

30:47 Emma Sjöström: Yeah.

30:48 Rodrigo Cabrera: Yeah, that I think is a it's probably the main one that cash.

30:49 Emma Sjöström: Yeah, without the easier than sorry. Just because we're here. I have to ask if

30:54 Rodrigo Cabrera: They?

30:56 Amanda Mitt: Expectation.

30:57 Rodrigo Cabrera: Like cash, exactly. lot of cash actual versus forecasts and in having like the kind of variance analysis, easy, easily accessible, A But yeah, I don't know.

31:20 Emma Sjöström: because we have if you click the graph here you get like this variance. I like in. Yeah, in the past value, maybe past eight.

31:25 Amanda Mitt: Yeah.

31:30 Emma Sjöström: you know, this maybe only Yeah. you, it would be very helpful for you guys to just build your own sort of dashboard to kind of See that. That would be yeah.

31:47 Amanda Mitt: Go back, like if we wanted to see more.

31:50 Emma Sjöström: Of course that too. Like further back. Yeah.

31:53 Amanda Mitt: Best. Yeah. But I think it's more a lot of the future as well. Like just this visual of all the expected companies and balances.

32:02 Emma Sjöström: Yeah, and I'm

32:03 Amanda Mitt: Maybe I think Rodrigo covered all of it mainly but because for me it's a lot of Indian. I need a lot of consolidated data from the financial statements from most of my reports that I think it's more, it's not the goal.

32:20 Emma Sjöström: Sorry. I lost it. I for just the last thing. What was? It's not

32:25 Amanda Mitt: No, because I think when you visited like we discussed a lot for example that we fertilized, we reporting I mean, like, I don't know like this reporting that we have to do externally as well. And that we support when we share the results, we need a lot of financial statements data.

32:48 Amanda Mitt: So It's not something. Yeah, it's from accounting. So it's accounting data. What we

32:53 Emma Sjöström: Yeah.

32:54 Amanda Mitt: could do is like, maximum this cash or investments like concentration by bank. For example, this would help a lot. for this quarterly reporting and then I think maybe something's interested, but

33:05 Rodrigo Cabrera: That's five years.

33:07 Amanda Mitt: nothing else that I can think of Yeah, I think I my cases are more with this external data, not really data from Palm, so data from the plan or data from the financial statements. Yeah. If we could connect that somehow one day and have this as a BI feature as well, would be really cool and I don't think other TMS have this at all.

33:26 Amanda Mitt: Like, of course you can do the API but I think it's a lot of customization.

33:32 Emma Sjöström: Yeah, that's yeah. True, that's an interesting one. A totally hear you. I need to think about that for a few laps but yeah.

33:41 Amanda Mitt: But yeah I don't think like I said he's the priority or the main goal is just like more sharing my perspective but it's not really the main goal. I think Papa

33:49 Emma Sjöström: No, but I am being able to like play around with a data on the same page, like seeing for example, your liquidity planning data. Well, also being able to have that full view of whatever you know, Paul Native data. For example, I get it, it sounds very reasonable. But just going back to Self-served.

34:11 Emma Sjöström: And so, if we go to the reporting page here, just for fun, And there was a button on this page that said something like Create report, or What would you? Expect to happen.

34:27 Amanda Mitt: Like I, for example, I select the table. So the database I think like balances Or. Transactions.

34:36 Emma Sjöström: Just, what would you like to see?

34:41 Amanda Mitt: Yeah, imagine like a different data sources like lookers example as we go to

34:44 Emma Sjöström: Yeah.

34:45 Amanda Mitt: this different kind of Sources and then very broad. Like, as you can see all data, all columns and then you can select from there, I think. So, really from the beginning.

34:55 Emma Sjöström: Yeah. Okay, Gotcha. Yeah.

34:58 Amanda Mitt: I don't know. Yeah, I think that's the easiest one to make sure everyone. Yeah. Rodrigo. Sorry.

35:07 Emma Sjöström: And I was also gonna ask because he mentioned before, let's say you have a

35:09 Rodrigo Cabrera: Yeah, I know. I agree. I don't know. If you have did I well I guess you have different data sources, so you will have the banks, the forecast, the Well, they actually our forecast in the AI forecast. Eh, investments affects whatever the Yeah, we just need to find a way to link it, but I think that that will be On the, on the, on the back end.

35:39 Rodrigo Cabrera: Right? So we can just yeah, grab and drop from the different tables nor data sources.

35:52 Emma Sjöström: report and then you'd like to just apply another currency or you'd like to make small durations to the report would would features like coping and existing report and build on top of that. We help example.

36:05 Amanda Mitt: Yeah, I was gonna mention that, like, I think this would be super cool. Like, if we could duplicate this one, for example, this page, with cash, and then edit,

36:13 Emma Sjöström: Uh-huh.

36:17 Amanda Mitt: I don't know why, it's usually it loads first time with me.

36:20 Emma Sjöström: I, Think there's something up with balances.

36:26 Amanda Mitt: Okay. Yeah, but like, if there's three dots here, had something like edit or Copy. Or duplicate the page like in the reporting. Something here, maybe we could. Or. Dynamic, filtering. Like, for example, I go to the cash balance one. What's it like? I know, wait. I want to. Kind of deep dive.

37:03 Amanda Mitt: A bit.

37:05 Emma Sjöström: Gotcha. So, if you would see, so what would if balances by bank? What would the

37:06 Amanda Mitt: click on it, you know, and see a table that was, that shows the data or yeah, kind of you know this feature

37:14 Rodrigo Cabrera: Yeah, I think yeah that ability to drill down. I think it's quite

37:15 Amanda Mitt: or like, It's real down.

37:20 Rodrigo Cabrera: It's quite good. It's quite important. Yeah.

37:22 Amanda Mitt: Really sorry.

37:28 Emma Sjöström: drill down be like into the individual? Trust.

37:32 Rodrigo Cabrera: Today individual account, for example.

37:34 Emma Sjöström: Count. And yeah.

37:35 Rodrigo Cabrera: Have you? Yes. And then we can drilled out into the

37:39 Emma Sjöström: Yeah.

37:40 Rodrigo Cabrera: Or yeah, by currency or by account or by a yeah, I guess depending on on what we're looking at. We can select the next drill down.

37:56 Emma Sjöström: Makes sense.

38:00 Amanda Mitt: Yeah.

38:00 Emma Sjöström: So Grace. So let me just look at my little question sheet here. I don't know how much I've used, but I know because Kristen has been obviously building things for you and I get a you've had a lot of conversations. But like in terms of, so we are going to revamp sort of the visualized like the charts and everything a little bit as well.

38:30 Emma Sjöström: So you've mentioned the pivot table already. Other other like crucial. Charts or anything like that, but you feel like it's missing that you already know that you. Probably would need.

38:47 Amanda Mitt: Mmm. I think. Rodrigo, probably needs more. More on this cash balances. Right. But I think we're sometimes like afraid to be more like a painting. Yes. And as too many details, right? But I think Or Julia as well. She was asking me this top 10 bank accounts. Balances. I don't think we have it.

00:00 :

39:08 Rodrigo Cabrera: Yeah.

39:11 Amanda Mitt: Yeah, it's hard.

39:11 Emma Sjöström: Oh so like something that continuously just displaced the 10 largest balancer? Yeah.

39:17 Rodrigo Cabrera: Yeah, or the top five depending on the day. What do you want to see? But if you

39:22 Emma Sjöström: Okay.

39:22 Amanda Mitt: Yes.

39:24 Rodrigo Cabrera: were asking about which graph do we need like which graph type I don't think that like that the main the most common ones bar chart, maybe it's pie chart, they didn't and

39:37 Emma Sjöström: Thing.

39:38 Rodrigo Cabrera: Line, I think should be enough of course if there are more extract and once we can use them. But yeah, we can we can start basic as long as we're able to. I don't know, compare within the same graph and multiple different line. For example, if we want to compare to accounts or to, or, or fork effects, or

40:01 Emma Sjöström: Yeah.

40:03 Rodrigo Cabrera: something that a Yeah, I think today. There are so many that we will. I don't know if you go to excel, you can shoot from 20, 30 different types and we don't need the first that many, but maybe I don't know the most common ones.

40:20 Emma Sjöström: Yeah.

40:21 Rodrigo Cabrera: Will be.

40:23 Amanda Mitt: True. Yeah.

40:24 Emma Sjöström: That makes sense.

40:25 Amanda Mitt: We don't have any complex. Visuals, I think.

40:35 Emma Sjöström: Well, that's bad. Just wanted to sign it to check if there was anything else but I hear the pivoting would be and I

40:41 Amanda Mitt: Buttons would be cool as well if we could add them buttons. Like

40:45 Emma Sjöström: What would you? What would the buttons do?

40:48 Amanda Mitt: For example sometimes I feel bad because like here would want to add company. For example, like Something that would for example I'm creating a report for Christoph and I want him to yeah select like maybe a quick filtering button, you know?

40:59 Rodrigo Cabrera: Process.

41:07 Amanda Mitt: so he can click and select complete, you know, like in power bi usually I think you can let like,

41:15 Rodrigo Cabrera: like if we have like the the overall view of the of the company, if we have four

41:16 Amanda Mitt: Yeah.

41:21 Rodrigo Cabrera: different buttons, one for global one for apex, one for a minion one for America, for example, so you can quickly filter A

41:31 Emma Sjöström: Oh okay, so quick filters. Quick quick action. Sort of

41:33 Amanda Mitt: Yeah. Yeah, something like your Christian built. This one.

41:36 Rodrigo Cabrera: You know. I think that's what you meant. Yes.

41:38 Emma Sjöström: Oh nice. Okay yeah, go check.

41:40 Amanda Mitt: Yeah. Maybe another name. Sorry.

41:46 Emma Sjöström: No.

41:46 Rodrigo Cabrera: No. But yeah, in power bi they are called buttons and you can personalize

41:51 Emma Sjöström: Yeah.

41:52 Rodrigo Cabrera: it's a different view, for example, the term button, so, Yeah.

41:58 Emma Sjöström: Gotcha, gotcha. Now I understand you loud and clear. All right. Good and just like those filters. Their behavior currently mostly is like they control older charts of the page, right? I think. The top level fortress that you say that like the Day Range, Entity currency.

42:19 Amanda Mitt: Yeah, that would be nice as well if we could. Have a lot of options there.

42:24 Emma Sjöström: Yeah, so like I'm imagining just Oh, but these filters are for these charts only, and these filters are for that part, or stuff like that too. Or

42:34 Rodrigo Cabrera: I think I think it's really good, if if they feel their supplied to everything, but for a specific graph, you can

42:40 Emma Sjöström: Huh.

42:42 Rodrigo Cabrera: select Don't apply The fields are in

42:46 Emma Sjöström: Okay. So more like yeah, yeah.

42:49 Rodrigo Cabrera: So yeah, can I share my screen? For example, here, okay. This Google sheet. So, for example, here, we have like this filters, but for example, in this graph, We have selected this include hidden or field filter data. So we it shows whatever like here is just a filters here is without any filter so first specific cases that you will want to see a historical data.

43:30 Rodrigo Cabrera: For example, instead of just a one like today I think called be good, of course it's case by case but yeah the filters applied to

43:34 Emma Sjöström: Yeah.

43:40 Rodrigo Cabrera: everything that's needed but if we could remove a specific Parts. I think that that's good.

43:49 Emma Sjöström: Like a specific maybe actually a specific filter and for that chart that's like the time period, for example, but that's static and not affected by the other global filters.

44:00 Rodrigo Cabrera: Yeah, or

44:01 Emma Sjöström: Yeah.

44:04 Rodrigo Cabrera: I think in even in Lutherans, in local might be better. Okay, gives you the option. So to have a filter and to select which charts, you want that filter to apply?

44:18 Emma Sjöström: Yeah.

44:18 Rodrigo Cabrera: I think it's better. Which you want that filter? Not to apply because you want the majority. Yeah,

44:27 Emma Sjöström: No makeup.

44:27 Rodrigo Cabrera: you get the idea. Yeah.

44:29 Emma Sjöström: Culture, love them here.

44:31 Amanda Mitt: Mm-hmm.

44:32 Emma Sjöström: Nice. Okay, but I'm hearing, there are some pivot table filters buttons, some like you want some creative flexibility right to play around with stuff, the data and components you want the way to perhaps, I guess, build both larger dashboards, but also a way to quickly do sanity check or Explore some data, just like whenever the need arises.

44:58 Emma Sjöström: and for the collaborative aspects of it all at least some sort of snapshot and then maybe like a link so that they at least could view At some point, like I don't know if that will make it to the initial scope of self serve. But like unless you tell me it's crucial, right? But I think that's something that we could do move further down.

45:27 Emma Sjöström: with some like, Potentially restricting, like who can edit what? And so on if if that's a thing. People. Anything else? Did I miss anything crucial for you guys? And of course yes the data sets themselves will iterate on as well. And I saw your point Rodrigo's on like, perhaps seeing your actuals and then your forecasts next to them.

45:55 Emma Sjöström: Like those sort of merge data sets, if you will between actuals and forecasts could be, Valuable guys.

46:06 Amanda Mitt: Now, if you covered, Yeah, it's possibility to add external. They like combined mentioned. No. Okay.

46:13 Emma Sjöström: Yes.

46:15 Amanda Mitt: Yeah.

46:15 Emma Sjöström: Yes, you mentioned. I'm just like a little bit, like, maybe for the pushing that a little bit further ahead right now, that's because I did, or did I get you

46:21 Amanda Mitt: Okay.

46:23 Emma Sjöström: wrong? It wasn't like urgent or crucial for this. Yeah.

46:26 Amanda Mitt: No. Yeah, correct.

46:30 Emma Sjöström: But that's cool. Good point. Nice.

46:33 Amanda Mitt: I think. That's a lot. Very very we feel very spoiled.

46:41 Emma Sjöström: Very cool.

46:42 Amanda Mitt: In power, bi, you can like look as well. Like you post Yeah, you make public like here. It depends, like in the license but I think you can also make public not, that would make completely public. But yeah, you can just share like this link and yeah, people can view.

46:59 Amanda Mitt: I don't know how hard it is to do that. Was that what you imagined? Or you imagine like some Something like in that people still need to have a login or like, just a page, they can access. Yeah.

47:12 Emma Sjöström: And another depends on your needs, right? maybe some sense of a login if it's financial, but at least On employees, could this? But we can dive into nitty gritties of that later. It was more something we're thinking about, yeah. So interesting to hear your thoughts as well.

47:41 Amanda Mitt: Because I don't know if it's like, it would be an email, or if it would link, I don't, I don't know. We can also ask the teams what they think if they have examples or right, I don't know.

47:54 Emma Sjöström: very,

47:57 Rodrigo Cabrera: Hey Venice. Flag.

47:59 Amanda Mitt: yeah, even like

48:02 Rodrigo Cabrera: Whatever. I see. What

48:06 Amanda Mitt: True.

48:12 Emma Sjöström: All right, do you feel like there's something missing that we haven't talked about, for the For like reporting that you capabilities that you need. Very nice.

48:27 Rodrigo Cabrera: We are all good.

48:27 Amanda Mitt: Thank.

48:29 Emma Sjöström: Thank you.

48:29 Rodrigo Cabrera: Thank you very much. I know he was a lot. Sorry.

48:36 Emma Sjöström: no, I I

48:37 Rodrigo Cabrera: But haven't we have the note taker here so she'll be all good.

48:40 Emma Sjöström: Yes, I will be all good. Don't worry. Ai is very useful this way. So this was super valuable by the way, it's really helping me, you know? Very fine. What decisions to make moving forward.

48:56 Rodrigo Cabrera: I just something quickly before we go, I just try to schedule and report from from Luca. So we get a snapshot in PDF of the actual report, but we also get the

49:05 Emma Sjöström: Yeah. Yeah.

49:11 Rodrigo Cabrera: link of you this data in Lucas. So the team members can go in and I think Potentially drilled down on here if they have a question. If they look at here here it looks quite low the Internet. For example they can go here and drill down on that specific data.

49:34 Rodrigo Cabrera: Yeah, I think that might be good. Yeah, sorry. Now I'm done.

49:41 Emma Sjöström: The drill down capabilities. I, I know Will We are looking into as well. How to potentially like support those drill down use cases because I also reckon there.

49:51 Amanda Mitt: Listen.

49:51 Emma Sjöström: They're quite useful.

49:53 Rodrigo Cabrera: Yeah. Yeah.

49:55 Emma Sjöström: Yeah. Super cool. All right. I'll bring this feedback to the team and we'll have some internal discussions and, you know, Update, you guys whenever we have something oh, and the batch uploads, apologies, without taking some time. We just have some like interesting working

50:15 Rodrigo Cabrera: Okay, it's okay.

50:16 Emma Sjöström: out into. Yeah. I'll let you know as soon as soon as possible.

50:21 Rodrigo Cabrera: Perfect, thank you.

50:23 Amanda Mitt: Thank you so much, super cool. Just take you.

50:24 Emma Sjöström: so,

50:24 Rodrigo Cabrera: Thank you, Emma.

50:26 Emma Sjöström: Yeah, bye.

50:27 Rodrigo Cabrera: Bye.