Getting the Power BI sertification….

A few weeks ago, I decided to get certified in Power BI. The closest certification I could find is the MSCA BI Reporting sertification from Microsoft. So I will be writing a short series covering the journey. It will be a bit longer than what I first foresaw. The MCSA sertification is awarded after passing... Continue Reading →

Make over Monday week 6

Make over Monday week 6 This weeks data set is a set of metrics comparing the Chinese New Year and the American Thanksgiving celebrations. Looking at data per inhabitant changes the picture quite a lot. Especially Retail and Restaurant spending during the holiday. For this weeks challenge I kept it simple and I did the... Continue Reading →

How to simplify your forecasting

I do forecast modeling and scenario planning in Excel and it is quite simple: Be clear on your assumptions — typically top left in the worksheet Document your formulas by including a comment on input (column M below) Follow these two points and you can easily update your model, or do a handover to your... Continue Reading →

Why I love Excel

I took all the MS Office courses I could get my hands during my first job. Getting up to speed with advanced Excel training from the start has been quite beneficial. I could hardly believe how useful it was — once I managed to convert the knitting-pattern of a baby sized sweater, with a complicated... Continue Reading →

Blog at WordPress.com.

Up ↑