Few days ago I shared my analysis on the legalization and illegalization of marijuana in some of the states in America using MySQL. If you haven't seen it please check out my previous thread or topic. A lot of insights was gotten from the analysis and I was able to answer my client questions on the legalization and illegalization of marijuana in some of the states in America. And with my findings he was able to pick and relocate successfully to one of the legalized states

But sharing my MySQL analysis with another client who was looking to relocate but also had issues with the illegalization of marijuana in America, there was a slight problem.

Being the non-technical clients that she was, she couldn't quite grab my MySQL analysis, so I decided on creating a simple, straight forward dashboard using Power BI.

So I will be analyzing the weed dataset using PowerBI like I did with MySQL

SO HERE WE GO...…

The picture below shows the full dashboard with no filters. And as you can see from the map, the colored bubbles shows the:
*fully legal (dark blue bubble),
*fully illegal (red bubble)
*medical (dark yellow bubble)… states in America.

You can also look at the KPI above for better display.

Also three (3) filters were created to help you get any particular answer or insights you want from the dashboard.

Now let's filter and get some insights from this dashboard.

I) The first pics shows the number of states in America that have not legalized the use of marijuana either for medical use or recreational use. And as you can see on the map the red bubble shows states on the map. So these are the states my client who has confidential told the she uses marijuana for medical use only should avoid. And I forgot to mention that opposite the map is a table that shows the per capital income, median rent and median age of the illegalize state.

2) The second pics shows the number of states in America that have fully legalized the use of marijuana. So these are the states my clients bear in my mind when choosing a state to relocate to. And opposite the map is the table that shows the per capital income, median rent and age of the legalized states.

3) The third pics shows the number of states in America that have approved the use of marijuana for medical use only. These means you can't use marijuana for recreational use. It's not allowed. And like the first two pics the table opposite shows the per capital income, median rent and age of the states that approved the use of weed for medical use only.

More Filtering

1) The first pics shows the number of states which decriminalized status shows FALSE i.e.. states that have sanctioned the possession of weed as a criminal offence. And as you can see from the dashboard there 14 medical states and 5 fully illegal states that have criminalize the possession of marijuana. Marijuana is not allowed either for recreation or medical use.

2) The second pics shows the number of states which decriminalized status shows TRUE i.e... states that have not sanctioned the possession of marijuana as a criminal offence. It is not an offence. You can use weed for both recreational and medical use.
And surprisingly, looking at the map you can see a red bubble. That means in south Dakota marijuana is illegal but not an offence don't look at me that's what the data says LOL.

This is much, much better and quite interesting.

Still The Filtering Level

1) Looking at the decriminalized and Medical filters, the first picture shows the decriminalized status as FALSE and Medical status as TRUE. What this means is that the states seen on the dashboard has approved the use of marijuana for medical use purposes only i.e... it is medicinal. But not for recreational use. It is a criminal offence, If caught, you will be penalized.

2) Also looking at the decriminalized and Medical filters, the second picture shows the decriminalized status as TRUE and Medical status as FALSE i.e.... it is not an offence to have marijuana and it is also not medicinal. In other words you can use marijuana for recreational use. No Doctor is gonna prescribe marijuana as form of medicine. Not in this states. Enjoy your marijuana No one is gonna arrest you.

Ladies and Gentlemen that is all I have for you and my client today.

More and more insights can be gotten from this dashboard. I can't share everything you not because I don't want to but I think the ones I have shared are the most important aspects that you can get from this dashboard, the ones that will really help my client in making a better decision on the state she wants to relocate to.

And like always I look forward to sharing more sample project with you all.

Thank you for your time

Peace.

BRATISLAVA:
This is much, much better and quite interesting.

Thank you.

Seems you're also high from the marijuana from posting same pics over n over again

GREATIGBOMAN:
Seems you're also high from the marijuana from posting same pics over n over again

look closely. They're all different. I can't give full analysis with just one picture nah.