VBA and Macros are advanced topics in excel. You may have to search for it on YouTube. It's mostly about automation. Excel is so so underrated. I don't think that an Excel expert, I mean real expert, will ever go hungry anywhere. There are so much you can do with that tool.
ibromodzi: Nice submission but you have to take it easy boss. I have a feeling that we have some things in common. When I started with Python last year September, my goal was just to do data analysis. When I 'finished' mastering the fundamentals of descriptive and inferential statistics, I said to myself; this can't be the end of it so I started learning about ML, then DL and I became obsessed with CV and NLP. After getting a solid understanding of DL, I said to myself; this can't be the end so I made some research and found out how ML/DL models can be turned to web/mobile apps so I started learning web dev (backend and fronend) till I gained proficiency in it and started building my portfolio. My next target is to start contributing to open source projects (most especially, NLP).
I think for anyone to be come a master (I mean not working for someone your entire life) in this tech space, one has to be curious and be innovative at the same time.
For anyone that wants to go deep into DS, don't listen to anyone telling you to focus on some aspects and ignore some. Get a standard learning path (check Analytics Vidhiya) and stay focused while you climb the ladder.
Between, could you please quote me with the link to that Edureka video on excel?. I don't really like their courses but let me try this one since you found it interesting. Thanks!
You may still not find it interesting because they were a bit fast in the video. I think they were trying to cover up as much topics as possible. What I normally do is to write down the topics and summary of what it is all about, then search YouTube for where they digested any topic I want to learn well enough.
ibromodzi: Nice submission but you have to take it easy boss. I have a feeling that we have some things in common. When I started with Python last year September, my goal was just to do data analysis. When I 'finished' mastering the fundamentals of descriptive and inferential statistics, I said to myself; this can't be the end of it so I started learning about ML, then DL and I became obsessed with CV and NLP. After getting a solid understanding of DL, I said to myself; this can't be the end so I made some research and found out how ML/DL models can be turned to web/mobile apps so I started learning web dev (backend and fronend) till I gained proficiency in it and started building my portfolio. My next target is to start contributing to open source projects (most especially, NLP).
I think for anyone to be come a master (I mean not working for someone your entire life) in this tech space, one has to be curious and be innovative at the same time.
For anyone that wants to go deep into DS, don't listen to anyone telling you to focus on some aspects and ignore some. Get a standard learning path (check Analytics Vidhiya) and stay focused while you climb the ladder.
Between, could you please quote me with the link to that Edureka video on excel?. I don't really like their courses but let me try this one since you found it interesting. Thanks!
It's funny how you listed all of these for people to learn while you have problem with the little I listed. And you do not get it that I am a bookworm cos you don't know whether I am or not.
Someone asked about ML and I explained to him how he can start up with that. You don't even know whether he/she can do analysis already, or interested in the "sharp sharp" you are advising.
Actually, the intro to statistics can help him greatly in analysis. You should never advise someone to dim his/her curiosity no matter what. If he/she is curious about anything, direct him to the right path. He/she has already seen what is needed for data analysis and not here saying ML doesn't make sense in Nigeria.
The interview you attended, if someone else interviewed for that position and has the same skills as yours and maybe has a knowledge of regression analysis, who do you think will be picked?
The ML you are talking about that doesn't make sense, is it not with the same knowledge that some Nigerians are winning some money on Zindi Africa? Zindi Africa is supposed to be for Africans but guess the country that is winning mostly there?....
Not everybody here is sitting at home hustling for data science and analytics jobs. Some have good jobs and want to transition, and it will be really good if they have a very good understanding and be really good at it.
I became very good with Python because I always download and go through notebooks on Kaggle. Why did I go to Kaggle on the first place? Because I was curious about ML. Nobody can do ML without processing the data first and you get to see notebooks that are just for analysis.
I couldn't learn Tableau even after watching videos till I went back to statistics to really understand about data. I remembered asking here which videos I can watch to really understand it. Do you also think that analysis is just about dragging and dropping and drawing charts? Won't you recommend or do some predictions for the company based on what you understood from the data given to you.
Oh, before I submit, let me also said that curiosity about ML also led me to learn about softwares too. I can build websites also. While I have come up with a portfolio on data science and applying for the jobs, I am also building a web project to apply for front-end web developer. Yes, I was curious about ML, and it has led me to acquire more than what I expected.
ML Engineers are also available remotely. You should be curious enough to learn what is relevant beyond your location. Upwork and Fiverr are all global. Someone has brought two questions here from upwork and we were just confounded. A work on excel actually, and we couldn't get it. All of them are available online. The day I watched Edureka 4hrs video on excel, I was dumbfounded to know so many things I can do with excel. You can build bots using excel, finance goal seeks, VBAs, Macros...
We are still here talking charts and functions and still asking what excel can do that pandas can't do. If someone says anything that is foreign here, we try to shut down the person with "it's not applicable in Nigeria bla bla bla". Do you even know the worst thing about us youth in Naija? We are even ready to explore or think beyond our locality, and the worst of the worst? We try to drag others along with us to stay myopic as well, that is why we are where we are today.
Shalom!
wisemania: We need to be careful when dishing advice.
We get it! You are a bookworm, you can't help it, we understand, but be careful with your advice. Ejiod already explained the process of becoming a data scientist.
How? By FIRST becoming a data analyst. You do not need to understand the intricacies of advanced statistics (or ML) to become a data analyst. What you need is
1. basic mathematics (statistics),
2. basic intuition of how ML algos work(they've been written in packages already for your usage). Kiril eremenko did a great job on that on udemy. Just get the course for free and learn the intuition with how and when to use it.
3. Excel,PowerBI(because it's cheaper for companies to integrate as most companies rely on Microsoft products and it's simply advanced excel) and or Tableau (or any other visualization tools). Tableau is a bit expensive though
4. SQL (T-Sql/MySQL/P-SQL) they are all 90% the same. Learn MySQL and the rest will become a breeze!
5. A programming language (Python/R/Julia, etc). You don't need to know all the functions of the language, just learn the basics and the necessary libraries for now (trust me, there'll be plenty of time to dive deeper into these languages later!)
After you're pretty solid on the above, start applying for jobs (junior data analyst or Business Intelligence Analyst).
Or if you want a higher pay, Immerse yourself in MSSQL (Data warehouse tools) I.e Learn
T-SQL (Microsoft customized SQL)
SSRS (pretty deprecated, but many companies still use it for reporting. To be frank, modern visuals like PBI, Tableau are taking over.dont spend too much of your time here)
SSIS -makes your life easier, as it reduces the amount of dml you need write. It's very easy.
SSAS - same.
Spend your time learning the above and you'll begin to earn a lot.
Because if you spend your time going though the Forever learning path, you're gonna be a jack of all trades yet a master of none.
If you need to feed, get a job with excel,powerBI/tableau,SQL,Python/R then learn the remain (Statistics, ML-DL) on the job as required.
Else, you go HUNGRY
This is barely my 3rd month into data analysis and I've gotten some interviews already... No time to waste, as you need to survive...
Marveaux: Kind sir,please do you know any books I can read to have a good theoretical knowledge of ML/DL?Not books about Data science as related to ML/DL(i.e python libraries),but more of the concepts of ML/DL as a whole. Thanks.
I will suggest to immerse yourself in fundamental statistics, linear algebra and if possible, a little bit of Calculus(Chain rule)
Udacity has a lot of free courses on intro to statistics, ML and DL. Although you can't get a certificate, but learning it is the important part. If you can brave it, try Andrew Ng's Machine Learning course on Coursera, that's the gold standard. You can audit the course for free. You will learn all the math and stat behind ML but I will advise you have a good foundation before you try that course. Another deal breaker is that he teaches the course with MATLAB/Octave, but not to worry, if you can grasp that, you can implement it using Numpy. The course will teach you how to build ML from scratch and not just to import modules.
You can also Calculus course on Coursera by UPenn. You can audit for free.
Do not let the math and stat scare you anyway. The beginning is the hardest. You can do so much on ML if you can grasp how to build it from scratch.
N.B: Please DO NOT believe that it doesn't make sense learning ML because you are in Nigeria.
AnalysisGuru: Good day guys, does anyone know where to download a well structured PHP and JavaScript video, or do you know any sound teacher by name on them either on YouTube or elsewhere?
Ajibade123: please domain should put me through working with Jupyter....when I installed the anaconder I was able to launch jupyter with it and ran hello world through chrome but now I am trying to open the navigator this is what it is showing me
I don't know which OS you are using. I'm using Windows and I can locate it at my start menu shown below. I pinned it to my task bar to make it easily accessible. You can also open it through anaconda prompt by typing, jupyter notebook, then click enter.
nwele2017: learn what i have listed Excel ,pandas , SQL ,statistics ,tableau or power bi That's only what you need to become a data analyst any where in the World.many people are running into Data science thinking that it is self heaven and sexiest job of 2020 but, they don't know there is high demand of Data analyst than a Data scientist. Even software engineers are in high demand than data scientist.
A standard firm can employ tens of software engineers, 5 to six data analysts and only one Data scientist. Am not discouraging people from learning data science; i just want to be realistic , this is what is obtainable in the industry .it is just like playing the devils game. There is high demand of Data analyst and software engineers than data science. I will tell you that data science is like a bubble that will soon burst. people see data science like a black box that can solve any problem but in reality it's a lie, the problem data science algorithm can solve is limited.And also data science i not all about knowing algorithm. There are more to data science than knowing algorithm, understanding the context of industry you are working and also communicating the result visually and orally is also important. The sure and easiest way of becoming a data scientist is to become a data analyst or business intelligence analyst and by doing this you become acquainted with problem that is need to be solved.
I can agree with you when you say that Data scientist doesn't really mean much in Nigeria, but don't relate it globally. Data science encompasses both analysis, big data and the machine learning you mentioned, it's like a unicorn role. The issue is that it involves a lot that when someone is doing just part of it, he/she will identify as a Data scientist. Machine learning like you mention is on a very high demand in a developed country. Of course it is artificial intelligence, and there is no field I can ever think of that is in demand more than AI and Robotics. Netflix, amazon, facebook, and microsoft recommendation engines, Google self driving cars, tesla, fraud detection, image recognition, and so many others are all ML and DL.
You wouldn't advise someone in US, Canada and co. to forget ML. You can even get it as a remote job. It is not even easy to learn ML, cos you need a good knowledge of statistics, algorithms and maths(linear algebra and calculus) to understand how model works. A machine learning engineer like they said is one that knows statistics more than a software engineer and knows algorithms more than a statistician.
For me, they should just delete the Data Science name cos it is a confused role. Unless you can do analysis, visualization, maths, stat, algorithms handle big data and good business knowledge, you are not a Data scientist, but if you do, you are the hottest in the market.
Blessing456: Hi everyone, To those who have written the GRE exam or planning to write I need help on; 1. How much is GRE? Been seeing some(45k,60k,80k,100k)...I really don’t know the exact price 2. Where to register 3.what books do I really need to pass? 4.can I prepare in 3 months? 5.is there like a group say WhatsApp where people planning to write can have a time to time discussion. I’d appreciate a prompt and clear answers Thank y’all.
For the first one, do you need to specify the encoding? Is the default(utf8 I think) giving you unicode error?...
The second one, is the notebook file you opened in the same folder with the file you want to import?... Again, do you need to specify the encoding?....
engrjoe: Yeah I actually have this video and that is what I am using. The set up part is my problem. I have reached 1hour of the video but havent been able to advance well enough. Is there a way I can reach u on WhatsApp pls
engrjoe: Hi guys please I need assistance on Data analysis. I am currently using youtube to learn SQL but I am not getting it well enough but I am very interested. Anyone around Ijaye, Kola, Alakuko, Tollgate or Sango area (Lagos) who can help me please.
Thanks you
Have you tried Mike Dane's (Giraffe Academy) video on MySQL?.... I learnt with it.
Can anyone please point me to a good YouTube video that major on:
1. Data science with the use of jupyter notebook please.
2. Data analysis with the use of Microsoft excel.
I need am pass anything please....
The beginner friendly video I watched that introduced me to jupyter was Mosh's YouTube video on Python, the section where he discussed Machine learning.
Can anyone please point me to a good YouTube video that major on:
1. Data science with the use of jupyter notebook please.
2. Data analysis with the use of Microsoft excel.
I need am pass anything please....
I'm trying to answer no 1 without complicating it for you. You can search Edureka's 9hrs video on Machine Learning, they did a good job there. If you can, please try Kaggle. You will see lots of Jupyter notebooks you can look at to guide you through. Google tutorials on the use of jupyter notebook, Dataquest did justice to that.........https://www.dataquest.io/blog/jupyter-notebook-tutorial/ When you feel you are ready to practice, pick up Titanic competition on Kaggle. There are so many notebooks that will guide you through. NB: Kaggle can get overwhelming. You may feel lost being there, but continue anyway.
I did Titanic and House Prices, but the one I can defend wella is Titanic. Doing it really exposed me to Data Wrangling and Feature Engineering. I looked up on different notebooks and downloaded videos from YouTube to help me with it.
noob03saibot: please bro, I will like to ask two questions, is it possible for me to download anaconda, jupyter notebook on my system while I have pycharm installed too without having any issues or I should first uninstall pycharm ? The thing is, I started with pycharm last month and I will like to switch over to jupyter. And in the advanced option page when installing anaconda, should I click on add anaconda to my path environment variable, or leave it as it is? Thanks in advance
You can. I installed both of them, and they are working fine. I suggest you go look up FAQ on anaconda site. They have all the answers to your questions, in fact, I was looking at the guide while I was downloading Anaconda.
mcemmy0z: Get Tableau 10 A-Z: Hands-On Tableau Training For Data Science and Tableau 10 Advanced Training: Master Tableau In Data Science by Kirill Eremenko . These two videos will surely help .
OK, thank you. Please do you about answering queries on Python?
Ejiod: They do the same. However TABLEAU has been the boss for the past 8yrs in data visualization. PowerBI is like a new kid in the block. Though I like powerBI for one thing which is DAX syntax which has edge over TABLEAU
Please I need to start practicing what I've learnt in MySQL. Is there any app or website I can be answering queries to get grounded in it. Again, how can I answer queries on python? I'm using jupyter notebook. Is there any algorithm or something? Please help me, I'm lost.
Again, I can learn on my own, in fact, I've been doing that, but I can't get my head around Tableau. I've been learning with Edureka's video on YouTube, please is there a more comprehensive video you can point me to?...
Ejiod: 1st given their data to work on from home. 2nd was given their data plus theory which was executed in their office 3rd was given their data which I also did from home.
Just understand the data being thrown at you is to check whether you are capable or not and to know how you think about data. Questions on the data are always direct
Bros please I really need your answer to that question I asked abeg....
Ejiod: Please can you create a separate thread for this. It’s not allowed here. We support any content users can easily get without hidden fee. This thread is for people to share their journey through data science and help younger ones.
Thank you for opening this thread. You can't imagine the hope you just gave to me. I am currently teaching myself and it's been progressive.
Please I want to ask, when you went for data analyst interview, the practical part, how was it? Do they just give you data, tell you what to analyze, give you time and leave you to it? Or they supervise what you are doing while you are doing it? And the theory part you talked about, please could you remember the nature of their questions? Is it questions relating to maths, stats or type of charts you can use?....
Ejiod: Funny enough it was through YouTube channel and when I was a web developer. I started by testing different cases on a web app just to fish out bugs. It was purely functional testing. Started growing up in testing API... My best framework was katalon studio and Selenium before I started with SoapUI and postman. Truth be told, software testing is cool when you understand the architectural design of an app and you knowing little web stuff plus little code. These days software testing pays good but you need work it out by running many iterations just to beat bugs in a system.
fabulousLady: Good evening everyone, Please is there anyone here who can mentor me on how to apply for abroad scholarships? Especially US and Canada. It will help my 'moving on'
BenklinsJones: Same here bro.. Homeless,Jobless, will be 27 this March(Highly worried over this).. despite graduating at the early age of 22. I have lost count of interviews I have been to.Will get to final stages but never get the job.Seems I am just pouring water inside a basket..nothing seems to just be working for me. Dont even know what to do anymore. I am still hoping on Jehovah God.
I think you need to up your game for interviews. Maybe you need intensive interview coaching. You can also contact Jarus cos the reviews are good. Also try to develop yourself and try add to your technical skills. Ask yourself what you have to offer apart from your certificate. What stands you out among your peers.
You can learn programming languages that can help solve company's problem. Python is one, and YouTube videos can help. If you can easily learn languages, learn one or two, it will come in handy. Volunteer too. And then you need to be expressive enough to tell it all at the interviews.
We still have MNCs that offer jobs on merit in Naija. And the truth is that every HR wants to offer the best to the company cos it improves their appraisals. They won't let you go if you are a goldmine. Oh well if they do, their loss.
You already have an edge since you can scale through aptitude tests. Some of us still struggle with Dragnet. My 2Cent. All the best.
Jesus!! You took that so seriously....wow!!...It is well with all of us
Well you were quite serious man. You just got APL on Friday and quote, insinuating that girls will start rushing cos of NNPC. Hope you have something good to offer other than money shaa?
TWoods: If a faceless forum member who you’ve never met and who has zero access to you, is able to “kill your dreams” (whatever that means), then you are the problem.
Yeah sure... you should get a hold of a bible and read it first before claiming “testimonies”... you all make Nigerian “Christians” look like the hypocrites they are.
In this same faceless forums, people get help that transforms their future for the best, advice and encouragement to push still, and you think a dream cannot be killed here? So all your intelligence and ITK didn't tell you that?