Welcome to Dynamics Corner Podcast!
Episode 337: In the Dynamics Corner Chair: Fabric meets Business Central in the Great Lakes
Episode 337: In the Dynamics Corner Chair: Fabric meets Bus…
In this episode, Bert Verbeek speaks with Brad and Kris about Microsoft Fabric: what it is, how to use it, and how it integrates with Micro…
Choose your favorite podcast player
Sept. 3, 2024

Episode 337: In the Dynamics Corner Chair: Fabric meets Business Central in the Great Lakes

Episode 337: In the Dynamics Corner Chair: Fabric meets Business Central in the Great Lakes

In this episode, Bert Verbeek speaks with Brad and Kris about Microsoft Fabric: what it is, how to use it, and how it integrates with Microsoft Dynamics 365 Business Central. The conversation also clarifies what we do with the Great Lakes—Data Lake and One Lake. They discuss how Microsoft Fabric is a powerful tool for businesses to leverage their data and make informed decisions.

#MSDyn365BC #BusinessCentral #BC #DynamicsCorner

Follow Kris and Brad for more content:
https://matalino.io/bio
https://bprendergast.bio.link/

Chapters

00:00 - Exploring Dynamics 365 and Microsoft Fabric

18:01 - Data Management and Reporting in Fabric

30:53 - Utilizing Fabric and Dataverse in Businesses

44:03 - Understanding AI Prompting in Data Science

Transcript

WEBVTT

00:00:00.480 --> 00:00:07.314
Welcome everyone to another episode of Dynamics Corner, the podcast where we dive deep into all things Microsoft Dynamics.

00:00:07.314 --> 00:00:17.812
Whether you're a seasoned expert or just starting your journey into the world of Dynamics 365, this is your place to gain insights, learn new tricks and what it takes to create a fabric.

00:00:17.812 --> 00:00:19.225
I'm your co-host, chris.

00:00:19.960 --> 00:00:20.702
And this is Brad.

00:00:20.702 --> 00:00:24.972
This episode was recorded on August 26th 2024.

00:00:24.972 --> 00:00:28.048
Chris, chris, chris Fabric.

00:00:28.048 --> 00:00:30.667
Every time I hear fabric, I think of clothing.

00:00:31.431 --> 00:00:37.130
What I'm wearing, yes yes, or sewing how it connects together, it woves together.

00:00:37.479 --> 00:00:44.722
See, this is where some of these names come from, I believe, and also we had the opportunity to talk about jumping into the lake With us today.

00:00:44.722 --> 00:00:46.488
We had the opportunity to speak with Bert.

00:00:46.488 --> 00:01:06.025
Hello, good afternoon, how are you doing?

00:01:06.364 --> 00:01:10.251
hi, good afternoon, I'm fine, thanks.

00:01:10.251 --> 00:01:11.433
Thanks for having me.

00:01:11.433 --> 00:01:11.861
How are?

00:01:11.861 --> 00:01:16.611
You uh brennan, chris ah, everything's going well over here.

00:01:16.650 --> 00:01:28.942
Chris and I were just talking about how we need to have, like, a pre-podcast pump-up song or something, because we sit and talk before the podcast and before whomever we're speaking with joins.

00:01:28.942 --> 00:01:37.066
We need something to rally us up, to get us a little excited, especially the time difference, because it's really early here.

00:01:39.792 --> 00:01:43.506
Wake me up here, maybe the song Eye of the Tiger.

00:01:43.947 --> 00:01:49.347
I always We'll have to try that, chris, later on to see.

00:01:49.347 --> 00:01:53.301
We're always excited, but I want to just have like an intro or something for us.

00:01:53.301 --> 00:02:07.483
Just like you know, I can picture like a football game or a sports game where people are in the locker room or the tunnel waiting to run out yeah, pumping the music, let's go, let's go, you know, or some sort of match it would be good, that does always thing right.

00:02:07.602 --> 00:02:17.472
If you play the right music I'm also also doing that with sports, indoor cycling then just a good music and a quite a good beat.

00:02:18.373 --> 00:02:20.459
Yeah yeah, no, it's good.

00:02:20.459 --> 00:02:21.621
It even works with workouts.

00:02:21.621 --> 00:02:30.108
I noticed I listened to some I techno music with upbeat music when I work out because it gives me that energy and drive to go through.

00:02:30.108 --> 00:02:31.406
Sometimes it's a little difficult.

00:02:32.080 --> 00:02:41.270
Do any of you do that when you're like, when you're focusing on work and you play music in the background, or at least through your headset, however, you listen?

00:02:41.270 --> 00:02:42.866
Do you ever any of you both do that?

00:02:42.866 --> 00:02:44.605
Yeah, I do that often.

00:02:44.645 --> 00:02:48.848
Yeah, that, however you listen, do you ever any of you both do that?

00:02:48.848 --> 00:02:50.453
Yeah, I do that often, yeah, yeah, yeah, I do that often.

00:02:50.453 --> 00:02:52.318
I listen to, to music, um, to kind of just keep me energized.

00:02:52.318 --> 00:03:04.948
To be honest with you, I listen to techno music, then sometimes country music for a certain point, but then also I found like classical music or symphony yeah, it's good you're focusing yeah, it's good for focusing.

00:03:04.967 --> 00:03:05.688
Yeah, it's good for focusing.

00:03:05.688 --> 00:03:08.532
Indeed, that's very correct, brett.

00:03:08.532 --> 00:03:18.611
When I also need to focus and concentrate on one thing, I play always some classical music with no voice, or just the classical.

00:03:20.963 --> 00:03:22.308
Yes it's amazing how it works.

00:03:22.308 --> 00:03:24.427
It helps you really get into the zone and focus.

00:03:24.427 --> 00:03:36.187
Albert, thank you for taking the time to speak with us this morning, this afternoon, this evening, whatever it is, wherever anyone is, and we've been looking forward to speaking with you.

00:03:36.187 --> 00:03:42.659
And before we jump into it, could you tell everyone who's listening who doesn't know a little bit about yourself?

00:03:43.600 --> 00:03:45.644
Yeah, thanks for having me, Brett and Chris.

00:03:45.644 --> 00:03:48.008
I'm Bert Beek.

00:03:48.008 --> 00:04:03.443
I am 41 years old, married, have three children, living in a small city in the Netherlands, the same city as AJ Kaufman I recently discovered.

00:04:03.443 --> 00:04:12.447
The beginning of this year, we were in a conference in Denmark and we said maybe we can drive together.

00:04:12.447 --> 00:04:14.189
And oh, where are you from?

00:04:14.189 --> 00:04:14.751
Barneveld?

00:04:14.751 --> 00:04:17.081
Oh, I'm exactly the same.

00:04:17.081 --> 00:04:23.514
So we didn't know that for a couple of years we are living in the same city.

00:04:23.514 --> 00:04:34.779
Over a couple of years we are living in the same city, never met each other there, and I'm working at 4PS as technical solution architect.

00:04:34.779 --> 00:04:50.228
They are working for 12 years, but 70 or 80 years working with Dynamics, na, nev and Business Central and mostly focusing on the technical part and also the functional part of Business Central.

00:04:50.228 --> 00:04:53.526
That's great.

00:04:53.605 --> 00:04:54.187
It's interesting.

00:04:54.187 --> 00:04:56.312
It's a small world, it's a really small world.

