Episode 346: In the Dynamics Corner Chair: Reporting in Business Central's 2024 Wave 2: Ready?

Transcript

WEBVTT

00:00:00.561 --> 00:00:03.770
Welcome everyone to another episode of Dynamics Corner.

00:00:03.770 --> 00:00:09.827
In this episode it is a very special episode because we're right next to each other.

00:00:09.827 --> 00:00:12.085
I'm your co-host, chris.

00:00:12.426 --> 00:00:13.089
And this is Brad.

00:00:13.089 --> 00:00:16.451
This episode was recorded on October 14th.

00:00:16.451 --> 00:00:18.125
Chris, chris, chris.

00:00:18.125 --> 00:00:21.972
We're right next to each other, but it doesn't look like we're right next to each other.

00:00:21.972 --> 00:00:23.065
Look look look, look See.

00:00:23.065 --> 00:00:26.015
Oh wait, your finger went into my screen.

00:00:26.035 --> 00:00:26.579
I know it's warm.

00:00:27.341 --> 00:00:28.806
Wait, wait, wait.

00:00:28.806 --> 00:00:30.190
How come I can't go into yours?

00:00:30.190 --> 00:00:34.523
Oh, there we go, okay, oh, no, great.

00:00:34.523 --> 00:00:39.634
Here we are, day one of a community summit North America here in San Antonio, texas.

00:00:39.634 --> 00:00:42.529
I want to go get some steak and a cowboy hat.

00:00:42.529 --> 00:00:46.066
See, I should have bought a cowboy hat.

00:00:46.066 --> 00:01:04.542
We have to do another recording with the cowboy hats which we're going to get, but in this episode we had the opportunity to just learn a lot about what's new in Business Central 2024, wave 2, for both reporting and Power BI, with what I call the year of reporting and data analytics With us.

00:01:04.542 --> 00:01:09.161
Today, we had the opportunity to speak in person with us in the same room.

00:01:09.161 --> 00:01:39.319
Kenny, I don't know what to do sometimes, kenny, thank you for joining us today.

00:01:39.319 --> 00:01:45.153
Here we are, day one of Community Summit North America in San Antonio, texas.

00:01:45.153 --> 00:01:47.346
How are you liking San Antonio?

00:01:48.379 --> 00:01:54.593
Oh, I only had a fish taco at the hotel before my first session, so I arrived noon.

00:01:54.593 --> 00:02:06.301
I left Fargo, north Dakota 5 am this morning and I arrived here at noon and got a fish taco and directly to our first session.

00:02:06.301 --> 00:02:10.247
So that's the kind of San Antonio I've seen.

00:02:11.431 --> 00:02:14.843
So it's the usual travel, where you show up when you see a room.

00:02:14.843 --> 00:02:21.405
Oh yeah, just like they put you in the basement to do work, they put you in a room here to not see anything.

00:02:21.405 --> 00:02:25.533
Well, hopefully you get to see more as you're here in San Antonio.

00:02:25.533 --> 00:02:27.405
And again, thank you for taking the time to speak with us.

00:02:27.405 --> 00:02:41.855
Here we are at the Community Summit, which is a big event, but also we recently had the release of 2024 Wave 2, which is something that's also extremely important and has a lot of features and functionality with it.

00:02:41.855 --> 00:02:51.497
So a couple of things I wanted to speak with you about is what's new in 2024 wave 2, with business central for reporting wow, that's a.

00:02:51.878 --> 00:02:52.079
That's.

00:02:52.079 --> 00:02:57.350
That's a lot of things and a lot of small things, so let me just start with the small things.

00:02:57.350 --> 00:03:11.712
So, for anyone working with the layouts, we did a like 10 small features just to make that easier, and we have a video on that for our Business Central launch event where you can kind of see all the small little tricks.

00:03:11.712 --> 00:03:16.631
I call it all the little things we did to make that easier.

00:03:16.631 --> 00:03:32.687
Then, for document reporting, so anything where you send your quotes or your sales invoice to a customer, we added a lot of things to the word layout feature, highlighting three things I would say.

00:03:33.639 --> 00:03:41.507
The first one is freeing up the word feature called sections, and that's a huge thing.

00:03:41.507 --> 00:04:05.454
This means that there's a lot of things in Word that is bound to the section, so things like your margins, your paper orientation, your watermarks, your footers and headers, and by enabling this in your Word layout you can actually change all of these during your layout.

00:04:05.454 --> 00:04:13.979
So let's say that you have an invoice or something you sent to the customer, where page two would be nice to have a wide table.

00:04:13.979 --> 00:04:19.497
You can just change your margins and your orientation on that page two in the same layout.

00:04:19.497 --> 00:04:20.509
So that's number one.

00:04:20.480 --> 00:04:24.915
Number one, yeah, number one of a lot so that's number one Number one yeah, number one of a lot.

00:04:24.915 --> 00:04:26.904
It's a, it's a, it's a.

00:04:26.904 --> 00:04:32.709
It's a lot to digest, but I'm happy to see the direction that we're moving with Business Central and the word layouts.

00:04:32.709 --> 00:04:35.329
Yeah, and we'll go with the other ones.

00:04:35.329 --> 00:04:42.151
I have a few comments on this, but I'm excited to hear yeah, number two, number three, number two is support.

00:04:42.319 --> 00:04:43.884
This was kind of a POC.

00:04:43.884 --> 00:04:51.648
I wanted to see how I knew we could do it, but now it's also part of the standard layout and that's a themable layout.

00:04:51.648 --> 00:05:05.411
What this is is changing our standard layout in Word so that whenever you go to the layout option in Word and change the office theme, everything changes to the theme.

00:05:05.411 --> 00:05:06.925
So colors, fonts, everything.

00:05:06.925 --> 00:05:16.226
So what this means is and I'm actually going to do a demo here at the keynote tomorrow, but this will go out after, I guess- We'll try to put it out as quickly as possible.

