Getting more wins from your data – with Nicholas Mann

Nicholas Mann, founder and CEO Stratos Consulting, has got the best out of the data for hundreds of companies. He has helped data and analytics leaders go from siloed, heterogeneous data source to a  modeled data warehouse and analytics platforms. In this awesome analytics episode he shares some of his experiences:

  • Getting companies on their data journey
  • The importance of FP&A not just staying in their lane 
  • Inner workings of how data is impacting the rest of the business 
  • From deep finance domain expert to understanding the business
  • FP&A Data Maturity Assessment 
  • When Business Grows – how do FP&A teams grow with them?
  • Data Stewards and how they work 
  • Creating a finance and FP&A Center of Excellence 
  • Why I favor the Snowflake ecosystem 
  • What you should hire consultants for – and not hire them for when it comes to finance and data strategy
  • People in data: change management challenges
  • Using AI for variance analysis 
  • About me: rare eye condition achromatopsia and how I have overcome the limitations 

Notes

Full blog transcript below 

Glenn Hopper:

Welcome to FP&A Today, I’m your host, Glenn Hopper. Our guest today is Nicholas Mann, founder and CEO of Stratos Consulting, and a leading expert on data and analytics. With over a decade of experience as a technology consultant, Nico has helped FP&A and IT and data teams across industries. He’s worked in fields including life sciences, manufacturing, retail, and financial services. He previously served as enterprise applications architect at Akebia Technologies, where he honed his deep technical skills, integrating diverse data sources into cohesive platforms. Nico is a passionate advocate for the Snowflake ecosystem and excels at helping organizations maximize the value of their data infrastructure. Please join me in welcoming Nico, who will share his insights on the modern data stack and how companies can harness the power of their data. Welcome to the show, Nico.

Nicholas Mann:

Thanks, Glenn. Happy to be here. Excited to have a good discussion with you today on data and analytics.

Glenn Hopper:

Yeah, really looking forward to this. And for our listeners you and I were introduced from an another data geek who I just put in the same fraternity that you and I are in. Nathan Bell, who I’m gonna say, I’m gonna throw a challenge out to you. Nathan’s episode is the most popular episode since I started hosting the podcast. So our goal is to try to beat that one and put, take Nathan down a, a, a notch or two, you know,

Nicholas Mann:

Challenge accepted. Nathan, it’s on <laugh>.

Glenn Hopper:

<Laugh>, I’ve got a million questions for you, and these always go so fast. So let’s, let’s go ahead and just dive in. So first off, tell me about your journey and, and kind of what inspired you to start Stratos Consulting, because I understand you initially focused on the office of the CFO and now you, you’ve expanded that a little bit. So tell me a little bit about your journey and, and what you’re doing now.

Nicholas Mann:

Yeah, definitely. So I was very fortunate to come out of college in a field that I was actually good at, which was very surprising. So I came outta college with a degree in finance and information systems, and I knew I was never going to be this investment banker in investor. And on the other side, I was not a deep coder. I actually failed my visual basic test in college. So, which was much to my dismay, but it was one of those things where I said, okay, well how do I blend these two degrees together? And so I was very fortunate to get my first job within technology consulting that did exactly that. So I worked for a company called Peloton Consulting Group, where their focus was with the office of the CFO and deploying financial applications for enterprises to do their budgeting and forecasting. So right outta school, I was open up to this new era of, oh, there’s data involved in companies, especially within the finance teams that I knew nothing about that was never taught in college.

It wasn’t something people said, here’s a career trajectory you go. It was always, oh, big four consulting. Or you go to these banks, but never this very niche industry to say, Hey, people are using data and analytics at these companies in general. And so I really embraced that and had an opportunity to work with a lot of different industries. And then I started to get more into business intelligence. BI was becoming a big thing at the time. A lot of these finance teams said, Hey, I have all this data in my enterprise performance management, financial planning software. How can I do more things with it? How can I blend it with other data across the organization? And so certainly got a lot more into that. Got to see what some other companies were doing and help other companies get there along their data journey. And then, quite frankly, I got to the point where I was burned out.

Consulting is a very intense culture and as much as I learned from over those first five years, I wouldn’t be here today without them. And I made some incredible relationships. It was incredibly time consuming, mentally, physically, everything associated there. And then I had the fortunate opportunity, one of my past clients, he actually moved and started a new job at a place at the time was Carex Biopharmaceuticals and eventually was merged with Akebia Therapeutics. And he said, Hey Nico, we’re looking for a technical person. You can kind of invent this role however you want it to be. I figured you could help the various teams here from finance to commercial r and d across the organization and really help them with their data needs. Do you wanna have a conversation? And of course, really loved the guy. He’s still a good friend today. And so had that opportunity then to meet with his boss, get involved in that culture.

And I really, really liked it and what their vision that they were trying to do there. And yes, I had the opportunity to start to work with a lot of the latest data and analytics cloud technologies. So you think about at the time, now, this is seven or eight years ago, not all companies were bought into the cloud. And that’s still the way it is today. So I got to now work with some of the latest data integration technologies, the latest reporting, financial planning applications in the cloud. And so I got a amazing experience and of course, growing business acumen within the pharmaceutical industry from an internal perspective, not just the outside, not just being a consultant. So I got to see the true pains that consultants see a lot of the time, but they don’t necessarily see when they’re not in those internal conversations.

And so from there had an opportunity to make a lot of really incredible relationships there and help out in many ways that I could. And doing things like integration work, managing the commercial data warehouse, helping them with, at the time they’re on host analytics for a financial planning platform. So being the admin of that and really just bringing data across the organization and automating it in as many ways as possible. Because as a lot of you probably know, there are a lot of manual processes that get overlooked, especially within finance. And, and so that’s a long way of saying, Hey, I went from consulting to the corporate world, but I found that the corporate world was a little too slow for me. People had all these visions and ideas, but nobody wanted to execute against it. And it was just, I’m somebody who likes to move very quick and bring value and learn and grow and work with amazing people.

And that was great for a while. But then it got to the point where that was no longer the focus. And our head of FP&A at the time, he said, Hey Nico, I’m going to another company. I’m gonna be a VP of fp and a over there, just wanna let you know this is my last day. And then the week after that, he said, Hey, I’m looking for a financial planning tool. Can you gimme a recommendation? You know, you’ve worked with Oracle S Space, Hyperion, planful, adaptive, all of these different technologies. Can you give me a recommendation? And so as a friend, I said, yeah, I’ll draft something up for you. Approached it no different than I would any consulting engagement. And gave him a kind of a writeup based on the pros and cons of his requirements and said, Hey, for you, it seems like Oracle EPM Cloud is the right thing for you.

