Hey guys. Was laid off as a generalist consultant last month. My eventual goal is to get into data analytics and data science. At this point I’m really good with excel and have some working knowledge in both SQL and tableau. I feel kinda lost still, what should I be learning specifically? I’d love to chat and learn about what you guys do and a bit of mentoring (if you’re up for it). Thanks in advance!

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

Learn python

likehelpful

I second Python... add learning R.

like

Doing proper analytics, viz and building models are just one half of the picture. If you really wanna have influence in orgs and get models into production, you need the business process / it side of things as well. The latter skills are common in consulting, but just make sure you can translate analytics into action, otherwise it risks falling flat and not delivering (speaking from experience)

like

Absolutely. Thank you!

Once you get your hands on python and tableau, spend some time building your portfolio. For tableau, you can check out makeovermonday, prepping data Monday and workoutwednesday. For data science, you can consider working on some mini projects and write about them. Gives you a little headstart and a better understanding. Holla if you need anything else!

likehelpful

Thank you!

Excel then SQL then python. Tableau is also useful. Within python you can go in so many directions, visualization, data cleaning, machine learning, statistics, web scraping, etc. i’ve done online courses from multiple places, and I like Udemy. It’s not quite as official and pretty on your LinkedIn as other places, but it’s cheap (there are always sales) and as long as you stick to the courses with thousands of reviews and students you’ll be fine.

like

General rule for UDemy is always buy on sale. It should be rare to buy a course for more than $20 - and you always get a lot for your money!

likehelpful

Business/Data analyst type roles rely heavily on thought process, analytical thinking, Excel and SQL. Tableau as well, python skills would be an awesome plus. Data science requires all of the above with heavy emphasis on coding and tech skills as well as modeling experience, algorithms etc. Both will require industry specific skills as well.

You have a perfect foundation as a generalist in consulting.

If you are a newbie, data analyst roles would be a good starting point and work your way up to scientist role as part of career growth.

like

Yeah, I think I want to start with data analyst and move to data science at some point

Since you are on the market and want to find projects, try Upwork and see if you can find anything suitable entry level. Doesn’t make a ton of money but gives you the chance to make a few bucks and maybe do something totally random you haven’t done before.

Also if you don’t use alteryx yet, try to pair that with your SQL learning. Goes very well with tableau and also can invoke python code through one of the tools. Go after the free 14 day trials. Happy to send you starter python code

like

Will check out upwork and alteryx!

Get good at stats, beyond just the basics. SQL Python, R, tableau, etc are good to know but are just tools for the job.

like

If interested in a role in big pharma send me a dm?

like

Sent

Learn some math for sure. Not just surface level Statistics, but calculus and probability as well.

Khan academy has great explanations on foundation of math and stats concepts

Have any of you used kaggle to learn python? Would you recommend?

Kaggle is great for finding some interesting projects and datasets. I, personally, haven’t used it to learn Python but have used it to check out other DS’s and DA’s projects/code.

like

Related Posts

Has anyone gone back to school for their MBA? Did help further your career?

like

Will there be any layoffs in GDS?

Do titles in industry matter when exploring an exit? Which title seems better - Principal - Strategy or Senior Director - Strategy if everything else is equal.

like

I’m 27 & going to go to back to college for my bachelors. I have worked in the legal field for about 8 years & I’m burnt out. After a lot of research an thought I am leaning towards either architecture or interior design. I wanted to ask some advice from anyone working as an architect or interior designer. How do you feel about the field? What are the stress levels like? Do you enjoy it? Are you working at firm or are you working independently? Any info helps! Thanks 😊

likeuplifting

I have been looking at the curriculums for Harvard Business School's Master of Business Administration and Harvard Extension School's Master's in Management. They both have the same requirements, generally speaking, including a field immersion course that serves as a capstone in the Master's in Management, which is fairly new. If I am not able to gain admission to Harvard Business School, but wanted a similar educational experience to become a consultant, should I attend Harvard Extension?

like

Got an offer from pwc in the data privacy role.
With 13.5 Lpa currently i’m at 12 and made switch on march.
Though my current company is an mnc but not that big and no work pressure is there, amazing work life balance. However, there is little to no learning and its very slow, the project is just starting and the client itself is not clear what they want. Do you think I should switch just because its a big 4. Please help me decide. Yoe -3.5

like

Anyone have a CFE designation and taken the test recently? Debating about getting it wasn’t sure if it’s worth it.

like