00:05:16.387 --> 00:05:24.742
Yeah, but the demo tomorrow and the keynote is a marketing head of marketing wants to do something fun for Halloween.

00:05:24.742 --> 00:05:27.685
A marketing head of marketing wants to do something fun for Halloween.

00:05:27.685 --> 00:05:32.173
So what they want to do is they want to have Halloween themed quotes they send to customers.

00:05:32.173 --> 00:05:33.413
That would be fun.

00:05:33.413 --> 00:05:48.600
Now, halloween is also about scary, and maybe for some developers that seems like a scary thing, and then it's not.

00:05:48.600 --> 00:05:50.564
You just, they can actually just go and download the word layout for the quote.

00:05:50.564 --> 00:06:13.949
They can go and change the theme to something gothic, like a gray theme or maybe a halloween yellow one or orange one, and I even did a copilot in Paint and asked for a Gothic watermark and got that generated and then incorporate that as a watermark in Word, and that takes all in all five minutes.

00:06:13.949 --> 00:06:19.220
Upload back to Business Central and now your quote is Halloween-themed.

00:06:19.620 --> 00:06:35.548
See, that is an excellent feature, because I know you're talking about doing that for fun, with Halloween as a demonstration, but I could see how a user of Business Central can incorporate that into their business where they may have something seasonal, where they may want to put a promotion.

00:06:35.699 --> 00:06:37.985
I know a lot of partners or even other customers.

00:06:37.985 --> 00:06:42.906
If they even go into a conference such as this, they put a watermark on their email signatures or other documents.

00:06:42.906 --> 00:06:45.733
Visit us here and now they can easily change that.

00:06:45.733 --> 00:06:57.877
I really get excited and AJ and I had talked about this in our academy session this past weekend with the developers who are there to learn and move forward and grow.

00:06:57.877 --> 00:07:28.790
With AL development is we're really taking and separating the business logic or the data from the user interface in the report, giving more control and easier control for the appearance of their reports to the users of Business Central and it doesn't take a lot of effort for them to be able to change it, and that's why I really like the theming of it, because you can change it, as you had mentioned, for an event or you can change it just because we want to change the look of our report for.

00:07:29.742 --> 00:07:31.088
Christmas for anything.

00:07:31.088 --> 00:07:48.584
Next thing is Christmas, and then the next thing is our I don't know our Easter sale, and then our summer sale, and and suddenly you have exactly the seasonality of your documents and you don't have to pay a designer for it, you don't have to pay a partner for it.

00:07:48.584 --> 00:07:54.178
It's just five minutes in word of things you already know in word.

00:07:54.178 --> 00:08:09.687
And, speaking of word, I think a lot of business central developers need to go back to school, because I I know I had this challenge last year where I challenged business central developers tell me what's not possible in Word.

00:08:09.687 --> 00:08:23.923
And then I did all of it, most of it, actually, probably a few things I couldn't do, but most of it was possible in Word and, to be honest, easier Because it's just in there, it's built-in functionality.

00:08:23.923 --> 00:08:26.612
Just do it.

00:08:26.839 --> 00:08:38.171
Yeah, I think it makes it accessible for small, medium-sized businesses where they want to be able to make it more fun, especially for small moms and pops to be able to have that theme.

00:08:38.921 --> 00:08:56.933
Well, with that word and I've had a number of conversations as well there's a lot of talk between RDLC, word, excel, the different layouts, one of the points that you had mentioned, where if you ask somebody something of what you would do with a report and the ability to be able to do that in Word or not in Word.

00:08:56.933 --> 00:09:02.292
Sometimes they even ask the question is it the right tool for what you're trying to do?

00:09:02.292 --> 00:09:10.591
Because there's often you know, I joke with everybody with Copilot it was like, well, copilot didn't do this, they didn't do that.

00:09:10.591 --> 00:09:13.724
But if you pause for a moment and say it did 80% of what you needed to do, it gets you started, it saves you some time.

00:09:13.764 --> 00:09:15.171
So the same thing comes with reporting.

00:09:15.171 --> 00:09:20.784
If you're trying to do something in a report, is it really the proper tool for it?

00:09:20.784 --> 00:09:26.030
Is it something that should be done in the business logic or is it something that should be done in Power BI or another tool?

00:09:26.030 --> 00:09:36.008
And that's one of the challenges to portray when you're designing and architecting is make sure that you're using the right tool before you're saying, well, it can't do something for me.

00:09:36.008 --> 00:09:39.240
It's put it in perspective of let's analyze the proper tool.

00:09:39.240 --> 00:09:47.539
So that's one thing I try to keep in mind and to promote, that you know it's not intended to do everything right.

00:09:47.539 --> 00:09:58.744
It's intended to do, you know, certain functions and be able to present and create your documents and not necessarily be a big Power BI type reporting, because that's where a lot of hopefully we can talk about.

00:09:58.744 --> 00:10:02.994
Effort has also been made into Power BI reports to get more analytical data reporting.

00:10:03.320 --> 00:10:06.850
Yeah, if I just may say the final third thing we did.

00:10:07.240 --> 00:10:09.764
Yes, yes, I was trying to get you to go, but I have comments on all of these.

00:10:09.764 --> 00:10:10.386
I get excited.

00:10:12.326 --> 00:10:13.349
So that's interesting.

00:10:13.349 --> 00:10:23.448
Something we actually wanted to do for the product since we released Word Layout 10 years ago in NAV 2013, is a Word Add-in for the editing.

00:10:23.580 --> 00:10:25.005
Yes, I'm excited for that one.

00:10:25.600 --> 00:10:28.629
And I think 10 years ago that was not so easy to do.

00:10:28.629 --> 00:10:34.791
It would probably require some VBA coding and a lot of special skills.

00:10:34.791 --> 00:10:40.485
That maybe was only for the Office developers in a sense.

00:10:40.485 --> 00:10:58.724
Now, since then, the Office team have, or the Microsoft 365 team have released a JavaScript API for Office, which means that it's actually fairly easy to create a Word add-in now, and that's what we did.

