Eawwal:
I stumbled on this thread a week after I started my journey into data science, I started with phyton, after going through the whole thread, I had to put python on hold and I started learning excel, I've now mastered excel and also power Bi, the only issue I have now is DAX formulas, I believe I'd improve on that as time goes on.

I'm moving onto sql, I haven't decided which one to go for between mysql and mssql. I need advice.

I'll advise you move to SQL.

Learning DAX formulas can be a little bit niche and not many analyst adverts demand for it.

Raalsalghul:


I'll advise you move to SQL.

Learning DAX formulas can be a little bit niche and not many analyst adverts demand for it.

I'd do that.
Thanks �

Kenny242:

Why not go for postgresql

I just made research on postgresql and I think I'd settle for it. Do you have materials I can use to learn.

Raalsalghul:


Try below link;

https://www.youtube.com/user/ExcelIsFun

Thanks

I must finish excel before the end of 2 weeks

Raalsalghul:


Start with SQL (Over 95 per cent of Data Analyst roles require this skill). There are many RDBMS you can use to learn but MySQL is the most common.

Then learn Excel with emphasis on (Look-up and Statistics functions, referencing, conditional formatting, power query for cleaning data, pivot tables for summarizing data, power pivot for modelling and then DAX).

Followed by PowerBI or Tableau: you'll use these tools to visualize the results of your SQL queries. I personally prefer PowerBI as it's more robust in function.


People mention Python a lot, but I've seen many Data Analyst vacancies excluding it in their requirements (emphasis on "Data Analyst"). Nonetheless you can add it to your skill set if you want to go the Data Science Route or just for personal development purposes. Learn the basics first and then move on its libraries: Numpy, Pandas, Matplotlib and Seaborn. There's also the Scikit learn library for its machine learning capabilities.

If you can master the first 3, you're job ready: then scale up your knowledge from there.

This advice is beautiful!

I’ve learned MySQL, Excel, Power BI and Cognos Analytics (with certifications from Coursera)

I’ve also completed a data analysis project on 2015 Economic Data

How do you suggest I start looking for jobs boss? I talked to someone in the tech world (a web dev) yesterday and he said he doesn’t really know anyone who got a job through Ng Indeed.com, meaning the chances of getting a job there may be narrow or something

Raalsalghul:


Try below link;

https://www.youtube.com/user/ExcelIsFun

@Homeboiy I recommend this Youtube link too. Dude is one of the best teachers on YouTube and you’ll learn the concept very quickly depending on how dedicated you are

Navigate to his Excel Basics Playlist…

Eawwal:

I just made research on postgresql and I think I'd settle for it. Do you have materials I can use to learn.

Well i use amigoscode(YouTube) = he uses sqlshell , while programminguru(YouTube) = he uses both shell(promt) and pgAdmin

I still don’t know which one is better to use weather the shell(promt) or the GUI(pgAdmin).

ebixy:

The bottom of the pyramid is saturated right now. Go on LinkedIn and almost every knows how to use those tools (Excel, Power BI, Tableau), the competition is very very high.

Our target should be the global job market, not just the Nigerian job market where opportunities are few. Gather as many skills and tools as possible and be good at them.

But I get your point and it is valid. Start somewhere and grow from there with time. SQL, Statistics, Excel, PowerBI, and Python (Pandas, Numpy, Matplotlib) are enough to enter the industry.

Omo, this thing you said about the bottom of the pyramid just made me weak. I started my job search as a data analyst this eeek

I’m proficient in the aforementioned skills including MySQL. I’m however, in the process of learning Python by reading the ‘Automate the Boring Python’ book and looking to start with R since my course in the university teaches statistics and probability

Let’s assume I become a professional data scientist and want to pivot to the level of getting a foreign job, which platform do you recommend?

haryomikun:


@Homeboiy I recommend this Youtube link too. Dude is one of the best teachers on YouTube and you’ll learn the concept very quickly depending on how dedicated you are

