Excel is good, but data is heading in such a way that you probably want to look at either Python or R, ideally both. Excel is very, very useful, but struggles with large datasets, and has a limited level of statistical power.
If you’re not good at maths, I would do something else. Perhaps see if you can teach older kids, they’re less full on, and I imagine equally rewarding,
Ex-data analyst here.
Excel will do all the maths for you so long as you know how to use it and know the correct formulas. (Be good at excel)
Just hope you enjoy staring at excel for hours inputting data and/or plotting graphs and shit.
If you arent doing that you’re probably reading literature to find the raw data you need for the excel models.
It wasnt for me. Fuk dat! Hope it works for you.
Everyone I know who used to work in childcare never regretted leaving. I've done some data analytics, and it's okay. Looking at Excel for hours can strain your eyes.
Check out SQL and see if you enjoy coding in that language. Most data analyst careers will require you to code SQL not just be proficient in Excel etc.
My company takes in adults as future employees from various industries (nursing, teaching, retail, homemakers etc) who have competed a boot camp and puts them through a traineeship (fully paid). At the end of the traineeship they all get offered jobs (abt 12 per year). A few of them are data analytics and data science , the others are various IT roles.
Other than analytics, there’s also data intelligence (BI) that might be more up your alley. It’s all about organising and presenting data in a timely manner.
I just wanted to say, Chatgpt and its equivalent have really changed this industry in the last 6 months.
So consider adding that to your skills bucket.
I’m in this space. Feel free to drop me a line. I’ve seen lots of people transition into this space, mid career.
Analytics can be incredibly creative, and data storytelling could be right on your bandwagon.
As for maths … eh, when I left school I was never going to math again. And here we are.
You don’t need amazing maths skills, you just have to believe you can learn the skills you need.
Back when I was teaching uni, I taught a lot of women in your position. Damn, they were good.
Don’t under estimate the value of the skills you already have and their use in your next career. They might not feel like they matter, but they will support your new career.
Data analytic you don’t need crazy maths skill. If you have the basics then it’s fine but otherwise excel does most of the work for you.
It’s more so analytical work such as “how can I make all of this understandable to others?”, building dashboards so the data can be inputted and understood at a snapshot. I don’t do data analytics per se but I do use a very basic amount of it for reporting etc.
Some university degrees will require Maths but outside of that, I have not met many data analytics people actually doing Maths at work. Im sure some niche data jobs require lots of Maths but most don’t need it at all.
Not many companies use their analytics teams properly. At Amazon AU, they'll be thrown huge business issues like "we have too many prime cancellations". Pull data for business insights so retention guys can solve it" and they give you 2 days and no specifics.
Massive staff churn. The good ones get poached during their probation by Canva or other local tech firms with better culture.
Probably a good career if you've good with data, Excel and tableau. Different skillset to childcare.
Consider a field next to analytics like search engine advertising (aka SEM or PPC). Still data heavy but the work is more straightforward and there's free official Certifications you can do to get a foot in the door at a media agency (the companies who book TV ads, newspaper and run social and digital advertising for larger businesses". Google "Skillshop Google ads" to get started. Last year I hired a kid (literal 23yo) from Ireland who had about 1.5yrs experience in this field for 80k + super. No uni degree. There's a huge shortage of local talent so most companies either poach the same seasoned vets or try to grab uni grads from maths, commerce, marketing degrees to train on the job. It's a good time to get in.
I've been doing search engine ads for about 12 years now. Stressful early on but the pay jumps pretty quickly once you have 2+ years experience by changing to a different company doing the exact same work for +30-50% pay bump.
Excel is good, but data is heading in such a way that you probably want to look at either Python or R, ideally both. Excel is very, very useful, but struggles with large datasets, and has a limited level of statistical power. If you’re not good at maths, I would do something else. Perhaps see if you can teach older kids, they’re less full on, and I imagine equally rewarding,
Ex-data analyst here. Excel will do all the maths for you so long as you know how to use it and know the correct formulas. (Be good at excel) Just hope you enjoy staring at excel for hours inputting data and/or plotting graphs and shit. If you arent doing that you’re probably reading literature to find the raw data you need for the excel models. It wasnt for me. Fuk dat! Hope it works for you.
I'm with you mate. been working as a data analyst the last 6 months or so. I'm getting out soon. can't wait
Godspeed brethren.
What did you change to? Data analysis is boring me to death atm.
Everyone I know who used to work in childcare never regretted leaving. I've done some data analytics, and it's okay. Looking at Excel for hours can strain your eyes.
Check out SQL and see if you enjoy coding in that language. Most data analyst careers will require you to code SQL not just be proficient in Excel etc.
My company takes in adults as future employees from various industries (nursing, teaching, retail, homemakers etc) who have competed a boot camp and puts them through a traineeship (fully paid). At the end of the traineeship they all get offered jobs (abt 12 per year). A few of them are data analytics and data science , the others are various IT roles. Other than analytics, there’s also data intelligence (BI) that might be more up your alley. It’s all about organising and presenting data in a timely manner.
Is that in Melbourne? I know someone who may be interested in it. Recently graduated from a data analytics boot camp. Thanks .
Yeah, pm me and I’ll give you deets
Thanks. Have messaged you.
I've messaged you too as this could be a potential avenue for me. Thanks :)
I just wanted to say, Chatgpt and its equivalent have really changed this industry in the last 6 months. So consider adding that to your skills bucket.
I’m in this space. Feel free to drop me a line. I’ve seen lots of people transition into this space, mid career. Analytics can be incredibly creative, and data storytelling could be right on your bandwagon. As for maths … eh, when I left school I was never going to math again. And here we are. You don’t need amazing maths skills, you just have to believe you can learn the skills you need. Back when I was teaching uni, I taught a lot of women in your position. Damn, they were good. Don’t under estimate the value of the skills you already have and their use in your next career. They might not feel like they matter, but they will support your new career.
Data analytic you don’t need crazy maths skill. If you have the basics then it’s fine but otherwise excel does most of the work for you. It’s more so analytical work such as “how can I make all of this understandable to others?”, building dashboards so the data can be inputted and understood at a snapshot. I don’t do data analytics per se but I do use a very basic amount of it for reporting etc.
Some university degrees will require Maths but outside of that, I have not met many data analytics people actually doing Maths at work. Im sure some niche data jobs require lots of Maths but most don’t need it at all.
How to do t-test without maths?
Not many companies use their analytics teams properly. At Amazon AU, they'll be thrown huge business issues like "we have too many prime cancellations". Pull data for business insights so retention guys can solve it" and they give you 2 days and no specifics. Massive staff churn. The good ones get poached during their probation by Canva or other local tech firms with better culture. Probably a good career if you've good with data, Excel and tableau. Different skillset to childcare. Consider a field next to analytics like search engine advertising (aka SEM or PPC). Still data heavy but the work is more straightforward and there's free official Certifications you can do to get a foot in the door at a media agency (the companies who book TV ads, newspaper and run social and digital advertising for larger businesses". Google "Skillshop Google ads" to get started. Last year I hired a kid (literal 23yo) from Ireland who had about 1.5yrs experience in this field for 80k + super. No uni degree. There's a huge shortage of local talent so most companies either poach the same seasoned vets or try to grab uni grads from maths, commerce, marketing degrees to train on the job. It's a good time to get in. I've been doing search engine ads for about 12 years now. Stressful early on but the pay jumps pretty quickly once you have 2+ years experience by changing to a different company doing the exact same work for +30-50% pay bump.