₦airaland Forum

legalization of marijuana in the state you are looking to relocate to shouldn't be your only reason for wanting to relocate. Checking out the Per Capital Income and the average rent paid per month should also help in you decision making. You are not just moving to smoke weed or use it for medicine. You also want to work and earn so that you can afford to buy as many ounce of weed you can afford

Lets Check It Out;

a) The first pics shows the fully legal states and its per capital income. Ranging from the state with the highest per capital income to the state with the lowest. It also shows the average rent paid per month in those states. As you can see below District Of Columbia has the highest per capital income but is that the state you would love to move to. Take your time and choose the fully legal state and its income that is best for you.

b) The second and third pics shows the per capital income and average rent of states where marijuana is fully illegal or used for medical purpose. Lets say for instance you've always wanted to move to New York but the legality status is medical i.e. you can't smoke but only use only for medical purpose. The per capital income and rent can help you decide if you want to move to New York or find some where else.

Lets Check Out The States;

a) The first pics shows the six(6) state that have not legalized the used of marijuana. And not only is it illegal, it is also a criminal offense. The decriminalized field shows all state as false i.e. it is a criminal offense except for South Dakota.

b) The second pics shows all 16 states that have legalized the use of marijuana. These are the states you should bear in mind when you are ready to relocate. And as you can see all 16 states show true i.e. it is not a criminal offense.

c) The third pics shows states that have approved the use of marijuana for medical use only. That means you can use marijuana as a form of medicine only and not for recreational use. If caught smoking you can be penalized as you can see below all values in the decriminalized field shows false i.e. it is a criminal offense.

d) The fourth pics shows states that have legalized the use of marijuana for both medical and recreational use. You don't need to worry anymore one of this states should work for you.

My Findings:

a) The first pics shows the legality status In America. Marijuana is fully illegal, fully legal or medical in some of the states in America.

b) The second pics shows the number of states in America and its legality status. And as you can see below there are six(6) that have not legalized the use of marijuana either for recreational use or medical use.

So you are looking to relocate to the United States of America but feel discourage coz you heard the state you're moving into have not legalized the use of marijuana . Which also means it is a criminal offence to have in your possession marijuana or weed like some may call it.

Feeling sad and confused about the next step to take, you hire a data analyst (me of course ) to help you analyze a dataset you saw online. A dataset that shows all the states in America and its legality status, per capital income, median rent etc...… and you believe with the insights and findings the analyst shares with you, you are able to make a decision on which state in America to relocate to.

And just to be clear you only use marijuana for medical use and not for recreational use


Hello! my name is Jamer the analyst. I have been able to analyze the dataset and this are my findings...…..

BUT before I go into sharing my findings, I would love to start from the beginning and show you the step by step process into my findings.


Here We Go:

As you can see in the picture below, this dataset has two tables. The REGULATIONS table and the WEED_CLEAN table

a) The first picture shows the values in the REGULATIONS table
b) The second picture shows the values in the WEED_CLEAN table
c) The third shows a virtual table (state_weed_data) I created to join both the REGULATIONS and the WEED_CLEAN table together. The blue line represent the regulations table and the red line represent the weed_clean table.

As a data analyst having a TECHNICAL MINDSET is one of the most important analytical skill you can have. The ability to break things down into smaller pieces and use that pieces in a logical and orderly manner is something that will help you in your career as a data analyst.

sharing our findings, insights and conclusion from the data we got to non technical people like our boss or shareholders is really important.

A lot of data analyst do not like this part We just want to clean, transform and analyze our data without having to share our findings in front of everyone. You can't escape it

Personally what I do is go online, search for sample dataset, work on it and pretend to share my findings gotten from the data. It could be presenting my findings in front of friends, or the mirror or video like the one I will be sharing. This helps build my confidence and I am also able to work on my weaknesses (lots of weaknesses )

I have done quite a few number of videos but today I will be sharing with you my first ever video.

Here is my analysis on a student adaptability levels to online education.

Please watch and tell me what you think. Thank you.



https://www.youtube.com/watch?v=Cn2AQXtdJ-M

nisot14:
Boss pls, which video, site or book are you learning sql from

There's a channel called "Full course" on YouTube . They have a 20 hrs mysql beginner to expert video. Check it out.

Hello Guys! Please, are there more advanced MySQL functions out there, coz I feel like I know them all.... From "ranks" to "views" to "stored procedures" to more "advanced sub-queries". I am no expert, I just wanna learn something new and different on MySQL. Searching for advanced MySQL videos on YouTube still leads me to the ones I listed above or functions on other server like postgre, Microsoft server etc.. (which I don't use). I have done and posted few sample Data Analysis projects here on nairaland. Plz Kindly view my profile and see if there are more things I need to know and Improve on. Thank you.

More filtering and analysis was done. I can't share them all

Finally I am done with this dataset No more.

I look forward to sharing more of my sample projects.

Thank you for you time.

#dataanalyst
#dataanalysis
#datavisualization
#data

Peace

F) And finally this pics shows the number of students with "Mobile devices" that uses the Internet with "Mobile data" using a "4G" network.

