A little while ago I wrote about the benefits of fuzzy matching and the add-on for Excel that Microsoft provides. Well since then Microsoft have been super helpful and put the fuzzy matching function from Power BI into Excel’s Power Query too! Happy fuzzing!
Excel
Fancy New Updates And Fancy New Skills
Last week there was an update rolled out to my copy of Microsoft Office. Usually this wouldn’t merit much discussion, but this update included improvements to a tool I’ve been using extensively for the past few months; Power Query. What improvement was that? It was the super useful Intellisense feature, as well as syntax highlighting. Basically, Read More
Failing At A Paid Course And Enjoying It
Today I took the plunge on the Business Statistics Specialization I’ve been enjoying for the past few weeks. I fully enrolled with the 7 day free trial then £37 a month until I complete the course. Why? Because I finally started working on the final capstone course and saw that there are peer-reviewed assessments. Having got Read More
Welcome To IainSaunders.uk!
After much consideration, and discussing several different options with my lovely wife, I have finally decided to go ahead with my own website; IainSaunders.uk. Welcome! Although it might seem like a really easy name for me to use, I spent a couple of weeks trying to figure out what exactly to name it. My main obstacle Read More
Master Excel Reporting With PowerPivot And CUBE Formulas
Here’s a post for the Excel nerds out there, because this was so helpful to me over the past couple of days that it is worth talking about. For non-Excel nerds, if you work in analysis or reporting, give this post a quick glance at least, you might pick up something useful!
Linear Regression for Business: Review
So it’s been about a week since I started studying the Coursera course Linear Regression for Business Statistics in the Business Statistics and Analysis Specialization. One of my early thoughts was how thankful I am that in this course you can submit your answers on the practice quizzes even when auditing the course. This instant feedback Read More
Your Career Is Made Up Of Life And Business Skills
One of my hopes for this blog, and generally the content I share here, is that it may help others who find themselves somewhere on the same path as I am. That may be where they’ve learned enough Excel to be able to list it as one of their skills, and they want to know where Read More
Learning And Following Business Standards
Today I started realising how beneficial it is to follow a set of standards in your work, especially when there have been some company standards set (even if your manager doesn’t insist on you following them).
How Complicated Is Linear Regression Really?
For the last few months, I’ve been looking at linear regression and trying to understand what it is and why it appears so much in business analytics courses. It has something to do with mathematics and statistics, but the only word that I really understood in it was linear. I’m still not sure I understand it Read More
The Paradox Of Automation
Followers of this blog will probably recall how big a fan I am of automating work. VBA is most often my tool of choice, and I would use it to fetch various files, dump them into templates, copy the converted outputs and post them into a central file to then automatically output reports from that can Read More