00:10:58.724 --> 00:11:16.451
We created a Word add-in that can do new concepts for Word layouts and we started with the things that are most difficult in Word, which is conditional visibility, and that's the new layout controls, as we call them.

00:11:16.451 --> 00:11:23.269
So we try to say the content controls you have today, where you map data to the document.

00:11:23.269 --> 00:11:31.912
We then talk about layout controls instead for something that controls kind of conditional logic in the layouts.

00:11:32.879 --> 00:11:33.965
So that's a great new feature too.

00:11:33.965 --> 00:11:45.552
Now there's a Word ad and I'm assuming there's a desire and intent to increase the functionality of that Word ad and its Word reports as time progresses, to facilitate the creation of Word reports.

00:11:45.552 --> 00:11:46.844
There's a lot of new features.

00:11:46.844 --> 00:11:47.788
I'm excited with this.

00:11:47.788 --> 00:11:49.323
And again it goes back to.

00:11:49.323 --> 00:11:50.749
I like to comment about going back to school.

00:11:50.749 --> 00:12:03.009
Sometimes, you know, with the changing of the technology, the changing of the language, the changing of the application, it's important to stay up to date with it and understand the usage of it and how you can use it.

00:12:03.009 --> 00:12:06.769
I'll ask you a question also with this that you talk about.

00:12:06.769 --> 00:12:13.808
We talk about the excitement of Word and I heard some comments in some of the sessions that I had attended today.

00:12:13.808 --> 00:12:17.850
Where does this leave the RDLC reports?

00:12:17.850 --> 00:12:25.176
Because this was a question from a specific customer during a session that we were talking about some tips and tricks for Business Central.

00:12:25.176 --> 00:12:28.332
Sure, a question from a specific customer during a session that we were talking about some tips and tricks for Business Central.

00:12:29.302 --> 00:12:29.462
Sure.

00:12:29.462 --> 00:12:37.312
So I think the question is not so much RDL reports but more maybe.

00:12:37.312 --> 00:12:38.933
I think there are two questions.

00:12:38.933 --> 00:12:45.527
Will the capability of using RDL layouts go away in the Business Central platform?

00:12:45.527 --> 00:12:47.066
That's question number one.

00:12:47.066 --> 00:12:52.542
Yeah, to my knowledge, no, that will not go away.

00:12:52.542 --> 00:12:59.823
So RDL is a core part of Power BI patinated reports.

00:12:59.823 --> 00:13:15.291
It seems like that technology is there to stay and therefore I don't see that going away as a capability in Business Central, capability in Business Central.

00:13:15.291 --> 00:13:18.495
However, the second part of that question is how about the usage of RDL layout in the base application?

00:13:18.495 --> 00:13:20.759
And that will change.

00:13:20.759 --> 00:13:41.931
So what I see happening is that over the next years you will see less and less RDL layouts in the base app and we will modernize the report objects to be able to cater for a new world of Excel and Word where it makes sense.

00:13:41.931 --> 00:13:55.073
Some reports of that have been in the product for many years will go away because there would be modern at with either PowerPI data analysis or Excel.

00:13:57.519 --> 00:14:03.072
You will see new features in reporting, like being able to deprecate a layout.

00:14:03.072 --> 00:14:06.777
You can't do that today.

00:14:06.777 --> 00:14:21.683
You will likely see new features in the report object to hide certain, or at least hide certain columns in data items that were from from for the past.

00:14:21.683 --> 00:14:30.849
So by doing this we'll be able to keep reports functioning well with RTL layouts.

00:14:30.849 --> 00:14:37.038
Add new layouts that don't exist, that don't use old columns that are not needed.

00:14:37.038 --> 00:14:59.684
There will likely be new features in word, in the word add-in, so that maybe we can have system and just like in Excel today, in Excel layout you have this system metadata worksheet where we stamp in metadata about the report, metadata about the request and so on.

00:14:59.684 --> 00:15:07.083
So in the Excel layout you can easily have company name, which user it was, what date and so on things like that.

00:15:07.083 --> 00:15:28.721
The same concepts will likely surface in the word add-in as well as system or even in the data set, so that when you in the future create a word report with a word layout, you don't have to build all this company and all of that into the data set.

00:15:29.231 --> 00:15:29.995
It's just there.

00:15:29.995 --> 00:15:34.111
That into the data set.

00:15:34.111 --> 00:15:34.774
It's just there.

00:15:34.774 --> 00:15:37.984
And that will also simplify a lot of the data sets, because why do you need to code the company name into the data set?

00:15:37.984 --> 00:15:38.566
That's stupid.

00:15:38.947 --> 00:15:42.318
Yes, let's do that in the platform and just once for all.

00:15:42.318 --> 00:15:52.403
That also means that the person doing the layout will have the same look and feel of that data set, no matter which report they are in when they lay out.

00:15:52.403 --> 00:15:59.562
And all of this is a UX for a different type of user.

00:15:59.562 --> 00:16:14.890
If it's a developer, maybe it doesn't matter so much the usability of the data set, but for an end user it matters a lot that the data set is understandable, which also means we will likely have two tips on report data set.

00:16:14.890 --> 00:16:25.500
I columns because we can surface them in the layout tool and in the Word add-in so that you can see oh, this field is about blah and this field is about blah.

00:16:25.500 --> 00:16:35.621
So a lot of the features that we will build into the reporting platform will just make it easier for a different type of user to lay out reports.

00:16:36.410 --> 00:16:38.097
I like where the direction of that's going.

00:16:38.097 --> 00:16:43.322
So to go back to the answer to the question, just to put back to you brought up the two points to do questions.

00:16:43.322 --> 00:16:50.518
The technology of the RDLC or the RD reports is not going away, it's the usage of the RD reports may change.

00:16:50.518 --> 00:16:59.442
So if somebody has an existing implementation with a lot of reports they use to run their business, they don't have to worry about having to redo all of their reports through the upgrades.