Currently doing Strategy Consulting. How is Revenue/Sales Strategy considered as a career move? Is it prestigious/important in tech companies and what’s the future path?

like

I currently work at Fidelity Investments in the call center. I want to move my career towards in person planning at a branch and there isn’t a lot of opportunity here at Fidelity to do that in my area. What are some other good firms to work for? I was looking into Merrill Lynch, Morgan Stanley, Edward Jones, and some others. Thoughts?

like

For TCS, if anyone joins as Systems Engineer Grade C1 with 3.5 years of experience, approx how much experience is needed to get promoted for IT Analyst ? And how much hike will be given?

Would you say being a partner is more demanding than being an industry exec?

Hi All, need your advice!
How often is it okay to switch organizations? I know this is entirely specific to a particular situation /circumstance but just wanted to know, how often should one change companies, without coming into scrutiny for the same?

My situation: after working with an organization for over 7 yrs, I've switched from the next one in 1.5 yrs and about to switch again after completing 1.2 yrs in my current org.

Skill: SAP functional
YoE: 10

like

Currently a Wealth Advisor for Citi but I honestly hate it here with a passion it’s the worst company I’ve ever worked for in my life and I’ve been in Wealth Management in the banking channel for over a decade. Series 7, Series 63, Life, CFP, ChFC, and soon to have my MBA with a focus in Mergers & Acquisitions. I’m look to enter another area of Finance at this point instead of starting over somewhere else from scratch, but not sure what direction to go. Interested in Investment Banking or M&A.

If you do two years as an analyst at one bank is it possible to lateral into an associate position at another, or would you be an analyst again? Not at a good enough platform to get into the type of Buyside roles I want. Unsure of next steps.

like

Equity research associate considering to pivot into IBD. Is this a wise choice? Heard ER is an exit for some of the IB folks out there.

like

New to IT B2B marketing. Any advice on how to educate myself with IT? Any classes, books, etc. that you recommend?

like

GS 2023 New Analyst Program. Is this a good program to apply for someone looking to start as an analyst? How easy is to get into this program or even GS overall? I have 1-2 years of experience and some Finra licenses if that can help me somehow. Looking for some opinions about the program. Thanks

like

Dumb questions but genuinely curious:

1) Let’s say you’re a recent undergrad candidate with no internships on your resume. What’s the deciding factor that you’re qualified for Advisory vs Tax vs Audit? Is it school, gpa, etc.?

2) Why can’t you switch from Tax to another SL without having to pull strings? I understand that there’s a difference in tax vs book experience but why does the Accounting field gatekeep other SLs? It’s not like we’re incapable of learning other areas.

like

Hey all! I have an interview with
Deloitte in Regulatory Risk and more precisely in their Investment Management Services team. I would like to know if anyone
knows what the job entails exactly. I keep hearing about people "fooled" into taking a job in risk advisory thinking it'll really be advisory while they only end up doing IT and Audit support (which I do not want to do).
Is it the case here?
Thanks!

like

Has anyone transferred to FDD in late manger years (M2/M3) from audit or accounting advisory? Has the transition been hard? Any advise would be appreciated!

like

More Posts

My brother is starting as an analyst at Goldman Sachs in Salt Lake City. I want to give him a nice accessory/piece of clothing as a starting gift. Any suggestions?

like

Can any one tell me what kind of projects does IBM have in its Whitefield office at bangalore.
Is IBM working in hybrid mode or mandating work from office ?

like
like

Can anyone help me out with a sample sales
territory plan? I’m looking to move from a fully inbound sales role to an external role managing a specific territory. This is going to be a change and a challenge that excited for! Any advice/tips would be most appreciated!

Has anyone gone back to school for their MBA? Did help further your career?

like
like

Will there be any layoffs in GDS?

Is montblanc’s horology legit? Might sound like a dumb question but I think of them as a stationary company first before a watch company

like

Hi,

My technical round has been scheduled with TCS for front end, angular developer position.

Can anyone please help me, which type of questions generally asked in this video interview.

like

How is the job security in accenture, i am switching to accenture on new technology which i learnt my self. I will try my best to.perform well, if i dont meet thier expections will i be put on bench or in PIP.
Exp 4

like

Hi All
I have 4.6 years of experience in Oracle PL/SQL development. Can someone please refer if there is any opening in your company?

Thanks.

like

Hello guys, Can anyone refers me for the role of manual testing or automation testing? I am an experienced candidate.

like

Does anyone have a set of consolidated LP questions to prep for Amazon? Thanks!

like

Anyone like Sexting?? I am married man but I enjoyed that...

