Data & Analysis – Page 28

Data & Analysis Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV 2017 – Cortana Intelligence

Thanks to the option of expanding the NAV environment by means of various extensions, Dynamics NAV 2017 users can now also view sales and inventory development forecasts using machine learning. Bron : ERP & BI Newsroom Lees meer...

18 April 2017

Data & Analysis

Daylight Saving Time And Time Zones In M

Quite a few people (Ken Puls, Reza Rad and today Chris Koester) have blogged about how the M date/time zone functions work in Power Query/Power BI, and the related problem of turning a UTC time into the actual time in any given location taking Daylight Saving…

4 April 2017

Data & Analysis

Quick Tip: Working With Multiple Power BI Subscriptions/Accounts

As a consultant I frequently work with customers who want to add me to their Power BI tenant so I can publish reports, monitor data refresh and so on. However, this means I end up with many different Microsoft “Work or School” accounts, one for each…

29 March 2017

Data & Analysis

Thoughts On Visio And How It Could Integrate With Power BI

The recent release of Visio Online (which means most people with an Office 365 subscription can now see Visio diagrams in the browser) and updates for Visio Pro for Office 365 (the desktop version of Visio, needed for creating diagrams, available on subscription but annoyingly not…

24 March 2017

Data & Analysis

Benefits of Power BI using Jet Enterprise as a Business Intelligence Solution

The importance of choosing the best business intelligence solution for your company, and the advantages of choosing Power BI using Jet Enterprise. Bron : ArcherPoint Lees meer...

21 March 2017

Data & Analysis

Power Query/Get & Transform: The Future Of Data Loading In Excel

Last week, Dominic Petri shared a link on Twitter that contained some important news from Microsoft: as of the March release of the Office 365 click-to-run version of Excel 2016, the old methods of loading data into Excel will be replaced by the newer “Get &…

13 March 2017

Data & Analysis

Exporting Your Queries’ M Code From Power Query And Power BI Using Copy/Paste

Two years ago I blogged about a method to export all the M code for all of your queries in Power Query using the Send A Frown button – useful if you need the code for documentation purposes. This trick doesn’t work with Power BI Desktop,…

7 March 2017