Report Building
3 Things to do when handing a Power BI report / model for Report Personalisation As a powerbi developer you know your data and your model inside out. Part of my role as an external consultant is to train people in using their reports and increasingly how to use the dataset in different scenarios and […]
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. […]
Leaderboard for Virtual Staff Engagement
One of my customers runs interactive courses for Virtual Staff Engagement and wanted to explore the idea of a virtual leader board which refreshes from a Google sheet and ranks participants based on their score of the game and when they participated in the game using PowerBI. The leader board should be nice and simple […]
Present with Confidence
Present with using Microsoft PowerPoint I love training and there is no better feeling than seeing people enjoy your session. Learning should be fun but it should also mean that you develop skills which you can use. That is the challenge with training. You need to ensure you give enough information but that it is […]
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 Power BI – a quick way to ensure your client is happy with their dashboard
Client Satisfaction is critical to ensure that your dashboard works. I came across a genius idea whilst working through a masterclass in Power BI with the brilliant Chandoo which was very kindly hosted by Plum Solutions. The genius idea…. use a power point template to structure your dashboard. Why is this genius? It means that […]
How to grow your business with data – Growth accounting
There are two main types of growth: Short term – growth hacking, users are encouraged to buy products by incentives which ensure new users but not necessarily retained users. Long term – users buy into your product or business because they value your product and want to stay with you. Data Analytics allows you to […]
Customer Acquistion vs Customer Retention?
When is the best time of day to send that email reminding clients to buy your product or renew their service? Don’t rely on generic marketing advice, look at your customers and predict when they buy so your email hits them just at the right time to press the buy button. Data Analytics allows you […]