Revolutionizing Federal Operations: Ed Williams on Power BI, CRM Systems, and Power Platform Integration

Transcript

WEBVTT

00:00:01.824 --> 00:00:03.430
Welcome to the Power Platform Show.

00:00:03.430 --> 00:00:04.945
Thanks for joining me today.

00:00:04.945 --> 00:00:11.449
I hope today's guest inspires and educates you on the possibilities of the Microsoft Power Platform.

00:00:11.449 --> 00:00:13.868
Now let's get on with the show.

00:00:13.868 --> 00:00:30.934
In this episode we're going to be focusing on enterprise deployments on the Power Platform, dynamics 365, as well as development.

00:00:30.934 --> 00:00:32.743
Today's guests are from the United States.

00:00:32.743 --> 00:00:36.593
They work at AndWorks as Power Platform developers and consultants.

00:00:36.593 --> 00:00:42.713
You can find a link to Ed's bio in the show notes for this episode and with that, welcome to the show, ed.

00:00:43.441 --> 00:00:44.304
Thank you very much, Sher.

00:00:44.304 --> 00:00:45.228
Very glad to be here.

00:00:45.880 --> 00:00:46.621
Good to have you on the show.

00:00:46.621 --> 00:00:51.744
I can't wait to hear your story, being that you've been around this space for a good some time.

00:00:51.744 --> 00:00:55.273
But to start with, why don't you go ahead and introduce yourself?

00:00:55.939 --> 00:00:56.680
Yeah, thank you very much.

00:00:56.680 --> 00:00:57.942
So my name is Ed Williams.

00:00:57.942 --> 00:01:01.749
I am the Senior Solutions Architect here at Handworks.

00:01:01.749 --> 00:01:11.573
We're a small company based out of Falls Church, virginia, that primarily focuses on the power platform and what it can do for the federal government.

00:01:12.061 --> 00:01:14.426
I myself have been doing this for a couple of years now.

00:01:14.426 --> 00:01:39.944
I've started off working for the federal government as a soldier, then moved into contracting, then moved into being a civil servant, now back into contracting and throughout my entire time working for the federal government or the US federal government, that is we have seen where things like data, be it within reports or be within applications, has always been not so fun to play with.

00:01:39.944 --> 00:01:59.349
When, a couple years ago, when the power platform really kicked off, when a couple years ago, when the Power Platform really kicked off, I got the itch to really start looking at and see how we could improve what we have within some of our federal spaces, which ultimately made me leaving federal service as a civil servant and going back into contracting and doing some of this work.

00:01:59.349 --> 00:02:11.591
There are so many great things that we have available to us within the Power Platform, but I truly believe that we can make our federal government better with some of these tools.

00:02:12.391 --> 00:02:12.793
I love it.

00:02:12.793 --> 00:02:13.433
I love it.

00:02:13.433 --> 00:02:18.889
Before we get underway and listen to your story, tell me about food, family and fun.

00:02:18.889 --> 00:02:20.412
What do they mean to you?

00:02:21.173 --> 00:02:21.974
Food, family and fun.

00:02:21.974 --> 00:02:24.228
So I am a father of four boys.

00:02:24.228 --> 00:02:28.480
I've been married for 16 years to my great wife.

00:02:28.480 --> 00:02:30.907
I live in the state of Maryland.

00:02:30.907 --> 00:02:34.381
So fun fact about Maryland, it is a cult, not a state.

00:02:34.381 --> 00:02:45.072
I am originally from the state of Illinois, from Chicago, and now live in Maryland and can tell anybody who has come to the state of Maryland that is very, very true.

00:02:45.072 --> 00:02:47.489
If you can eat it, you put Old Bay on it.

00:02:47.489 --> 00:02:50.879
If you can't, put the flag on it, but from there food, family and fun.

00:02:50.879 --> 00:02:56.793
I am a huge fan for anything that you can put Old Bay on.

00:02:56.793 --> 00:03:03.768
I'm not the biggest fan of crabs being here in Maryland, so don't fight me on that one, but I do love me some of that.

00:03:03.768 --> 00:03:06.227
We travel around the US.

