Power BI & COVID19

Posted on

I created this Power BI report for a client interested in COVID19 data. Unfortunately, the work fell through but I don’t want it to go to waste. If you would like the file just download it below. Dont forget to check out all the other Power BI freebies on the site! Download the file here, […]

DAX COALESCE

Posted on

DAX, the COALESCE function Don’t you hate it when a card looks like this? Meet COALESCE This function was introduced in March 2020 and instantly became a favourite of mine.  Although I think a more appropriate name would be ifblank! Wrap it around your DAX statement and the Default Measure will be presented instead of […]

DAX YTD & LYTD

Posted on

DAX for Financial Years I use these two measures quite a bit. YTD Total Sales is straight forward and calculates in this case a sum of sales from the 1st of July to today. The trick is what to do when you want to compare the same period for the previous year. That is where […]

5 Tips to a Successful Side Hustle

Posted on

I have now been running my side hustle for 1 year now and I don’t think I have ever learnt so much. There are so many varied skills required but here is my top 5 that I believe will set you on the right path for a successful side hustle. 1. Personal Brand My number […]

Embedded Power BI Toolbar

Posted on

Ever need more space of your embedded Power BI report? Then this trick is a great way to reduce the size of your toolbar. Follow along below and grab the pbix at the end to have a go yourself. Here is the Embedded Power BI report. Engage with the nifty toolbar to open and close […]

Canva + Power BI

Posted on

Background Concepts for Power BI Recently I read an article on background concepts for Power BI by Chris Hamill. It touched on the importance of a report background and its role within data storytelling. It then gave a tutorial on how to create a PowerPoint background for Power BI. It really is a great article […]

Liveability versus Density

Posted on

Liveability according to the Cambridge dictionary refers to “the degree to which a place is suitable or good for living in.” This seems straight forward but dig a little deeper and you will realise that this buzz word is harder to define than you think. What actually makes a city liveable seems to be under […]

Top 50 Websites – Bubble Chart

Posted on

This Power BI Freebie is an interesting look on the top 50 websites. It is using “Bubble chart by Akvelon” which allows you to place an image in a bubble chart. I am also using the same image url in the table. I had a bit of fun creating this one so I hope you […]

Victorian CrimeStats Analytics in Power BI – Part 2

Posted on

This is following on from my first blog on Victorian Crime Stats here: https://datatale.com.au/victorian-crimestats-analytics-in-power-bi/ This report is designed as an investigative tool. To help the business user to understand anomalies and trends by local government area. Check out the video below where I am looking at Latrobe and trying to understand the upward trend. But […]

Victorian CrimeStats Analytics in Power BI

Posted on

Next up in the Power BI Freebies series is Crime Stats by Local Government Area in Victoria.  Data from Crime Statistics Agency, 2019 The map is a high level overview of Crimes by Local Government Area. As you can see no matter how you look at it overall Crime is on the up compared to 2010. […]