00:04:56.312 --> 00:05:05.759
I come across individuals everywhere that have some sort of connection, and it's cases such as yours, where you and AJ live in the same area.

00:05:05.759 --> 00:05:07.966
You said netherlands, did you watch the race?

00:05:07.966 --> 00:05:09.209
Did you go to the room?

00:05:09.250 --> 00:05:15.161
no, I don't go to the race, uh, because the price dates are quite expensive.

00:05:15.161 --> 00:05:34.514
Uh, I watched only the starting, and that that's maybe because, um, and that's maybe because last season it was perfectly because Max won and stuff like that, and now, yeah, it's a little bit getting annoying.

00:05:34.514 --> 00:05:38.557
Maybe that's the orange culture here.

00:05:44.490 --> 00:05:46.720
If you know Max is not winning, you don't watch.

00:05:46.720 --> 00:05:49.569
Ah, I am so happy when Max doesn't win and I'm happy to see that others are winning.

00:05:49.569 --> 00:05:50.173
It makes for a better race.

00:05:50.173 --> 00:06:03.882
I mean, it was a stretch of time there not to talk all about f1, but there was a stretch to have time where the you know, even on the television they were focusing on the middle of the pack because it was a better race, because max was always so far ahead.

00:06:03.882 --> 00:06:11.346
At least yesterday we could talk about it, because by the time this is released if someone doesn't know the results then you know they.

00:06:11.346 --> 00:06:12.788
They probably won't be watching it.

00:06:12.788 --> 00:06:19.108
But just to see norris finish so far ahead of max just made me happy yeah, indeed, but that that was very crazy.

00:06:19.228 --> 00:06:25.526
It was, uh, I'm not sure, 16 or 17 minutes, sorry, seconds before it's.

00:06:25.526 --> 00:06:32.134
It's just crazy how fast Norris was at the second half of the season.

00:06:33.841 --> 00:06:34.846
Oh, I like it.

00:06:36.942 --> 00:06:46.149
I can see, indeed for other countries, that there are some better competitions on it and truly had the better for Formula 1.

00:06:46.149 --> 00:06:52.372
But yeah, I'm a Dutch guy so I was hating it.

00:06:53.882 --> 00:06:55.680
No, no, I understand, you have to have loyalty.

00:06:55.680 --> 00:07:04.410
Just as a side note, I did go to F1 Miami, where Norris won his first race and started this whole trend of Max losing, which I'm so happy.

00:07:04.470 --> 00:07:23.069
Yeah, indeed, you know, it's like I I said it makes weird days, but to uh to bring it back, um, you know, one of the things that we were talking about and uh, that's, you know, strikes us some interest, uh, that I believe you also have some interest in is this whole, uh, fabric type stuff.

00:07:23.069 --> 00:07:42.949
This fabric type stuff, chris, I'm not talking fabric like to make clothes, I'm talking about a different type of fabric, and even more so because I've seen some articles and I've seen some information that Dynamics 365 Business Central now can work with fabric.

00:07:42.949 --> 00:07:45.228
I don't know what it's making, but it can work with Fabric.

00:07:45.228 --> 00:08:02.310
So if you would, bert, if you could help shed some light on, maybe, what is Fabric, what is MS Fabric, and then, how does it fit with Business Central and how does it fit in the Dynamics 365 ecosystem?

00:08:02.310 --> 00:08:04.374
There's a lot there.

00:08:05.060 --> 00:08:16.427
There's quite a lot and indeed I can know that people don't know Microsoft Fabric because it is quite a new product in this time.

00:08:16.427 --> 00:08:26.971
I thought in May last year Microsoft has launched Fabric and in November last year it went GA for it.

00:08:26.971 --> 00:08:47.354
And what you see mostly when you cut a data warehouse because Fabric is all about data warehousing and consulting and analyzing your data what the problem mostly is is that the integrations are very complex.

00:08:47.354 --> 00:09:22.567
When you move or starting to move from, for example, bicentral or Sales, or you have got another solution and you want to move that data to a data warehouse or a database, it is quite cumbersome and difficult, especially when you are upgrading your solutions and one data is stored in one database for analytics and another one in another database.

00:09:22.567 --> 00:09:34.261
You want to combine it and you have to move all the data and there you can see that people are losing interest Even right now.

00:09:34.282 --> 00:09:57.794
You've got quite good examples in Azure with Data Factory and Synapse Links and all that kind of stuff, and that's what Marks of Fabric wants to cover all Just a very easy to implement and to import data inside Marks of Fabric in it.

00:09:57.794 --> 00:10:16.927
That's in a few sentences from what Mark's Fabric is Just to have have easy import your data in it, analyze it and then show it to the world.

00:10:17.610 --> 00:10:36.076
In that case, oh okay, so is Microsoft Fabric in essence a different type of data warehouse or a data warehouse in Azure that is intended to have centralization of data or easier centralization of data?

00:10:36.076 --> 00:10:39.625
I hear of this fabric and I also see.

00:10:39.625 --> 00:10:48.884
I enjoy the terms because I associate them with many things Fabric I always think of sewing and clothing, and then MS Fabric also has another thing.

00:10:48.884 --> 00:10:54.707
It's called lakes and one lakes and data lakes, and I think of lakes as swimming lakes.

00:10:54.707 --> 00:11:04.109
So maybe you could shed some light on the terminology of a data lake or a lake and how it relates to fabric.

00:11:04.860 --> 00:11:13.592
Well, what I always say, what you say is, when you are similar to a lake, is how you can swim in it.

00:11:13.592 --> 00:11:19.188
In a lake, there are tons and millions of data in it.

00:11:19.188 --> 00:11:27.394
For example, you can swim in it and it's quite large and you don't know how large it is.

00:11:27.394 --> 00:11:47.013
And what Microsoft wants to cover is and that's also the marketing function of Microsoft is they call it One Lake Because first, before Fabric, you see that there are quite a couple of data lakes in it.

00:11:47.720 --> 00:12:03.708
Maybe you've got a data lake for your finance data, for your marketing data or HR data, and in one lake that is just all stored in one data lake.

00:12:03.708 --> 00:12:10.269
Underneath one lake there is Azure Data Lake, but it calls One Lake.

00:12:10.269 --> 00:12:40.852
So if you're importing the data inside the One Lake and everybody consumes that data in there, so you don't have to export it anymore to another data lake you can easily combine it just from one silo to another silo, and that's the perfect thing about the one lake in that.

00:12:40.852 --> 00:12:53.169
So what I said, you don't have to have separate data lakes anymore, you can just do it in one lake, and it's mostly similar to what you have in your OneDrive storage.

00:12:53.169 --> 00:13:01.052
Onedrive is all what you gather around, you put it in there and everybody can use it.

00:13:01.052 --> 00:13:08.981
You can share it, you can use it on your own, and that's just the one leg for data warehousing.

00:13:09.462 --> 00:13:31.650
In that case, so I guess I'm trying to have a bigger grasp, because back in early days when you're on-prem, you know, you just stand up a separate SQL database and then you're just like, oh, let's just throw everything in there, pull everything in one SQL database, and then you create SSRS, report or connect some other tools.

00:13:31.650 --> 00:13:40.595
So now that we're online, is this sort of a replacement, or is Fabric sort of a replacement of that concept back then?

00:13:42.542 --> 00:14:00.174
Sort of sort of back then Sort of sort of, because what you see in the SQL database it is all structured, it's all structured data and inside your one lake you can have unstructured data and structured data.