00:03:06.227 --> 00:03:07.204
We have a big old RV.

00:03:07.204 --> 00:03:11.246
We like to drive up and down the East Coast If you go West Coast we get a chance to.

00:03:11.246 --> 00:03:17.084
But me and my boys love to get in our big old RV and drive up around because it's so much fun to do.

00:03:17.866 --> 00:03:22.727
Nice, I got to say crabs, I think is one of my favorite seafood meats that you can have.

00:03:22.727 --> 00:03:24.472
They're so sweet, it's so tasty.

00:03:25.052 --> 00:03:28.705
If I'm going down like Key West or Florida, like something like that, I'm getting like some stone crab.

00:03:28.705 --> 00:03:29.348
I can deal with that.

00:03:29.348 --> 00:03:44.968
I just I've been married to my wife for a very long time now and to watch the love of my life the person who brought my children as a world to devour crabs with her face and then the mustard and everything associated with it.

00:03:44.968 --> 00:03:46.150
You know what?

00:03:46.150 --> 00:03:47.111
Maybe not.

00:03:49.033 --> 00:03:49.694
That's awesome.

00:03:49.694 --> 00:03:50.376
That's awesome.

00:03:50.376 --> 00:03:56.772
Tell me about you know you've talked about your role in the military, things like that.

00:03:56.772 --> 00:03:59.752
Tell me about how you got into Microsoft tech space.

00:04:00.294 --> 00:04:04.170
Yeah, so I am a chief warrant officer in the Maryland Army National Guard.

00:04:04.170 --> 00:04:09.652
Chief warrant officer is kind of that middle space between what an enlisted soldier is and what an officer is.

00:04:09.652 --> 00:04:11.568
We are technical experts in our field.

00:04:11.568 --> 00:04:17.187
I am what is known as a 255 November, a network tech so kind of strange.

00:04:17.187 --> 00:04:22.608
Some folks I do like large-scale network operations for the Army and Maryland in general, for the Army and Maryland in general.

00:04:23.250 --> 00:04:34.968
And then a couple of years ago when I was working for the Navy as a civilian civil servant, at the same time doing guard stuff, I started seeing a lot of stuff with Power BI.

00:04:34.968 --> 00:04:50.810
So when I was seeing some of the first iterations of Power BI in some of the higher classification spaces where it really paid dividends, we had a big issue where we're doing studies, your classic Excel, whatever libraries you have out there.

00:04:50.810 --> 00:04:54.170
It was just not up to speed for what we need.

00:04:54.170 --> 00:05:11.514
So we got the old school Power BI server, installed it and just from there I was hooked Then, seeing everything we could do as far as Power BI and getting some of those just starting with the Power Apps or really what Power BI could do as far as Power BI and getting some of those just starting with the Power Apps, or really what Power BI could do for us and some of our ERP type systems.

00:05:12.355 --> 00:05:24.923
Nice, nice, as we jump in now to what I like to call anchor apps, big apps built on the Power Platform that, once installed, and organizations are going to pull them out in a hurry, right, because they are.

00:05:24.923 --> 00:05:28.709
So you know, you could use the word strategic.

00:05:28.709 --> 00:05:34.632
They could be mission critical, they could be absolutely have a massive impact on the organization.

00:05:34.632 --> 00:05:45.826
But before we start, I just want to say to the listeners we will not be mentioning any particular agencies, names, et cetera, in this episode, so you can guess as much as you want.

00:05:45.826 --> 00:05:49.302
And so, with that, can you tell me a bit about?

00:05:49.302 --> 00:05:57.345
When you think of Anchor Apps and the projects that you've been on, what comes to mind For me it's with CRM.

00:05:58.065 --> 00:06:05.970
It goes down to how CRM is working with finance and budget, because money is what makes the world turn.

00:06:05.970 --> 00:06:17.411
If we don't have good finance operations, if we don't have good ways of moving things around, we are going to struggle with how we get actual things done.

00:06:17.411 --> 00:06:23.288
It's like they say in the Army wars are won not only with soldiers.

00:06:23.288 --> 00:06:25.913
But how are your supply logistics going down?

