Paginated Reports
Paginated Reports and Power BI Datasets. I have been exploring creating paginated reports with Power BI Datasets and the below is a summary of my findings, with links to tutorials for each step. There are some excellent free tutorials on how to design and build your reports which I can thoroughly recommend, I’ve pasted the […]
COVID Dashboard
COVID 19 Summary View This is a useful summary of the steps used to create the data model for the Reports. SEE IT IN ACTION Step 1 – created a query to pull in the first data set. Created a parameter for a filename. Then changed the filename in the query to the parameter filename, and ensured that the query would dynamically […]
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 […]
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 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 […]
Microsoft Excel – shortcut to create a Table
Excel Tables are awesome but so easily overlooked. Place your mouse anywhere in your data and click. You can use the Control and T key pressed together to select a range of data, this will then convert it to a table. Have a look at my clip below. Once your data is converted to a […]
Microsoft Power Bi Dashboard – a sales dashboard example
So if you know me, you’ll know much I value and enjoy working with Excel, R, Python and Shiny. I love data and the power that it gives you to find out what is happening with your business. Therefore you may be surprised to learn that my allegiance is under threat…. Microsoft Power BI is […]