00:14:00.174 --> 00:14:06.432
In that case you have got a lake house or a warehouse.

00:14:06.432 --> 00:14:18.548
So an unstructured data is just data that you put in there and you really don't know what it is, what type of data is in there.

00:14:18.548 --> 00:14:31.327
It is all unstructured and that you are going to convert from an unstructured data set to a structured data set and that you are going to convert from an unstructured data set to a structured data set and there a warehouse is more.

00:14:31.327 --> 00:14:33.780
Yeah, the same.

00:14:34.503 --> 00:14:40.846
Chris, what you said is on an on-prem SQL server where you then connect all your tools on it.

00:14:40.846 --> 00:15:06.131
So that's mostly based here on a, a warehouse and what you can easily do also with a warehouse, also with a Lagos, that you can attach not attach, sorry you can see it like in SQL database in the front-end, so you can use your SQL commandlets and all that stuff you can use there.

00:15:06.131 --> 00:15:11.711
Also you connect with the other parties that can read SQL.

00:15:11.711 --> 00:15:22.870
But in the backend it is not stored in just tables but it's in a Delta Parquet format in it.

00:15:26.663 --> 00:15:28.340
So with it being unstructured?

00:15:28.340 --> 00:15:32.788
I hear a lot of structured and unstructured data so maybe we'll go all over the place.

00:15:32.788 --> 00:15:45.827
So with it being structured data, it's normalized in a sense of how we would think of like a customer table, where it's defined as you have these fields, elements and records in here.

00:15:45.827 --> 00:15:54.754
To come up with a customer, a data lake would be just data that anybody throws in there, as you're saying, because it's unstructured.

00:15:54.754 --> 00:15:58.779
But how would they get it in and get it out if it's not structured?

00:15:58.779 --> 00:16:07.191
Because is it unstructured in the sense that the application isn't holding the structure, but the user of the data is defining the structure of what they're putting in?

00:16:07.191 --> 00:16:20.279
Because if I had customer data in one system, could I put it in the data lake or the one lake and then retrieve that information out or combine it with customers of another system that may have a different structure.

00:16:20.279 --> 00:16:32.932
This whole I'm trying to visualize structure and unstructured data and and how we can associate or view it yeah, mostly what you can say about.

00:16:33.094 --> 00:16:57.254
Yeah, sometimes it is quite difficult because when you are, for example, base central, how you've got a customer table, you're importing that in your lake house and then you say, okay, it is unstructured, even though that in BIS Central it is structured because you've got rows and columns and stuff like that.

00:16:57.254 --> 00:17:08.890
But when you want to report something, you want a better structure on it, so like you've got some kind of dimensions on it.

00:17:08.890 --> 00:17:16.630
What's your open demands on it?

00:17:16.630 --> 00:17:37.731
All that kinds of dimensions you can create on there and that's how you combine also with other sources that you put in your warehouse where it is structured and where a user can immediately report on it in that case.

00:17:37.731 --> 00:17:56.773
So it's more like a structured data that the user can immediately build a Power BI, report on it without any merging or remove columns and create dimensions on it.

00:18:00.265 --> 00:18:01.366
This is interesting.

00:18:01.366 --> 00:18:04.093
How does that work with performance?

00:18:04.093 --> 00:18:10.894
See, I know SQL rather well so I'm trying to anyone else that may understand SQL or visualize SQL.

00:18:10.894 --> 00:18:14.891
So, sql you have the rows and the columns, as we had discussed, within the tables.

00:18:14.891 --> 00:18:16.827
You can have multiple tables within a database.

00:18:16.827 --> 00:18:29.806
In large data sets often there are indexes that have information and just a quick retrieval of the data with the columns that they include and the columns that they're sorted by clustered and non-clustered indexes.

00:18:29.806 --> 00:18:39.534
If you have unstructured data, how does it work with performance when you have a large data set with this?

00:18:39.534 --> 00:18:40.394
Or is it just magic?

00:18:42.021 --> 00:18:43.326
Yeah, it's always magic.

00:18:43.326 --> 00:18:54.481
No, no, it is stored not in a table, what you said with the columns and the rows and stuff like that.

00:18:54.481 --> 00:19:07.548
It is stored inside One Lake in a Delta per K file, and Delta per K file is just optimized for very fast reading for that performance.

00:19:07.548 --> 00:19:46.172
It is also and parquet file is also not based, what I said, on rows, but it is more based on columns, so you can very easily search, combine columns together and read your data, because if you combine multiple Parquet files and merge it to a structured data table sorry, a structured data set that's also based on a Parquet file.

00:19:46.172 --> 00:19:57.930
So it's all based on that particular Delta Parquet format and that's why it is reading that fast, faster.

00:19:57.970 --> 00:20:13.688
Yeah, yeah, so with that it sounds like then is so Fabric is more intended to be, as Chris had talked about, where you have information, a SQL survey in early days, just trying to equate it where you copy the data to a data warehouse.

00:20:13.688 --> 00:20:19.529
So Fabric is meant to be a destination for a lot of data, not necessarily transactional.

00:20:19.529 --> 00:20:33.711
So the intention of because you had mentioned that the files are meant for fast reading, so you wouldn't use it as a lake to store your data for your transaction, your day-to-day use, it would be where you would offload your data so that it could be read and queried upon.

00:20:33.711 --> 00:20:36.842
So that's, in essence, how it's used.

00:20:37.041 --> 00:20:44.030
yeah, perfect, perfect now with with fabric, um, Fabric.

00:20:44.030 --> 00:20:49.096
I'm trying to again trying to understand this fully, right?

00:20:49.096 --> 00:20:57.775
So when you're implementing Business Central Online and it kind, of people always have that question.

00:20:57.775 --> 00:21:01.723
It's like how do I report against it, how do I build a data warehouse?

00:21:01.723 --> 00:21:11.482
So should that be a natural path for organizations?

00:21:11.482 --> 00:21:20.772
They should always consider fabric to do some reading of reports or maybe utilizing Copilot.

00:21:20.772 --> 00:21:30.665
Right Now that you have this larger, more of a fabric one like database, Could you call it database?

00:21:30.665 --> 00:21:32.443
Wait, can you still?

00:21:34.423 --> 00:21:36.852
Yeah, I think you could feel it Okay.

00:21:36.852 --> 00:21:40.107
And utilizing all the Copilot tools.

00:21:40.107 --> 00:21:41.251
Is that a natural?

00:21:41.251 --> 00:21:46.207
Should that be a natural path for organizations when they get to Business Central Online?

00:21:47.421 --> 00:21:54.513
No, I think, and that's what you see also in Business Central.

00:21:54.513 --> 00:22:23.049
You've got some very good reporting with the NLS views, currently also with the Excel reporting, and I'm really a fan of that one, and I think if you're quite a small company, you can use the Excel reporting and there are also now some Power BI reports that consumes the APIs on it.

00:22:23.049 --> 00:22:31.288
That's enough for just a small customer or a small company, I think.

00:22:31.288 --> 00:22:57.382
If you want to more complex data, combining data from Business Central with an HR system, or even if you're using Power Platform with Dataverse on it, and if you want to combine that data, I think, then it's really interesting to go to Fabric in that case.

00:22:57.382 --> 00:23:21.432
So it's, if you have just reporting and, yeah, reporting is more, I think, about showing a list or combining two, three tables together, and that's your overview Then I think Dissental right now has the tools in it for it.

