Was on a call with @BifolaX yesterday and the issue of colors came up. Felt like I needed to share this. Some of us are bad with colors, that’s who we are. I am one. The best we could do is find a way around this with technology.
For me I believe if there is a problem that technology can’t solve now, it’s just a matter of time before something is created/invented.
Jun 9, 2022 • 29 tweets • 7 min read
It’s been a while guys. Hopefully we are back for good. Still on showing you how to do other forms of analysis rather than just telling analysis goes beyond so so and so made the highest sales while so so and so made least etc.
Today we will be focusing on scenario analysis. It’s nothing complicated, trust me.
We’ve all had this had I know moment. If you had known, you would have done something differently. What if I had done this thing this way or that way, maybe the result would have been different.
May 14, 2022 • 17 tweets • 4 min read
So, I’ve always said if you call PowerBI just a visualization tool, you don’t fully it’s capabilities. Also, for entry level analyst, analysis goes beyond exploratory analysis. You can take your analysis one level higher with anomaly detection and asking the question of why
it is happening. Good news, you don’t even need to learn any new thing.
May 11, 2022 • 4 tweets • 1 min read
Over the next couple of weeks/months/years😂😂 we would be simplifying DAX to it's most simplistic understandable form
Day 1
Demystifying DAX
Day 2 – Iterative Functions
For this thread we will be looking at Iterative functions and the FILTER functions.
DAX are evaluated by one of the following ways
1.Row context – calculated columns
2.Filter context – measures
What Iterative functions does is allow you to create a measure while employing the row context because by default your DAX measure use the Filter context.
