Euro 2024 Quarter Final Results
The quarter finals have finshed But how did our predictions compare to results? Background We have been predicting the results for the EURO 2024 football tournament, with a target of getting 70% correct So far in the group stages we predicted 10 of the 16 teams to qualify for the knock out stages (62%) In […]
Euro 2024 Last 16 Results
We now know who will be in the quarter finals. But how did our predictions compare to results in the round of 16 Background We have been predicting the results for the EURO 2024 football tournament, with a target of getting 70% correct So far in the group stages we predicted 10 of the 16 […]
Euro 2024 Match Predictions Results
The group stages are now completed, the results are in…. How did we do? Background Once again we set to work predicting the outcomes for the EURO 2024 group stages With a target of getting around 70% of the correct resuts This time around We now have a stronger basis for each indicator after running […]
Euro 2024 Match Predictions
The Euro 2024 football tournament starts tomorrow in Germany with the hosts playing against Scotland and I cant wait. For the last few football tournaments I have run a match prediction league for friends, colleagues and other associates I wasnt going to do it this time….It is a lot of work, but its so much […]
Forward Stock Cover
What is Forward Stock Cover? Forward stock cover is a technique used by retailers to determine how long the current stock will last considering forecasted sales quantities It is used to control the levels of stock to help ensure that the stock is held at a appropriate level with the risk of being short of […]
Comparing Year on Year in Power BI
In an earlier post we showed you how to use SAMEPERIODLASTYEAR in power BI to compare data to the prior year The major shortfall of this is that the built in function matches the day of month and month, and does not properly reflect the day of the week If we show these with the […]
How to Sync Slicers in Power BI
This post explains how to sync slicers in Power BI, without any complex code Slicers are an excellent way to give your users the ability to explore data, allowing users to use the slicers to filter the data down to particular information of interest. But, if your data has different data sets with common values […]
Using Google Search Console Data in Power BI
Google Search Console is a very powerful tool to measure SEO performance. This post highlights how with a little effort you can use Google Search Console Data in Power BI to create much more compelling dashboards It tracks a vast amount of really insightful data, but the reporting is limited The example below is the […]
Split a column in BigQuery
This quick guide shows you how to split a column in BigQuery When working with text data, quite often you need to split a column or trim excess characters to clean the data This quick guide shows you how to do it. Using URL data from Google Analytics GA4 to create separate columns for the […]
Import XML into Excel
Importing XML data into Excel allows you to have a readily available data source that can be refreshed on Demand Once that data loaded into Excel you can use Excels features to explore, filter, sort or augment that data from other sources What is an XML file? An XML file is a plain text file […]
