Super-charge your automations in PowerAutomate by customising the data coming into it using Power BI’s query editor…
Categories
Transform your data in PowerAutomate
Category: Data
Capturing, analysing, and sharing insights on data helps us make better decisions.
I’ve long been an advocate of effective reporting for this purpose. From getting my Master’s research and data analysis published in 2003 to developing a suite of Power BI reports in 2016, I continue to share my learnings in the articles below…
Grouping datasets into overlapping circles can, in many cases, allow your audience to easily grasp relationships between them. Power BI comes a bit short in being able to deliver on this, with no out-of-the-box visualisations for Venn or Euler graphs – and the custom visualisations are lacking essential features or cost up to US$5,000 p/annum. […]
Bringing content from applications that aren’t indexed by Sharepoint search can be expensive, complex, and fraught with unknown variables. Follow this guidance to quickly populate your index with such external content without having to go down the Graph/Cognitive Search route… This post will clearly show you the steps to accomplish this: In the guidance that […]
Moodle allows you to quickly build a custom database, including a location field; this article will show you how to make it easy for your users to populate that field, and then generate a beautiful, interactive map from its data
Categories
Power BI – Keeping it Simple
You know the scenario – you throw some visualisations together and publish a proof of concept. People love it, and start filling up your backlog. You quickly add new features accordingly, and before you know it you’ve an unintelligible mass of pages, charts, tables, filters, maps, and text boxes; the ‘love’ turns out to be […]
The out of the box list settings in Sharepoint are simple and easy to get your head around. Here are some basic configuration settings that will bring out the very best Sharepoint has to offer. So head to your list, and add these in…
Sometimes it’s the little things that get me excited; so I was delighted to find out the Power BI toggle switch visualisation has been updated. This handy little graphic allows a user to click on it to filter the data in other visualisations to a value, or values, that you specify in the options; and […]
The new version of Yammer is a massive improvement over the previous – full text and interactive emails, favouriting communities, the replacement of Yammer profiles with the Office 365 ones, and the hidden gem of closing posts to further comments have been met with universal acclaim. I’m not here to gush, however, so lets get […]
We an issue we were able to cunningly solve in the query editor; we wanted to show in our report which values in one query had a match in the other. One query was a list of features on a site, the other was a list of core features. We wanted the site features to […]
We wanted to improve our communications, and figured that understanding the characteristics of messages that had lots of ‘likes’ would help us do that. A request to find the most liked Yammer messages in our network was received, and we and figured out a way to find it…