FILTERING THE DATA

D) The fourth pics shows the complete data of only the male students. This shows you the total number of male student online that are from the University or college. It also shows the devices, network and Internet used by male students online........ etc..

E) Just like the fourth pics, this pics shows the complete data of the female students online.

FILTERING THE DATA

B) Clicking on a particular data changes the whole data on the dashboard which in turn gives you the insights or information that you need. The second pics shows the number of online students from a Private University.

C) The third pics shows the number of online students from a public College.

Yo fam!!! I'm back again with another form of visualization; this time Power BI. Few days ago I did some analysis on the "Students Levels online" dataset using my SQL and also created an interactive Excel Dashboard which I posted (if you haven't seen it, please check it out)

So today I will sharing my analysis with this data using Power BI. I love using Power BI for my visualization. It gives me more and better options than Excel. With Excel you need a slicer to analyse the data to get more insights but with Power BI, the data can be filtered without the slicers. Clicking on a particular value on the dashboard can get you what you want.

Without wasting much of your wonderful time. Here We Go........

A) The first pics shows the complete dashboard without any filtering. This is everything you need to know about this data. With the help of the data labels you can also read and understand what is happening on the dashboard.

More and More Filtering

e) The last two pics showed just one selected item from one slicer but with the pics below more selections from different slicers was done to give you more insights from the dashboard. This pics shows the number of students from "RURAL" location that said "YES" to doing their IT (industrial training)

F) And finally with more selections, this pics shows the the number of students that used the "MOBILE" device, with internet type "MOBILE DATE", which has a "4G" network type to get access to their online education.

And apart from just the total number of students or total number of male and female students, other analysis like the age distribution, the number of students from each education level, the number of students from each institution type can be gathered from the dashboard etc.....

The slicers helps you analyze the data how you want. And looking at the dashboard, a lot more analysis and insights can be gathered.

#Dataanalyst
#Dataanalysis
#Datavisualization

Peace.

MORE FILTERINGS
c) The third pics shows the "High" flexibility levels of the students

d) The fourth shows the Network types used by the students. The selected item for this analysis was the "4G" network. From the dashboard we are able to figure the number of male and female that used 4G, the institution and education level that used 4G etc...

Few days ago i shared with you some of the analysis i did on a dataset which i got from kaggle, using MySQL. A lot of analysis was done on that "student levels online" dataset; if you haven't seen it plz look at my last topic or thread.

For most technical users, MySQL is enough to get insights from a data but for some, not really. A graphical representation also known as DASHBOARD was needed to convey the insights gotten from the data to both technical and non-technical users, which in turn helps the users make more informed decisions.

Please Note: This is an INTERACTIVE DASHBOARD.

a) The first pics shows the full dashboard without any filtering. Not much can be gotten from this dashboard coz it mostly shows the Total of some of the values from the dataset. For more in-depth analysis we...…..

b) FILTER. Yes we filter. Filtering the data gives you the freedom to explore more options. You are able to analyze the data based on the particular insights that you need. For example the second pics shows the financial condition of rich students. And as you filter a particular item from the slicer, the data changes. The more you filter the more the data changes, giving you correct analysis of what you are looking for.

Note: The slicers were modified. The dark yellow shows unselected item with data and the purple shows unselected item with no data. The selected item was the "rich" value.

airsaylongcome:
Have you seen this?

careers dot hotjar dot com/o/sales-data-analyst-emea

€55,000 to €75,000 annually

No. I am gonna apply ASAP. Thanks Man.

airsaylongcome:
Nice stuff. I like how you regularly throw these kinds of analysis out here. I'm more shocked at the level.of detail that "they" can tell what kind of connection (4G) the devices are on. Meaning they can tell to very huh detail what device is been used, where in the world it is been used from. Bye bye privacy.

Personally, I prefer these kind of quantitative analysis to Dashboards o. I can see the raw figures and make my own "back of the napkin" calculations.

Are you aggressively hunting Data Analysts roles? I think you should be if you aren’t


Also do something to aggregate this into the various types of connections, without disaggregating it into Uni, School and College.

Dataset looks like UK dataset

Boss! thanks for the input. Like i said earlier a lot more analysis was done with and without aggregating them into uni, school and college or the institution type. The screenshot is a lot, 40 of them or so. I wish I could post them all. And yes I am aggressively hunting for data analyst roles both naija and abroad.

That is all I can share. More analysis was done on the location, flexibility level and financial condition of this students. I feel like I have posted enough. I am going to stop here. This is why a lot prefer dashboards to all this.

Note: This is a simple analysis, nothing advanced. The "group by clause", "order by clause", "count" and "concatenation" was used for most or all of the analysis.

Next is to design a simple DASHBOARD.

Peace.

5) LETS LOOK AT THE INTERNET AND NETWORK TYPE USED BY THIS STUDENTS