Did some demos with him to show him what it was like. And he’s like, well, this is all great, but can you actually implement it for me? And I think, I don’t know if he was joking or not, or if he was being sarcastic. And, and so I thought about it and I said, yeah, I could probably do that for you. And so it was that, it’s, it’s funny how timing is everything. Where I was kind of at this point in my career where I said, Hey, I kind of wanna go back to something else, or back to consulting or something new that’s fast paced. And this opportunity popped up. And so I formed an LLC, went through the processes of the contract, everything there, had my first project with them, signed that, and then gave my notice to Carricks at the time. And then kept them as a client.

’cause Of course they wanted to still use my services to support their environment. I’ve made a lot of great relationships. And really the biggest thing was, hey, I had learned a lot in consulting and then I’d seen the pains of the corporate environment. Now I wanted to bring this back to consulting where I could say, Hey, let’s do consulting. Right? Again, this isn’t about hypergrowth. I don’t need to double our revenue every year, bring in all this headcount, bring all this notoriety to myself or the business. I was never the intent by any means. It was let’s work with as many clients as feasible. We can grow organically, we don’t have investors. And then that way we can focus on the culture that we want to build here at Stratos, which is around, hey, people are excited to come to work. They enjoy the people they work with.

They don’t feel like they’re burning out. And of course the ultimate thing, they’re bringing value to the clients and they enjoy working with these clients. And I’m fortunate to say we’ve had an incredible team, we’ve grown over the last six years or so, and certainly made some transitions. And it’s it’s been quite the journey. And so there’s a little more to the story there though, is that when I first started Stratos, as I said, the focus was on the office of the CFO and FP&A and doing financial systems and data just specifically for those functions, even though I had more experience across the enterprise as it related to Carex pharmaceuticals. So within, call it, the last three years, we’ve made the transition to focus more on the data and analytics space across enterprises because there’s so much value you can bring in finance, but finance needs data from other parts of the business. And other parts of the business need finance data. So we wanted to focus on how can we focus more on the enterprise label for level for data and analytics and bring that value to different stakeholders in each of those functions. So you can see this progression over time to now get where we are today.

Glenn Hopper:

Your story is so interesting because there are so many parallels and I look at what’s happening in finance and FP&A today. And I think about when I started, so I, my, my first finance gig, I was fresh out of business school, so I was a good generalist, but I wasn’t a finance expert back then. And my first role, I was, I actually didn’t roll up to the CFO I rolled up to the COO because he needed you know, basically he needed someone to translate financial speak into operational speak and, and vice versa. So I was in this sort of hybrid role where I was gathering all these operational metrics, but I was using them to forecast our, our purchasing needs and our inventory levels and, and maintain all the things that A COO looks at. And so my evolution through finance came up really where, because I was, I, I spent so many years at the start on the operations side, it was realizing I knew more about the data, the metrics we were track tracking on the ops side, and then I was just getting what finance was feeding me.

But I think that informed my whole career because I was used to working with all this data that was became, you know, I, I started to see firsthand what the levers are and how these metrics impact the financials. So, and I actually in that role, ended up running the company’s first BI team. This, I’m dating myself a bit here, but this is the early two thousands when this was happening. But that has informed my whole finance career. And I, as time has gone on, because I’ve been so adamant about systems and technology and data, like the amount of time I spend today on actual finance work is a lot different than, I mean, it’s a lot less than what I spend on systems, technologies, data KPIs, and just in organizing all of it. And I really think, and this is just my view, but the, you know, 15 years as a CFO and going through multiple companies, this was my approach to it there.

And going through multiple ERP and multiple systems to try to, to gain data. I think finance and operations and all this data are, are hand in hand. And you would love it if, I would love it if all finance people had this deeper understanding of BI and even data science. And it’s just, that’s what’s worked for me. Now, there are still needs, obviously for the straight accounting and the, the true fp and a, but I think there’s a marriage between those now and I, I see the integration there. And so I’m an, I’m an advocate for why FP&A pros really need to know the BI and data science. And with yours, I mean, I know you’re more heavily leaned into the data side, especially now that you’re not just the office of the CFO that you’re looking across the company. But what are your thoughts on the role of BI and data science for FP&A professionals?

Nicholas Mann:

Yeah, it’s one of those things that I think for a long time, FP and a people finance people, they stayed very closely within their domain and said, Hey, I’m really good at figuring out how to do the budget. I probably have all my spreadsheets to pull all these things together and then I’m just gonna follow a good process, build relationships, and grow from there. And I think that worked for a long time before BI data science analytics became more enterprise level, call it 10, 15 years ago, finance never thought about, oh, I can have my own person who understands analytics or understands the data components in my space specifically. That’s an IT function and I have to rely on it. And there are pain to work with. I was an it, so I can say that it’s true, but it’s one of those things where now that the technology exists, I think for people to grow, they need to embrace exactly as you described in your career, embrace some of these other data components that actually drive and help run the business.

Because if you stay in your lane and you’re just focused on fp and a and just doing that, that’s great. You’re gonna, you’re probably gonna go really far ’cause people know those need those roles. But I think a lot of ambitious people have this vision for, oh, I want to be a CFO of one day. And that’s amazing. And the, the best CFOs I’ve ever worked with, well, they have a broader understanding of the business needs, not just at a high level and how to do that from a budget, but they’ve been there, they’ve taken on responsibilities and seen those inner workings of how data is impacting the rest of the business and the pain that people have to pull some of that data together for some of the most, what you would think are rudimentary questions like how, what are my sales numbers for the upcoming forecast?

What is my revenue for the last quarter? Oh, well that does that in factor, factor in all of these management adjustments or other elements that would come into this normally, oh, well, no, I have to go pull these from different places. So until you’ve actually lived that and done that, it’s hard to get a full appreciation for how valuable that skillset can be and will be long-term from a data perspective for, for fp and a. But I would say that applies to any other leaders within different functions. I mean, we’re in the era where generalists plus, if you think of that T model, okay, I’m deep in something, but I’m broad a lot of, in a lot of other ways, that’s gonna take you so far in a, in a finance or FP&A role because you’re not someone who just says, oh, well that’s not my job. You say, you know, I probably have a pretty good idea of how to do that even if I haven’t done it before. Let me give it a shot, see if I can help you out. Let me go get the data you need. And then people are gonna see you as an advocate and want to advocate for you. Like, wow, they were really helpful. And that takes you farther into your career than, than so many things as well too.

Glenn Hopper:

Yeah, and that’s such a great point because when I started my career in FP&A back in the stone age it was, there were very much these data silos and every, everybody was protective of their information. Like, like I said, I was worked for the coo so I had to fight tooth and nail to get access to the financial data that I needed from the controller who was just, you know, he was hanging onto it. But since then, you’ve seen the whole concept of business partnering where you have embedded data scientists or embedded FP&A people within departments and within different organizations. And really I think the evolution of the role of the CFO has gone from you used to be able to stay in that ivory tower of finance and accounting, and you would say, you know, I am a, a mile deep on, I know every GAAP rule.

I know every s sec, you know, I know all the, the components that I need to of finance. I don’t care what we’re selling. I don’t care what the widget is, just I’m reporting on it. But the nature of, and I think because there’s so much more data and the people realizing the power of it, you’ve had to expand. You couldn’t just be that, that you know, super deep domain expert, you had to understand the business. So I think, you know, it sounds like you and I have seen this sort of same evolution in the, in the, in the profession. And it’s, I I think it’s making it a more powerful and a more understood profession too. And the more we can embed ourselves across functions in an organization, the more we move away from being seen as that cost center, you know, IT and finance both get labeled with that of what value, you know, you’re, you’re just a, a necessary expense. But we’re showing, and as we get better and better at using our data, we’re showing that we have increased value in decision making and prediction and, and and explanation of, you know, why we hit or missed our numbers and what we need to, to do to drive them.

Nicholas Mann:

And, and I want to add something else to that point too, because data as a whole, we use the data terms, data and analytics. Wow, there’s a lot of things that can go into that. And from a business perspective to how you analyze the information, I think the value related specifically to FP&A is you need to focus on, well, where, where’s my, I hate the term low hanging fruit, but I’m gonna use it here. Where are my quick wins in the sense, because you don’t necessarily need to say, oh, I need to do, go do all these things with ai because that’s cutting edge. You need to look and say, well, where am I spending my time on data tasks that could otherwise be automated? And I’ll give you a perfect example. And one of the companies I was working with, there was a, a head of fp and a, and it was an fp and a team of four.

It wasn’t huge. He told me he was manually downloading data from their Oracle ERP, he was then putting it into Excel. He was doing some pivots to make sure it aligned. He would cleanse the data a little bit, maybe enrich it with some additional attributes and then load it into their financial planning system to do their budget forecast. So I immediately was like, what are we doing here? This is something we can automate within a week or less, just so you’re not doing this on a regular basis. And so that’s a long way to say, data doesn’t need to be this wow pie in the sky vision. I need to accomplish all of these things. Look for the things where you’re spending the most time as an FP&A professional and start questioning why. I think so many times people are brought into a company and maybe they’re junior mid-level, and they’re, it’s like, Hey, here are your tasks.

You need to go do these things. Okay, cool. Do them diligently. You get faster at doing them, faster at doing them, but you need to take a step back and say and ask, why am I doing these in the first place? And not only why is there a better way to do it? And then, oh, let me do some research to see if there’s a better way to do it, because maybe you don’t have the internal stakeholders to support you in that journey. But when you start bringing that kind of value as little as you might think, it’s, those are the game changers. Because when organizations happens all the time, they go through transformations where they go through layoffs, they go through reorgs. And when they’re choosing people who to say who to keep and who to stay, if you’re someone who’s grown their business and have saved them money, so they don’t need to hire additional headcount, you’re a keeper. And that’s not gonna change anyone else who’s just following tasks and does the same old thing. I hate to say it, but they’re gonna be looking for other people to stay because they want people who are innovative. And innovation does not mean cutting edge. Innovation means how do we do things better using the tools that we have?

Glenn Hopper:

<Laugh> again, I love hearing you say that because I think that the success that I’ve had in my career, I can attribute to there, there’s a quote that I think it’s off often attributed to different people incorrectly to Steve Jobs and and others. But it is, if you want to find the most efficient way to do something, give the job to a lazy person, <laugh>. And so as, as you’re talking about all the, all the ways that we can move forward, for me it was, if I had to spend two hours a day or two hours a week doing some the same task over and over, it’s, this isn’t how I’m gonna spend my time. I’m gonna, I’ll spend a hundred hours trying to automate it, but then my ROI is, I get those two hours back every day or every week or whatever. Yeah, for sure.

And then I’m off doing, doing something else. And I think that’s the way we need to think about our processes. And as AI makes more, and AI and just technology in general makes the, the allows us to automate more and more of these kind of menial tasks, the tasks that led our group to be considered a cost center where we’re just doing data entry and not adding a lot of value, we need to shift away from that and get to where we can add value. And I think a big, you know, I think data maturity and automation kind of go hand in hand because it’s, you know, the, the, the data is the artifact of the automation or the, or the, or seen the other way. Data is the fuel of the automation. So it’s all, you know, link systems capturing data points along the way.

And I think, you know, you and I were talking before the show, if you, regardless of the size of a company, if you look at where that company is on a data maturity level, one, it’s gonna tell you how much automation you have, and two, how much is ad hoc and how much is systematized and how much you have sort of a, a data lexicon and understanding of KPIs and all that. But I think a lot of businesses don’t really kind of understand where they are in that data maturity scale, the whatever. I think I’ve seen different versions. There’s either three, four, or five levels of, of data maturity. But we were talking before the show about f data maturity assessment, and that would be, and I’d love to actually link it in the, in the show notes if we could as well. But can you tell me a little bit more about that tool?

Nicholas Mann:

Yeah, yeah, absolutely. So one of the things, I mean, you hear about these companies out there, B, CG, McKinsey, I mean, people will spend hundreds of thousands, millions of dollars on these companies, these strategy companies to come in there and tell you five things that you probably already needed. You knew, but now you’re paying the consultants to tell you that. So it’s kind of like a, a COA situation. But in this particular case, what we found, and we’ve used this time and time again with different clients, with prospects, is this short survey that essentially is a quiz of testing you on some of the things that you are doing today and how you’re doing them. And what we found with very, very close consistency is that people are actually bucketed into certain categories that make perfect sense for them, that they could have spent weeks, months, beyond to actually figure this out, working with some extensive high price strategy consultant.

And what this is meant to tell you is that, hey, you fall into one of these four buckets, here’s where you fall in based on the criteria that you provided, and here’s what your focus should be. Yes, for example, some people might want to focus on AI because that’s all the buzz, but then you start answering things like, oh, well I’m spending 70% of my time manipulating data to get it into Excel models, or we’re not even on a financial planning platform. So I would challenge people and say, how can you even possibly consider AI as being an important project when you’re paying very high salary individuals to do all of this manual work that could otherwise be solved by automation? And that’s just one example. But if you go ahead and follow this quiz and take a survey, it’s free. It’s more of a self-assessment for yourself to see how do I compare to other companies out there and what should I be focusing on given my current scenario and situations going on today.

Glenn Hopper:

And I think, you know, it’s, it’s an Im, it’s important to do that self-assessment and understand where you are. But then, you know, a lot of people I talk to, especially if I’m coming in on a consulting assignment, it’s, it’s still that, well, it’s still that mindset that’s hard to let go of, of, well really that’s IT. Or really the data guys roll up under this group, or they, they’re not gonna give us access. And I, so for me it’s, I, it was always, well, I need to figure this out so that if I can’t get outside, you know, we’re gonna do citizen development here, we’re gonna run Python on a, on our own laptops or whatever, <laugh>, and, you know, running our own SQL tables and all that. But so I, but the, it is a common situation where FP&A people feel like they’re kind of at the mercy of these other groups. And I’m, we’re seeing it more and more, but there are still are people who are fighting this battle. So what do you think, I mean, how could finance and analytics be integrated to create, you know, how can you get that, get over that data silo and get access and integrate analytics, BI finance altogether to create, you know, to add power to the FP&A function?