00:06:25.913 --> 00:06:28.906
How are you able to pay soldiers?

00:06:28.906 --> 00:06:33.040
How are you able to get beans, bolts or personnel to the right locations?

00:06:33.040 --> 00:06:41.704
So it is really for me, anchor applications surround what it means to do finance and operations in regards to some of the CRM type stuff.

00:06:42.586 --> 00:06:47.855
But the struggle with getting a lot of that done is things around security and governance.

00:06:47.855 --> 00:06:59.406
When we have a lot of the movement to the cloud around the federal space, the easy button for a lot of ISSOs, for a lot of security governance folks, is governance.

00:06:59.406 --> 00:07:19.468
When Power Platform first came out and a lot of the practitioners of these applications are surrounded by the low-code developers of being citizen developers or what have you, that kind of threw a lot of red flags for folks and gave the wrong impression to what it can actually do for some of our large-scale enterprise applications.

00:07:19.468 --> 00:07:38.242
So we've been having to kind of work it back for the past couple of years and flip the script and really showcase to folks how there is so much security and governance surrounding these tools, how that when we get these big anchor applications, how they can breed into other things.

00:07:38.242 --> 00:07:43.485
But they really need to first start with you know what does security and governance mean to them?

00:07:44.345 --> 00:07:45.906
Yeah, so at a high level.

00:07:45.906 --> 00:07:55.872
Just give us run some numbers around sizing of projects that you've been on and use whatever metrics that you think is applicable to how you would reference that.

00:07:55.872 --> 00:08:07.019
Whether you know, I had somebody on recently who implemented the Power Platform for a government agency in a country that managed their entire passport system.

00:08:07.019 --> 00:08:21.857
So therefore you know millions of users accessing via PowerPages, for example, only 600 actually you know behind inside the agency but, of course, external, facing massive volume of folks.

00:08:21.857 --> 00:08:24.533
So when you think about that, what comes to mind?

00:08:25.185 --> 00:08:30.778
So, yes, something very similar where it's more internal versus the external.

00:08:30.778 --> 00:08:34.371
We do have some of those, to your exact point, external facing power pages.

00:08:34.371 --> 00:08:59.188
We are just now getting some of those turned on for some of our external implementing partners, but we have large scale power platform solutions that touch a good number of our one of the agencies we work for a large swath of their customer base it's upwards in the thousands of people using this on a very, very frequent basis.

00:08:59.990 --> 00:09:00.932
Awesome, Awesome.

00:09:00.932 --> 00:10:15.212
So one of the questions that has come out a bit, particularly from enterprise architects that I've heard this, is the platform enterprise grade or there's a perception, because of that citizen developer discussion, that it's not right that if anybody can build on it, is it just Excel in the cloud and there's no rigor around application lifecycle management, there's no rigor around security of endpoints, there's no rigor around standard security practices and considerations, when an organization might have not only PII data but also secret data and really any amount of data sets that have to be kept highly secure, particularly not just from an external potential threat but also from maybe accidental internal People copying a file, sending it to somebody thinking they're doing it internally and put somebody in the email address field that it shouldn't go to as an example, so accidental kind of risk profile.

00:10:15.212 --> 00:10:16.155
What's your response?

00:10:17.384 --> 00:10:19.572
So a lot to unpack there.

00:10:19.572 --> 00:10:33.431
So when it comes to flipping the script for what we had citizen developers and showing that this truly is enterprise grade, I take it back to it's nothing more than another language.

00:10:33.431 --> 00:10:37.426
It's nothing more than another server that you're working on.

00:10:37.426 --> 00:10:46.732
So if you knew how to do governance, if you knew how to do your agile or whatever process you're using, then you can use those same things.

00:10:46.732 --> 00:10:57.373
It's just a different mechanism to get there and just like you have to take time to understand how SQL works, you have to how different things in AWS, different things in whatever system it is.

00:10:57.373 --> 00:11:08.605
It is something where we have to go and make sure they understand that this is just as capable even more capable at times for using some of that stuff.