00:16:59.442 --> 00:17:12.015
So that's an important point because there's a lot of rumors now, because some individuals see a lot of effort being made to enhance the Word and the Excel reporting, that the RDLC reports are going away.

00:17:12.015 --> 00:17:14.421
But it's a two-part question.

00:17:14.421 --> 00:17:23.834
As, gennie, you had mentioned, you may have less RDLC reports I call them RDLC reports within Business Central for the base application but the technology is there.

00:17:23.834 --> 00:17:30.055
So anything that you have invested in that's running your business, that's important to you, you still would be able to use.

00:17:30.289 --> 00:17:31.413
I mean we are in the business of ERP.

00:17:31.413 --> 00:17:33.801
That's important to you you still would be able to use.

00:17:33.801 --> 00:17:41.826
I mean we are in the business of ERP and we, as Microsoft, can't simply go and break thousands of customers' document reporting or any reporting.

00:17:41.826 --> 00:17:42.390
We can't do that.

00:17:42.390 --> 00:17:46.781
I know we did it with the classic client, the classic report, things right.

00:17:46.781 --> 00:17:48.415
We're not going to do that again.

00:17:48.415 --> 00:17:50.614
That would not be fair.

00:17:50.653 --> 00:17:51.276
No, that's a good point.

00:17:51.276 --> 00:18:01.196
Thank you for clarifying that because, again, it's how the rumors are and everybody hears bits and pieces of information and shares it.

00:18:01.196 --> 00:18:03.465
And hearing a conversation today and also hearing some conversations before, I knew we were going to speak.

00:18:03.465 --> 00:18:04.369
I wanted to clarify that which is important.

00:18:04.569 --> 00:18:09.281
But if you listen to this 20 years from now, it might be that that technology is going away.

00:18:09.281 --> 00:18:09.541
Right?

00:18:09.541 --> 00:18:15.442
You can never promise anything that will never change, right?

00:18:15.690 --> 00:18:16.433
No, I understand.

00:18:16.493 --> 00:18:19.579
yes, but I have no secret plan and no secret roadmap.

00:18:19.579 --> 00:18:25.722
I'm not showing to anyone that the capability of RDLC is going away in Business Central.

00:18:25.829 --> 00:18:29.009
Well, I'm hoping in 20 years I'm retired or not working so that's okay.

00:18:30.094 --> 00:18:30.776
No, that's a good point.

00:18:30.776 --> 00:18:40.616
That has to be inferred that as technology and time evolve or passes, there may be a point where word may not even be in there anymore because a new technology comes out.

00:18:40.616 --> 00:18:50.300
But I'm more talking of the near future, because there's a lot of attention in the current wave and in future waves on reporting and just to clarify that.

00:18:50.300 --> 00:18:53.338
So it is a good statement to say that we can't never.

00:18:53.338 --> 00:19:00.801
We can't ever say never, but at least for the short term, in some years everyone can plan to use what they have.

00:19:01.423 --> 00:19:02.708
And there's no secret plan.

00:19:02.708 --> 00:19:07.999
There's no devious secret plan hidden in the Microsoft basements somewhere.

00:19:10.230 --> 00:19:11.353
It's funny Not about that.

00:19:12.336 --> 00:19:13.818
We have other secret plans, which is great.

00:19:13.818 --> 00:19:14.922
I say that too.

00:19:14.922 --> 00:19:18.220
You make me think of something I say with a lot of people.

00:19:18.220 --> 00:19:24.439
They say something to me and I tell them no, I sit up all night long figuring out how to make your life difficult, and that's what we're doing.

00:19:24.439 --> 00:19:30.115
We have some secret plan to purposely make your life difficult, which is not the intent.

00:19:30.115 --> 00:19:33.717
There's some great features coming in for the Word reporting.

00:19:33.717 --> 00:19:34.398
I'm excited.

00:19:34.398 --> 00:19:35.280
I've been using it.

00:19:35.280 --> 00:19:36.323
I've been working with it.

00:19:36.323 --> 00:19:53.080
As I mentioned, we had gone through it this past weekend when we were going through some development training to have some developers again go to school to work with now using Word layouts instead of RDLC reports, just to show how easy you can create an invoice or even an item list or something and have some nice formatting it.

00:19:53.080 --> 00:19:57.618
In addition to the reports, I see a lot with Power BI.

00:19:57.940 --> 00:19:58.280
Correct.

00:19:58.300 --> 00:19:59.124
That's exciting.

00:19:59.124 --> 00:20:01.509
I get excited about the whole thing.

00:20:01.509 --> 00:20:02.392
I tell everyone.

00:20:02.392 --> 00:20:04.577
This is like the release of reports, right?

00:20:04.577 --> 00:20:05.961
Or data analytics.

00:20:05.961 --> 00:20:13.417
Can you share with us some of the Power BI features that were released and if you have any insights into the future of that too?

00:20:13.509 --> 00:20:18.137
I know there's a lot of questions about that as well, Anything you can say from the basement.

00:20:18.137 --> 00:20:25.458
So, first of all, we are adding 75 Power BI reports to the product come November.

00:20:25.458 --> 00:20:27.933
Wow, that's a lot, 25.1.

00:20:27.933 --> 00:20:37.114
Seven different Power BI apps across finance, sales, purchase, invoice sorry, inventory twice.

00:20:37.114 --> 00:20:47.960
Two of them one for projects and one for manufacturing and they come fully embedded inside Business Central with so tell me, works, bookmarking works.

00:20:47.960 --> 00:20:51.747
They are embedded on the role centers with the so tell me, works, bookmarking works.

00:20:51.747 --> 00:20:54.958
They are embedded on the role centers.

00:20:54.958 --> 00:21:01.259
They are embedded on the report explorer as part of these departmental role centers.

00:21:01.259 --> 00:21:08.676
They are multi-language, so if you switch to French, the labels will change to French, because we need that.

00:21:10.980 --> 00:21:11.402
What else?

00:21:11.402 --> 00:21:17.359
See, those are all exciting features because everybody loves dashboards.

