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 […]

Microsoft Power Bi Dashboard – a report on Facebook Usage

So 21 Power BI MVPs bring out a book each contributing a chapter on different tips and techniques for using Power BI.  The first chapter is how to use BI to analyse Facebook data and it seems rude not to have a play. I knew I was using Facebook a lot less, but having the […]

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 […]

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 […]

Should I buy Microsoft Office 365 or buy Excel 2019?

There are two ways to purchase Microsoft Excel.  You can occur a one off purchase (a perpetual licence) of Office 2019 or you can choose to have a monthly subscription for Office 365.  The one off purchase will enable you to buy Office 2019 and use it for however long you like.  However, it will […]

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 […]