00:11:08.605 --> 00:11:36.375
And that really is on the enterprise architects and the solution architects working with those security governance folks and really detailing out and showing how things like auditing and things like concatenation data because you brought up a very good point where there is a particular issue when you have data type A and data type B, and when data type A and B are together, they make data type C, which is a whole other level of thing that nobody should be talking about or looking at.

00:11:36.375 --> 00:11:39.528
So how do you build in those controls to do some of that stuff?

00:11:39.528 --> 00:11:46.109
And these are things where dataverse things, where the Power Platform are just natively available to do that.

00:11:46.109 --> 00:11:56.937
It may not from the surface look like it, but there there it just takes time or it takes education for these enterprise architects to truly understand what it is.

00:11:57.024 --> 00:12:07.778
Because it has been a struggle for the past couple of years to really move from that citizen developer slogan to showing how this is more than that.

00:12:07.778 --> 00:12:21.397
And I think our company and others in our arena have really been able to push that over the past couple of years or a year or so by really starting with some of the citizen developers and making those anchor point, anchor applications.

00:12:21.397 --> 00:12:24.692
And they go oh well, I can now do this, well, I can do this.

00:12:24.692 --> 00:12:28.339
And can you show me how the security worked on that thing?

00:12:28.339 --> 00:12:29.424
Oh, I didn't know I could do that.

00:12:29.644 --> 00:12:32.695
I didn't know I could do the comm level security like that.

00:12:32.695 --> 00:12:34.913
I didn't know I could do hierarchy security like that.

00:12:34.913 --> 00:12:37.144
I didn't know I could just have business units.

00:12:37.144 --> 00:12:38.871
I didn't know I could do those things.

00:12:38.871 --> 00:12:58.518
And a lot of times it takes experimentation on developer standpoint, it takes just brown bags, whatever it may be, because again, the shortcut to no is security saying no, I don't think there's enough governance around this, I don't like it and they want to pull it back.

00:12:58.518 --> 00:12:59.158
Or you know what?

00:12:59.158 --> 00:13:02.341
We know how to go build a server.

00:13:02.341 --> 00:13:04.101
We know how to go build our own database.

00:13:04.101 --> 00:13:07.591
We're going to go, you know, have all the people go do that.

00:13:07.591 --> 00:13:14.830
But you know we're just going to relegate over this power platform stuff, building step trackers or whatever crazy little Wimbosh things out there.

00:13:15.533 --> 00:13:59.990
Yeah, have you done anything in the licensing space for your customers and I don't mean on what licenses, what fit, but what I find with large enterprise organizations is that they almost need a tool to automate license allocation and, for want of a better term, license retrieval around the allocating of licenses and then bringing the licenses back into the common pool for reuse elsewhere, whether it be people leave the organization, a team gets disbanded, whatever A number of reasons, apa gets retired.

00:13:59.990 --> 00:14:06.158
Have you built anything or addressed this kind of use case?

00:14:06.904 --> 00:14:08.225
There's actually a couple things with that.

00:14:08.225 --> 00:14:17.669
So the first part is explaining what licensing actually means, because we meet with a lot of customers and one of the first things they think about is they call it the Dataverse license.

00:14:17.669 --> 00:14:21.171
The Dataverse license Well, no, no, no, it's not the Dataverse license.

00:14:21.171 --> 00:14:27.975
It's a premium license that gets you this and this and this and that and all these other things, and Dataverse is to be one of the things inside of there.

00:14:27.975 --> 00:14:35.912
So that's one of the first things that we really want to make sure, when we're having that license discussion, that people understand what's going on.

00:14:35.912 --> 00:14:40.451
And then to your question about pulling licenses in and out and how do we manage some of that stuff.

00:14:40.451 --> 00:14:43.904
A lot of that is I'm really looking forward to it.

00:14:43.904 --> 00:15:00.811
We have something where the auto-claim policy so the auto claim policy, so like the auto claim policies within the PowerApp platform to pull PowerApp's premium licenses in and out just like you would a PowerPage or something that we're looking forward to use a lot more here within our sovereign cloud.