00:23:21.432 --> 00:23:22.541
Right now has the tools in it for it.

00:23:22.541 --> 00:23:29.933
But if you want to one step further, then I definitely want to recommend Marks of Fabric in it.

00:23:32.324 --> 00:23:42.794
Yeah, with Fabric and Business Central it's what we talked about with tools you had mentioned to make it easier to import data into the lake.

00:23:42.794 --> 00:23:44.539
I love calling it a lake.

00:23:44.539 --> 00:23:48.779
I always want to think of swimming and fishing, and that's how I look at it.

00:23:48.779 --> 00:23:50.226
There's a lot of data in the big lake.

00:23:50.226 --> 00:23:52.025
It's fish swimming around.

00:23:52.025 --> 00:23:55.690
Is the data we have to drop our fishing pole in to pull out the data?

00:23:55.690 --> 00:24:06.164
What is built in or what is set up with Business Central that allows for the easy importing of data within or exporting?

00:24:06.164 --> 00:24:15.194
However, if it goes that way into the data lake or into Fabric, into a data lake or one lake in Fabric?

00:24:15.576 --> 00:24:16.696
Indeed, indeed.

00:24:16.696 --> 00:24:28.441
It's sometimes confusing all those terms Indeed, all those terms, indeed.

00:24:28.441 --> 00:24:53.073
But if currently the situation is that you can only consume data from BizCenter into Fabric with the APIs that's the official statement of Microsoft in it and if you have quite a big database on it with a lot of tables and with a high volume of data, then it can be quite slow, I think, because it will affect your NSDs.

00:24:53.073 --> 00:25:08.907
And mostly when I look at our customers, they said okay, I want to have a two hour import from BizCentral into my fabric in my one day.

00:25:08.907 --> 00:25:31.031
In that case and that's not quite an interesting story because we've got one customer that does it every each two hours with the APIs and eventually they said okay, we have quite a performance drop when it is running.

00:25:31.031 --> 00:25:41.846
We don't know what it was running, but in the telemetry we saw okay, hey, but you are using those APIs quite heavily, so just put them off.

00:25:41.846 --> 00:25:44.352
And the performance went very well.

00:25:46.101 --> 00:25:59.752
And that's also what two years ago the Microsoft two guys from Microsoft has implemented BC2-ADLS, that is, a Bicentral to Azure Data Lake.

00:25:59.752 --> 00:26:02.659
So they're exporting data to Azure Data Lake.

00:26:02.659 --> 00:26:07.871
So they're exporting data from Base Central to Azure Data Lake and in deltas.

00:26:07.871 --> 00:26:18.289
So in that case it doesn't have a full export but only the deltas in it and it was extremely fast for it.

00:26:18.289 --> 00:26:23.348
It just exported in CSV and in this case it was Azure Data Lake.

00:26:23.348 --> 00:26:31.323
It will combine it and you can use it in Power BI and that tool.

00:26:31.442 --> 00:26:42.050
I thought, ok, when Microsoft Fabric was arrived, why don't we use the One Lake APIs just to store this central data into Microsoft Fabric?

00:26:42.050 --> 00:26:55.428
So in that case now B2A2S is also can move data very fast from business central to Fabric, in this case inside your OneLake.

00:26:55.428 --> 00:26:59.048
So in that case you can consume it.

00:26:59.048 --> 00:27:19.526
That test, just yeah, there's no source tool, but I definitely and that's a temporary tool, but I'm just betting on another one and that if that is official, then I will be crazy it is mirroring a SQL database.

00:27:19.526 --> 00:27:39.887
So in that case you very easily in Microsoft Fabric say, okay, I want this Azure SQL Server with this database, with those tables, and it is directly mirrored inside my Fabric space.

00:27:39.887 --> 00:27:50.369
So with a couple of seconds maybe one or two seconds if you change your business central data, it is there inside your Microsoft Fabric.

00:27:50.369 --> 00:27:53.667
So that will be fantastic.

00:27:55.342 --> 00:28:05.930
That does sound fantastic and it affords the opportunity to have some enhanced reporting without impacting business central, but you still have more or less real-time reporting.

00:28:05.930 --> 00:28:10.530
If the, as you had mentioned, I'm hooked on the analysis views.

00:28:10.530 --> 00:28:19.853
The analysis views, with being able to pivot and export and even save those views, is, what we say sometimes, a game changer.

00:28:19.853 --> 00:28:28.420
It gives users the ability to, once you have it, once you have a list established, and even being able to create pages off of queries.

00:28:28.420 --> 00:28:31.670
But now you can take that information a bit broader.

00:28:31.670 --> 00:28:37.786
It cuts down on the needs to have a lot of these one-dimensional I call them reports where it's always look at this information.

00:28:37.786 --> 00:28:42.722
In this view, that's the user of the application sort of control, as long as I mean.

00:28:42.722 --> 00:28:46.826
Again, it's important to understand the data, but they can control the information that they're looking at.

00:28:46.826 --> 00:28:54.891
As you were talking about this, with the data going from Business Central into Fabric, it made me think of Dataverse.

00:28:54.891 --> 00:28:59.834
Where does Dataverse or is that an outdated term now fit in all of?

00:28:59.875 --> 00:29:00.015
this?

00:29:00.015 --> 00:29:03.237
No, no, no, dataverse is not an old term.

00:29:03.237 --> 00:29:03.557
It is.

00:29:03.557 --> 00:29:12.391
Yeah, it is part of the Power Platform solution.

00:29:12.391 --> 00:29:23.446
So if you're using Power Platform, dataverse is the database of it, so that's the storage and there are also some connectors from Abyss Central to Dataverse of it.

00:29:23.446 --> 00:29:47.436
But Dataverse, what you said, is more for the power platform and also, if you are financing operations, it stores the data inside Dataverse and also with dynamic sales and stuff like that, and also with dynamic sales and stuff like that.

00:29:48.440 --> 00:29:53.316
But Dataverse is not a warehouse solution because it is quite expensive in that case.

00:29:53.316 --> 00:30:03.640
But you can also create some kind of shortcut to move your data from Dataverse inside Fabric.

00:30:03.640 --> 00:30:19.910
So in that case, what you can do, what you said, brett, with your analyst views, it is just a one-dimension view and that's really fantastic and really a game changer, I think, also for especially, the end users.

00:30:19.910 --> 00:30:33.942
For example, if you have got a PowerApp and you've got your BIScentral and both are representing inside Fabric, you can really do quite a lot of analysis on that one.

00:30:33.942 --> 00:30:50.703
So in that case, it is really fantastic just to have your data from the Power Platform combined with BizCentral and that is really fantastic with your NLS on it.

00:30:53.067 --> 00:30:58.699
So is Dataverse another unstructured database that's meant for a transactional database, or is it?

00:30:58.699 --> 00:31:04.717
I don't mean to deviate from fabric, but now you have my mind going on this.

00:31:04.717 --> 00:31:07.805
No, it is With the Eye of the Tiger song in my head.

00:31:07.805 --> 00:31:08.267
Yeah, indeed.

00:31:10.205 --> 00:31:11.351
No, no, dataverse is more.

00:31:11.351 --> 00:31:13.891
It is a structured database for it.

00:31:13.891 --> 00:31:21.752
So it's more, chris, what you said, it's the old SQL database, but then in the cloud on that one.

00:31:21.752 --> 00:31:37.974
So there you can create your columns, your tables, with a specific column type and with the schema on it and store your transactions in there.

