Some examples of our work
Viewing entries in
PowerBI
This project takes a large amount of data and produces a compelling report that is easy to understand whilst still allowing complex comparisons and detail drill-down.
It illustrates the use of additional reference data that is essential for meaningful reports, and how to ensure it is in synch with the main dataset.
It features a particularly good use of area charts to illustrate the cumulative effect of energy use reduction over time.
A Power BI report built for a recruitment company summarising the movement of people between companies, sectors, geography and levels of seniority.
The solution required fuzzy matching with Excel, an additional reference data sheet, a bespoke word matching function in Power Query and an advanced technique to read the contents of a SharePoint folder. It also features a couple of really cool Chord charts.
A performance dashboard built for a UK Loans Intermediary company using Power BI and shared via the Power BI Service and SharePoint.
It features extensive data transformation with Power Query and a particularly successful customer activity heatmap. Although the DAX measures are not complicated there are 66 of them and USERELATIONSHIP is used extensively to manage the 7 connections between the Fact and Calendar tables.
