₦airaland Forum

dauddy97:
Great job.
Use sns.set_style('darkgrid'); I love that dark shade

lots of color palettes in seaborn. I will check this out. Gracias.

Raalsalghul:
Jamerflepz try using one colour for your bar chart.

You can do this by editing the color parameter in your method.

Using different colours for your bar charts is kind if loud.

Thanks man. Noted.

thanksjosh005:
I think I like what I see. Good job jamer... You tried. I do mostly love the first and second one, especially the second one. All the best

Thank you.

Suspect33:
Boss, how long did it take you to become this good in data analysis, and in your opinion, which of the softwares do you think is the most difficult to learn?

Two years. I'm no expert. I'm still learning everyday. For me python was kinda hard to learn.

More.......

When I'm not working on a real dataset for clients, i do go online and look for sample datasets i can work on. That way I don't forget things. Learning four or more different tools for analysis ain't easy. After weeks of working on SQL, Excel and Power BI, I decided to brush up my python a little.

This is a "used car dataset" I found on kaggle. Instead of Excel or Power Bi for my visualization, I chose Python today.

I did some cleaning and analysing with Excel Power Query before loading them on python.

And ladies and gentlemen, this is what I was able to accomplish.

Not advanced. It's quite explanatory. No need to explain anything.

temiyato:
Ur visual is okay but needs little advice to make it better. Before i give u my little advice , am currently taking "google data analyst" on coursera , "fundamentals of data visualisation with tableau on coursera and other courses too.
1) top N shuldnt be visualized in RED . it is generally accepted that red should be used for LEAST N , loss etc
2) a pie chart should have better visualised " local address with top sales" since its in percentage or a simple bar chart would also be good compared to the area chart u used.
God bless us all sir

Noted.

Desammyst:
Which version of MS Excel did you use in creating this visualization?

Excel 2019

airsaylongcome:
So I have a second GUI frontend that connects without issue to the remote Mariadb. But not Mysql. Yeah let's wait to see if the OP has any ideas. Thanks for the troubleshooting though

I can't really say. Never really had issues like this. Maybe it could be the user/password error. Have you tried resetting your Mysql/Mariadb root password. Coz that is what a friend did when he had issues connecting to postgre server from mysql. And it worked.

3) More Filters

2) I also designed the Filters using Macro and VBA(visual basic for applications). And if you look closely the data is different from the one above.

In my last thread I posted a simple project I did with MySQL and today I will sharing with you the dashboard I created with the same dataset.

Data visualization is an important aspect in data analysis. The goal of data visualization is to make it easier for us to understand trends and patterns in large datasets.

I use Power BI for most of my visualizations. But today I decided on Microsoft Excel instead.

1) After more cleaning and analysing of the dataset, I created this simple dashboard.

airsaylongcome:
Let me go and dust up my SQL skills. Reading this was very nostalgic. With v8 I'm assuming you don't touch Maria. Postgres?

Nah I don't. I do work on postgreSQL sometimes but not as much as MySQL.

airsaylongcome:
5.7 or v8?

v8

gbengaoyeladun:
Well done

Thank you.

adebayal:
Guys Euphoria season 2 episode 5 is da BOMB ....cried thru it

I agree. I had to rewatch that scene with rue, her mom and sister over and over again. Fucking emotional. That girl can act.

jamerflepz:
2) I decided to clean and analyse the data by:
a) adding row numbers to the data
b) using the CASE function to create a new product_ranking column
c) using the WHERE clause to remove product_name that has ? on it.
d) highlighting from 9 - 17 and running it, gives you the result below.
e) this is my new dataset

This new dataset is exported to Excel or Power BI or tableau or python for data visualization. Creating a dashboard is important. Very important.

7) Finally Just like the STORED PROCEDURE above, I created another to store products with price greater than the total average price.
a) writing query from 75 - 84
b) calling the stored procedure by highlighting 86 only and executing it, which then gives you the result below.

6) Instead of sending multiple sql statements, I created a procedure to store the products with price lesser than the total average price
a) writing query from 61 - 70
b) calling the stored procedure by highlighting 72 only and executing it, which then gives you the result below.

5) Just like the VIEW above, another VIEW was created to show 'private' values only from the professional_publication column
a) writing query from 44 - 55
b) highlighting 57 only and executing it, gives you the result below.

4) Instead of executing the same query multiple times, I created a VIEW showing only values with pro from the professional_publication column.
a) writing the query from 28 - 39
b) highlighting 41 only and executing it, gives you the result below.

3) Writing a query to find the top 3 products and their prices.
a) highlighting 21 - 25 and running it gives you the result below.

2) I decided to clean and analyse the data by:
a) adding row numbers to the data
b) using the CASE function to create a new product_ranking column
c) using the WHERE clause to remove product_name that has ? on it.
d) highlighting from 9 - 17 and running it, gives you the result below.
e) this is my new dataset