Nicholas Mann:

Yeah, and I think it really depends on the size of the organization. For companies that tend to have, say smaller fp and a teams call it one to, to five, to six to seven, there’s gonna be opportunities for individuals to stand out. And kind of like what we were talking about earlier is go take on additional responsibilities outside of the function just to learn the business and understand the data needs associated with them. Those people may not go and actually solve them right away, but they can then at least partner together and say, okay, are there some quick wins that we can solve together? Can IT solve them or do we need to figure out a roadmap to actually solve these together by bringing an external partner? Or once they grow to that scale to be able to afford these things, they can then go in and do that and support those initiatives.

Now as you start growing though, and you become a team, you probably call it over a hundred million, you’re maybe a couple billion anywhere in between your needs of your organization grow. And you think of FP&A teams growing where, okay, well now they’re doing very granular modeling across the organization, probably for multiple products. So you’re doing revenue planning, really granular product costing to figure out the right price volume mix. You’re gonna do long range planning. And of course the cost side of all of this. So your opex, any type of product allocations and complexities that go along with these growing organizations, especially ones that do acquisitions and other things there, there’s so much data that now is coming up now these companies and we’ve seen it, is they’ll try to have an enterprise call it a data center of excellence to own data across the organization.

So not just for finance or FP&A you’re talking about manufacturing, commercial marketing, everything in between. Now it sounds good in theory and, and I don’t think there’s anything wrong with trying to take that approach. I think the execution has been inconsistent at best at a lot of these large enterprises that we’ve seen over the last five or 10 years, depending on where they’re at in their journey. And so what we end up seeing is to this transition where we are today, you’re starting to see this focus on data mesh. And what that means is, yes, you might still have standard governance, data architecture infrastructure within your organization. So everyone’s on the same platform. You can have consistent training, you have governance frameworks to support everything, but you then have data experts, domain experts sitting within each of these teams. You might also hear the term data steward.

And we saw this very successfully. One of our clients, they’re a multi-billion dollar pharmaceutical company. And so one of the things they did is, yes, that company had a center of excellence, but finance was frustrated, FP&A was frustrated, accounting was frustrated because they need to close their books fast. And this is a global billion dollar company. They’re closing their books in four days. So you know what that means? This better be a well-oiled machine, or someone is gonna have to go up to the executives and say, here’s why we missed our three and a half, four day close. And so what they found is because there was so much reliance on ITfor management of their databases, for their data, for the reporting, they said, this isn’t working. We can’t scale, we can’t go through all these acquisitions and expect to have the same results because we’re not getting the support we need from this center of excellence.

So what they decided to do, which is where we came into play as part of this, is create a finance FP&A center of excellence. And so we said, first of all, honing in, again, going back to all the pain points, where are you spending your time? Where are their bottlenecks today? So you think about performance bottlenecks, let’s use a perfect example. Their incremental data load process from all their ERPs took around two hours. Now that’s not that bad if you’re like, okay, we only have to run that one time. But how often do you only have to run that one time during a closed crisis? And especially if an accountant said, oh, I forgot to put in that major adjustment that we usually do at the end of the month and I need to go do that. Well, if you need to rerun that and you’re, you’re on the clock, you’re waiting for this to go, you’re gonna be very anxious because someone’s gonna be calling you saying, well, where are those reports?

And so these are where we look for opportunities to say, Hey, let’s fix some of these performance issues. So we got that incremental process down from two hours to, I think it was 20 or 25 minutes. So now they were able to run this consistently. It didn’t matter if somebody forgot, of course they want to stay on that schedule and everyone’s really focused in getting things done, but nobody’s perfect things happen. And that way you can adapt and focus on that fix when the time comes. Now, the reason they’re able to be successful with this as well, if you think about reporting, so if IT owns all the reporting and any kind of change needs to go through extensive version control, it needs to go through SDLC software Development lifecycle. That could be a three to five week migration process, three to five weeks you’re in another month that you’re onto the next close.

That’s impossible. So what we said is, well within Tableau, let’s actually build out the things that require the most sensitivity or adjustments on a regular basis. And that way when you focus on, you hear the term last mile reporting, that people in FP&A using their data steward could actually make those adjustments. And there was, don’t get me wrong there, there was quality and governance and checking and around all of this, but it could work, work at the speed of FP&A, which is a lot faster than it or the rest of the business when it comes to their data needs. And so they saw so much success with this and, and unfortunately this company over the last few years, they went through multiple reorgs where they actually had to do a lot of layoffs. Their drug lost exclusivity happens all the time in the pharmaceutical industry.

And so because they had all this process in place, they had the center of excellence, they had automated integration processes, their reports were automated. A lot of what they used to do in PowerPoint and Excel, they weren’t doing, ’cause it was all in Tableau. They actually were able to run a significantly leaner team call it. They were at a team of 25 30 FP&A people, and now they’re down to just a handful of people running the most business critical processes because all of the data is automated. And so that’s a long way of saying data doesn’t have to be AI, it doesn’t have to be cutting edge. It can be what helps makes people’s jobs easier so they can actually focus on the value that they’re bringing to the company because now they’re in steady state mode and they don’t need all those people for growth because they’re not growing, but they can run their business critical processes. So focusing on functional domains around the idea of an enterprise center of excellence goes a long, long way for productivity.

Glenn Hopper:

FP&A Today is brought to you by Data Rails. The world’s number one fp and a solution data rails is the artificial intelligence powered financial planning and analysis platform built for Excel users. That’s right, you can stay in Excel, but instead of facing hell for every budget month end close or forecast, you can enjoy a paradise of data consolidation, advanced visualization reporting and AI capabilities, plus game changing insights, giving you instant answers and your story created in seconds. Find out why more than a thousand finance teams use data rails to uncover their company’s real story. Don’t replace Excel, embrace Excel, learn more@datarails.com.

You mentioned a couple of tools out there and I’m always, you know, I’ve, I’ve worked with a lot of software providers and have used a lot of these software tools and I think they all have their place. So I wanna be careful, like I don’t ever shill for one, you know, software over another, but you know, whether somebody’s using Tableau or Power BI or or another reporting tool, I mean, I think that it’s, there’s the foundation level of the data and, and whether it’s a data lake, data warehouse, however you have it organized, understanding what it is, which data to use, what our source of truth is and all that. As an example, I know you’re a big Snowflake guy, but so like Tableau and Snowflake, I mean the modern tools and as people progress through their levels of data maturity talk a little bit about how these modern tools and so, you know, the reporting layer and then the structure of the data and the, the sort of cloud architecture and all that, how do these new tools help finance teams advance their capabilities? Like so you, the, the point you just referenced where they went from 25 30 to many fewer FP&A people, but I’m probably getting at least as good if not better results because of the tools. Walk me through this a little bit.