like

Hi fishes,
what is the increment range at S&P global for software developers ? IHSMARKIT is soon to be merged with S&P global. So wanted to know if it is better to wait for the merger or make a move.

Payu

PayU is hiring Automation Tester with 2 - 6 Years of experience in Pune, Bangalore and Gurgaon locations.

Interested candidate can send resumes to yatin.chopra@payu.in.

Preference - Immediate joiners https://www.naukri.com/job-listings-Automation-Tester-PayU-Payments-Private-Limited--Pune-Bengaluru-Bangalore-Gurgaon-2-to-6-years-270522002907

like

Do titles in industry matter when exploring an exit? Which title seems better - Principal - Strategy or Senior Director - Strategy if everything else is equal.

like

I have been looking at the curriculums for Harvard Business School's Master of Business Administration and Harvard Extension School's Master's in Management. They both have the same requirements, generally speaking, including a field immersion course that serves as a capstone in the Master's in Management, which is fairly new. If I am not able to gain admission to Harvard Business School, but wanted a similar educational experience to become a consultant, should I attend Harvard Extension?

like

I’m 27 & going to go to back to college for my bachelors. I have worked in the legal field for about 8 years & I’m burnt out. After a lot of research an thought I am leaning towards either architecture or interior design. I wanted to ask some advice from anyone working as an architect or interior designer. How do you feel about the field? What are the stress levels like? Do you enjoy it? Are you working at firm or are you working independently? Any info helps! Thanks 😊

likeuplifting

I was offered a position at fidelity. Now when I trade on behalf of a client, will I get commissions for that trade?

like

Additional Posts in Data & Analytics Consultants

Has anyone created live dashboards via Data Studio instead of Tableau? Thoughts?

How did you ramp up into doing actual data science work at your clients?

I am early in my career (3 YOE), but I have a masters degree, cloud data science certs, and strong Tableau/Alteryx experience. However, it seems like a lack of experience doing actual data science client work is what keeps blocking me from landing on data science projects. Any tips?

like

I'm planning to transition to Data Science. What should be the key technologies that i need to learn and add to my resume to make this work?

Thanks for your suggestions.

like

Anyone works/heard of DMV Group? Mind if i shoot some questions about them?

Anyones firm still hiring entry level, under 1 YOE. In Chicago?

like

What are the dream companies to work for to pursue data analytics/ engineering jobs

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

Does accenture have proper data science projects? Seems like most of projects are pretty basic analytics, reporting, and/ or ETL

likehelpfulsmart

The longer I do this job, the more I want to accept a tech job... no travel, same / better pay, no annoying clients...

like

Looking for experienced Data Scientists and ML Engineers to grow my team. I’m head of Machine Learning and Data Science at one of the largest Fintechs. Shoot me a message if you’re interested. (ex consulting manager) Thanks!

like

What approaches have you used to enforce data consistency for ML services? System and conf tests can be written definitively for SW applications but it becomes challenging when Data variability exists ?

like

Anyone at Google willing to refer? I want to apply to a role I’m interested in. Thanks in advance! 🙏🏽 Google

like

What is your best advice for moving into data science without going back to school for a masters?
I have an engineering bachelors and my mba, and want to move into the data science and analytics side of things in the long term.
I’m currently in Strategy Consulting and I find it too functional and hypothetical/theoretical/ high level. Looking for advice on resources, timelines, skillets, building connections/network, things to consider, moving forward /path of last resistance, etc etc

like

Does anyone work at EY in their Decision Modeling team? Not asking for answers, but just wondering if someone is able to share what concepts I should be familiar with when prepping for the case study (i.e. do I need to know how to run an LBO or is a DCF sufficient)?



like

What kinds of models can I create for low frequency businesses?

I recently switched to a startup at a data analyst role and have been teaching myself about statistics…I found survival analysis models and wanted to try and implement one to determine our customer retention rate and eventually a LTV

The business I’m in is very low frequency (most customers use our product once a year, but we do have many users) and I’m worried this will lead to poor results. What other models do…

like

could i dm someone to criticize/suggest feedback on my resume? i’d like to believe i have good experience but unsure why im not receiving any bites

like

It’s been ages since I’ve taken college statistics. Can anyone recommend an online course where I can review and brush up?

like

Anybody interviewed for a data engineer role for Facebook? I have a SQL and Python coding interview next, any idea on what to expect?

like

Anyone in a non-technical analytical consulting roll?

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

Scan your QR code to download
Fishbowl app on your mobile

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