Mimisboygreat:
So that means i should go for postgresql then?

yeah true. But people are saying that postgresql is the best new thing now. I'm just confused

Raalsalghul:


The most important thing is that you start learning: whether postgre or mysql.

You can easily switch depending on future requirements.

Felixitie:


Consider the one that is widely used or applied in the business world. However they all have same syntax, just little differences.

baqirshuayb:
pls, is knowing python and its libraries (numpy,pandas,matplotlib, scrappy etc) enough to qualify one as a data scientist?
if no, what do one needs to add to qualify?

Felixitie:


If you mean as data analyst, maybe yes. But as a data scientist (ML/AI), No.. Even as a data analyst you need to be proficient at SQL, plus Visualisation skills ( excel, powerbi and Co)

Toppytek:

Na trust issues go be our major problem with employers, who go trust us with their Database?

GidiCars:



I will do that next week.

movado19:


lol!
This comment is golden! Trust is a commodity that we do not have in spades both locally and internationally.
It's even more worthy than the data itself!
What even makes it worse is the society that hails those who break trust bonds and classify them as "local heroes".

Ejiod:
Apologies all for this long wait..
Traffic here in Lagos can be mental sapping.
Like I said on the headline,I will be detailed on my journey...
Just to clear all doubt..I didn't study computer science or any computer related field..

TRANSITION PERIOD: After graduating from the university with my BSc Biochemistry...I felt I'm a big boy, I can apply to any firm and start earning big.... Damn, I was wrong...took real stress and effort to even get a teaching job paying less than 20k.....Then it was then I realized what I studied wasn't relevant to Nigeria...It was actually frustrating...I felt I could be better of.. Fast forward I went for MSc thinking I could get a lecturing job but even graduating with a Phd grade of 4.3 I was offered a job of under 50k....
It was then I knew I had to switch for good...
Mind you I always had a knack for computer but never did want to go into it..


Will continue tomorrow..need to rest guys.

BoleAndFish:

dahdopedaniels:


How can one reach out to you for career advice?

Englishisamust:
Plz how can I get conda virtual without environment without using command prompt

Kaymax2222:
hello good evening..... I can see you are helping people on there way to become a data analyst, God bless you for this.... Pls help me too. I want to start too but don't just know how to go about it any help from you will be appreciated

GidiCars:



It depends on the gadgets you have at your disposal. For instance, I have a good laptop, phone, lots of data to burn, and about 4 to 5 hours which I can study with everyday. Some people would tell you they do not have a laptop for study. I personally don't think phones can be used to effectively learn and practice data analysis.

Also, do you enjoy reading more or you prefer videos? These and many more would determine how I can help you out
.

Lastly�, do you know python or have used Power bi?

GidiCars:



It depends on the gadgets you have at your disposal. For instance, I have a good laptop, phone, lots of data to burn, and about 4 to 5 hours which I can study with everyday. Some people would tell you they do not have a laptop for study. I personally don't think phones can be used to effectively learn and practice data analysis.

Also, do you enjoy reading more or you prefer videos? These and many more would determine how I can help you out
.

Lastly�, do you know python or have used Power bi?

Blesschemical:
Please sir help me with some courses for data analysis.

Raalsalghul:

Your location?

GidiCars:


It depends on the gadgets you have at your disposal. For instance, I have a good laptop, phone, lots of data to burn, and about 4 to 5 hours which I can study with everyday. Some people would tell you they do not have a laptop for study. I personally don't think phones can be used to effectively learn and practice data analysis.

Also, do you enjoy reading more or you prefer videos? These and many more would determine how I can help you out
.

Lastly�, do you know python or have used Power bi?

movado19:



To butress your point, @ Gidicars,
@Kaymax222 can go through the thread and see that excel, PBI, SQL, Tableau, Python are the most frequent tools & languages to learn.

If s/he is brand new to any of these, then I would personally suggest the following route:
Excel - SQL - PBI - Tableau - Python.

My reason for this is that excel is the "mothership" of all, if not most of these data viz/spreadsheet tools (including google spreadsheet).
Having a good grasp of excel will ensure smooth sailing in PBI and Tableau.
SQL should be next or in tandem with excel because then one can see the similarities and differences with respect to how both of them deal with data cleaning through their functions.

Python should be after one is proficient to a certain degree in the 4 prior tools (in my opinion).

@Kaymax222 can go to the following link to download the workbook tutorial which takes one through some very important excel formulas.

https://templates.office.com/en-us/Formula-tutorial-TM16400656

https://support.microsoft.com/en-us/office/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?wt.mc_id=otc_home

I hope this helps.

Raalsalghul:


You do know your stuff, meanwhile can you point me to any web scrapping material?

movado19:



Thank you.

For web scraping using Python, here's a free Udemy video on how to:
https://www.udemy.com/course/web-scraping-python-tutorial/

For web scraping using Excel, here is the workflow on how to:
https://www.promptcloud.com/blog/how-to-use-excel-to-scrape-websites/


I hope this is helpful to you.

Raalsalghul:


Thanks, I very much appreciate.

Sageez:
Let me share my little cent.
I am a newbie too. Certification is also very important I think.
Most people just start data analysis without understanding the fundamentals.
Someone is us here can't even differentiate between Descriptive and prescriptive analysis but are already jumping into excel. Best of luck to them!
My suggestion.
If you have data, go to Coursera and enroll for Google data analysis professional certification. If you are as rich as I am, apply for financial aid. Best of luck.
For me it is Excel, very little of SQL(still working on it), R(I took some course in edX)...

movado19:


You are very right.
Knowing the data types and analysis types is very important...that should actually be the first goal and this can be learned in a day or two, I believe. It's not something that would or should delay one from still starting in Excel, because in there, one gets to see the various data types at play.
The analysis types become more understandable when/if anyone takes Statistics (at least begin by understanding the philosophy).

If you have data, go to Coursera and enroll for Google data analysis professional certification. If you are as rich as I am, apply for financial aid.


So Google has a Data Analysis certification? Interesting! I will definitely check it out.

Combining preparation for DA100 exam and work has been tasking.
Yes, yes, yes! No one should let finances stop them from learning and they do help out a lot with financial aid.
I also believe that course/certification would be very nice for anyone who looks into it. Google has done a lot of work to simplify virtually the whole data analysis process. They have put together a fine blend of soft and hard skills that are in demand.