Nicholas Mann:

Yeah, the, the technology is very interesting because the barrier to entry to the data, call it data infrastructure in general for teams even five years ago, but let’s go back 10 years, it was very difficult because most companies call it, maybe they’re on SAP or ERP or Oracle or something else, they would or Microsoft, they would always be that shop. They’d be like, I’m an Oracle shop, I’m a Microsoft shop, I’m SAP so that means I have their ERPs and then I’m also gonna have their data integration tools. I’m gonna have their analytics platforms. Now as a lot of, you know, not all of these companies are perfect at everything because if they were all these other companies wouldn’t exist. But the point is, these were very challenging environments to stand up. Let’s say you were somebody in FP&A and said, oh, I just wanna source data outta my ERP because I want to do exploration on this data to see how we can do additional reporting.

I don’t know where we’re at yet. So think like a lake data into a data warehouse data that was a no go because IT would be, well first of all we own the databases. How dare you tell us to do what to do with the databases? And then second of all, they’d say, well that’s gonna take us a long time. We don’t have the resources. It’s too expensive to get servers. The memory, we’re very tight on our budget and you guys are fine. Like just download it to Excel. You guys are Excel people, right? That’s de yeah. So fast forward to modern day, so much of that barrier to entry has been lowered by using tools like Snowflake. But Snowflake is the data platform and, and it’s an incredible platform because of its capabilities in cloud. There’s no reliance on DBAs anymore. IT auto scales.

It truly is a very low maintenance data infrastructure. But that’s only one part of it. And that’s the value of something like the Snowflake ecosystem is these other tools that make it easy to get data into this platform. So you think about in the past when you wanted to ingest data or source data out of your E-R-P-C-R-M, third party, API applications, any external data done in Bradstreet, any of these other ones that are out there, it was very challenging. You have to go hire someone or have someone in it write a custom logic against an API and say, here’s how we’re gonna get this data. Or they would download files to an SFTP, transform them, upload them. Again, a very time consuming process to do now with the tool like FiveTran and some of the other ones out there, they manage all the connectors.

You plug into these data sources and it’ll extract the data you want into your Snowflake platform. And now you have at it, you can put a reporting tool on that, you can query it and you can do that without it. It’s truly can be owned within the function if you don’t have that support across the enterprise. So that barrier to entry is so much lower. And people say to me all the time, oh Nico, I could just custom code that or let me go hire someone to custom code that ’cause that’ll be cheaper. Okay, well you did that that one time. What about the next 20 times when you need to go add in new connectors or you need to fix something? Are you gonna go hire this high priced consultant to do this every time? No, and I’m a consultant so I’m telling you not to do that.

I’m telling you, go, go use these tools because the maintenance is so easy and the barrier to entry entry is so low that you can start using consultants for the actual value add consultant, value add activities that consultants should bring. Like how do we architect our data? What are our data? What does good data modeling look like? How do we build out our data warehouse and let’s execute this in a very quick manner and deliver it because we don’t have the internal people to do it. Instead of hiring consultants to custom code connectors or spend all this time standing up things that software could otherwise do at a nominal fee. So you have to look at that true total cost of ownership. And these tools have made it so much easier to bring FP&A data, finance data accounting data, really enterprise data. But I know we’re talking fp a today, so into this data platform makes a world of a difference.

And I’ll say, I mean even a few years ago we weren’t having these conversations with FP&A. Now a lot of people I’m talking to are FP&A ’cause they’re excited, they see the value of, oh, we can just stand this up and it fits into our architecture and we can get access to that data a lot quicker than we used to be able to. Whereas a lot of it was, oh well sales always got the priority because that’s where, you know, they’re driving revenue so they can support their needs, but no other people have data needs today. And using these modern technologies can get you there. So I would say watch out for consultants or anyone out there who says it’s talking about processing the old way, like downloading files, moving them over here, relying on all of these outdated movement processes. Start to question that, look for people who are working with the latest tech to get you where you need to go a lot faster.

Glenn Hopper:

Yeah, <laugh>, it’s, I think I have to, I have to apologize at some point in there, I might have blacked out because I went into like a Hadoop PTSD moment, <laugh>, you know, and I was just thinking back to, you know, just dealing with data in the early days and just waiting on the overnight you know uploads and, and the long reports and the crime jobs and all the stuff that we were doing that we were waiting on data. So yeah. Wow. Okay. I’m, I’m back. It’s modern day. We’re good. Wait, did

Nicholas Mann:

You say Hadoop? Is that what you said? Yeah,

Glenn Hopper:

<Laugh>.

Nicholas Mann:

Oh, lemme, lemme talk about Hadoop since we’re on the topic. So I actually wrote a post about this on LinkedIn the other day, which was one of very high engaged posts, but I guess Hadoop rubs people the wrong way a lot. So one of the things in the big data era, and this is why I equate AI and big data in a lot of ways that they are very similar because call it 10 years ago, maybe even six years ago, people were saying, oh, big data, should I be doing that? Who’s doing that? Like, let’s go do it. Let’s go get a Hadoop cluster. And I even had this conversation for one of the companies where they said, Nico, should we get a Hadoop cluster? And I’m like, why <laugh>? Because they said, well, because other people are talking about it and it’s all that. I’m like, well first of all, that’s a file management system more for a data lake.

What you guys need in finance and FP&A is structured, modeled accurate data, you need a finance data warehouse. And so we talked more about that and then we ultimately ended up, that’s what we deployed, was an FP&A financial data warehouse for them to automate a lot of their data ingestion processes, have a lot of their reports automated out of Tableau. And it would’ve been, oh, I’ve, I mean that’s what was five years ago and we’ve seen the value with thousands of hours. These teams continue to save every year because of this. But I’m just thinking like if they had done Hadoop, where would they be today? Yeah, <laugh> with the frustrations you just said, they’d probably be blacking out too because they’re like, oh

Glenn Hopper:

My gosh,

Nicholas Mann:

The Hadoop again is not, this isn’t what I needed. But I mean, I sidetracked for a moment, but I was when I was back at Peloton and so Hadoop was kind of on the early days. This was seven or eight, nine years ago, and we were, as a technical analytics team, we were getting into it, we’re like, this isn’t that user friendly. Like that’s kind of complicated. No,

Glenn Hopper:

No, it was not yet <laugh> and

Nicholas Mann:

We’re smart, like we’re gonna figure this out. But we decided strategically not to sell that to anyone because we’re like, if we can’t figure this out, we figured it out. But if we can’t actually maintain this or teach clients to maintain this, there’s no value for them here. I mean, there’s gotta be something better. And then of course, snowflake came out a few years after that. You have AWS Google following, they have all similar technologies now in the cloud, but a lot of companies are still using Hadoop. But I think they’re still facing those frustrations as well today.

Glenn Hopper:

That kind of leads me into the next question that I had. I mean, you know, if you, it it’s the devil, you know, and you’ve gone to all the effort to set up a Hadoop cluster or whatever you know, whatever your current data lake environment is. So I think it’s, it change is hard and it’s disruptive. It’s just like putting in a new ERP or any kind of big software thing. It’s very hard. If people know a system and it’s working and it’s clunky and it’s not modern, it can be very hard to shift from this is working, I don’t wanna rock the boat and you know, how do I get to this sort of cloud first modern data architecture. And then there’s also just in that, there’s challenges and issues around just the data and analytics environment in general. So I guess, you know, my, my question is maybe two part, it’s one, you know, what you recommend for somebody getting started maybe on sort of the more technical side, but then you have to have this data-driven culture and, and you know, understand the value of analytics and understand the value of automation.

Like, I mean, it’s, it’s intimidating to try to change something that is maybe not optimal, but you’ve kind of figured out how to work in the system. So if you come into a company that is just, you know, really maxed out on what this old system is and they’re trying to move into this new modern architecture, what, I mean, what are, what are your steps there? How do you help them?

Nicholas Mann:

Glenn, you’re talking about one of my favorite topics, which is people in data, which I’m sure we could do a whole nother podcast on. So let’s start there though. So technology has always been incredibly successful within finance, within IT across the organizations. But the adoption, the change management behind it has been one of the most challenging things that companies have wasted so much money on this tech only to find that nobody’s using it because they didn’t go through those proper channels to see are people actually gonna get value out of this? And so whenever we go into an organization, usually it is somebody who, there’s probably a project sponsor or stakeholder, they may be director, vp, C level, depending on how large the organization is. But we like to learn what are some other things that are gonna be, or other people, departments that are gonna be directly impacted by this change.

So those are some of the areas that we start because a lot of time people will say, oh yeah, no, no, this is just for us. This is just for us. And then as you progress into this larger project, you find it’s not just for them. And there are a lot of people who get really frustrated ’cause you say, oh well you didn’t include me and why didn’t you ask me about this? I’m the expert on this data or I know this process. So as part of our deep discovery sessions, we start to really drill into those details to find out what’s truly going on and where those pains are. And they tend to be well beyond either the data IT or finance functions. It’s in support of the subject matter domain experts in general. And so once you start to find that, you then start to, you wanna identify, well, let’s see how we build relationships with these people and get them bought in.

And that’s not, we can guide that process and we do that all the time, but ultimately it has to be the internal stakeholders because we want to see them succeed because once we’re gone, it’s on them. So they need to go start to facilitate engagement and excitement for these types of initiatives. And a lot of that comes down to, let’s say you’ve never met with somebody and you know, somebody in HR is struggling with data or somebody in sales or marketing and maybe they’re a little introverted, they kind of like stay in their lane. I would just set up a meeting with them. We’ve seen this time and time again, just set up a meeting, Hey John, we wanna talk to you just to understand some of the data pains. We’re working on this initiative and we think it might help. It’s helping us in finance.

So we wanna see if it can help in hr, would you mind meeting just so we can chat? And then you spend that time having mostly just listening, asking the questions that are relevant to this and understanding what their data challenges are, their analytics challenges, where a lot of their time is taking, what’s frustrating, what’s keeping them up at night, what, what at the end of the day are they dreading the next day? ’cause They have to do it. And then you document and you capture all of those pieces. And then not only do you say, okay, well John, thanks for meeting, appreciate it and then never talk to them again. And that’s what happens a lot of times. There’s no execution, there’s no next steps, there’s no project management. In that meeting I would say, Hey John, can we get a meeting on the books for a week out, two weeks out?

Let’s figure out, I wanna work around your schedule, but I wanna make sure we keep the momentum and I come back to you with some recommendations on how this new initiative can actually help you. That I’m gonna have conversations with our internal teams. And then when you have that second meeting with John, then you start to set up timelines and say, Hey, this is something that can be a quick win for you. Our team’s done this before, we have an idea for it if you’re open to us trying it, but let’s do that. We’d love to spend some time with you to get this set up. Look for those quick wins. You start to build that relationship. And by the time you say, all right guys, we’re going in to launch this bigger initiative across the enterprise, maybe it’s a few functions, however you approach it.

John’s like, cool, yeah, like let’s do it. In fact, these guys helped me out already. I’m excited for it and let’s get some momentum going here. Now you have an even bigger sponsor for your project than just the original stakeholder who was focusing on this. And I say all these things, it’s not easy, it’s not easy at all, but it takes you to go out of your comfort zone to build relationships. And we’ve seen it time and time again. Not only are projects successful, but these people get promoted, they move on, they do well in their careers. So yeah, it takes being uncomfortable to make a lot of progress in these areas. And so that’s the people aspect of it. And to answer your second question there around how do you actually approach from, say you want to deploy this modern data stack, what’s a good approach to do it?

Well, historically we look at, oh, sales vendors come in and say, Hey, you’re gonna get all this ROI out of this analytics tool, out of this database. Wow, look at these cost savings over here based on these few variables you told me. Very cool sign now for this three year agreement, multimillion dollar agreement. Those times have changed. And I caution you for any vendor, be it technology or services or pushing something like that on you definitely question it. Definitely get a second or third opinion because this is the era of easy to stand up data infrastructure. No, it was never like this before. We’re very fortunate to have that technology. So what we recommend is, there’s two things. One, to do an assessment. So an assessment is, could be anywhere from a couple weeks to a couple months to say, what do we actually want to focus on?

What are our needs? Well, how do we want to plan these in the near term and long term? ’cause Of course everyone loves to have everything at once, but that’s not realistic. So you need to prioritize things. What is priority for the business? What’s gonna drive more savings in the near term, long term? As you figure out all the challenges, you document the gaps, you look at your current infrastructure and see what the future state could look like. And then once you’ve defined that future state on paper, you’re like, yeah, this seems pretty good. I think this is how the data should flow. We’re gonna source out of these different systems, we’re gonna ingest it into this data platform. Put a reporting tool on top of it. Then you want to do a proof of concept or a prototype. Don’t go buy all of these technologies as much as they’d like you to do that.

What you should do is say either work with a partner or if you have the internal resources to do it, say, Hey, I’d like to do a proof of concept with Snowflake and I wanna ingest the data with FiveTran. I want to transform it with coalesce. I wanna report on it with Sigma or Tableau. There’s a lot of tools in these ecosystems. So you need to be cautious of not bringing in all of them, but you want to focus on the ones that actually can add value to you. And then you could do a proof of concept in its shortest three weeks, maybe ideal is six weeks. And then you say, oh wow, this actually did everything that I wanted it to do. Now let’s focus on how this impacts the longer term. And we’re going through that right now with a, with a, one of the largest manufacturers in the United States.