00:21:18.050 --> 00:21:20.534
Everybody wants the appearance of dashboards Again.

00:21:20.534 --> 00:21:26.878
So much energy and effort goes into putting data into Business Central to be able to pull that information out now easily.

00:21:26.878 --> 00:21:28.896
It increases the power of it.

00:21:28.896 --> 00:21:32.721
It's already a great application and now for you to be able to easily.

00:21:38.869 --> 00:21:42.381
In many cases, it's already a great application and now for you to be able to easily in many cases it's like a selling point, right, like just having a dashboard built in.

00:21:42.381 --> 00:21:47.092
I mean, kenny and I were talking about you know a competitor and that's that was the deciding factor do you have this dashboard built in?

00:21:47.092 --> 00:21:52.179
Now we can say, yes, it's right, right here, all the options.

00:21:52.220 --> 00:22:07.820
Yeah, I'm not a salesman, so I don't look at it as a selling point, but I do see it as enhancing the power of the application for those using it and those looking to use it, and it's the ease of being able to have access to your data, and in a dynamic manner.

00:22:07.820 --> 00:22:09.503
Right, that's the important thing.

00:22:09.503 --> 00:22:12.356
I remember when I first started working, you created with the classic reports.

00:22:12.356 --> 00:22:13.199
I wanted a report.

00:22:13.199 --> 00:22:14.402
Okay, give me this report.

00:22:14.402 --> 00:22:15.709
Oh, I want to be able to sort it this way.

00:22:15.709 --> 00:22:17.036
Oh, I want to be able to do it this way.

00:22:17.036 --> 00:22:19.136
And you required someone to make a modification.

00:22:19.890 --> 00:22:28.335
Now, here we are, all these years later, and now, with Power BI, today, I want to look at my report this way, or I want to look at my sales this way.

00:22:28.335 --> 00:22:31.901
I can easily make that change without having to.

00:22:31.901 --> 00:22:35.815
It's not necessary to say have a developer do it.

00:22:35.815 --> 00:22:48.961
You don't have to wait for the time for somebody else to do it, and that, to me, is the important thing, because it's a time saver, because how I want to look at my business today may not be the same tomorrow, or the data or the analytics.

00:22:48.961 --> 00:23:08.907
So these are all applications that I try to push with some of these features, that it's not necessarily the cost or how it's how long you have to wait to get it back Because, like I said, time changes rapidly, things change rapidly and day to day you may need something different, which is important.

00:23:09.755 --> 00:23:11.501
And I think this also unlocks.

00:23:11.501 --> 00:23:18.606
So we do have a lot of things already on docs for Business Central on how to track your KPIs.

00:23:18.606 --> 00:23:26.064
With Power BI metrics, for instance, which is an amazing feature in Power BI the new reports will require a Power BI Pro license.

00:23:26.064 --> 00:23:38.626
So for you to use them I joke that they cost between $0 and $10 a month, meaning that if you're a customer that already have Power BI Pro, the new reports are free.

00:23:38.626 --> 00:23:46.469
If you don't have Power BI Pro licenses, you need to pay for the capability and now the reports work.

00:23:46.828 --> 00:23:51.727
Right Now, with Power BI Pro, you also have this metric tracker.

00:23:51.727 --> 00:23:56.157
It's no code Any user can set up.

00:23:56.157 --> 00:24:03.069
I want to point to this number in this report and I want to track it over time and build a dashboard on that.

00:24:03.069 --> 00:24:04.877
Think about this for a moment.

00:24:04.877 --> 00:24:06.922
I am.

00:24:06.922 --> 00:24:07.844
This is just.

00:24:07.844 --> 00:24:12.579
You get this for free quote unquote for free because you have it in your PowerBear Pro license.

00:24:13.240 --> 00:24:21.965
Now we have, we give you I don't know how many let's say 50 KPIs that you can track your business out of the box and with metrics.

00:24:21.965 --> 00:24:33.582
If these are not tracked because they are computed by whenever you refresh, you can set up tracking over time on them your own, create a dashboard like that.

00:24:33.582 --> 00:24:35.865
It's called a scorecard.

00:24:35.865 --> 00:24:39.078
You can even embed that scorecard back in Business Central.

00:24:39.078 --> 00:24:46.346
You can have any KPI with these trackings and you can set up rules for when you want to be alerted in Teams.

00:24:46.346 --> 00:24:55.275
So things like, if you want to be alerted on a certain financial KPI is crossing a threshold, you can get an alert in Teams.

00:24:55.275 --> 00:25:02.977
You can start collaborating on that directly in your scorecard with your colleagues and you can ask questions and things like that.

00:25:02.977 --> 00:25:13.019
And because we now have Power BI content built in, all of these features light up automatically and just give so much more value.

00:25:14.222 --> 00:25:17.029
That is the key, it's the value and the time.

00:25:17.029 --> 00:25:39.868
I'm getting excited, I'm getting the chills thinking about it because, as you had mentioned, the ability to interact with the changing number, to put it simply, is amazing and to say, like you said, it's the cost, it's free if you have Power BI Pro today, if it's a license cost, if you need it in the future, but it's what are you getting for that?

00:25:39.868 --> 00:25:43.685
Some people focus on it, whereas, again, what are your options?

00:25:43.685 --> 00:25:49.923
You can either have somebody develop that for you, which will take time and cost money, and is it cheaper over time?

00:25:49.923 --> 00:25:52.923
And also, what's the carrying cost of that modification?

00:25:52.923 --> 00:26:07.421
Also, what does it cost you to not react to a number and see, those are a lot of the hidden costs, or the hidden portions of it that I think some, if you look at it differently right, maybe look at it from a different perspective.

00:26:07.421 --> 00:26:13.042
It's not $10 a month, but it's actually saving me in the future to make better business decisions.

00:26:13.115 --> 00:26:18.163
It's like your unrealized gains that you typically don't think about.