00:31:38.765 --> 00:31:46.538
So back to Fabric with Business Central and hopefully, as you had mentioned, we'll get to the point where it could be mirrored in real time.

00:31:47.306 --> 00:31:52.025
You had mentioned that Dataverse isn't the solution for warehousing because it's expensive.

00:31:52.025 --> 00:32:03.859
I am one who doesn't follow pricing for a reason because there's no way I could ever understand Microsoft licensing and know what I ever pretend to.

00:32:03.859 --> 00:32:05.240
I gave up on that.

00:32:05.240 --> 00:32:07.933
I focus on the technical and functional aspect of it.

00:32:07.933 --> 00:32:11.748
But how costly is fabric?

00:32:11.748 --> 00:32:26.781
And then also with Business Central you can have data retention policies to minimize the cost of the database within Business Central.

00:32:26.781 --> 00:32:33.713
Is it something where, if you move the data over to Fabric, you can report on both?

00:32:33.713 --> 00:32:49.474
And if you move the data over to Fabric and then you also adjust your retention policies within Business Central to reduce the amount of data that you have within your database, what would be the cost difference for a solution like that?

00:32:49.474 --> 00:32:53.375
And then also, could you report off of both of them simultaneously?

00:32:53.375 --> 00:33:04.498
I guess you could, because if you had real-time mirroring into data like one lake of fabric, you could look at the data in one view.

00:33:05.891 --> 00:33:08.332
Yeah, indeed, and I'm also not a licensed guy.

00:33:08.332 --> 00:33:21.134
I think, indeed, if you are doing that, especially on the Microsoft, you'll get a full day job, maybe more than that one one, because there are a lot of exceptions and it's really crazy on it.

00:33:24.067 --> 00:33:27.876
Isn't it just a moment of general comment on the pricing?

00:33:27.876 --> 00:33:43.655
I thought Fabric is like it's Azure right you just pay by the hour of use with a certain storage, or something like that as well yeah, you, you pay in, indeed, for the storage and the uh uh excuse, and that's yeah.

00:33:43.696 --> 00:33:47.884
So so in that case, um, uh, chris, that is indeed right.

00:33:47.884 --> 00:34:09.144
When you have got an sq, that represents a capacity unit and if you multiply it by 24 and a couple of metrics, then you can get, for example, 170,000 seconds of consuming the things.

00:34:09.144 --> 00:34:26.114
So in that case, when you are merging or combining reports sorry, data on it, it is consuming seconds on it, and that's where the price is in that case.

00:34:26.114 --> 00:34:41.974
But what I always say because, as you agree, brad, the license guide is really great for Microsoft there is a free app that you can install it.

00:34:41.974 --> 00:34:46.197
It's called the Capacity Metrics app.

00:34:46.197 --> 00:34:54.572
It is from Microsoft and then there you can analyze how many seconds or capacity units something is using.

00:34:55.864 --> 00:35:11.688
So in that case I will say just do a trial workspace or fabric and then analyze just one or two months how many seconds you need, and you can then buy it in that case.

00:35:11.688 --> 00:35:13.952
So then you really know.

00:35:13.952 --> 00:35:29.538
And a special thing I think is when you are mirroring a SQL database, it is mirrored inside Microsoft Fabric and that storage is free.

00:35:29.538 --> 00:35:39.992
And that's the beauty of it, I think, because what Microsoft said and that's only because I'm Dutchman and free, it's always good.

00:35:39.992 --> 00:35:50.994
But Microsoft said, okay, you pay already on your SQL storage, the capacity, you don't have to pay it also on your fabric side.

00:35:50.994 --> 00:35:53.471
So in that case, yeah, it is.

00:35:55.088 --> 00:35:56.398
For the mirroring component.

00:35:56.525 --> 00:35:58.032
Yeah, indeed, for the mirroring component.

00:35:59.105 --> 00:36:01.012
Yeah, which is actually really cool.

00:36:01.965 --> 00:36:03.311
It's still all confusing to me.

00:36:05.447 --> 00:36:07.530
It can be, it is.

00:36:09.146 --> 00:36:10.172
No, I understand.

00:36:10.172 --> 00:36:13.956
I mean the way it's all charged in Azure by, in essence, use.

00:36:13.956 --> 00:36:20.597
It's a pay-by-use, but in my opinion, not to go around going down this road.

00:36:20.597 --> 00:36:24.014
But I wish there was an easier way to estimate use.

00:36:24.014 --> 00:36:31.650
It's tough Again, it's how much gas will I use, right, it's in a vehicle, or how much electricity if you have an electric vehicle.

00:36:33.844 --> 00:36:59.574
I think people need to consider when like to Bert, you mentioned, you know, when I think where Fabric comes into play is if you have multiple data sources.

00:36:59.704 --> 00:37:21.876
Again, this is the same concept as what it was in SQL, where you just have different data that's coming in and you want to put it in a centralized data warehouse, and that's when business intelligence come in by looking at other data that you're coming from anywhere from your organization and then using.

00:37:21.876 --> 00:37:24.619
I think this is when co-pilot comes into play.

00:37:24.619 --> 00:37:37.539
This is when your power BI comes into play, where they can consume data off of it and be able to have much more of an intelligent reporting or intelligent analysis of your business.

00:37:37.539 --> 00:37:42.800
And this is where you get answers to questions that you didn't know.

00:37:42.800 --> 00:37:48.137
You should be asking versus hey, yes, there is reporting in Business Central.

00:37:48.137 --> 00:37:52.416
Yes, there is, you know you can connect part of BI, but it's usually just more of a.

00:37:52.416 --> 00:37:59.452
You know a very set data, so it is something to consider.

00:37:59.452 --> 00:38:06.376
Yes, it can get costly, but I think if you plan it out correctly, it brings a lot of value.

00:38:06.597 --> 00:38:10.813
Yeah, indeed, and that's, I think, chris spot on.

00:38:10.813 --> 00:38:25.557
It can be costly, but you can also use the data just for decision making and if you don't have that, I think that's also quite costly for your company.

00:38:25.557 --> 00:38:39.103
If you're doing the wrong decisions, creating the wrong decisions and can bankrupt your company, that is quite a huge cost.

00:38:39.103 --> 00:38:48.574
But if you spend a couple of money on your data, doing the right analysis okay, what's my trends?

00:38:48.574 --> 00:38:57.853
And stuff like that, especially when you have got a lot of data in it, I think it can make you quite a lot of money in it.

00:38:57.853 --> 00:39:04.235
I think it can make you quite a lot of money in that case, those intangible costs sometimes are difficult for someone to appreciate.

00:39:04.615 --> 00:39:17.692
As you had mentioned, you're not measuring the cost of not doing something because you're not doing it and there's no way to say the efficiency, but you can measure the cost of doing something because it's going to cost you a price.

00:39:17.692 --> 00:39:26.557
With fabric and unstructured data, how does it work?

00:39:26.557 --> 00:39:34.059
A lot of individuals now talk about AI, co-pilot, prompting, getting information.

00:39:34.059 --> 00:39:38.295
Where does fabric fit in that space or does it fit in that space?

00:39:38.965 --> 00:39:52.813
Yeah, it really fits in that space because you can also analyze the trends in it, and that's why co-pilot.

00:39:52.813 --> 00:39:56.039
But more data science is coming into place.