He, he was ready to say, Hey, like, let’s get this project going. It’s a multi-year project. And I said, well, let’s take a step back and say, let’s actually prove this out. And of course, to me it would be, oh yeah, like, let’s sign, let’s get rolling. No, because that leads to failure. So what we’re doing is a proof of concept. And I even said to him, Hey, if you hate working with us at the end of this, then you can look at other service providers and you get the proof of concept to see the results of that. And of course, that’s never gone that way. They’ve always chose to work with us. But that’s the reason why is because you’re hedging your bet. You are showing that you understand the value of this technology, you’re showing the business the value of that. And once you’ve defined that proof of concept, you can say, cool, this will work for other situations because you focused on the most complex issues early on. And then you can focus on signing contracts with the software vendors and the providers and whatever is gonna get you there. Or do it internally. But don’t take on all this unnecessary risk when we are in the era where technology is so powerful and easy to stand up, just do a proof of concept.

Glenn Hopper:

Yeah. And as an agile guy, I love hearing your agile mentality come through and everything you’re saying here with these s small wins and you know, just addressing one component at a time rather than doing this massive waterfall. And I, you know, I’ve seen it so many times where you get a, a really slick software salesman comes in and just tells you, this software is a magic wand. You just buy the software and it’s gonna fix everything. Whereas whether it’s an ERP or a data environment or, or, or full finance tech stack, you don’t just buy the product and then try to fit your problems to the product you first. So you know, like what, what you talked about going through and looking at the steps. So if you’re making a, a roadmap, here’s the road, here’s a pothole, here’s a speed bump.

Let me, let me first fix the potholes, figure out what’s going on in the speed bumps. You know, maybe there’s a paths where whatever you’re doing takes a hard right turn. You’ve got that noted in your, in your process, and then maybe there’s parts of the road that are fog covered and you have no idea what’s going on there. Well, there’s a gap that’s something we need to fill. And then, but if you can, I don’t, I don’t know if, if physical processes, right, because everything is, is so digital these days, but understanding what people are doing, where they’re having problems, what exactly you’re trying to solve for, and then plugging in the appropriate software solution is much better than this sort of square peg round hole, just jam everything into into one solution. So I, I love hearing your, your approach there. We’re going along here, and I’ve got 20 other questions listed here.

I wanna, <laugh> I want to cover with you of course. But of course in the interest of of time, and because it is top of mind for everyone, and it’s one of my mantras that I’m, I’m using all the time right now is because everybody wants to talk about ai generative AI in particular. And it’s super cool. You see the potential of it, you know, we’re in the dial up AOL prodigy era of, of generative ai. So it’s, we’re gonna look back at this and say, I can’t believe how bad it was, but we’re all seeing the potential of it right now. So people always want to talk to me about what do we need to do to be AI ready? It’s like, well, you have to have BI before you can have ai, and if your data is still ms, AI is not gonna help you.

So there’s sort of this, this path, but, you know, and we’ve talked about the implementation and how to increase data maturity. But from someone in your role, knowing analytics as well as you do, knowing data and how it can be used and what its power is, as you see the potential of generative AI right now, I mean, how do you see the role of technology and, and AI evolving in FP&A with the rise of AI and machine learning? And I think, you know, sophisticated FP&A departments have been using machine learning for years now, but it’s, it was only accessible to a handful of people. So, you know, you’re seeing the potential, you kind of know state of the art where we are. What do you put on your crystal ball here and, and let us know what you’re thinking about the future.

Nicholas Mann:

Yeah, I’m glad you said that too, about machine learning. ’cause That’s something I was gonna touch on as well, is that a lot of these technologies, financial planning, budgeting softwares, as well as just some third party softwares outside of, say the major players, they’ve been focusing on machine learning and statistical models within these tools for a long time. Now, in all fairness, there it’s a bit clunky. You still have to kind of know what you’re doing to inform that. But a lot of people were always looking for ways of, okay, well how do I propagate data in some of the things that you always know are gonna be consistent or you can use historical data to inform those models. Maybe there’s some other variables that drive that based on success or failure, fresh thresholds for a particular product or its successes, anything like that. So I would say that’s not necessarily new.

A lot of people are doing that, but you’re right, it is, again, talking about barrier to our entry. Now we’re looking at ways for how people can do more of that. And I think gen AI on its own, let’s talk on that before machine learning. ’cause I think machine learning, I, I was at the Snowflake conference a few months ago and someone was saying, oh yeah, you can do machine learning and this integration tool, and they’re talking about variables and all these things. I’m like, well, this is great, but I still don’t really understand statistics that well, so I’m not the best one for it. So people have tried to make it simpler to use, but you still need someone with that knowledge to say, well, how is this model actually going to work? Because when you get numbers out of that model, when you’re talking to your leadership, I can assure you your leadership likely does not know how that’s gonna work.

So they’re gonna want answers, how did you come up with this number? What’s driving that? And if you list off like 10 different variables in a statistical mumbo jumbo that they don’t understand, they’re gonna be like, why don’t we try this again with something that we can actually explain and take to our board or our shareholders in that case too. So I think there is a longer way from a machine learning perspective to get there. And that’s why some of these larger orgs can afford to have data scientists to actually do that. And it does help expedite some of their FP&A processes and better inform, so their tighter on their budget forecast. And I think that’s great. Let’s talk to AI for a little bit. So one of the biggest things in fp and a over the years that took so much time was variance reporting.

So you think about, okay, why is this variance 20%, I now need to type some. Okay, well I need to drill into the details to look it up. What’s causing this? I need, maybe I need to go talk to somebody, then type it up. And then that’s a lot of time for one person to even spend on say a single line item to accomplish that. So for a long time when there was a lot of talk of NLG or natural language generation that could help automate some of these, the generation around the commentary capture that needed to go into these reports. That’s where I see Gen i gen AI taking off for these teams, because now so many of those tools, they were third party plugins, they weren’t that easy to use, they’re a bit costly now with this advent of these models being available, and you can now actually use them within your own ecosystem.

So you’re not sharing your data with the outside world, it’s all secure. Now you can focus on training these models so it can actually auto generate that commentary capture for you and go say, oh, well I have access to the granular details in this data model to actually go find this information. But what I said there is data model, because finance data needs to be right. As you know with gen ai, there’s a lot of things that appear right, but are not right. And so some of the bigger companies out there, or at least who we’ve talked to in other departments, they’re doing, they’re putting out these initiatives where they call ’em data quality initiatives where they’re building these AI models and as soon as it spits out a result, they have a team or a process that says, okay, does this actually check out?