00:15:01.525 --> 00:15:24.347
But right now a lot of it is based upon we structure it on team, so we have an overarching O365 team that has a where we give licenses available there, and then we have a power app where, as you just come in there, we have that approvers Okay, give this personal license, take this license away, because we have people come in and out of teams.

00:15:24.347 --> 00:15:27.081
We have people that shift to different places around the world.

00:15:27.081 --> 00:15:30.090
Maybe their organization is going to give them a license now.

00:15:30.090 --> 00:15:38.395
So we need to be able to not only take those away, but not take those away if they got a new one from their new organization all that kind of stuff.

00:15:38.395 --> 00:15:40.268
So a lot of times it's based around.

00:15:40.268 --> 00:15:44.446
We have a very simple way, just a very simple MDA.

00:15:44.446 --> 00:15:54.094
We put a Canvas app on front of there to allow some of that stuff, but the first part of it is just getting that O365 team, because that's a really simple way for us.

00:15:55.014 --> 00:15:55.235
Nice.

00:15:55.235 --> 00:16:00.339
Tell me about fusion teams and how do you think about this?

00:16:00.339 --> 00:16:05.562
How do you think about standing this up inside an organization that you're working with?

00:16:05.562 --> 00:16:20.673
And I'll just say one thing I know that a fusion team can have this term citizen developer within it, but I tend, in the way I segregate it in my mind, is that you have citizen developers who can build solutions for personal productivity.

00:16:20.673 --> 00:16:29.024
One of them might get elevated to a broader use case, but there's going to be a lot of other rigor that's going to go around that in that use case scenario.

00:16:29.024 --> 00:16:30.380
So let's put that over to one side.

00:16:31.375 --> 00:16:41.076
In my mind, fusion Development is what I would call your more traditional development that's been around for the last 20 odd years in the Microsoft space.

00:16:41.076 --> 00:16:44.125
That originated with Dynamics or MSCRM originally.

00:16:44.125 --> 00:16:49.984
That is, you have a robust team of specialists.

00:16:49.984 --> 00:16:59.586
There'll be subject matter specialists, there will be developers, there will be architects, there'll be analysts, testers, project managers, program managers, et cetera, et cetera.

00:16:59.586 --> 00:17:00.799
And change managers Because I program managers, etc, etc.

00:17:00.799 --> 00:17:05.626
And change managers because I know that people listen to the show and know how important I believe change management is.

00:17:06.394 --> 00:17:12.998
Tell me how do you think about fusion teams and how do you explain that to folks that you need to as part of a project?

00:17:13.660 --> 00:17:21.425
I'm really glad you showcase it in that way that it's not just your traditional software developers and local developers working together making magic.

00:17:21.425 --> 00:17:22.720
It's more than just that.

00:17:22.720 --> 00:17:28.064
You really have to have everybody from your scrum master, your project manager, everybody involved inside of this.

00:17:28.064 --> 00:17:37.423
And because I think that's where a lot of people lose the love language of what software development is when you say, oh well, it's just these two teams working together doing good stuff.

00:17:37.423 --> 00:17:50.647
So when we like in our organizations we typically build applications, we have the product manager, we have that, or the team lead who is managing the day-to-day operations.

00:17:50.647 --> 00:17:51.348
See what's going on.

00:17:51.348 --> 00:17:58.904
And then if there are specialized, things need to be put out, like if we need to build a specialized website.

00:17:58.904 --> 00:18:10.282
Things need to be put out Like if we need to build a specialized website, or we need to maybe have some sort of specialized code that's like a NET type application that's going to be concatenated with this local application, like how those things are going to be melding together.

00:18:11.056 --> 00:18:18.405
One thing that we try to do when making a lot of this stuff is how do we actually manage that workload?

00:18:18.405 --> 00:18:19.643
How do we actually manage the product owners?

00:18:19.643 --> 00:18:20.307
How do we manage the workload?

00:18:20.307 --> 00:18:31.102
How do we actually manage the product owners, how do we manage the stakeholders, how do we manage a lot of that stuff, and I personally built our own product management tool within the Power Platform.

00:18:31.102 --> 00:18:33.442
We did this for a number of reasons.

