PinnedSimon Harrison - Analytics, Power BI, SQLHow I built a high performing analytics teamIn 2008, I had recently left Wm Morrisons Supermarkets where I was responsible for the finance department and Operational IT for a £400m…Nov 22, 2021Nov 22, 2021
Simon Harrison - Analytics, Power BI, SQLUnderstanding Implicit and Explicit Measures in Power BI — Select Distinct(Part 1 of a 2 part post about modelling in Power BI)2d ago2d ago
Simon Harrison - Analytics, Power BI, SQLUnderstanding Power BI Gateways — Select DistinctUnderstanding Gateways in Power BI: A Comprehensive GuideJul 5Jul 5
Simon Harrison - Analytics, Power BI, SQLEuro 2024 Match Predictions Results — Select DistinctThe group stages are now completed, the results are in….Jun 27Jun 27
Simon Harrison - Analytics, Power BI, SQLEuro 2024 Match Predictions — Select DistinctThe Euro 2024 football tournament starts today in Germany with the hosts playing against Scotland and I cant wait.Jun 13Jun 13
Simon Harrison - Analytics, Power BI, SQLUnlocking the Power of DAX LOOKUPVALUE in Power BI — Select DistinctDAX LOOKUPVALUE function is the subject of this blog. It is particularly useful for retrieving values from tables based on specific…May 21May 21
Simon Harrison - Analytics, Power BI, SQLDouble and Triple-Click in SQL ServerDouble and Triple-Click in SQL Server are two very useful shortcuts to save you time and reduce errorsMay 16May 16
Simon Harrison - Analytics, Power BI, SQLMastering Excel LAMBDA Functions — Select DistinctCreating powerful, custom functions in Excel got easier with Excel LAMBDA functions. These functions offer a dynamic way to create…May 10May 10
Simon Harrison - Analytics, Power BI, SQLHarnessing the Power of Streaming Data — Select DistinctStreaming data has emerged as a critical component of modern data strategies. Streaming data refers to data that is continuously generated…Apr 16Apr 16
Simon Harrison - Analytics, Power BI, SQLinMicrosoft Power BIComparing Year on Year in Power BIIn an earlier post we showed you how to use SAMEPERIODLASTYEAR in power BI to compare data to the prior yearApr 16Apr 16