Simon Harrison ACMA CGMA

Our latest blog post on the DAX CALCULATE function Learn Best Practices and Alternatives Purpose, Usage, Benefits and Syntax selectdistinct.co.uk/2024/09/23/dax… #DataAnalysis #PowerBI #DAX #BusinessIntelligence #DataScience

Implicit and Explicit Measures in Power BI What are the key differences between implicit and explicit measures in Power BI? We will also explain the “Discourage Implicit Measures” feature and its significance selectdistinct.co.uk/2024/09/12/imp… #PowerBI #DAX #PowerBIMeasures

@JoeFisherSEO 😀😀

This SEO guy keeps staring at me everyday through the window. Creepy crawler

What is Microsoft Fabric? Launched in 2023, Microsoft Fabric integrates data engineering, data science, data warehousing, real-time analytics, and BI into a single platform Learn more selectdistinct.co.uk/2024/01/11/the… #MicrosoftFabric #DataScience #BusinessIntelligence #DataEngineering

The Data Warehouse What is it? Why you need it? How to choose one About the different technologies, and how we can help you selectdistinct.co.uk/business-intel… #datawarehouse #analytics #businessintelligence

Euro 2024 Predictions - Quarter Final Results We got 3 out 4 correct in the quarter finals See our Semi Final predictions and who we think will be in the final selectdistinct.co.uk/2024/07/08/eur… #EURO2024 #Germany2024 #England Credit to Tournament Predictor tournamentpredictor.com/euro-2024

Learn about Power BI Gateways by reading our latest blog post #PowerBI #MicrosoftBI #datagateway

@tallbaldybloke You were right with Spain, personally I wanted to see Germany reach the final, but not to be France made it, Switzerland made it a tough game for England, but those penalties were very good I havent yet seen the Turkey game, too busy celebrating the relief of scraping through

@SimonharrisonD I got all 8! Probably because i didn't place a bet. I strongly disagree with you on the last 4. I go Spain, France, Switzerland, Turkey.

We predicted the 8 teams to make it past the last 16 of Euro 2024 We got 7 of them correct What do we think will happen in the quarter finals? selectdistinct.co.uk/2024/07/04/eur… #EURO2024 #Germany2024 #England #EURO2024predictions

@tallbaldybloke It will be tough for #Spain to get to the final, first they have to get past #Germany

@SimonharrisonD Spain to beat Switzerland in the final!

Euro 2024 moves on to the last 16 stage Here are our predictions for this rounds winners Germany, Spain, France, Portugal, Switzerland, England, Netherlands and Austria Have a go yourself on this site tournamentpredictor.com/euro-2024 #EURO2024 #Germany #England

Euro 2024 Predictions - Group Stage Results How did we get on? We predicted 10 of the 16 teams to prgress to the last 16, just one less than we targeted A fantastic win last night by #Georgia selectdistinct.co.uk/2024/06/27/eur… #EURO2024 #Germany2024 #England #EURO2024predictions

Euro 2024 kicks off tonight With Germany v Scotland I found a great little site to play around with match predictions Euro 2024 Predictions Based on Team Rankings (tournamentpredictor.com) It doesnt look so good for Scotland though #EURO2024 #Germany #Scotland

Here are our Euro 2024 predictions for the group stages Will England make it through the group stages?, Will Germany use the home advantage to full effect? Follow our progress, see how many we get right selectdistinct.co.uk/2024/06/13/eur… #EURO2024 #Germany2024 #England

Calculating Forward Stock Cover How to use Google BigQuery to do it, and why retailers need to get this right to maximise profits and minimize risk selectdistinct.co.uk/2024/06/06/for… #SQL #BigQuery #Retail #InventoryControl #SQLWindowFunctions #SQLPartition

How to choose the best data import method for your Power BI reports Whether you're dealing with large datasets, need real-time updates, or require advanced data modelling. selectdistinct.co.uk/2024/05/29/opt… #PowerBI #DataAnalytics #BusinessIntelligence

Year on Year comparison by weekday in power BI A Step by Step guide to avoid potential errors when using SAMEPERIODLASTYEAR and a simple solution to ensure you compare matching weekdays selectdistinct.co.uk/2024/04/16/yea… #PowerBI #SAMEPERIODLASTYEAR #DataViz

Sync Your Slicers in Power BI A Step by Step guide, to keeping seperate slicers in sync across different data sets using slicer groups selectdistinct.co.uk/2024/03/12/syn… #PowerBI #Slicers #DataViz

Make you Google Search Console Data more useful with Power BI Here is a simple step by step guide to taking the daily GSC data, and presenting a lot better selectdistinct.co.uk/2024/03/01/usi… #SEO #DataAnalytics #PowerBI #GSC

How to split a column of text in BigQuery If like us you analyse your website traffic in Google BigQuery, you might find it useful to split the URL data into a clean URL and a URL parameter field selectdistinct.co.uk/2024/02/20/spl… #bigquery #STRPOS #splittext #GA4 #GoogleAnalytics