Some examples of our work
Viewing entries tagged
Power Query
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.