00:26:18.523 --> 00:26:26.765
Yes, and think about one employee not being able to track important KPIs for what they do.

00:26:26.765 --> 00:26:29.093
I think that's worth ten dollars a month.

00:26:29.093 --> 00:26:34.874
Like being able to do that is is worth a lot more than ten dollars a month.

00:26:34.874 --> 00:26:44.144
I believe so, and the amount of hours developer hours we've we put into this is is a lot like if you wanted to build these reports from scratch.

00:26:44.144 --> 00:26:49.844
It's probably take you thousands of hours to get to what we just give away for free.

00:26:50.355 --> 00:26:55.200
And if there are changes or updates, you don't have to make them.

00:26:55.200 --> 00:27:00.494
Yeah, that's the other part of this which is important is it comes with the application.

00:27:00.494 --> 00:27:09.015
You no longer have to maintain those yourself because there is a carrying cost to a modification in any implementation, not just business central, which is important.

00:27:09.075 --> 00:27:09.336
You can.

00:27:09.336 --> 00:27:25.538
Even so, since these are embedded as AL pages, you can use permissions to turn off the things you don't want, and similarly, in Power BI apps, the reports behind the scene you can turn off, like visibility on the things you don't want, and that means you can.

00:27:25.538 --> 00:27:27.124
You can also mix, mix and match.

00:27:27.124 --> 00:27:40.123
Let's say that you want to take page two, five and seven for the finance app and you keep that because they're nice, but your implementation of your liquidity KPIs are different, so you actually want to do your own for those.

00:27:40.123 --> 00:27:43.380
Fine, no, problem.

00:27:43.420 --> 00:27:47.588
Just do that With the Power BI reports and again, a lot of this.

00:27:47.588 --> 00:27:59.578
I bring some of these questions just from conversations that I have with customers or individuals implementing Now that Power BI reports are in Business Central within the same application, so you can see these dashboards.

00:27:59.578 --> 00:28:08.483
There's some questions with customers either migrating to Business Central from a previous version or moving over from a new application.

00:28:08.483 --> 00:28:15.597
They may have some legacy data that they need to still have for analysis Years ago.

00:28:15.597 --> 00:28:17.942
Some would say well, you still have access to your old system.

00:28:17.942 --> 00:28:25.280
Or we may bring some of the data over With Power BI and the way that you have it embedded within business central today.

00:28:25.280 --> 00:28:33.166
Is it possible to see some of that data correct in in in line with the business central data, so you don't have to put everything business central?

00:28:33.166 --> 00:28:34.055
That's a good.

00:28:34.055 --> 00:28:35.695
Can you read it from an external source?

00:28:36.496 --> 00:28:36.695
sure.

00:28:36.695 --> 00:28:38.916
So we actually so, since we've.

00:28:38.916 --> 00:28:41.218
So we actually so since we like.

00:28:41.218 --> 00:28:48.561
We try to be smart about engineering with the new apps and we didn't want AL developers to code anything.

00:28:48.561 --> 00:28:52.702
So what we did was we wrote a code generator.

00:28:52.702 --> 00:29:03.827
So let's say that you are the owner of this Power BI app report that runs on some SQL servers or something right.

00:29:03.827 --> 00:29:09.070
These reports are deployed to the Power BI service, but they're not like that's it.

00:29:09.070 --> 00:29:15.032
So you have a report with some pages and you would like to embed them in Business Central.

00:29:15.032 --> 00:29:27.663
Here's what you do you type in your report names, your teaching tips because, because, of course, we want teaching tips.

00:29:27.663 --> 00:29:35.525
You are, you put in information about the report IDs and the report pages in an Excel workbook, configure all of this in Excel.

00:29:35.525 --> 00:29:54.624
Then you run a command line script that reads that and that script spits out an extension with all the generated AL code for all the pages, for all of that, and you take that and you deploy that as a PTE and that's it.

00:29:57.064 --> 00:30:10.211
Wow, I'm kind of speechless now, because that simplifies the data management in the analysis within Business Central using Power BI reports with external sources.

00:30:10.211 --> 00:30:12.718
So it's not only historical data.

00:30:12.718 --> 00:30:16.884
But there are cases where Business Central is a great application.

00:30:16.884 --> 00:30:20.789
But I've worked with implementations where they need another system to do something else.

00:30:21.275 --> 00:30:22.571
I've worked with implementations where they need another system to do something else, because Business Central is a tool.

00:30:22.571 --> 00:30:30.847
You use the tool to do the job, but now, if they can take that data, they don't need to go to another system that can look at them.

00:30:30.847 --> 00:30:32.940
Together they can do it all within Business.

00:30:32.961 --> 00:30:33.201
Central.

00:30:33.201 --> 00:30:41.999
I forgot to say one thing though that Excel workbook you also configure, your permission sets for all of this, and it generates all of that for you as well.

00:30:41.999 --> 00:30:48.926
Wow, Because the thing is we needed this for seven apps for 75 pages.

00:30:48.926 --> 00:30:59.015
We didn't want to write all that boilerplate code, so we just made a code generator, and that's available on BCTech, so you can just go download it and use it in your project.

00:30:59.214 --> 00:31:03.066
So on the GitHub repo, BCTech it's the Microsoft repositories.

00:31:03.066 --> 00:31:15.075
Bctech has a lot of great business, central technologies, as I call it, it's under akams forward slash bc power pi samples and that's where you find it.

00:31:15.836 --> 00:31:22.390
That's also our code sample for how to script the multi-language, which is a similar thing.

00:31:22.390 --> 00:31:37.423
You have a resx file for each of your language and you just do a command line tool and we'll inject that into your Power BI, because we needed that and the tools we built for this project we're giving to the community for free.

00:31:38.655 --> 00:31:39.713
So I'm kind of speechless now.

00:31:39.713 --> 00:31:42.261
I almost wanted to start writing Power BI reports.

00:31:42.261 --> 00:31:43.424
It becomes much easier.

00:31:44.517 --> 00:31:45.621
You're going to the other side now.

