Journeys with Power BI
I find my stakeholders always require all the data points to be labelled on graphs. However, if there are lot of data points, I think this can sometimes make it distracting to try and get an idea of the trend. Hence, as outlined in this post I’ve provided a simple solution to toggle between showing …
Why am I getting a data mismatch error when everything has been working perfectly for ages?? The original article I found advised duplicating the table with the error, to replace the original error. This worked. Link to similar article However, it’s very tedious if you’ve created perspectives, have lots of relationships and calculated columns to …
In this post I’m outlining how to setup a report that enables users to navigate to individual pages based on the logged in user. Users should only have access to their tabs. Why would you do this? For context an example scenario could be providing call statistics per call taker. Add a caveat I would …
We have a peer review process at my work, which has always been a great opportunity to learn. I remember in one review; I had critical feedback as to why I had used a pie chart on a report – pie charts are bad. This review led me to read up on pie charts and …
The main data source for the reports that I build from is SQL Server. To build the report I need to first extract it from the relevant databases and then build the data model in Power BI. Most of the transformations are done in SQL, transforming the data before it is imported. The Where clauses …
This post outlines how to make your export to excel file names more user friendly. Why do this? Can’t you just go save as and change the file name? Point. But this was a business requirement as different areas export a lot of data to excel from the reports we support on different days. This …
I remember my boss at the time asking me, so all this theory stuff is fine but how are you going to make benefits real? In other words, show me the money. Up until this point, I’d had to get across the message of what benefits realisation is and why we should be implementing it …