00:18:33.442 --> 00:18:48.705
First off, it allowed us to do experimentation on Dataverse Power Platform how we can build our own code to then give to our customers, because we like the adage of eating your own dog food.

00:18:48.705 --> 00:18:53.903
If by golly I'm not willing to use it every day, then why should I expect my customers to use it every day?

00:18:53.903 --> 00:19:15.345
So we built this low-code project management tool that allows us to track everything from sprint cycles to what's going on with the code as it's pushing through Power Platform pipelines, as it's going through the solutions, tracking all that kind of stuff all done in one single pane of glass there.

00:19:15.655 --> 00:19:19.182
With that project management tool it's grown a lot.

00:19:19.182 --> 00:19:25.105
Initially it was just it was an idea that we had out there in a SharePoint list and evolved into a project.

00:19:25.105 --> 00:19:28.098
That evolved into Dataverse tables and all this great stuff.

00:19:28.098 --> 00:20:02.655
But I'm a huge advocate for using this tool for us at least because it allows us to really experiment with what the tools can do and how we can make our customers' lives better and through that we're able to then enhance our conversation with our security governance team, with our EAs, because then they themselves are in the tool every day, making decisions for how we're going to be promoting code, how we're going to be maybe not promoting something, deprecating something or whatever.

00:20:02.655 --> 00:20:09.410
So then they can make educated decisions as to how they can then go use these tools themselves in other projects.

00:20:09.410 --> 00:20:15.017
Or when somebody asks them about building something for a customer, they go oh well, you know what?

00:20:15.017 --> 00:20:18.936
We kind of already solved this internally ourselves with a power platform type solution.

00:20:18.936 --> 00:20:23.880
Maybe we can go do the same thing and it's actually happened quite a few times now where our customer goes.

00:20:23.880 --> 00:20:24.240
You know what?

00:20:24.240 --> 00:20:28.663
We already did this let's just spin off this module and go throw it over the fence with this team here.

00:20:28.663 --> 00:20:31.884
So I'm a huge advocate for doing it.

00:20:32.474 --> 00:20:33.777
It's not suited for everybody.

00:20:33.777 --> 00:20:34.238
I will.

00:20:34.238 --> 00:20:38.644
If you are somebody who loves your ADO, you love your Jira, go for it.

00:20:38.644 --> 00:20:46.284
This is something that's worked very, very well for us, particularly in helping educate people on what the Power Platform is and how it is to be used.

00:20:46.284 --> 00:21:00.938
It also really helps junior developers get up to speed, because if you have folks who are coming out of the platform very new and they may have messed with some Canvas stuff, a little bit of Dataverse, but they're really wanting to understand.

00:21:00.938 --> 00:21:04.227
Okay, how does JavaScript work with inside of an MDA?

00:21:04.227 --> 00:21:09.748
Or how do I integrate Power BI pipelines with Power Platform pipelines?

00:21:09.748 --> 00:21:13.584
Using this tool allows us to accelerate a lot of that stuff.

00:21:14.286 --> 00:21:14.487
Nice.

00:21:14.487 --> 00:21:16.941
Is that something that's up on AppSource?

00:21:16.941 --> 00:21:19.501
It is, or is it just really with your clients?

00:21:20.035 --> 00:21:21.561
So actually I have the whole thing on GitHub.

00:21:21.561 --> 00:21:28.364
I have a blog where I walk through the entire thing on how to do it, so feel free to copy it at your will.

00:21:28.364 --> 00:21:30.099
Yeah, yeah, it is a lot of fun.

00:21:30.099 --> 00:21:32.102
I make updates to it all the time.

00:21:32.102 --> 00:21:36.606
I'm actually working on a solutions watcher right now for managed environments.

00:21:37.327 --> 00:21:52.304
One thing that against security is a big thing I hit on because I used to be a security guy for many, many years was what happens when people want to go download a solution, go download a PCS solution and you want to install it inside their environment.

00:21:52.304 --> 00:21:53.467
Who approved that?

00:21:53.467 --> 00:21:55.259
Who said, yes, you can put that there.

00:21:55.259 --> 00:21:56.380
No, you can't put that there.

