Bookmarks
Bookmarks Bookmarks are an excellent way to keep your reports simple and uncluttered whilst giving your users additional information when they use it. For example, if you click on the ‘i‘on this report, it places an overlay on the page which gives the supporting information. I found them a little hard to get my head […]
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 […]
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. […]
Power BI and Power Point
There is a lot of discussion about how well Microsoft Power BI and Microsoft Excel compliment each other, and they really do, but I also find that Microsoft Power BI and Microsoft Power Point are also better together. Power Point sometimes gets bad publicity but it is actually an amazing tool and in the right […]
Ensuring Column Names in Power Query Are Dynamic
Challenge: To create a dynamic report that measures time spent on specific projects daily by many team members. Each team member is required to enter their hours at the end of each day. Report needs to be future proofed, eg, for the report to be flexible if more projects are added, the query has to […]
DAX Challenge Puzzle
DAX Challenge which leads to so much more…. I understand the challenge and got the answer eventually, however I could not explain why, and it bothered me. Not being a natural programmer, I really have to understand the “why” so here is my explanation which hopefully is clear. Whilst thinking about it I came across this blog post (note the date […]
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 […]