00:39:56.039 --> 00:39:59.724
That, but more data science is coming into place.

00:39:59.724 --> 00:40:24.934
So in that case, there's also a part in fabric and I haven't got that quite well around and investigated, but with data science, that's the part that you can use AI to see the trends from quite a lot of data that is maybe unstructured in that case.

00:40:24.934 --> 00:40:40.438
In that case, copilot can also help you with, because you can also program in inside Fabric to create mergers of tables and stuff like that.

00:40:40.438 --> 00:40:45.257
That's quite easy, also then doable with Copilot in that case.

00:40:45.257 --> 00:40:56.594
So in that case, indeed, copilot can quite easy help you, and also with AI.

00:40:56.594 --> 00:41:05.117
The source of all your data is just in your one leg, so it doesn't have to go around with multiple data sources.

00:41:05.117 --> 00:41:09.135
It's just there and you can analyze with it.

00:41:13.807 --> 00:41:15.012
So with the co-pilot?

00:41:15.012 --> 00:41:16.275
See, this is all.

00:41:16.275 --> 00:41:19.425
I have so many questions that my mind is going all over the place.

00:41:19.425 --> 00:41:31.197
I need some, you know, fabric and co-pilot to structure, uh, the data, and like I wish I could put my brain into a lake yeah, you know and all the information we consume to be able to.

00:41:31.746 --> 00:41:46.125
To bring the information out, I did just read a book called my Second Brain which pretty much talked about that how you can offload data into a place and quickly retrieve it and then use Copilot to summarize what you're thinking about.

00:41:46.144 --> 00:42:04.009
There's a different strategy the book was written before Copilot, but it was an essence of how to reduce stress and free up space in your brain by using a second brain and just more or less having a cataloging system that you knew how to use so you could find the data fast, almost like your own co-pilot, I guess you could say.

00:42:04.009 --> 00:42:09.235
But I guess now that you say that, chris, if you could have co-pilot, go against it you could.

00:42:09.255 --> 00:42:18.396
I mean technically right, I mean, if you drop everything about you then you're quite um with all the writing and stuff like that.

00:42:18.416 --> 00:42:19.099
Yeah.

00:42:21.811 --> 00:42:27.527
Well, if you do it incrementally, little pieces over time, I mean you try to fill up the library all at once.

00:42:27.527 --> 00:42:32.759
But if you start cataloging stuff from point A going forward, it could be good.

00:42:33.465 --> 00:42:35.190
Sorry, really quick on that.

00:42:35.190 --> 00:42:36.253
Fabric and Copilot.

00:42:36.253 --> 00:42:47.398
This is where I don't quite understand and maybe I don't know the answer and maybe for anyone listening to us, you know maybe can provide a little bit more.

00:42:47.398 --> 00:42:57.552
Or at least maybe because I don't use it enough is where Copilot comes into place with your data sets, right, where Copilot comes into place with your data sets, right.

00:42:57.552 --> 00:42:59.753
And you know, we've been hearing that Copilot.

00:42:59.753 --> 00:43:02.235
It's really meant to be conversational.

00:43:02.235 --> 00:43:10.840
It's not meant for analyzing numbers or you know what I'm saying.

00:43:10.840 --> 00:43:13.262
It's not meant to do that.

00:43:13.262 --> 00:43:15.387
It's more of a conversation.

00:43:15.387 --> 00:43:16.652
It's a natural language.

00:43:16.652 --> 00:43:20.588
So I'm curious how people use it out there.

00:43:20.588 --> 00:43:22.572
You know when they're using Fabric.

00:43:22.572 --> 00:43:25.097
You know Fabric can be used for data warehousing.

00:43:25.097 --> 00:43:39.492
People use it for data science, power BI, and so it's all about these numbers and crunching numbers, but then, on the other hand, copilot's not really designed for that yet.

00:43:39.492 --> 00:43:46.577
So how do people end up using Copilot when it's just a bunch of numbers in a data warehouse?

00:43:46.577 --> 00:43:48.304
This is where I'm trying to figure it out.

00:43:49.467 --> 00:44:02.114
Yeah, maybe that's a little bit confusing, but there is also Copilot inside Fabric, but that's more what we're also using in Bicentral and in Vistri Code.

00:44:02.114 --> 00:44:13.271
How can I write a good Spark language or Python language just to create?

00:44:13.626 --> 00:44:14.632
Oh, I see what you're saying.

00:44:15.164 --> 00:44:28.217
And then you've got the data science, and in that case you have to create oh, I see what you're saying and then you have got the data science, and in that case you have to create your own model, or you can use another model, but that's not text-based indeed.

00:44:29.990 --> 00:44:30.784
Okay, that makes sense.

00:44:30.784 --> 00:44:40.398
So you're using Copilot to build tools, or how to I extract the data?

00:44:40.398 --> 00:44:45.532
That makes sense now and then with data science.

00:44:46.313 --> 00:44:46.875
You have to.

00:44:46.875 --> 00:44:50.985
Yeah, you can use models that are already out there.

00:44:50.985 --> 00:44:59.280
You can create your own model and enrich it with your data and train it in that case, Got it.

00:44:59.304 --> 00:45:09.576
So they use Copilot to say, hey, I need you to build a Python library for it, or even R language, if people still use that.

00:45:09.576 --> 00:45:11.753
But okay, that makes a whole lot of sense.

00:45:11.753 --> 00:45:12.909
You just answered my question.

00:45:12.909 --> 00:45:14.606
It's like where does Copilot come into play?

00:45:14.606 --> 00:45:15.608
So that makes sense.

00:45:15.608 --> 00:45:22.559
It's just used for how to build your tool, okay.

00:45:22.559 --> 00:45:28.876
Yeah, indeed, that makes a whole lot of sense, okay.

00:45:30.306 --> 00:45:42.454
So then the other point of Copilot or AI and I think we spoke about this briefly is now we're talking about fabric and data and data science and leaks Prompting.

00:45:42.454 --> 00:45:53.896
What's your take or what's your thoughts on how someone can efficiently prompt AI?

00:45:53.896 --> 00:45:57.634
I mean, ai is just such a broad term.

00:45:57.634 --> 00:46:00.012
Ai encompasses many things.

00:46:00.012 --> 00:46:17.889
Maybe, if you use the co-pilot for Business Central, or co-pilot in a sense of even within your M365 tenant, what is the strategy for prompting to get the proper information out?

00:46:17.889 --> 00:46:31.378
I just I my mind, just really to be honest with you, after a few episodes ago, when we had the great conversation about AI and I finally understood vectors and how it all works.

00:46:31.378 --> 00:46:35.610
So you know, now I'm thinking, okay, now that all that information's in there, how do we get that out?

00:46:35.610 --> 00:46:40.836
I can see you know relationally, how it all sits.

00:46:42.465 --> 00:46:52.940
Yeah, I think prompting if you create very good prompts, then you can really have the good results.

00:46:52.940 --> 00:46:54.606
But mostly prompting.

00:46:54.606 --> 00:47:06.826
That is very important and I'm always also struggling with it because I thought mostly a prompt must be very simple and small.

00:47:06.826 --> 00:47:23.567
But currently what I'm seeing with prompting is they're quite huge on it, quite huge on it.

00:47:23.567 --> 00:47:41.380
So what they always do is putting an example in it or say on bullet points, okay, this is not what you can do on it, just maybe 10 bullet points, and then say, okay, please don't do this, this or that or use this standard and and stuff like that.