00:31:45.621 --> 00:31:46.704
You're going to do some BI stuff.

00:31:46.934 --> 00:31:54.588
I might have to start doing analytics in BI because I'm just impressed with where this has moved.

00:31:54.588 --> 00:32:02.548
If you just think of the evolution over time where we started, it's difficult to keep up to be, honest with you.

00:32:02.548 --> 00:32:11.989
Are there any other tips and tricks or future tidbits or bites that you can share with us.

00:32:12.255 --> 00:32:21.070
All the tooling I mentioned here is explained by Enrico, one of our developers, in the BCLE session on what's new in Power BI.

00:32:21.070 --> 00:32:22.560
He's demoing all of it.

00:32:23.694 --> 00:32:26.840
And those are all available on the BC YouTube.

00:32:26.840 --> 00:32:38.500
I believe it's akms forward slash BC YouTube all of the recordings from the Business Central launch event with what's new in Business Central 2024, wave two, and it's publicly available.

00:32:38.500 --> 00:32:44.558
So you could sign up for the launch event to register to watch the live Q&A, to watch the live sessions.

00:32:44.558 --> 00:32:50.520
But the recorded sessions, if you weren't able to see them, are now available and all of the sessions are available.

00:32:51.242 --> 00:33:04.846
But we're not done Because in 25.2, so the December, January is release we're coming out with a Power BI app on the new subscription billing module.

00:33:04.846 --> 00:33:09.584
That's right, it will come with its own Power BI reports.

00:33:09.584 --> 00:33:18.642
We are also cooking up on better dimension support for all the Power BI apps so they support your dimension setup.

00:33:19.336 --> 00:33:22.665
Again, it's the year of reporting and analysis.

00:33:22.665 --> 00:33:26.259
I put again reporting and analysis a Power BI user's analysis.

00:33:26.259 --> 00:33:26.797
That's great.

00:33:26.797 --> 00:33:31.184
With the subscription billing, I see a lot happening with subscription billing.

00:33:31.796 --> 00:33:34.881
That's like a full feature, like everything you need right.

00:33:34.881 --> 00:33:38.482
Like reporting is a big component of that, Wow.

00:33:39.605 --> 00:33:40.347
Oh, it's excellent.

00:33:40.494 --> 00:33:43.384
And then we're sanitizing all our existing reports.

00:33:43.384 --> 00:33:49.515
We're documenting all of them, putting teaching tips, so in client help, we are making them available.

00:33:49.515 --> 00:33:53.825
I want to talk about that secret, so you will hear of that in six months.

00:33:53.825 --> 00:34:04.009
We're documenting, trying to document all the analytical reports in our docs with articles for each of them.

00:34:04.009 --> 00:34:10.014
So we're trying to make discoverability of existing reports easier.

00:34:10.795 --> 00:34:16.748
And some people say why do you want to invest in writing documentation for reports that are 30 years old?

00:34:16.748 --> 00:34:17.840
Why don't you just grab them?

00:34:17.840 --> 00:34:28.788
You just grab them and I think, well, it probably took a developer and a program manager a week or two to come up with why this was a good idea to have.

00:34:28.788 --> 00:34:39.380
So some of them might not, but there might be a lot of old gold there that needs maybe just need some polish and still be valuable for the next 10 years.

00:34:39.380 --> 00:34:56.202
So that's why I think it's still worth it to invest in like making sure that people know okay, this report can do this for me and they can choose to say, no, it's fine, I don't want it, I want to use Power BI, but maybe for some scenarios this is fine and we'll document it so people will know.

00:34:56.202 --> 00:35:04.780
Okay, these are the use cases, and it seems like this is a good report for me use cases and it seems like this is a good report for me.

00:35:04.800 --> 00:35:15.036
And yeah, I'd like that because it gives microsoft the opportunity to review the reports to see if they still applicable for what they were created for, but also now users can see reports they may not know existed, exactly where it's.

00:35:15.036 --> 00:35:22.735
I can't tell you how many times I've seen requests for a report that was already there yeah because it wasn't easy to find.

00:35:22.735 --> 00:35:26.974
So the discoverability of it, with being able to easily see what it is, is helpful.

00:35:26.974 --> 00:35:30.135
They're really not letting you out of the basement with all of these things coming in.

00:35:30.235 --> 00:35:31.320
This is the year of.

00:35:32.175 --> 00:35:45.237
I mean we had just had a session with 200 customers here at UT Summit and our moderator asked how many of people you know about the report Explorer and the client.

00:35:45.237 --> 00:35:49.235
The report Explorer is this link you can click where you like.

00:35:49.235 --> 00:35:57.121
It's the top of the of the, the role center, where that shows you your reports and you have these stuff departmental role centers.

00:35:57.121 --> 00:36:11.701
Probably 5% of people knew that existed, which means our main discoverability feature, except for search and chat, the main one that shows you what are my sales reports 5% people know that.

00:36:11.701 --> 00:36:15.894
That's insane, right.

00:36:15.894 --> 00:36:27.000
Then I'm not surprised that your customers don't know what reports exist if they don't even know where the report overview is Right and we need to tell them.

00:36:27.000 --> 00:36:30.184
We need to explore, like tell them what's available.

00:36:30.423 --> 00:36:31.106
No, that's important.

00:36:31.106 --> 00:36:32.300
See, it's a lot of these features.

00:36:32.300 --> 00:36:34.523
Again, it's discoverability which is important.

00:36:34.523 --> 00:36:36.661
There's a lot there and it comes out.

00:36:36.661 --> 00:36:37.976
Yeah, that's….

00:36:38.277 --> 00:36:39.300
And functional consultants.

00:36:39.300 --> 00:36:44.393
They would benefit from that too, because sometimes they don't realize that there's.

00:36:44.432 --> 00:36:48.025
Some of these reports See Kenny said AL developers need to go back to school.

00:36:48.025 --> 00:36:53.282
I think functional consultants need to go back to school now too, with the application it does.