Navigate to his Excel Basics Playlist…

Thanks bro

I like the feedbacks

I will attend to it

Help a brother guys

I'm having issue with Power BI visualization

I was able to visualize the excel document recommended in Power BI tutorial video but I'm having issue with visualizing my own excel document in Power BI. Please what would I do to be able to visualize my own excel document?

Or which video could you recommend?

SonOfNobody:
Help a brother guys

I'm having issue with Power BI visualization

I was able to visualize the excel document recommended in Power BI tutorial video but I'm having issue with visualizing my own excel document in Power BI. Please what would I do to be able to visualize my own excel document?

What problem are you facing specifically and at what stage? Kindly describe

Felixitie:


What problem are you facing specifically and at what stage? Kindly describe

At the visualisation stage, It was displaying like a text but when I used the data used in the YouTube video, It visualized perfectly.

Please w3schools a good place to learn data science?

Eawwal:

I just made research on postgresql and I think I'd settle for it. Do you have materials I can use to learn.

Download the SimpliLearn app on playstore and navigate to the Intro to SQL course.
MySQL is the way to go for beginners. And there only exist Syntax difference between size it and MS-SQL or PostGRE. However the app I recommended has a chapter dedicated to PostGRE teaching what you need to know in addition.
It's easier understanding MySQL workbench and transitioning to PgAdmin than the reverse

I saw this thread last year and it was the finally icing on my cake to go into Data Analysis. I just got my system and I'm ready to take off, I wish there are beginners like me here who can walk this journey with me. Thank you to the op who started this God bless you.

SonOfNobody:


At the visualisation stage, It was displaying like a text but when I used the data used in the YouTube video, It visualized perfectly.

Probably you are not using the correct data type in your table in powerbi. Also try to check if your values are not 'summarised', or aggregated by default otherwise you will have to change it. Are you using the right chart?

Felixitie:


Probably you are not using the correct data type in your table in powerbi. Also try to check if your values are not 'summarised', or aggregated by default otherwise you will have to change it. Are you using the right chart?

Yes sir

I got the data from PWC Power BI virtual internship and I just realized it is for call centre agents analysis. I will try and watch videos on it.

Thanks for your intervention sir.

Well done, guys.

May i ask, what's the difference between Business Analysis, Data Analysis and Data Science?

I see different courses online along those three lines and they seem intertwined.

At first, I thought I'd be best fitted in Data Analytics but seeing this video frim Alex changed my mind towards Business Analytics:
https://www.youtube.com/watch?v=G4syHs3M82E

My question is: what's the difference between Business Analysis, Data Analysis and Data Science?

SonOfNobody:


Yes sir

I got the data from PWC Power BI virtual internship and I just realized it is for call centre agents analysis. I will try and watch videos on it.

Thanks for your intervention sir.

I have worked on this actual dataset before, using powerbi. It is a straight forward thing bro. I did without watching a video. Follow the insights you are asked to get.

I need someone to give me an analogy of a class , object, method , function,inheritance etc


When something is an instance of something what do it mean.


I do know how to code but I am yet to grab this basic simple english

jackcanfield:
I need someone to give me an analogy of a class , object, method , function,inheritance etc


When something is an instance of something what do it mean.


I do know how to code but I am yet to grab this basic simple english

Using type of nouns as an analogy.

A class is like a common noun e.g man. But a man is not specific and can refer to several adullt male.

That's where Object comes in, example Ade.

So, to summarize, a class is like a template for creating several objects with specific features.

Man(class)
Ade(object)
Musa(object)
Kazim(object)...

A function is simply a block of codes grouped to perform a specific task. The grouping is simply to allow repetitive usage.

Inheritance is defining a class(child) in such a way that it re-uses the attributes of an already defined class (base)

Instance, depends on context. It could refer to occurrence or type. E.g isinstance("str1ng", str) will return true (python). Since "str1ng" is a string (str) data type.