00:21:56.380 --> 00:22:10.588
So, being able to not only see what's being installed inside of each of your solutions, your dev, test fraud or whatever it may be, but then put some approvals around it and then, if you didn't approve it, delete it out of there.

00:22:10.910 --> 00:22:14.662
So stuff like that, yeah, and doing things before makes its way up into production.

00:22:14.662 --> 00:22:17.299
Doing things at the lower levels, yes, doing things at the lower levels, yes.

00:22:17.299 --> 00:22:18.824
So that's a big part that I've been working on.

00:22:18.824 --> 00:22:20.406
I'm just about ready to publish it out there.

00:22:20.406 --> 00:22:23.810
I was actually looking at another post right before I got on the call with you.

00:22:23.810 --> 00:22:25.176
So it is a.

00:22:25.176 --> 00:22:28.123
I really really like the project.

00:22:28.123 --> 00:22:28.944
I really like the solution.

00:22:28.944 --> 00:22:40.938
I really hope that more people will look at it and build it yourself and see how it works for you Because, as I said, it works great for us and it works great for getting people on board with how to use these tools.

00:22:41.720 --> 00:22:42.121
I like it.

00:22:42.121 --> 00:22:46.059
Send us the link and we'll get that in the show notes so people can click on it and go see it.

00:22:46.059 --> 00:22:52.896
My final question I kind of want to wrap with is really looking at.

00:22:52.896 --> 00:23:11.651
You know, my career started 20 years ago over 20 years ago with MSCRM right, which, incidentally, if you look at the OG tool that Microsoft purchased, it was purchased by guys that were in the military that used it for IED tracking.

00:23:11.651 --> 00:23:17.417
It was the OG tool way back in the day, so it actually has its foundations there.

00:23:17.478 --> 00:23:29.817
But if we have a look across that period, there's the risk and I have been guilty of this of looking at back then Dynamics CRM as the golden hammer.

00:23:29.817 --> 00:23:34.426
I could build anything I wanted with this tool.

00:23:34.426 --> 00:23:37.778
I've built stupid things with this tool and sold them.

00:23:37.778 --> 00:23:50.017
The worst, I feel stupidly, this is when it was on-prem, non-cloud right was a payroll system that ran inside Dynamics 365 sales, as we would call it today.

00:23:50.017 --> 00:24:00.955
And then the risk then in the age of the power platform, is we then no longer have just a golden hammer, we have a golden toolbox, which is everything in the power platform right.

00:24:01.738 --> 00:24:11.942
And I feel that sometimes, because of this history and this legacy that people, particularly consultants, recommending solutions.

00:24:11.942 --> 00:24:36.763
They don't go outside that toolbox, fundamentally because they don't know what's outside the toolbox and so therefore, they don't want to recommend something that they are, one they're not up to speed on, and they've sat so long in this one area, Like back in the day it used to be finance and operations or Dynamics 365, ax and NavVision, et cetera, against CE, and it was even walled at the Dynamics level.

00:24:36.763 --> 00:24:42.827
But if we go higher up, then we've got Azure, we've got M365, we've got all the great stuff.

00:24:42.827 --> 00:24:51.086
The latest stuff like Fabric and Purview and so many other pieces are now part of that tooling.

00:24:51.086 --> 00:25:01.404
And then we stick outside the Microsoft ecosystems and we're plugging into things like SAP and ServiceNow and any number of X, you name it.

00:25:01.595 --> 00:25:08.404
And for years, my concern in recent times is seeing this golden toolbox type view of things.

00:25:08.404 --> 00:25:10.320
How do you handle this?

00:25:10.320 --> 00:25:43.521
And when you look at the enterprise projects you've been involved in, how much are you really stepping outside that tool set, particularly around accessing datasets et cetera, that don't just sit in either the Microsoft ecosystem or you know, I was talking with somebody recently who did this passport implementation system and there's certain biometrics type software that isn't sold by Microsoft right, it is a third party solution in the security space around this, so there's always going to be these integrations and sometimes other tools are fit for purpose.

00:25:43.521 --> 00:25:43.863
What are your?