00:36:53.282 --> 00:37:08.137
It shows why it is important to keep up with the launch event and other areas, because years ago, back with the vision, the up the back way, back, the way back machine, the updates weren't as rapid.

00:37:08.137 --> 00:37:12.391
So if you learn the application, you had a year to master it.

00:37:12.391 --> 00:37:21.134
It was gold because they weren't having another update for another couple of years and you could survive on that because there was a slow progression of change.

00:37:21.134 --> 00:37:33.364
Now, with that rapid progression of change, it's important to stay acclimated Correct, I use the word acclimated but to stay in touch with the changes of the software, which makes it more useful.

00:37:33.594 --> 00:37:35.402
But I think also as a functional consultant.

00:37:35.402 --> 00:37:39.425
This is also what makes you the gold consultant or platinum.

00:37:39.425 --> 00:37:43.175
This is the one where you already know.

00:37:43.175 --> 00:37:48.092
You know what to tell a customer like, oh, did you know this or did you see this?

00:37:48.092 --> 00:38:03.009
That's the kind of consultant that a customer would like to have on on their team, instead of the consultant that quote unquote just do what they are told and and maybe they're missing out the customer is missing out on smarter ways.

00:38:03.009 --> 00:38:15.280
So it's also a way to keep your value as a consultant by keeping up and I know it's hard because there's so many things that are happening, but I also know that because I've been a consultant myself.

00:38:15.280 --> 00:38:18.766
Part of the job as consultant is non-billable.

00:38:19.514 --> 00:38:31.445
You also need to sharpen your saw, it's true because it's the same thing as using Power BI and the licensing to use it to analyze your business.

00:38:32.478 --> 00:38:43.590
The time that you spend to learn the application makes you much more of a valuable teacher, user or consultant of business central.

00:38:43.590 --> 00:39:03.628
So your ability with that no bill time is returned in the future correct with the implementation of customers, and even internal I mean internal customers, it's you know, I don't know how the structure would be, but also spending some time each week, and I try to say spend a couple hours each week looking through what's new, looking through the notes you I know myself I have.

00:39:03.628 --> 00:39:11.918
When I launch up my computer in the morning with a browser, I have a number of tabs with just a number of different websites that I can see so I can keep up with things.

00:39:11.918 --> 00:39:25.762
Then at that point, like with the Yammer group for Business Central, for partners and such, I can keep up with things easily in just a couple minutes a day versus trying to cram, I think, just being aware of it as well, makes it.

00:39:25.802 --> 00:39:46.583
Yeah, you may not need it then, but you're aware that when it comes, it's like oh yeah, I remember reading into this and dive deep into it and I think the key here is not expecting people to spend a couple of hours a week because that might be a daunting task yes, but maybe just like when you want to lose weight or get in shape.

00:39:46.583 --> 00:39:54.335
Maybe it's just that five minutes every morning, consistently five minutes of learning, and just say okay.

00:39:54.335 --> 00:39:59.288
And many of the new videos on BCLE are bite-sized, so they're five to ten minutes.

00:40:00.356 --> 00:40:03.585
I like that strategy of the bite sizes you call it.

00:40:03.585 --> 00:40:06.902
I'll keep using that because I'll always go back to what you said to us every day.

00:40:06.902 --> 00:40:09.038
You know, many years ago, when you spoke, with us.

00:40:09.378 --> 00:40:10.340
How do you eat an elephant?

00:40:10.340 --> 00:40:13.657
Yeah, one bite at a time, and it's the same thing with ingesting data.

00:40:13.657 --> 00:40:18.516
You don't have to have the daunting task and having those bite-sized uh nuggets.

00:40:18.516 --> 00:40:21.346
If you have 10 minutes, you have a nugget.

00:40:21.346 --> 00:40:22.951
If you have 10 minutes, you have a nugget.

00:40:22.951 --> 00:40:24.195
If you have 20, you can see two nuggets.

00:40:24.195 --> 00:40:26.184
And again it's those small increments.

00:40:26.204 --> 00:40:26.608
That's what I found.

00:40:26.608 --> 00:40:36.820
That's why I said in the morning with me, I now have a habit of checking on a few resources online that I can keep up with the things that I would like to keep up with.

00:40:36.820 --> 00:40:39.094
I mean, obviously, there's another aspect of it too.

00:40:39.094 --> 00:40:41.599
You can't keep up with everything, because there's just a lot of information.

00:40:41.599 --> 00:40:53.784
It's just a matter of focusing on what, which area, your area and your specialty, and I now know who to call if I come into another area that I'm not familiar with.

00:40:53.784 --> 00:40:55.067
Yeah, but you're aware.

00:40:55.067 --> 00:40:56.635
Exactly that's.

00:40:56.635 --> 00:41:00.806
The key is, I'm aware that this exists and I send everybody to Kenny.

00:41:01.295 --> 00:41:06.717
You have to have a Power BI question On this episode.

00:41:06.717 --> 00:41:16.786
We'll have to put Kenny's cell phone number, so if anybody has any questions, feel free to call him, preferably at 2 in the morning, central Time, of course.

00:41:16.786 --> 00:41:17.467
No, that's great.

00:41:17.467 --> 00:41:19.623
Well, kenny, I'm getting hungry.

00:41:19.623 --> 00:41:31.509
Nobody likes me when I'm hungry, but thank you for taking the time to speak with us today to share your insights and information on 2024 Wave 2.

00:41:31.509 --> 00:41:32.739
We appreciate your support.

00:41:32.739 --> 00:41:37.184
We appreciate you spending time with us, because I truly mean it when I say time is the currency of life.

00:41:37.184 --> 00:41:42.847
Once you spend it, you can't give it back, because any minute you spend with someone or doing something you will never get back.

00:41:42.847 --> 00:41:54.027

Episode 346: In the Dynamics Corner Chair: Reporting in Business Central's 2024 Wave 2: Ready?

Listen On

Recent Episodes

Microsoft Episodes

Browse episodes by category