The Power of M…

...Power Query M WARNING: convoluted geek joke ahead Three data analysts walk into a bar, and the bartender gives them a problem: "My data table includes a column containing Company Name, but I want the business acronyms in a new column, with a space between each initial. Oh, and the data contains some hinky characters … Continue reading The Power of M…

Power BI: Making Data Pretty…

...and pretty understandable. Admit it: your business concurrently uses multiple legacy systems in multiple business areas -- whilst looking forward to the bright new shiny system you have commissioned -- and knitting all these data sources into a coherent ensemble presents a considerable reporting challenge. Power BI is a great way to render data meaningful … Continue reading Power BI: Making Data Pretty…

Course Results

My previous post Test Driving a New Course introduced Managing Customer Engagement with Microsoft Dynamics 365 from Microsoft Learning. Here I discuss my journey traversing the remainder of the course. Managing Customer Engagement focused on the capabilities of the Sales and Customer Service modules of Dynamics 365 and briefly discussed Field Service, particularly in the … Continue reading Course Results

IoT and that…a new etiquette?

The publication of the recent report by the UK's Royal Academy of Engineering and PETRAS on the internet of things (IoT) is timely in the context of the ongoing furore surrounding tech giants collecting, and indeed farming1, our data. The Royal Academy of Engineering and PETRAS report follows on from the Blackett review -- four years ago … Continue reading IoT and that…a new etiquette?

Test driving a new course

or: Decoding MS-Speak It seems that the fairly recent change in targeted audience for Dynamics 365 has prompted Microsoft to develop a free online course. Managing Customer Engagement with Microsoft Dynamics 365 from Microsoft Learning is weighted towards sales, which admittedly isn't really my bag, but the course content seems to be well thought out … Continue reading Test driving a new course

Getting Dynamic with Dynamics

Using my first Dynamics trial simply as an open-ended exercise in exploration, quite a few things are worth noting before getting into customising the solution to meet your needs. What you can see Playing with the dummy data and adding your own allows you to appreciate the work that has gone into the development of … Continue reading Getting Dynamic with Dynamics

365 Investigation

My investigation into Dynamics 365 is already exciting. This product has a sleek UI converging across all the MS Office products, closely resembling OneDrive and Office 365 -- no surprise there -- and newer versions of Office on the desktop. It looks a lot like LightSwitch too.   At the moment, I'm absorbing training videos from … Continue reading 365 Investigation

…and a new beginning

Continuing from the previous post, looking at my past experience it would seem that FMPro would be an ideal fit to meet my needs for a single user CRM on the desktop. Overall, FileMaker is the best rapid application development tool I've used to date, and has always been a great developer experience. One bugbear: … Continue reading …and a new beginning