Create a linked Excel table from your Power BI report
A current customer request is to enable a linked Excel table driven by a Power BI dataset that can be filtered by one parameter for department and then filtered by individual staff within that department. The request is then for each member of staff to make comments on their information which can then be stored […]
Quick Books Online to Power BI to Excel
How to Connect Quick Books Online (QBO) to Power BI and then to feed into Excel To connect to Quick Books using Power BI you need a specific connector: https://docs.microsoft.com/en-gb/power-query/connectors/quickbooksonline To enable authentication to Quick Books, you need to: Download the new Microsoft Edge based on Chromium You then need to go into your Environment […]
Creating a printable list using Power BI, Excel and a little bit of VBA
Frequently my clients love the visualisation and aggregation of Power BI but want to be able to print off a scrollable list. However, this is one key element that is not part of Power BI, you need to use paginated reports which is included within Premium licensing. Paginated Reports give the ability to create a printable report on several pages of a table. […]
30DQUERY Day 29 Partitions
Share on linkedin LinkedIn Share on twitter Twitter Share on facebook Facebook This query involved taking the data and splitting it into four partitions using power query. I’ve split the data into four partitions and the query folds which means that a Power Query query generates a single query statement to retrieve and transform source […]
30DQUERY Day 30 Last day
#30DQUERY Day 30 Last day of this Challenge which makes me really sad 🙁 🙁 I have really enjoyed these challenges and a huge thank you to Alex Powers for driving the momentum. If you are interested in Power Query there is no reason why you can’t join restrespectively 30 Day Query link The final days challenge […]
Mastering DAX
So very thrilled to complete this. It’s been a real roller coaster of a journey which has involved dark rooms and rocking back and forth. What helped was also reading the book at the same time. I found working through the Demo files whilst watching the clips also helped as I could make notes and […]
How to save time using Excel
Data Modelling with in Microsoft Excel Do you import data into Excel? When you use Excel, do you perform a serious of boring and repetitive tasks? Do you repeat these boring, repetitive tasks every time you get a new set of data? Does it fill you with joy whilst you think about what else could […]
Microsoft Excel – KPIs
As a Microsoft Excel Trainer and PowerBI developer I have to stay current. Fortunately for me, I love to learn and then share my knowledge with my customers. There is a real joy in teaching Excel and seeing the lightbulb moment occur, usually within minutes and usually several times! I’m following a Udemy course with […]
Microsoft Excel stops the computer saying no….
When you know that it should work and it doesn’t, it drives you crazy… or is that just me? So the challenge was to take a data export from a time management software tool and convert it to a Power BI dashboard. This particular piece of software is used to measure the time spent by […]
Microsoft Excel Data Transformation Magic
Yesterday I received an SOS from a colleague… “Sue, I’m stuck! It says it can do it but it can’t…. and I’m running out of time. I have a deadline to meet and am seeing clients all day. Why won’t it work, help!!!” . So I did. The problem was that the HR software that […]