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 […]
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 […]
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 […]
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 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 […]
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 […]
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 […]
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. […]
Follow the below article to create your own LinkedIn Analytics report as below. 1. Extract LinkedIn data Click the Me icon at the top of your LinkedIn homepage. Select Settings & Privacy from the dropdown. Click the Privacy tab at the top of the page. Under the How LinkedIn uses your data section, click Change next to Download your data. Note: You may be prompted to sign […]
Local Government Total Revenue by Financial Year See how Power BI can make animated bar charts using data from the Victorian Auditors General Office. https://youtu.be/oYlZEd0x2sE Things look quite different when you divide the revenue by population. Take a look below. https://www.youtube.com/watch?v=KpZlURGEG2o Interact with the published dashboard yourself below. The visualisation I am using is referred […]