I am currently working in advisory and am looking to transition into a data analytics role. I have a math degree but feel under qualified for even an entry level position. Are there any trainings or certificate programs anyone could recommend? Or advice in general for entering this field?

likehelpful
Posting as :
works at
You are currently posting as works at

Start with the John's Hopkins Data Science Specialization on Coursera (few weeks).

If your Excel skills are non-existent, find a class on Udemy (short is fine, but practice whatever doesn't come naturally).

For SQL, find a course on YouTube or LinkedIn learning (just a few hours on this one) and then pour much longer into practice: Leetcode, HackerRank, Oracle Dev Gym, whatever else you can find (practice daily; SQL is basic, but you REALLY need to have the syntax down).

Python, I suggest a bunch of bite size courses on Data Camp (a week?). If you know a little about data structures and algorithms, do leetcode easy problems for practice. If not, do the daily drills Data Camp has after you finish a class.

Read about good data viz. Tufte is canon, but I recommend Storytelling With Data by Knaflic which reads very quick. Get Tableau (free student license?) and practice with it on whatever data.

Finally, practice hands on start to finish analysis from cleaning up initial data to making a deck with viz and a dashboard. Benchmark against the most informative presentations you can find, and don't forget a little "wow" factor. If you have an interesting meta topic or just something nifty, share it with us too for applause and optional constructive criticism 🍻

likehelpfuluplifting

Connect with folks in lighthouse. Math degree gives you insights into statistics. If not, think about data science/statistics courses that will give you basics of modeling. That's what they primarily do in lighthouse. But Analytics goes beyond modeling

like

You should try to transition over to the Workday practice and get Prism Analytics certified. We have been selling tons of work but we don’t have enough Prism certified folks

like

In a softer tone, I agree with KPMG. Workday modules are great to learn if you just want job security and implement the same thing at every client. However, if you wish to answer problems outside of the box, then I’d highly advise against it. Was one of the early workday consultants in my country and I spent years to pivot and get out of those golden handcuffs

Probably best to reach out to the folks in deal advisory strategy analytics aka the old SPI team. Much of the deals they're on are related to FDD and strategy deals. They use many different tools to solve complex business problems. Not as heavy as lighthouse, but the things they work on are very approachable for people with a basic understanding of analytics.

like

What’s your level? Try getting on a project first, if you can. I worked on several then made the switch.

The switch to LH that is, as a D&A Modeler

Related Posts

Anyone looking to switch careers to a Marketing role with a leading Medical devices company? Looking for someone with 1-3 years experience in strategy and operations consulting. Please DM me

Can anyone brief me about interview process in JP Morgan for Analyst position? Also, what is role hierarchy in this organization? Salary range for Buisness Analyst - Associate ?

like

What roles have you seen ex-MBB Managers take when exiting to PE? Anything other than Ops roles? What is the typical compensation range?

like

My biggest mistake was accepting a promotion to manager, it made me realize that I'm not very good at managing people. Should I ask if I can go back to my old role?

likefunnysmarthelpful

Any reviews about Fractal Analytics Senior Consultant Job Role
Work Life Balance & Work Pressure reviews ?

likeuplifting

What do you all think the odds are that China invades Taiwan next? I have a few thousand in NIO and am down... really hoping to get out of my position when I'm positive and move it to TSLA. Starting to become fearful that China will invade Taiwan before Biden is out of office and my NIO position will get destroyed...

like

Hello all, I’m excited to starting a new position in SF soon and am currently apartment hunting. Roommates seem like the move. Anyone have tips for finding roommates in SF?

like

I've completed the final rounds for 2 companies: AWS as an L7 Principal PMT and another that's a Series-A funded startup in the HCM space. I expect offers from both: AWS around $400k TC ($250k base + $150k stock) and the startup should be around $300k TC ($250k base + 20% bonus). If comp wasn't the ONLY consideration, what would you do? The AWS role will be an IC role and more hands-on/technical. The startup will be a CPO role reporting to the CEO with a team of about 50 devs+PMs.

I got a call for a Java position. I told them I do not develop in Java. I do JavaScript with React. He says “oh yes, that is what the client wants”. So I sent my resume. When he sent the confirmation email it stated Angular/Java. I told him that I don’t have much Java skills. He then sent this (pic) as a response. 🤔🤔🤔
When I spoke to the client she had no idea why the recruiter added angular react as it was just a Java developer position, Completely wasted so much time

Post Photo
likefunny
like

What's the expected job role for manager 1 in pwc ac Kolkata in advisory los . Is it equivalent to team lead or anything else ?

like
like

Where does Senior Manager fall in terms of hierarchy at Booking-com (Amsterdam)? What is the expected total compensation for SM role at Booking (Amsterdam)?

like

Have second phone screen with hiring manager. Any advice on what to expect or tips?

like

Who is hiring producers 🙂

like

R&D Tax vs Fixed Assets Tax, which is better in terms of exit and growth opportunities?

like

Time taken to become a partner in any of Big 4's?

As per my knowledge in EY it is 15 to 20 YOE

Hi all, I am currently serving notice period in SAP. I have one year of experience as a Java backend developer. I need referral in any company urgently as I had to resign because I couldn’t relocate to Bangalore due my mother’s health issues. I am open to work remotely or ready to relocate to delhi ncr. I have knowledge in Java, Springboot, MySQL, Git, Docker etc

like

Hi All,

I am currently in SAP profile, m interested in HANA but right now m in BODS admin support role which i dont like. m also not getting any calls or offers, m very frustrated. Now m learning python and luking to chng domain. plz suggest/guide if i m on wrong path.

like

More Posts

Do you mention who your clients are in interviews? I can never tell what the right way to do this is. I usually say something along the lines of “a large client in X industry/vertical” because dropping the client name feels tacky? But at the same time, my main client is niche and knowing who is kind of vital to understand the work.

like

I didn’t got the bonus mentioned in the increment letter. Only increased salary. When do we get it?

like

I’m a Max fan, but gotta say Lewis is a true sportsman.

like

Anyone have experience in selling capitol equipment? Looking to change industries into aesthetics and selling equipment, so any advice is welcomed! Currently selling commodity items so not as lucrative. Thanks!

like

I have an aptera reservation. Anyone else? I’m hoping it will be really fun to drive.

like

Can we negotiate notice period just for 3 days ? My next company is asking me to join on July 18 but my lwd in Mindtree is July 20...

How tough is it to break into a FAANG PM role at mid-level if you have less prestigious experience? I have 10+ YOE in product, but some was at a tiny meh startup that fizzled out, some was in the digital wing of a large old healthcare org, and though my current role is GPM at a “name brand” tech company, it’s on the smaller side. Went to a good-but-not-Ivy school. What qualifications and experience are FAANG companies looking for when hiring mid-level PMs? Can I break in at mid-level from here?

like
like

Has anyone here successfully exited to pharma after 1-2 YOE? Currently an SA at a small NYC market access firm with a wide range of projects under my belt for big pharma clients. I'm anticipating a promotion to AC perhaps this fall or winter, but I'm at a crossroads where I'm not sure if I want to continue consulting to the actual consultant level. Currently make $100k with a 10% bonus, would I even get a higher salary in industry at this stage? Also might be worth noting I have an MPH. Thanks!

like

What is the best tool for hiring teachers?

like

Looking to switch from IB to FP&A or Corp Dev. Anyone willing to refer?

like

Good maternity clothes for work???

like

3 Audible Credits to use before I cancel my subcrtiption. Looking for book recommendations.

And, go!

What AI tools should one consider for tech recruiting ? And has anyone heard of Celential AI

Would really appreciate everyones feedback.

like

Is Manager in FIL same as AVP in HSBC or similar investment bank.

Global logic or TCS

like

Anybody from Oliver Wyman in Toronto willing to chat? Thanks in advance!

like

Best wallet for my hard earned TRX?

like

Potential new job is flying me across the country….for a one hour interview. Red flag? Or just a formality since they want me to relocate so I can see what it’s about?

like

DM me if anyone interested for the below openings.

Post Photo
like

Additional Posts in Data & Analytics Consultants

Hey all. Question regarding Presto SQL and Arrays.

I’m working within a Presto DB and the column contains a nested array. I need to pull out the 3rd item of each array. Does anyone got any info on how to approach this?

like

I’m interested in going back to school for an analytics degree. I have a math & stat undergraduate degree and have been doing data science in my projects. Does anyone have recommendations for...

like

Does anyone work for a company that is paying for them to get an MS in Data Science or Business Analytics? If so, where?

like

what do you talk about in your 1:1s?

I got lucky and now have leadership that seems to care about my career growth, but I'm 1. a little overwhelmed taking over a new role from someone who went on parental leave earlier than expected and 2. not used to thinking outside my day to day job, happy to keep my head down and just produce good work.

most of what I bring up in these meetings are logistical or prioritization concerns but I feel like my manager is expecting a lot more from me.

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

AWS big data specialty exam worth taking? Does it involve any coding?

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Back end or front end?

Post Photo
funnylike

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

DC folks: how’s Clarabridge (company)? Thanks

Thoughts on the below role?

Got messaged about an analyst job doing the preliminary discovery stuff including dashboards. But not for the business, but to give recommendations to data scientists about where to focus. Having been a modeling DS, I can't imagine why I'd outsource exploratory analysis. Anyone seen a team like this before?

Also worried about career prospects. I've been wanting to turn business facing, but becoming the only DA on a DS team seems like it'd be a dead end with promos?

like

Anyone in here know much about Georgia Tech’s OMSCS or OMSA programs (Online Masters in CS or Analytics). I’ve been doing a lot of research and may pull the trigger on doing OMSCS part time. Talking to a team member soon about it.

like

Interviewing for a deals analytics role at EY- the interview day will include time with a partner, a senior manager, two managers and a 3 hour case study. What should I expect?

Anyone heard of the Math company Analytics start up? They just got $50m funding in January? Good company or not?

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

Would recommend data engineer or software engineer for pay and growth potential?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal