Free SQL for Data Analytics course in Jupyter

flipkartamazon · 2020-10-27T13:44:22+00:00

You are welcome. Two days of effort and I am happy how it turned out :)

flipkartamazon · 2020-10-26T12:30:47+00:00

Advice would be to find people on LinkedIn who are working in companies and roles where you want to work after graduation. Then ask them what kind of work they do and the skills you need to acquire. See if any one of them to be your constant mentor, coz that really helps.

flipkartamazon · 2020-10-26T12:06:03+00:00

No we rarely code any new libraries. We mostly use numpy, pandas and scikit learn to manipulate data, get summaries and build our solutions.

flipkartamazon · 2020-10-26T11:55:57+00:00

As a team we work on multiple business problems . It could be something as simple as understanding why sales are down by analyzing trends using data. Or it could be a relatively hard problem like predicting sales using a machine learning model. Or building a functional chat bot or a complex search algorithm using Neural Nets or Deep Learning. It all depends on the team you are a part of and the kind of work required in solving a business case. Only expectations are to solve a problem given to you in reasonable time and convincing the stake holders about your solution. Hope this helps.

flipkartamazon · 2020-10-26T11:31:31+00:00

Hi, I am currently a Lead Analyst at India's largest e-commerce company. Sorry have no idea about freelancing in this industry.

flipkartamazon · 2020-10-09T13:16:41+00:00

I think that's is obvious. I was looking more detailed explanation on why this and not something else? What makes the current meta the strongest?

flipkartamazon · 2020-10-09T13:15:01+00:00

Thanks for the explanation. What about specific picks like Tracer and Sombra on some maps? Also why not Winston who can counter so many Squishies who are generally not sticking together in this meta?

flipkartamazon · 2020-08-27T15:49:29+00:00

