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 […]
Thoughts on Passing DA-100 and Why I Sat It the Second Time
I am thrilled to have just passed the DA-100 but thought I would share why I sat it, the resources I used and importantly what it means to me. A little background about me, I work with Power BI every day and already had passed the MCSA BI Reporting certification, I’m a Microsoft Certified Trainer […]
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 […]
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 […]
What is Data Analytics and why should I use it?
Data Analytics gives you the Business Intelligence that allows you to: Profit Maximisation Cost Reduction Customer Retention New Customer Development Focused and targeted marketing Customer Behaviour Evaluation of Product / Service Behaviour Informed decisions Data analytics is a process of inspecting, cleansing, transforming and modelling data to discover useful information, suggesting conclusions, and […]