BI Reporting: Excel Stuff

Following on from my post yesterday, I wanted to give a small update. I’m now halfway through the Excel certification that contributions to the BI Reporting badge and I am learning some useful new features. As I mentioned before, I’ve been using PowerPivot for around 4 months, and while I’m aware there is still much to Read More

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

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