Power BI is a Global BI Leader

One of the great new features in Microsoft Dynamics NAV 2016 is natively working with Power BI. You can use this feature very easy using OData web service in NAV and copying this URL to Power BI when you try to use it. You just need to choose to import your content pack from Microsoft Dynamics NAV.

PowerBI_Content.jpg

Because of that, I want to write few words about this solution. This BI tool is not only for Microsoft Dynamics NAV, of course. You can use Power BI with i.e. other Dynamics product or with almost every database you want. This is is really powerful and modern tool for analyzing and visualization your data. And everyday is better and better. You can find a lot information about this product here and I don’t want to write about functionalities.

I’ve just wanted to show how other people outside Microsoft see this product. Gartner organized a huge survey about BI products and we can see this results in famous Gartner Magic Quadrant for Business Intelligence and Analytics Platforms. You can see that Gartner has positioned Microsoft as a Leader in this area. Microsoft is a leader for the ninth consecutive year, but for the first time, Microsoft is placed furthest in vision within the Leaders quadrant.

BI_Gartner.jpg

It means we can expect more and more capabilities and new benefits of this solution. Well done Microsoft.

My PPTs from Directions EMEA and NA

I’ve just published my Power Point presentations from both of Directions conferences. You can find presentations from Directions EMEA and Directions NA. I didn’t want to publish them earlier because Directions NA wasn’t closed.

Now, you can find all details from these two presentations and learn how to implement standard NAV solution in construction business. If you need some help about this, give me a question. If you want to know more about vertical solution for NAV in Construction, I will answer everything you need.

Presentation from Directions EMEA 2015

Presentation from Directions NA 2015

These presentations will be available for download until the end of this year.

NAV ‘Corfu’ is now NAV 2016

Today at WPC in Orlando, Microsoft have published official name of new NAV. Now, it is Microsoft Dynamics NAV 2016. New NAV will be released in few following months with really lot of news. Some of them are: Phone Client, better In/On, works natively with Power BI and CRM Online, e-Everything, Posting Preview, OCR, Workflow,…

nav2016

These information are official and you could see them on WPC. But, you can expect more details very soon (after NDA).

Using of Expressive Tiles in NAV 2015

Cues as tiles already exist in the Microsoft Dynamics NAV client that display business data as FlowFields and integers. But with Microsoft Dynamics NAV 2015, they start as some kind of BI tools to also present key performance indicators (KPIs) on Role Centers and includes the following new features. Now we have enhanced the functionality of Cues to give application developers, as well as end users, more control over the appearance of Cues. Each changing will be seen on all clients.

Cue1

Now, we have not only static tiles. With new feature, we can configure the Cue to display a bar along its upper border that changes color based on the data in the cue. It can be made by developing a cue or by end-user, using “Set Up Cues” on Role Center page. With this feature, Expressive Tiles provide us more quality in daily work.

Cue3

Developing cues, we can change the image that displays on the Cue or set up the Cue without an image on property. There are several images to choose from and for now, we cannot use customized images.

In previous Microsoft Dynamics NAV versions, we could only set up Cues based on FlowFields and we could set up them to display on integer data types. Now, in Microsoft Dynamics NAV 2015, we can also use normal fields (instead only FlowFields) and we can also use a decimal data type. This provides us additional data aggregation possibilities instead of just COUNT, such as SUM, MAX, MIN, and AVG and of course, extends source of Cue data, such as using query objects.

By using the AutoFormat and AutoFormatExpr properties, we can customize the format of the value in a Cue. For example, we can set the number of decimal places, or place a symbol such as currency sign or % before or after a value.