Is this valid? And until they meet a certain threshold of consistency and that the model is actually trained to accomplish that, then they actually allow it for productization. All that being said, I didn’t hear that necessarily with any finance or fp a data given how accurate that needs to to be. So yes, and actually somebody who I’m close with, he’s actually building an ai, a gen AI model on top of some of the, the data models for exactly what we’re talking about. So your EPM, your databases to get everything there to assist with that. So I guess the, the long-term vision there is imagine where you hit the month end. You need to do your monthly reporting package. And usually it was okay, if you have nothing in place, lemme go download all this data. Let’s put in Excel, let’s pivot it, let’s do the graphs, let’s screenshot it, let’s put it in PowerPoint, let’s type up the text here, let’s review it all.

Oh, I made a mistake, so go do it all again for this one. All right. So, but you got the point there, it’s very manual. Now imagine a world where it could either be in the web or it could be, maybe it’s automated in PowerPoint, but you just run your report, everything’s autogenerated, the commentary is there, the data points are there, and it could tell you something like, okay, here are the variances that really stand out that you, that seem outliers compared to the past that you should really focus on. Because you’re not gonna go through and wanna check everything you probably will initially until you build some level of trust with it and comfort. But that way you can spend your time actually where the attention needs to be. And oh, by the way, you didn’t spend all your time putting together these reports and that somebody you could have paid like $10 an hour to do, where you’re paying someone like $200,000 a year to do that, when now it can be automated through technology.

So I think a gen AI coupled with strong data models and a good process will help automate a lot of this repeatable reporting. And of course, the next thing being ad hoc questions when you say, Hey, you know, what was my revenue in this particular business unit and everything, a lot of things that data analysts will usually do, and it takes time to do. I think we can get there and it will take time. So there are a lot of exciting things, but it always comes back to the data quality, the consistency. Have you built a data model that can support all of this, especially when it comes to finance and fp and a data?

Glenn Hopper:

Yeah, absolutely. And it’s funny as you as you’re talking through that, I mean, that that is exactly what I’m trying to do in my day job when I’m not flapping my gums on the, on, on the podcast <laugh>, that’s, that’s where my focus has been. So yeah. Yeah. So we’re, we’re fully aligned there. We dove straight into all the data conversation and we do at the end of every show, like to remind our listeners that we’re all outside of our, our geekdom that we’re we’re people too. So one of the questions we always ask our guests is, what’s something that not many people know about you that you, you could share with our listeners today?

Nicholas Mann:

Yeah, so I think one thing I’d like to share is that just around this rare eye condition that I have, it’s called achromatopsia, and I wanna bring it up because it doesn’t get a lot, it’s not a very known condition that’s out there, but essentially it, it limits my ability to do some day-to-Day. Things like driving a car I can’t drive, so it’s difficult to cross the street sometimes. I’m very light sensitive, I have colorblindness. So all of these things, and I say that in a way to say yes, there are a lot of things I struggled with growing up and have to deal with of how to get around kind of like the norm or how people live normally. Just some basic things that we take for granted. But I’ve been able to be successful because I figured that out along the way and found some amazing people to support my career and grow in that way.

I mean, something is, even, even as simple as being in a conference room around a conference table and it’s, the blinds are open in a bright room, it’s really difficult for me to see. And then like I can’t see people’s faces or the responses that are on their face. So it’s one of those things you kind of learn and embrace to adapt to those situations. And one other thing I’ll say with Covid, now that everything is over zoom and virtual, for me personally, that’s made things a lot easier because I can see things a lot better now that I’m closer to the screen. It’s helped me, even though there’s so much lack of engagement by not being in person, I almost feel like I get a lot of value out of virtual because I can do things that I couldn’t necessarily do before. So that’s that’s something I just wanted to share in general.

Glenn Hopper:

Yeah, that’s so interesting. And, you know, having to overcome those challenges to work in, in a world, and especially, I mean, you know, when people think about eyesight and, and how important it’s, whether you’re doing virtual or or in person and then, you know, just the, the visibility and all the data and the stuff you work with, it’s that’s a lot to, to overcome. So it’s, it’s great that you have found the path through there with all this. So, all right, our other question that we ask, ask everyone, and we’ve been so like, so geeked out on such a different level, I don’t even know how we’re gonna bring it back here, but I I, I’m always fascinated to hear the responses here. What is your favorite Excel function and why?

Nicholas Mann:

So favorite Excel function for me, because I used it a lot in early in my career, and I still use it sometime today, is SUMIF. And so, especially when you’re doing any type of data validation across different grains of data and you need to match it up. And this comes into play, especially in major migrations of data from different environments. And yeah, you can write a lot of code to do that, but there are times you had to do it in Excel. And so the some if saved me a lot of times a lot of manual effort to actually accomplish that. And I still teach my team that sometimes today when there are, when there is that need. And then I think the other thing, I’m just a big pivot table person, I mean all the time ’cause we’re a smaller company, right? So we still, it’s funny, we’re a data company, but at the end of the day we still have a lot of these challenges as well. But at the end, we also don’t spend that much time doing these data challenges that companies face. So what I’ll do is I’ll take data outta certain systems, do some pivots, then enrich that data with my own thoughts analyses and it’s just, I still like working with Excel. And so I, I’m a believer of we’re never gonna eliminate Excel. Excel is a very, very powerful tool when complemented with data automation, with analytics tools, and that way they go hand in hand instead of just like, oh yeah, let’s get everyone outta Excel.

Glenn Hopper:

Yep. Yep. That’s excellent. And I guess in, in a conversation for a whole other day, I probably need to do a podcast on this, as you know, now that Microsoft’s integrated Python into Excel. And I have personally not messed around with that at all, but I I know people are very excited about that. So I’ll probably start, as people start figuring out the Python in Excel, we’ll probably start getting different answers there as well. So yeah, this has, this has been great. I guess one, you know, one thing I want to be sure for listeners who wanna connect with you and learn more about your work what’s the best way for people to, to get in touch with you?

Nicholas Mann:

Yeah, I’m a big LinkedIn person, so I’m regularly posting content mostly on a daily basis about all things data analytics, infrastructure, data modeling, anything related to how you can get more out of your data. So Nicholas Mann on LinkedIn, we’ll put it in the show notes and then you can check us out stratos consulting.com. And lastly, I would say if you are in that journey and you’re wondering how mature your data strategy is or where you’re at with your fp a data, check out that FP&A data maturity assessment. I think it’ll tell you a lot of things. Some you might already know, but there might be things like, oh yeah, that’s pretty interesting. So, and definitely happy to have conversations with other people who are out there who wanna just talk about data.

Glenn Hopper:

Well, Nico, thanks so much. This is a great conversation and and really appreciate you coming on.

Nicholas Mann:

Thanks a lot, Glen, really appreciate the opportunity.