Categories
Data

Mastering Visual Trends Analysis in Power BI

This post explains key methods for displaying changes over time in Power BI. It covers transforming date formats in Power Query, creating a date table, converting UNIX timestamps, and using visualizations like line graphs, column graphs, area charts, Gantt charts, and histograms. The post also provides steps for accurate running totals and highlights both DAX and simpler solutions.

Categories
Automation Data Social Learning Software

With Great Power Comes Great Responsibility: A Look at Artificial Intelligence

As we delve inexorably into the inevitable world of AI we’re finding it has the potential to revolutionize our lives in countless ways, from automating tasks to pioneering scientific breakthroughs. With this power comes a great responsibility to ensure AI is developed and used ethically. In this blog post, we’ll explore the basics of AI, […]

Categories
Data

Who hates Power BI URL Parameters?

I love ’em, me, until I need to extract a custom URL – especially if it’s to this, this, this, and this – to share with others. With a bit of DAX and button trickery, however, there’s a way to add a button to a page so once values are selected in a slicer, the […]

Categories
Automation Data Software

Transform your data in PowerAutomate

Super-charge your automations in PowerAutomate by customising the data coming into it using Power BI’s query editor…

Categories
Data Intranets Software

Power BI : Learn to build free Venn and Euler diagrams

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. […]

Categories
Automation Classification Data Intranets

Easy Route to Hybrid Search in Sharepoint

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: On a Sharepoint site, […]

Categories
Data Intranets Open Source Social Learning

Get Geospatial with the Moodle Database Activity

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
Data Intranets Software

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 […]

Categories
Automation Classification Data Intranets

Sharepoint library settings – quickly go from default to awesome

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…

Categories
Data Software

Power BI Toggle Switch visualisation updated

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 […]