Ps: I'm lazy typing

haryomikun:


Omo, this thing you said about the bottom of the pyramid just made me weak. I started my job search as a data analyst this eeek

I’m proficient in the aforementioned skills including MySQL. I’m however, in the process of learning Python by reading the ‘Automate the Boring Python’ book and looking to start with R since my course in the university teaches statistics and probability

Let’s assume I become a professional data scientist and want to pivot to the level of getting a foreign job, which platform do you recommend?

I don't think that book is enough for python.
I started learning python last week. Its a wonderful experience I can say. I use these:
SoloLearn app.
Learn python the hard way PDF
Automate boring stuffs with python. I have the PDF file but I've not opened it yet. I realized the author made a lot of video courses which are available on Telegram.
If you have Telegram, I have a lot of useful links for you.

mhizcutie:
I saw this thread last year and it was the finally icing on my cake to go into Data Analysis. I just got my system and I'm ready to take off, I wish there are beginners like me here who can walk this journey with me. Thank you to the op who started this God bless you.

I'm a beginner too. I've got a couple of resources and video lectures. I encourage you to use Telegram because it will cost me less data to share it compared to WhatsApp.
I'm in!

Prinss:



Using type of nouns as an analogy.

A class is like a common noun e.g man. But a man is not specific and can refer to several adullt male.

That's where Object comes in, example Ade.

So, to summarize, a class is like a template for creating several objects with specific features.

Man(class)
Ade(object)
Musa(object)
Kazim(object)...

A function is simply a block of codes grouped to perform a specific task. The grouping is simply to allow repetitive usage.

Inheritance is defining a class(child) in such a way that it re-uses the attributes of an already defined class (base)

Instance, depends on context. It could refer to occurrence or type. E.g isinstance("str1ng", str) will return true (python). Since "str1ng" is a string (str) data type.


Ps: I'm lazy typing

Thank you , I would read through it.

absool:
Please w3schools a good place to learn data science?

Download SoloLearn on PlayStore

Felixitie:


I have worked on this actual dataset before, using powerbi. It is a straight forward thing bro. I did without watching a video. Follow the insights you are asked to get.

Wow! This is nice, I will do that sir

Felixitie:


I have worked on this actual dataset before, using powerbi. It is a straight forward thing bro. I did without watching a video. Follow the insights you are asked to get.

Could you share me the link to the insight because I didn't see it there?

Please can someone recommend a YouTube playlist to learn phyton for data analysis.

I'm done with Excel, MySQL and power bi...

Please any python for data analysis videos on YouTube?

haryomikun:


Omo, this thing you said about the bottom of the pyramid just made me weak. I started my job search as a data analyst this eeek

I’m proficient in the aforementioned skills including MySQL. I’m however, in the process of learning Python by reading the ‘Automate the Boring Python’ book and looking to start with R since my course in the university teaches statistics and probability

Let’s assume I become a professional data scientist and want to pivot to the level of getting a foreign job, which platform do you recommend?

LinkedIn. Lots of job postings and you get to connect and interact with like-minds from around the world.

Felixitie:


I have worked on this actual dataset before, using powerbi. It is a straight forward thing bro. I did without watching a video. Follow the insights you are asked to get.

Gosh! I am just like those people who like to burst pimples or blackheads on other people's faces once sighted, but this time around with data visualisation, lol

I see a whole lot not right with this dashboard...they are the things that make the intended audience NEVER take action, even after all the time spend putting the charts together.

A lot of "hardcore" data people think its beneath them to put in the effort when it comes to visualisations, forgetting that this is the "PLATING OF THE DISH" for the audience and if not done correctly, then all the work done from inception falls into the drain.
You are practically engaing with the brain of people who have very little attention to give...

Felixitie:


I have worked on this actual dataset before, using powerbi. It is a straight forward thing bro. I did without watching a video. Follow the insights you are asked to get.

I have been able to visualize the data sir

Thanks so much