00:25:43.883 --> 00:25:44.163
thoughts.

00:25:44.163 --> 00:26:00.859
I love the question and as actually I'm going to steal an answer that I heard at a conference, so if I know SharePoint, I know Power Apps, I know SAP, I got that SharePoint hammer, I got that SAP hammer and by golly, every problem that comes my way I'm going to beat it with that hammer.

00:26:00.859 --> 00:26:05.042
It may not be the right tool for the job, but by golly I'm still going to hit that problem.

00:26:05.042 --> 00:26:11.464
And then that's actually a really it's a hard thing to get out of Because I come from network operations guys.

00:26:11.464 --> 00:26:13.201
I did large-scale network operations.

00:26:13.201 --> 00:26:16.599
Cisco was my answer to everything Cisco, cisco, cisco.

00:26:16.599 --> 00:26:21.929
And then the Cisco Firepower came out and I hated it.

00:26:21.929 --> 00:26:29.755
And then, because they came out with the security test and I didn't do great on the Cisco Firepower certification test, I was like no.

00:26:29.755 --> 00:26:31.358
So I went and learned Palo Alto.

00:26:31.358 --> 00:26:32.604
I was like, oh, this is so much better.

00:26:32.604 --> 00:26:33.961
Why wasn't I doing this for years?

00:26:33.961 --> 00:26:46.366
So yeah, getting out of that bailiwick of things you feel comfortable with is definitely a hard thing to do and fortunately, within our particular sphere, it's something we have to do.

00:26:46.366 --> 00:26:49.740
We are not.

00:26:49.799 --> 00:26:54.229
Any number of our datasets are usually within multiple locations.

00:26:54.229 --> 00:26:58.957
There's going to be some things within a lot of things In SAP.

00:26:58.957 --> 00:27:02.266
A lot of things are going to be maybe in some SharePoint type stuff.

00:27:02.266 --> 00:27:04.864
A lot of stuff could be in AWS type databases.

00:27:04.864 --> 00:27:09.047
They're going to be all around because different decisions we're making different times.

00:27:09.734 --> 00:27:14.106
And one thing I really like to showcase to people when using the Power Platform is it can be that center.

00:27:14.695 --> 00:27:16.454
It doesn't have to be the answer for all your things.

00:27:16.454 --> 00:27:23.339
It may not be the database for you, it may not be the database for you, it may not be the app for you, but it can be something that can help move things and connect things.

00:27:23.339 --> 00:27:28.603
So it's hard to get out of that mindset Like this is like I feel comfortable.

00:27:28.603 --> 00:27:30.542
I know I can fix this problem using this.

00:27:30.542 --> 00:28:09.710
It may have to take a little while and I may have to do some really interesting things and I may have to spend a little more time versus if you went with a purpose-built tool for the operation or you let data stay where it's at today and simply connected maybe your power platform solution to a virtual table or you use some of those SAP connectors within the power platform, or maybe it's not a power platform solution you need to be building, maybe it's something that needs to be something else, but it's about educating security governance folks for how to be better with all these tools.

00:28:11.776 --> 00:28:12.902
Hey, thanks for listening.

00:28:12.902 --> 00:28:17.987
I'm your host business application MVP Mark Smith, otherwise known as the NZ365 guy.

00:28:17.987 --> 00:28:21.919
If there's a guest you'd like to see on the show, please message me on LinkedIn.

00:28:21.919 --> 00:28:25.737
If you want to be a supporter of the show, please check out buymeacoffeecom.

00:28:25.737 --> 00:28:28.403
Forward slash NZ365 guy.

00:28:28.403 --> 00:28:31.288
Stay safe out there and shoot for the stars.

Revolutionizing Federal Operations: Ed Williams on Power BI, CRM Systems, and Power Platform Integration

Listen On

Recent Episodes

Revolutionizing Federal Operations: Ed Williams on Power BI, CRM Systems, and Power Platform Integration

Join over 1500 Power Platform & Dynamics 365 pros for a quick, fun, and insightful 4-minute read each week!

Subscribe to Tech Trailblazer newsletter

Listen On

Recent Episodes