Groovy Joe, where are you???

2am EST... Save me Lord!

I managed to complete my customer retention project in Power BI today. I learned some new DAX today. I'm not a Power BI guru yet, so this was good for me. I want to try and write off hand what I learnt, here goes:

Measure = DIVIDE(CALCULATE(COUNT('Variable', 'Variable'=1), CALCULATE(COUNT('Variable'))))

I am going to check to see if I'm right...

I didn't get the order of my parenthesis and I forgot to add the alternative value 0 at the end... Oh well... Baby steps I guess.

Measure = DIVIDE(CALCULATE(COUNT('Variable'), 'Variable'=1), CALCULATE(COUNT('Variable')),0)

This work is surely not for the faint-hearted and you can't try and rush things, else you will miss key points that are extremely relevant to the decision making. I'm just super relieved that this project is done and out of the way now. I can finally focus on some other things. Alex the Analyst is waiting for me on YouTube, and of course the ton of jobs out there waiting for me to apply.

And guess who helped me with a DAX expression today? Yup, ChatGPT! Amazeballs!!!

I got this one from it:

ChurnYesNumTicksNotZero = 
IF(Sales[Churn] = "Yes" && Sales[NumTicks] <> 0, 1, 0)

This tool is the real deal. And for anyone to stay ahead in this industry, you better add learning to use this as part of your curriculum. Definitely for the win.

Enough about data!

I missed church today - yesterday now - and I feel bad first, then good. Bad because I know I shouldn't miss church. I teach children in the Sunday School, and I wonder if someone else was able to manage without me. I feel good because I was able to sleep in longer, and I also had some time to work on my project. I made pancakes today also, from oats flour, with some cinnamon and nutmeg. Loved it!

Obviously 50% of my day is taken up by data, data, and more data! With my sleep time being part of the remaining 50%. I'm so boring and bored. Jeez! I need to get out more and live.

Dear diary, how about we find a way to hunt down and get back my groove? A ton of ideas already filling my head now. I'll tell you when it's done... wink wink… XOXO