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.
So, what do you do if you are bad with colors like me? The answer is simple, deploy technology to solve the problem. You don’t need to have sleepless nights worrying which combination of colors is suitable enough for your dashboard
There are some people, you see that color combination, na there talent. If I come across one of their dashboards and I love the color combination, I either save it as an image somewhere or take a screenshot.
Then what next? Take the image to either of those websites and get the color codes from there.
Simple and straight-forward. People post dashboards almost every day, I let them worry about color combinations for me. There is no award for best in color combination.
Let’s take a quick tour on how I go about it. For now, we will be using google search
Step 1 - Search for a nice report online
Step 2 - Upload saved image and extract color codes
You can also create your own color combination
Note that while using coolors.co to create your own matching colors, you don't need to lock in two colors. You can just lock in 1 and it will suggest four other colors that matches the one you locked in
You can also decide to use color picker
Did you the most interesting part, you don't need to go through this step of selecting colors every time, you can just create a reusable theme that you can always import.
This is how.
First export the pallete
Select Code and download
Open the download file and it will look like this
What we need are these set of numbers.
Here is the theme template file you will edit and load into PowerBI.
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.
That is basically you creating scenarios in your head.
A similar thing can be done with data. What if we put some discount on a product and demand increases by a certain percentage, what is going to be the effect on the profit etc. This kind of analysis
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.
So, what is anomaly detection?
Anomaly detection is simply identifying behavior or patterns that is different from the norm. In terms of data, it is simply identifying the datapoints that are different from the normal behavior of all other datapoints.
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.
So, what is the row context?
You skipped filter context.
Let’s go into excel to better understand this also