00:47:41.380 --> 00:47:49.454
And what I do is always a lot of practicing on it and that's.

00:47:49.474 --> 00:47:59.217
That's quite hard so you write a detailed prompt, yeah, telling co-pilot what not to return or what to not use.

00:47:59.217 --> 00:48:01.248
So you have a large.

00:48:01.248 --> 00:48:03.672
I've always done like you know.

00:48:03.672 --> 00:48:12.393
Draw me a picture of a guy planting a garden in cartoon style with a black shirt yeah, is what I would typically write, or something.

00:48:12.393 --> 00:48:21.650
I mean I use Copilot quite a bit now, even more so for getting information, because sometimes I get a lot of emails.

00:48:21.650 --> 00:48:25.047
You know threads and I can use Copilot to summarize the thread and it works great.

00:48:25.047 --> 00:48:33.211
But now back in the context of how you mentioned it, do you have an example of how you would use it with a large prompt like that?

00:48:33.713 --> 00:48:43.902
Well, what I did is probably you know the BIScentral performance toolkit.

00:48:43.902 --> 00:48:47.132
Yes, and currently we have also the page scripting.

00:48:47.132 --> 00:48:48.646
In that case, yes.

00:48:49.505 --> 00:49:03.914
So what I did and it is not perfect, I have to get it much better for the prompting is to just record the page scripting tool just to create a scenario.

00:49:03.914 --> 00:49:29.576
For example, I'm creating a customer and then creating a sales order of that customer, then you can export it in a readable format, and there I put OK, put Copilot on it and create a BCPT scenario of it.

00:49:29.576 --> 00:50:06.581
And there what I did is quite yeah, created quite large prompt from, if you are seeing this tag, just do this one, or using the test framework of it and this is an example of it, an example from a VCBT scenario that I already created with a lot of AL statements on it and put it in the prompt.

00:50:06.981 --> 00:50:35.103
In that case, that I would love to see is, at one point, just to see you going from the page scripting tool to use Copilot to create a BCPT scenario that can save so much time Indeed In the current version of the page scripting.

00:50:35.103 --> 00:50:37.543
I mean I'm a fan of the page scripting tool.

00:50:37.543 --> 00:50:40.204
I mean it helps with a lot of testing.

00:50:40.204 --> 00:50:46.202
I mean I'm big on automated testing and I write a lot of tests and having the page scripting tool helps.

00:50:46.202 --> 00:50:57.827
Hopefully one day I'll have to put it on my wish list that we can have some of that automated to create a library of tests there as well, along with like we have with the automated tests, have some sort of runner.

00:50:57.827 --> 00:51:00.525
But that is, you need to write about that.

00:51:00.525 --> 00:51:04.925
If you haven't written about that yet, with some examples or even a little video, that would be.

00:51:06.177 --> 00:51:18.923
Yeah, I presented before the summer on a conference and indeed, that's's true, I need to try something on it, but I need to do perfectly that's.

00:51:18.923 --> 00:51:20.547
But indeed it.

00:51:20.547 --> 00:51:26.409
It is quite a lot of time to take a BCPT scenario and have.

00:51:26.409 --> 00:51:36.619
What I said is I love also the page scripting and if, if it's automated, especially for customers with some customizations on it, it is really perfect.

00:51:36.619 --> 00:51:49.181
And I think those examples are quite good for CoPilot on that case, Just to have some clear statements on it.

00:51:49.181 --> 00:51:58.943
The BCPT scenarios are quite the same, with the same syntaxes and stuff like that, and structure is the same.

00:51:58.943 --> 00:52:04.070
So I think those scenarios are quite good.

00:52:04.070 --> 00:52:19.498
Sometimes for me it's also quite hard to create scenarios inside BIS Central for using Copilot on it Because, yeah, it's always text-based yeah, I mean it, I think it's almost, I think it's really more.

00:52:19.880 --> 00:52:26.016
I think it's more important now to uh understand the prompt structure.

00:52:26.016 --> 00:52:35.641
Um, and there's plenty of, there's plenty of online uh classes that you could take to do what they call prompt engineering.

00:52:35.641 --> 00:52:49.206
So you know, as soon as you get the basic concept, like you could do a lot of stuff with ChatGPT or Copilot, where you structure like, hey, you set a scenario and you know when you respond.

00:52:49.206 --> 00:53:02.411
You have to respond in a certain way, and so your prompt can get pretty big, but you get a much better result than, rather, being too creative where, like, oh, I'm going to interpret based on what you just said.

00:53:02.411 --> 00:53:13.630
So, if I can't remember who someone had mentioned, that you should take some prompt engineering classes, just so you can have a good understanding of the structure.

00:53:13.690 --> 00:53:19.782
Yeah, indeed, and I think probably the next job this year or next year will be prompt engineering.

00:53:19.782 --> 00:53:23.144
If you are doing that good, you can get a lot of money on it.

00:53:25.295 --> 00:53:26.641
Yeah, you can do so much with it.

00:53:26.641 --> 00:53:29.215
It'll be interesting to see where this all goes.

00:53:29.215 --> 00:53:37.440
It's the hype right now, but I wonder if it'll end up becoming commoditized over time as the dust settles.

00:53:37.440 --> 00:53:39.880
I guess you could say it's.

00:53:39.880 --> 00:53:44.242
You know, copilot will be more of a I think, a tool than a product.

00:53:44.242 --> 00:53:46.561
I guess that's just always my thoughts.

00:53:46.561 --> 00:53:50.199
Yeah, it is quite a bit to it.

00:53:50.661 --> 00:53:51.244
Totally agree.

00:53:53.063 --> 00:53:56.681
Well, bert, thank you for taking the time to speak with us this evening.

00:53:56.681 --> 00:54:12.373
We do appreciate it, and you did share a lot of information and enlightened all of us on a little bit more about what MS Fabric is, how it can be used with Business Central and what the hopes for the future with.

00:54:12.373 --> 00:54:22.637
Maybe, if we can get some of that mirroring and as well as the creative tools for ai prompting with the page script uh over to bcpt uh to create a scenario.

00:54:22.637 --> 00:54:31.784
I have to experiment with that or maybe I'll catch up with you after you can share one of your prompts of what you did so I can see how it did it I have a quick, quick question for you.

00:54:31.804 --> 00:54:44.297
But do you find, because you work with clients, and so do you find clients, um, still confused with fabric yeah, they are still confused with fabric.

00:54:44.878 --> 00:54:54.106
What it is indeed okay, yeah because they're like you know the k, I got the business central and now you're asking me to go get fabric right.

00:54:54.106 --> 00:54:58.809
So I'm just curious from your perspective of how that looks like for you.

00:54:58.809 --> 00:55:04.943
Because it is, it is a challenge to educate you know what is, what will fabric do for you?

00:55:04.943 --> 00:55:10.141
And usually I try to uh relay where, like hey, you remember data warehousing.

00:55:10.141 --> 00:55:22.543
You know, especially if you have an organization that has a lot of data coming from different places, it makes more sense to do that and usually they understand it at that point of what it used to be and then what it's going to be in the future.

00:55:22.543 --> 00:55:31.670
So, just out of curiosity, it sounds like it's still a challenge of customers not knowing what is Fabric.

00:55:31.670 --> 00:55:34.063
And then you see one lake.

00:55:34.063 --> 00:55:36.501
One lake is another term being used.

