Machine learning is like washing clothes

Machine Learning is all about data… and algorithms. But first and most importantly it’s about data. And it’s not just any data, we need enough, high quality and (and in many cases) “cleaned” data. When we talk about cleaning data, we normally use the word ‘wrangling’. Wrangling is like washing clothes: your dirty data goes in and clean, neatly ironed and folded data comes out.

Lees meer…

The Order You Select Columns In The Power Query Editor Can Affect The Output Of Some Transformations

Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain transformations.

Bron : Chris Webb’s BI Blog
Lees meer…

Extending the Outlook Add-in Experience in Microsoft Dynamics 365 Business Central and Microsoft Dynamics NAV

One of the showcase features of Dynamics 365 Business Central is the ability to use the product within Microsoft Outlook clients using Outlook add-ins. There are two add-ins that come out of the box with Dynamics 365 Business Central: The Contact Insights add-in and the Document View add-in.

Bron : Dynamics NAV Team Blog
Lees meer…

Ultimate Time Based Calculations Cheat Sheet for DAX / Power BI (including Week based calculations)

Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I used two-month periods in my example below). If you want those, you will have to create the calculations yourself.

Bron : Dutch Data Dude
Lees meer…

Cost Roll Procedure in Microsoft Dynamics NAV

The information below explains the steps to follow while rolling standard costs in Dynamics NAV. The process is relatively simple, but the goal of this document is to explain the importance of each step: and what is accomplished in those steps. So while this may appear to be a long blog, stick with is as it provides a thorough explanation and rationale of each step.

Bron : ArcherPoint
Lees meer…