Excel to MySQL
Analytic Techniques for Business

Is this Coursera specialization a good intro to BI?

https://www.coursera.org/specializations/excel-mysql

If you're looking at BA work try to learn the skill of slicing up data. Access is one way to do that but it is not the only way.

Sirven los MOOCs en Argentina?

Buenas a todos!

Estuve viendo algunas páginas de MOOCs como Coursera y Udacity y tienen cursos que se ven interesantes, en Data Science y Data Analytics por ejemplo (que son los que me interesan a mi). La cuestión es, sirven en Argentina los títulos que entregan esos MOOCs para conseguir trabajo? O es preferible pagar un curso en la UTN u otra institución local (que valen más o menos lo mismo)?

EDIT: hago este edit, para indicar que me refiero a cursos como éste, éste o éste, que son bastante largos y parecen estar bien organizados

I'm doing this [https://www.coursera.org/specializations/excel-mysql] specialization and have enjoyed it very much so far. I'm only in the second class so we will see how the rest are. I recommend taking Data Science Math Skills (also by Duke), if you need to brush up on your math before getting to Course 2

Comparing Coursera Specializations

I'm a newby to using data, but it is a skill I want to develop over the summer.

These are the specializations I have considered: https://www.coursera.org/specializations/excel-mysql https://www.coursera.org/specializations/data-analysis

or the Udacity Data Analyst Nanodegree.

My goal is to gain a fluency with using/visualizing data for decision making. I am interested in using it practically as opposed to really getting into the abstract. Thanks for any thoughts!

Career paths utilizing Python?

Hi All!

I'm looking for some assistance on the path to becoming job ready coding with Python. Thought it would be helpful to give a background on my progress. Thanks!

A few month ago I quit my sales job at a large recruitment website, and am now looking to make the transition into Software Development, Data Analysis, etc.

Reason for the change - The sales job I was at for four years was too volatile in terms of compensation, and the stress of always chasing a number was taking its toll. Looking into coding I was amazed at how many different career paths there were. I have always loved learning new things and continuing to expand my knowledge, which seems like a good trait to have for coding. After a few basic courses on Linkedin Learning I was hooked.

What I have so far - I took a few basic courses on Linkedin Learning before seeing if Python was something I wanted to invest time and money into. Once I saw it definitely was, I enrolled in the Coursera "Python For Everybody" Specialization. I am on the third class of five, "Using Python to access Web Data."

What's Next - After completing this specialization I was planning on taking IBM Data Science Professional Certificate and then Excel to MySQL: Analytic Techniques for Business Specialization. I also plan on using GitHub.

Questions - Where do these 3 completed courses put me realistically in terms of being job ready? Are there any good companies that offer paid training? What other resources should I be using to get job ready? How long does a transition like mine typically take? What job titles are good entry level roles? Any and all advice is appreciated! PM's are welcome too!

Advice needed on Data Analyst specialization

I want to go for a data analysis specialization on Coursera . Of the few available on Coursera I don't know which one would be relevant for India and for a guy with 0 work ex ( i am a fresher ) .

Also how is the Data Analysis Job scene , what's the skill set required .Thnks for your inputs

Coursera Specializations :

• Launch Your Career in Data Science

• Tackle Real Data Challenges

• Big Data Specialization

• Data Analysis and Interpretation Specialization

• Excel to MySQL: Analytic Techniques for Business Specialization

This specialization covers more basic tools and will give you a deep dive on analytics https://www.coursera.org/specializations/excel-mysql This one on visualization is great too. Check em out. It might take you 3 months to complete them both dedicating 1-2 hrs a day. https://www.coursera.org/specializations/data-visualization?=&page=1

Not sure what others think of these but this is what I’ve been looking at

https://www.coursera.org/specializations/excel-mysql

https://www.coursera.org/learn/sql-data-science

Coursera has a lot of courses you can audit for free. It's not too expensive to get a handful of certifications if you want those, but the certifications themselves are probably not worth it.

For R:

Data Science

Advanced Statistics for Data Science

For Python:

Statistics

Applied Data Science

Other Languages:

Excel, Tableau, MySQL

SAS

Thank you for the detailed response! As to your question as to what I want to do, it's hard to fully grasp the roles from the outside, but from your explanations it sounds like somewhere between a report/ dashboard developer and a business analyst. Basically whatever I can leverage my existing knowledge of how businesses run, while avoiding anything I would need to re-learn complex math and statistics. I want my work to be analytical, involved in business decisions, and social where i'm interacting with different groups.

I'll check out that book! I've found two certs from coursera I'm considering which seems to cover a lot of bases of yours and others comments if I enrolled in both of them:

https://www.coursera.org/specializations/data-warehousing

https://www.coursera.org/specializations/excel-mysql?

Maybe take these then enrol in a local institute to leverage networking opportunities?

100 percent this. Typically a data scientist is gonna have some sort of mathematics background. That's not for everyone. Its why they get paid 6 figures fresh out of college (often Masters/PhD level graduates). But there's still a huge gap between the average business analyst and a data scientist, and its filled by data analysts.

So if you ignore the more advanced aspects like AI/ML, NLP, hell even big data or non relational databases. Understand the core concepts of doing data analysis you'll likely carve a pretty good role for yourself. I've sat on teams of analysts and been a hero for being able to run simple SQL queries.

My curriculum for data analysts would start with a heavy focus in:

• ETL. Extract/Transform/Load.. essentially prepping the data for analysis

• Data Visualization. Lots of UI friendly point and click options that you can apply best practices too without advanced statistical modeling.

• Excel. Not so much because its the ultimate analysis tool. But it can do a lot and can give one a good sense of creative problem solving in both prepping data and running analysis. Lots of novel plugins as well like Fuzzy matching, and the analysis toolpak

Once you're comfortable with those, then you can explore R and Python (numpy, pandas, etc..). Learn how to apply your critical thinking/problem solving to the huge libraries of code that exist in those tools.

A few courses I just quickly snagged from Coursera that would be good for a newbie:

• https://www.coursera.org/learn/excel-data-analysis

• https://www.coursera.org/learn/ai-for-everyone

• https://www.coursera.org/specializations/excel-mysql

• https://www.coursera.org/specializations/business-analytics