00:55:36.554 --> 00:55:48.264
There are a lot of terms on it and that's always confusing on it and especially when they're changing the names, then it's getting more confusing.

00:55:48.264 --> 00:56:03.668
And, yeah, the bigger customers, okay, they understand it because they follow it and they have analytics on board, but with the smaller and medium customers, yeah, they really don't know what it is.

00:56:06.518 --> 00:56:07.762
It is difficult to keep up.

00:56:07.762 --> 00:56:12.827
I mean, the rate of change with technology to me is progressing faster.

00:56:12.827 --> 00:56:17.706
Rate of change with technology to me is progressing faster and, as you had mentioned, throwing the name changes.

00:56:17.706 --> 00:56:29.768
It's really difficult for someone to understand or appreciate the value of it with everything in essence being relatively new, even if it's been there for a couple years, also not knowing if it will be here tomorrow or not.

00:56:29.768 --> 00:56:40.018
If you look at a lot of these technologies that are tried, some of them last, some of them last, some of them fade away, some of them morph into something completely different, I think, over time.

00:56:40.018 --> 00:56:41.623
But it is.

00:56:41.623 --> 00:56:50.166
It's a good point, chris, that the challenge of now I have Business Central and now I also need the fabric and that Burt your points of this.

00:56:50.166 --> 00:56:53.405
Someone who's a small to medium sizedsized business may not even need it.

00:56:53.405 --> 00:57:04.722
They may have enough with their business central to not need it, to not even know about it, where a larger implementation will have the talent available to understand how it could benefit the business.

00:57:05.724 --> 00:57:06.487
I think that's a good point.

00:57:06.994 --> 00:57:08.240
It's a good approach to way to look at it.

00:57:08.240 --> 00:57:21.447
So if anyone wanted to reach out to you, Bert, and talk to you and maybe ask you any more questions, a little bit more about Fabric or AL prompting, what's the best way to get in contact with you?

00:57:22.534 --> 00:57:26.181
You can find me on LinkedIn, bert Speeg Twitter.

00:57:26.181 --> 00:57:36.420
I'm also there and I've got my own website, my own website, bestbakenl, and there you can also find my contacts on it.

00:57:38.125 --> 00:57:38.947
Excellent, excellent.

00:57:39.177 --> 00:57:42.353
Do you go into any conferences anytime soon?

00:57:42.996 --> 00:57:47.186
I hope directions EMEA that I'm there in.

00:57:47.186 --> 00:57:47.547
Vienna.

00:57:47.547 --> 00:57:52.239
I think that's for this year.

00:57:52.239 --> 00:57:55.286
I think probably's for this year.

00:57:55.306 --> 00:57:55.688
I think Okay.

00:57:56.795 --> 00:58:00.085
And probably you are going to Days of Knowledge Atlanta.

00:58:02.277 --> 00:58:06.237
I won't be able to make it, unfortunately it's overlapped, but I've heard.

00:58:06.237 --> 00:58:08.626
I mean, I think everyone should be able to check.

00:58:08.626 --> 00:58:11.625
You should be checking it out, especially from a technical aspect.

00:58:11.625 --> 00:58:14.222
You know answering questions like hey, when do you use?

00:58:14.222 --> 00:58:14.864
You use fabric, right.

00:58:14.864 --> 00:58:16.750
So I know brad will be there.

00:58:16.750 --> 00:58:19.559
So, uh, you know one of us is going to represent.

00:58:20.342 --> 00:58:22.873
Yes, absolutely, I'll be at days of knowledge in atlanta.

00:58:22.873 --> 00:58:24.458
We're coming up into the, the conference time.

00:58:24.458 --> 00:58:26.804
I know, uh, chris had asked you about the conference.

00:58:26.804 --> 00:58:34.527
It is tough to choose which conference to go to, so it there's a lot of conferences available, so it's just a matter of finding the right conference.

00:58:34.527 --> 00:58:38.639
That fits your target and with days of knowledge.

00:58:38.639 --> 00:58:42.527
Unfortunately, Chris and I won't be there, but I'll be there, Chris is also going to.

00:58:43.416 --> 00:58:46.744
I will be at the Power Platform, which they'll also.

00:58:46.744 --> 00:58:51.059
I think they'll be speaking about Fabric 2 and how they use that, so I'll be there.

00:58:51.059 --> 00:58:52.543
I'm excited about that and I won't be.

00:58:52.945 --> 00:58:54.168
So I'll be there I'm excited about that and I won't be.

00:58:54.188 --> 00:59:00.259
So you'll be representing on that one, and I'll be doing the other one with split-nose conferences and then afterwards share the knowledge of it.

00:59:01.722 --> 00:59:02.344
Absolutely.

00:59:02.344 --> 00:59:09.045
Yeah, we'll have to do a recap for Days of Knowledge, yeah, but also for our platform.

00:59:09.045 --> 00:59:09.967
We should do both.

00:59:11.076 --> 00:59:22.844
I think it's really interesting, both because data knowledge is also here in Europe and I've been presenting there and I think it's a really good concept.

00:59:22.844 --> 00:59:29.206
On it, just very small and you can speak to everyone.

00:59:31.556 --> 00:59:37.838
And I've never went to the Power Platform conference so, oh, this is my first one, so we'll see.

00:59:37.858 --> 00:59:41.222
That would be very interesting about your recap, chris.

00:59:41.983 --> 00:59:44.025
Yes, Chris, we have to.

00:59:44.025 --> 00:59:46.248
I won't say it, but maybe we could try to do something live.

00:59:46.248 --> 00:59:55.242
I don't know, we'll have to try to work that out that before, and it gets difficult with the internet connectivity at some of these conferences to do something live.

00:59:55.242 --> 00:59:57.567
But yeah, you know, maybe we can experiment well again.

00:59:57.567 --> 01:00:01.181
Thank you, bert, we do appreciate your time, uh, speaking with us this evening.

01:00:01.181 --> 01:00:08.286
Uh, it was extremely valuable and uh, you know, any time that anyone spends with us we appreciate, because you don't get that time back.

01:00:08.286 --> 01:00:09.757
Uh, thank you again.

01:00:09.757 --> 01:00:12.324
We look forward to talking with you, sir thanks for having me.

01:00:12.344 --> 01:00:14.539
Brad and Chris thanks a lot bye.

01:00:17.643 --> 01:00:26.494
Thank you, chris, for your time for another episode of In the Dynamics Corner Chair, and thank you to our guests for participating thank you, brad, for your time.

01:00:26.775 --> 01:00:30.005
it is a wonderful episode of Dynamics Corner Chair.

01:00:30.005 --> 01:00:33.539
I would also like to thank our guests for joining us.

01:00:33.539 --> 01:00:36.556
Thank you for all of our listeners tuning in as well.

01:00:36.556 --> 01:00:51.164
You can find Brad at developerlifecom, that is D-V-L-P-R-L-I-F-Ecom, and you can interact with them via Twitter D-V-L-P-R-L-I-F-E.

01:00:51.164 --> 01:01:08.139
You can also find me at matalinoio, m-a-t-a-l-i-n-o dot I-O, and my Twitter handle is matalino16 and you can see those links down below in the show notes.

01:01:08.139 --> 01:01:09.483
Again, thank you everyone.

01:01:09.483 --> 01:01:11.056
Thank you and take care.

Bert Verbeek Profile Photo

Bert Verbeek

Microsoft MVP | Technical Solution Architect