As a data analyst, SQL happens to be my favourite programming language or query language like I love to call it. It's quite easy to learn but gets complicated when you get deep into it.

I will be sharing with you a simple project I worked on this week. Nothing fancy. Just messing around with this dataset.

1) This is a productsData dataset and as you can see from the picture below:
a) i created a database
b) imported the dataset for Excel to mySQL
c) highlighting number 7 alone and running it will give the result below
d) this is the raw dataset

Cool. For data visualizations, personally I kinda prefer Power BI to tableau.

Only an introverted, minimalistic criminal would love something like this. Small, simple, less stuff and just being indoors reading (if books are allowed).

One of the things that scares us the most as a musician or an instrumentalist is our FUTURE. We ask ourselves questions like: What would the future be like for an instrumentalist? Am I still going to jam the drums in my 40’s and 50’s? Music is the only thing I know, if I am not playing what else can I do to earn a living as an instrumentalist?

If you have not thought about questions like this, I have. And honestly it can be a vibe or even a dream killer.
But like football, every industry has its branches. For example, if the dream was to become a professional footballer and you are not, due to injury and other life troubles, you can also be a football coach, writer, manager, anchor, referee or even a talent scout. All of this profession still revolves around football. You are still going to do the thing that you love but in a different way.

Same goes for instrumentalist. There are other branches in this music or instrumentalist industry. You just got to settle and think about it.

And so, I am going to let you in on some of the branches I have thought about so far. So, if you are not playing the instrument, you can:

• Start a blog and share you experience as a drummer. Blogging is still a good business. But a lot of patience is needed here.

• Start an audio or video podcast on YouTube or Facebook. Invite instrumentalist to your show. Talk and laugh. Just like the Oprah show. I haven’t seen any do this here in Nigeria. Its good business if you have the resources.

• Open a music store. Sell musical instruments and merchandise. This is common. But you can also do it too.

• Open a studio. This too is common. But you can also do it.

• Teach. Online, offline or both. Get students and teach them how to play the instrument.

• Write a book. If you are a well-known instrumentalist, then you should have a book or an e-book out. Your fans would love to read about you.

• Talent scout or manager. There are lots of talented instrumentalists out there with no connection or opportunity. Find these guys and get them Gigs and bands and also get your cut. Or even manage them.

• Create an app. An app that connects music managers, musicians and churches with talented instrumentalist. With this app, you can get any one based on location and skill. If you are in lekki or surulere, this app connects you with instrumentalist in lekki or surulere. You don’t need to look too far.

• Go into music production.

• And if you are still not satisfied with any of this, then it’s not too late to go into tech. That is where the future is. Keep playing your instrument but learn small tech. Still not satisfied? Look closely at the picture below.

Things are changing. The world is evolving. Artificial intelligence (A I) is taking over. I won’t be surprise if robots are playing the instrument or making sounds better than any instrumentalist would. I don’t know. But we just have to be prepared and look out for opportunities and other ways to earn a living as an instrumentalist.
Don’t be scared. It is what it is. Lol.

#Peace

We can’t do it all alone. I can’t do it all alone. And that’s why most times we (instrumentalist) need that push, support and encouragement from our friends and families to keep doing the things that we love.

We’ve been told to get a real job coz playing an instrument is not a profession, it is something you do for fun. We hear things like “is this what you want to do your whole life”, “can you build a house or buy a car from playing an instrument”, “no one makes a living from their talent”, “forget about this and pursue a real career” etc.……… I am pretty sure some of us have heard things we like this.

And due to societal pressure, lack of support and encouragement from the people that we love and serve, some who are making little to nothing from playing the drums, have made the decision to learn a skill, get a job or start a business.

But the fact that we doing this other thing (job, hustle, business) doesn’t mean we want to stop playing or doesn’t mean we are just going to give up on our dreams. We love music. We love to play. But to keep doing this, we need that push, that ginger, that support and encouragement from friends, families, colleagues, mentors and even our pastors.

Like and share the videos we put out. When we tell you about our dreams and our goals as an instrumentalist, be kind enough to show your love and support. Some of us have come to terms with the fact that we might not make a living as an instrumentalist. And that is okay.

Whether its our profession or not. Whether we make money or not. Just be there to show your love and support. Whether online or offline, it doesn’t matter. Lol. Just be there.

#Peace

meum:
Do you charge for a project like this? How much?

Yeah I do. Full data analysis using sql, python excel or power BI, I charge 40 - 80k depending on the dataset. For data visualization alone 10k, 15k also depending on the needs of the client.

Nice one bro.

meum:
Nice. I love data analysis and currently perfecting it via youtube videos.

4) Fintech dashboard using Power BI

3) A superstore dashboard using Power BI