Excel to MySQL
Analytic Techniques for Business
Formulate data questions, explore and visualize large datasets, and inform strategic decisions.
Binary Classification Data Analysis Tableau Software SQL Business Analysis Business Analytics Business Process Microsoft Excel Linear Regression Data Visualization (DataViz) Visualization (Computer Graphics) MySQL
Accessible for free. Completion certificates are offered.
Affiliate disclosure: Please use the blue and green buttons to visit Coursera if you plan on enrolling in a course. Commissions Reddsera receives from using these links will keep this site online and ad-free. Reddsera will not receive commissions if you only use course links found in the below Reddit discussions.
Executive in Residence and Director, Center for Quantitative Modeling
and 1 more instructor
This specialization includes these 5 courses.
Reddit Posts and Comments
1 posts • 56 mentions • top 14 shown below
7 points • enyoctap
Is this Coursera specialization a good intro to BI?
3 points • OnARedditDiet
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.
6 points • [deleted]
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)?
1 points • timetogetbytogetdry
I can only really speak to the fourth course in this program, but it is the best online course I've ever taken. And having a knowledge of relational databases is a big one for a data analyst role.
2 points • Rattix88
Career paths utilizing Python?
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!
2 points • b0rnz
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!
6 points • entra_guy
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 :
1 points • joe183288
Not sure what others think of these but this is what I’ve been looking at
1 points • joeysk2012
opinions about certificate classes online
What do people think about certificate classes online classes backed up by real universities such as this one:
It does not replace a degree but if you have a degree, it might look better on a resume because you can add it as a certificate program to your resume, it's backed up by prestigious universities (unlike udacity or coding bootcamps), it costs pennies compared to real education, and you come out with good personal projects at the end of it. It's not life changing but it looks better than just doing personal projects and it can supplement your credit school work with practical skills. Is there something I am missing? seems like a win win.
1 points • Gibson19
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:
1 points • SoulfaceTinker
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:
Maybe take these then enrol in a local institute to leverage networking opportunities?
2 points • Delta0211
What online courses are you doing?
This 'quarantine season' I am planning to take the classes mentioned below. What courses are you guys taking? share links to them.
1) CS -https://courses.edx.org/courses/course-v1:HarvardX+CS50+X/courseware/b94adcd6bd6b4e69b2af7eef0d828674/823f7d8a587743569c13eac2bbbd04dd/?activate_block_id=block-v1%3AHarvardX%2BCS50%2BX%2Btype%40sequential%2Bblock%40823f7d8a587743569c13eac2bbbd04dd
3) Self Development -https://www.coursera.org/specializations/excel-mysql
1 points • MoreTac0s
Want to Transition to a Data Analyst Role
To preface, I tried to do a search first and found similar results to what I'm looking for, but I was hoping for a little additional guidance in terms of resources for a few skills.
I currently work in Support, but I'm really interested in transitioning into a Data Analyst type role. The skills I was advised to focus on is Excel, SQL and possibly a data visualization tool such as Tableau. Does anyone have a recommended site to learn these skills? I've been playing with Data Camp for SQL, but ideally if I could find a site (paid is ok) where I could learn all, or most of these skills in one place, that would be highly recommended, especially if you've done them and found them to be helpful. Below I'll post a few I've come across if you don't mind sharing your insight.
Seemed a tad less reliable, but: http://datamonkey.pro/
https://www.excelerateclasses.com/asp-products/microsoft-excel-formulas-beginner-bootcamp-online-weeknights/ Never really heard of this one, so not sure what to expect.
Any insight you all could give would be greatly appreciated. I'm definitely a learn-by-doing person, so something with projects to follow-along with would be great.
Thanks a bunch
1 points • jboyd88
Please critique my two-year learning plan
I am currently working (40 hours a week) in a charity as a Project Manager but would like to eventually transition into Analytics/Data Science. I'm naturally technical but don't have any programming skills, I'm a good problem solver but have never studied analytics, I have very basic math knowledge from my school days (I'm 31). I know I have a long path of learning ahead and I would love your advice is I'm heading on the right track. My dream would be to use data to enable charities to make better business and impactful decisions.
In September 2021 I want to apply for a masters in Statistics with Data Science. I currently hold a Business Management bachelors degree and work in a project management position. My two-year learning plan is to prepare me for my masters and hopefully give me the base skills that I could potentially transition into a junior analytics role before or while studying my masters. I am intentionally avoiding heavy textbooks (apart from one statistics book) in the two-year phase before my masters to ease myself in (I dont traditionally learn well from heavy textbooks).
For my first year, I want to develop my current skills in excel to an advance level and learn the basics of analytics, business intelligence and coding (SQL & Python) and dashboards. I want to start applying what I'm learning within my current role at work by doing side analytics projects using the charity data. The resources I plan to get through are (in 10 hours a week):
- Coursera: Excel to MySQL Analytic Techniques for Business Specialization
- udemy: Your Excel Data Analysis Playbook
- Book: Data Smart: Using Data Science to Transform Information into Insight
- Book: How to start a business analyst career
- udemy: Data Science & Deep Learning for Business™ 20 Case Studies
- udemy: Automate the Boring Stuff with Python Programming
- Coursera: Data Science Specialization by Joh Hopkins (continued in year 2)
- Setting aside time at the end of the year for project work
In my second year I want to develop my math ability and learn some statistics before I go into my masters in September:
- Coursera: Data Science Specialization by Joh Hopkins (continued from year 1)
- MITOpenCourseware: Linear Algebra
- Book: A mind for numbers
- Book: Statistics without tears
- Book: The Art of Statistics
- MITOpenCourseware: Introduction to Algorithms
- Book: Bayesian Statistics the Fun Way
- Course & Book: An Introduction to Statistical Learning, with Applications in R by James, Witten, Hastie and Tibshirani (Springer, 2013)
- Start masters.
If you have any advice or critiques please let me know. I do worry I am taking on too much but I currently feel like I really need to get through level of learning in these two years. Year one to give me the base skills to get some hands-on experience doing data analytics in my current job, start doing side projects and potentially get a junior analyst/Business intelligence type role somewhere and year two to give me the prerequisite knowledge in maths and statistics to make it through my masters. Ultimately I want my masters because I eventually want to reach the data science level in my career.
If you are interested to see how I plan to pace these studies over the year you can see my spreadsheet here.
Thank you all for your help!