a) The first pics shows the internet type used by students from each education level. And from the data below we can see that the WIFI is the most internet typed used by university and college students. While school students use mobile data more than the WIFI. Also university students use more WIFI than any other education level and school student use more of mobile data.

b) The second shows the network type used by students from each educational level. 4G is the most used network type. Of course it is....

4) This analysis show the number of students that attended school, university and college from each institution (private and public). And from the result below we can see that there are more school and university students from private institution. While college has more students from the public institution than the private.

3) NOW LETS LOOK AT THE STUDENTS THAT WENT FOR THEIR IT (industrial training) AND THE ONES THAT DIDNT.

a) The first pics shows the the total number of student that said YES to doing their IT and the ones that said NO. Done with their education online, majority of students had refused to go for their IT. Would this have happened if the classes were offline?

b) The second show the students based on each education level that said YES or NO to doing their IT. This analysis show that unlike students from the school and college level, more university students choose to go for their IT. Do you know?

c) The third shows the students based on each institution that said YES or NO to doing their IT. And as you can see both institution has the highest number of Students saying NO to any IT. But more students from private institution said Yes to IT than the students from public institution.

2) NOW I WANT TO KNOW THE DEVICES USED BY THIS STUDENTS FOR THEIR ONLINE EDUCATION.

a) The first pics shows the devices and the total number of students that uses each devices for their online classes. And as you can see, the mobile is the most used device. Tech is advancing. students feel more comfortable using their mobile for classes than the computer or tab.

b) The second shows the devices used by students from each educational level. And as you look closely you would see that the mobile device is the most used device on all levels. Also the school happens to have the highest number of students using the mobile device.

c) The third show the devices used by students from each institution. And just like the second pics, the mobile device is the most used device from both institution. Also the private institution has more students using the mobile device than the public.

LET THE ANALYSIS BEGIN.....

1)
a) The first pics shows the total number of students from each educational level (university, school and college). The summary column is the concatenation of the first two columns to make it look more explainable and presentable to the anyone looking at the data.

b) The second pics shows the break down of both male and female students from each educational level. And this analysis shows you that there are more male students from the university and school and less at the college i.e. more female students than the male student

c) The third shows the number of students from each institution. And as you can see there are more students doing their online education at a private institution than the public institution.

d) The fourth is also a break down of both male and female students doing online education at the private or public institution. And from the analysis there are more male students at both the private and public institution. The boys are really taking the online education more better than the female.

This is a "student adaptability levels" dataset which has been on my system for a while. Feeling enthusiastic and hungry for data to analyze I decided to work on this dataset.

I got this dataset from kaggle, loaded it on excel for data cleansing but was quite disappointed coz there was nothing to clean. So I imported this already clean dataset to MySQL for more analysis.

This is what the dataset looks like...…

Keskyramirez:
How do I learn data visualization and what basic skill is required to learn it

YouTube, medium and Ebooks Bro. Lots of good stuff there. That is where I learnt mine before advancing to online courses (mostly for the certifications). Just type Data visualization and the lessons that you need shall be added unto you.

Sageez:
Any idea where I can volunteer?

No man. You should try freelancing on upwork. The more offers you get, the more skills you learn, which should get you ready for a job.

Sageez:
Aside Excel, which other software are you good at?

For me, Excel, sql, python and R, but I still feel I am not ready yet. I want to get myself grounded then intern or volunteer for any firm before applying for jobs

Excel and sql is where my strengths are. Python and Power BI; i'm goood but not like the former.

You should volunteer. No one is ever ready. You just have start and keep learning on the job.

NotBeenPaid:

---

Well done.

---

Thank you.

Sageez:
I have finally gone through all your chart but sorry, I am not impressed.
I am not saying this to hurt you but to make you work more and harder.
Please study graphs and chart and understand the reason to use them.

Let's take bitcoin for instance, the trend changes almost every minute, the best chart to display this will be line chart.
But let's say we want to know the performance of boys against girls in a particular subject, the best for this should be a histogram or bar chart.

I like your courage. We won't stop learning till we blow.
Sorry if you fined my first sentence offending.

Lol. Not at all. We are all here to learn. Thanks for your input.

Sageez:
Sir,

For the first dashboard, a histogram or bar chart would have been better.
Line charts are used for showing trend, but for categorical variables, histogram is usually the best.

Please correct me if I am wrong cuz I am also here to learn

Yes, you are absolutely correct. There are rules to data visualisation. Every chart has its purpose and must be used the right way. But on this dashboard, the emphasis was on the data label below the chart and not the chart itself. When creating this dashboard I'd imagine the stakeholder or client asking for a more labeled dashboard and Based on personal experience I have worked with clients who are only interested in labels not the chart itself. And that is why I opted to using Scatterplot on all boards and focus more on giving a well detailed label.

This is where I press the stop button There were more results I got from analyzing this dashboard but I can't share them all. I think the ones above are enough

Thank you for your time. Peace.

#dataanalytics
#dataanalyst
#datavisualization