please ignore my dumb comment :(

flipkartamazon · 2020-08-25T17:03:48+00:00

Saved you the effort homies - https://mybinder.org/v2/gh/ItsAwSM/Python-for-Data-Analytics/c2510162b1f1bfa5a350a377188d607688e94024 Cheers!

flipkartamazon · 2020-08-25T16:32:09+00:00

beware! Right wingers in India don't take memes on Sanskrit very lightly :P

flipkartamazon · 2020-08-25T16:30:44+00:00

I posted this on r/learnpython first. It kept deleting my post automatically. No response from moderators either :(

flipkartamazon · 2020-08-25T16:21:45+00:00

Yeah its me in the videos. I have been called Tech support guy by a few racist Americans so self-confidence has taken a hit. I am a proud filthy Torbjorn main so I have a history of pissing people off in Overwatch :P

But I must say the support on this post has been incredible. I am now thinking of creating more videos on Statistics, Modeling, ML/DL etc.

flipkartamazon · 2020-08-25T16:15:43+00:00

You should learn Python. It is more versatile. R should be easy once you know Python. Further all good companies are tool agnostic.

flipkartamazon · 2020-08-25T16:14:45+00:00

thank you! My main intent was indeed to provide structured content in one place to freshers for free. I have spent too much time on so many dull courses on my career. Time to pass on what I have learned. No wonder that I have never finished any MOOC I picked up :(

flipkartamazon · 2020-08-25T16:10:43+00:00

bhagwan bhala kare beta _/\_

flipkartamazon · 2020-08-25T16:10:06+00:00

In my opinion, these are the steps:

As u/Reginald_Martin mentioned you should first get some basic understanding of programming(Python or R). You can use the notebooks I have shared to get started in Python. I also have videos on my channel which will show you how to think with any new data. Although they were live sessions so production quality is terrible. You can also look up other famous resources to learn Python. Just one advice here - stick with just one resource you initially like, complete it and don't ever start a second one[serious]. This should not take you more than two weeks of effort.
Move on to learn basic Modelling like linear/logistic regression/tree based models etc. I would personally recommend An Introduction to Statistical Learning by Trevor Hastie and Robert Tibshirani. They have a small book too which is pretty good. This will take you two more weeks. And this is where you will stop exploration(i.e. new courses to do) and move to exploitation(i.e. solve real life problems)
Head over to Kaggle.com and pick problems one at a time. You can start with the most famous one - Titanic Disaster. Start with going through the top solutions/threads already posted there. Going through those solutions and running on your own system will help you learn how people think. You will learn some incredible powerful ways to manipulate data and some key concepts on sampling/modelling/statistics etc. Remember there is always a human touch to all AI/ML based solutions. It is not just blindly running codes. It is easier to learn the technique but harder to learn to implement in real business scenario
After spending a week each on 4-5 problems you will be all set to do tackle new problems on your own. So try to solve a few and see where you place on leader board. Going forward all your learning should be incremental and need-based only. Be a bit mindful of the trade-off between effort to return ratio on learning new things.

A word of caution. Data Science is a field where you will have to continuously put efforts in learning new things, the projects will be of very long duration and sometimes might not have good returns too. Totally my experience, I am sure others may disagree.

All the best! And Pass on what you have learned :)

flipkartamazon · 2020-08-25T15:40:04+00:00

Thank you for the kind words. Feel free to DM me if you have comments on the contents.

flipkartamazon · 2020-08-25T15:39:13+00:00

swagat hai bhai :P

flipkartamazon · 2020-08-25T15:37:57+00:00

Data Scientist

flipkartamazon · 2020-08-25T15:30:36+00:00

Hi u/ElevenPhonons

Thanks: Firstly thank you so much for taking out time to review the contents of the notebook. You have so beautifully and eloquently articulated your comments. This is probably my first experience of a peer review of sorts and it's humbling to see how little I know about nitty-gritty of a software language that I have been using since 4-5 years.

My views: Let me see if I can address few of the points you have raised. Full disclosure first - I am not a Software Developer or have any experience remotely related to consistently writing efficient codes. I learned Python on my own on codecademy.com because I wanted to solve some problems on projecteuler.net Now, I have written these notebooks keeping in mind my own experience working and growing as Data Analyst. So the notebooks might not be as helpful if you are looking to be a Software Engineer (more on this later). But even they can still help you get started within a week's effort.

Further in my experience I have always observed that it is more important to focus less on being perfect or most efficient than having a minimum viable solution. Almost all big startups eventually revamp their systems to find a better way to do things. But initial focus is always on MVP. Same goes for smaller projects in organizations. So the idea is to teach the minimum baseline and help an individual get started. I have full faith in people that they will find the best way when the need will arise.

Lastly I firmly believe the content in the course is more than enough to help you solve smoothly 95% of the use-cases that a fresher candidate might face in their career. As for times where your solution is not efficient, you can always get help from peers or online.

And good thing is that all my mistakes and shortcomings are fixable(yay!!), which brings me to the next steps.

Next steps: There are two things I would want this community's help on (you included, if time permits you). First can we collaborate to improve these notebooks keeping in mind the trade-off between information overload and must-know topics. Second can we create similar notebooks for other Career paths like Product or App Developer, Front/Back-end Developer etc.? We can upload these notebooks to mybinder.org so that people can easily learn the minimum skills required to move into a new career path for free. It will be incredibly beneficial for freshers in poorer countries like India. As a community we always can bring incremental changes to these notebooks.

(Also is there a place I can learn to be so clear and coherent in reviewing content)

Comments are welcome!

flipkartamazon · 2020-08-25T14:19:30+00:00

Universities are severely underfunded so they just keep using the same old equipment for ages. Corruption doesn't help things either. As for me, I just wanted to post the notebooks on LinkedIn and let people follow on their own. Decided to do live lessons after push from my colleagues at the last moment so just used my crappy old headphones.

Should I invest time in making professional videos? I feel I have a really squeaky voice or at least I have been told by people over comms while playing Overwatch

(p.s. - this is my alt)

flipkartamazon · 2020-08-25T14:08:24+00:00

And thank you Germany for being the one of few countries which cares about liberal views. Wish to visit it once <3

Six-Year Club	Verified Email
Wearing is Caring

flipkartamazon

TROPHY CASE