What are the most important skills I should pick up to transition to an Analytics/marketing science role?

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

Excel: Pivots, Vlookups, cleaning data, Sumifs, other complex formulas. Also in general getting good with viz and shortcuts - comes with practice

SQL: Queries, Conditionals, Joins, and pretty much the grasp of the concept of how relational database works. What a primary key and foreign key is in a table. Etc. SQLBolt and W3Schools are good free online ways to learn

Outside of this is deeper programming, such as Python, SAS, and R for stats related topics. Things that may not be especially required if you’re going into a general analytics role less focused on the science. Otherwise, its aaaalll the soft stuff. Getting the big picture, telling your clients the “3 things” they need to know, and making them care about what you have to say

like

Program skills: excel, UTM program (most likely GA), some may require SAS, if digital or social - specific platform knowledge

Generic skills: trend analysis, big picture thinking. Nobody wants somebody to just read off how something performed. Learn to dig deeper and see what business implications are

Those are two very different roles and what in Analytics do you want? To be honest you will be limited if you don’t get an advanced mathematics degree. Someone with a PhD will always beat you out once you get into a sr. role.

Related Posts

I have an interview coming up for internal audit manager. Currently in external audit. When asked about my experience in ERM - what would you say Is transferable skills that I can leverage in my answer?

like

Over a year ago, I lateraled from a firm doing mostly land use/development to a volume lender debt finance practice. By volume I mean I’m on 15+ deals a day. I don’t think this is for me….anyone have any other CRE practices that they enjoy? I’m thinking about jumping back to a borrower side practice, but curious to hear about other CRE associate experiences. Thanks!

like

Asking for my sister, she is considering going to georgetown law for taxation LLM. Just curious on how mathematically intensive the course is? What are the job opportunities? Thank for your help

like

Hello!
I’m a student majoring in Software Engineering. I’m starting my third year in a few months and have an internship where I’m learning more about working with an actual team on real-world projects. However, I feel like I need to do more to stand out and have a stronger software background. Anyone have any tips or suggestions for what I should do on my own time to strengthen my skills?

like

Hey looking to shift to healthcare consulting from pharma/academia and wanted to see if anyone had any advice

like

Any audit senior 3 and 1st year managers here? What positions are audit senior 3 and 1st year managers leaving big4 for?

One of the reasons I want to transition from industry to consulting (tier 1) is that I get frustrated when I have to collaborate with mediocre people. My assumption is that Tier 1 consulting firms hire really sharp people and if I can get in, I’ll be collaborating with folks on top of their game (not expecting much from clients). I’m aware there are personal aspects I need to work on like my mindset, patience etc etc, but I just get so frustrated with blatant stupidity.

likefunny

Currently in IBM at Band 9 (Austin,TX) and getting around 195k base. Just been approached by EY recruiter for Senior Manager position. Wondering if I should consider exploring it or not! What could be pay range for a Senior Manager in EY? Also, what career level of IBM is it equivalent to ? (Band 9 or Band 10)?

like

LA! Hiring mid-level CWs and ADs! Must have video prod. exp. and be very conceptual.

Solos and teams apply!

LINKEDIN ME (I’m bad at fishbowl)
Samantha Schneiderman (director of creative services)

like

I am offered a role with S&p global, salary negotiation yet to have.
Can someone please tell if s&p global is recession proof or not, I’m planning to join only if i get job security
I have offer from lti paying me 12 on 3.5 yoe??

LTI Information Technology Deloitte PwC IBM S&P Global

like

I’m an L&E associate entering my 5th year at a mid-sized regional law firm (approx. 400 attorneys). Barred in PA/NJ. Billed 2100 last year but my requirement is 1950. Should I try to lateral into BigLaw or should I try to go in house? Are either of those realistic options for me? I seem to be doing a significant amount of municipal law too, which is not what I expected or wanted at all. I want a life but would also hate to take a pay cut. Interested in L&E. Advice?

like

I am starting a new job where I will be investigating sexual discrimination cases. Employment law will be a new practice area for me. Do you have any recommendations on good learning resources? Any treatises?

like

Can I start learning DSA using JavaScript to get into product based company from service based ? Or I need to learn other language first like C or Java and then learn DSA in that ? I am working as a Frontend developer so I already have knowledge of JS. Please suggest how to proceed ?

like

Is there any issue, if the designation at the time of offer is different than that of relieving? Asking because, I am leaving IBM GBS, have told my designation as Senior software engineer ( offer letter had it) to the other company, but got to know that designation IBM will be writing on relieving letter will be application developer. IBM

like

I really need advice. I’ve been in my current role for a couple years and I’m just so defeated. I am good at my job. I work so hard and I’m so undervalued and unappreciated. My work is scrutinized to a degree that no one else experiences (I could give concrete examples of other people delivering design work that haven’t met BASIC design principles and it’s gotten approved) compared to me where I frequently get feedback that somehow makes my work worse but I just comply because it’s not (1/2)

like

Hi Everyone

My younger brother is in final year BE,
He wants to pursue data science, please suggest any best place to learn n do internship.

Thanks in advance

like
like

Bain & Company Hello folks, I’m a CA with 6years of experience in Risk & Compliance and Statutory & Internal Audit.

Can anyone help me with a referral in Bain at Gurgaon location?

Bain & Company

Is it worth it to go back to school for a better track to a FAANG company? The division I’m currently in seems like there are no good opportunities, and I have the funds available to finish my undergraduate full time (Canada). I applied to Amazon before for a highly senior position and made it to final interview so I think I would have a better chance for a new grad type role.

like

Hi ,

I have 5 years of experience as a .NET Full stack developer. I am holding offer of 21 LPA and I had HR discussion with Mastercard.

HR is not ready to share the exact budget they have (weird!! because HR usually give the idea of how much they can offer )

HR is asking me to expect something on top of the current offer I am holding.

The opening is for L8. How much offer I should expect from mastercard??

like

More Posts

Looking for advice. I have a few offers in negotiations for Senior IT audit role. My main motive is to get out of toxic work culture in B4 consulting and public accounting. Looking for better wlb, better work culture and decent compensation to make good living. Currently in TX making around 110K TC.

1. Children’s Place: Base-110K . Probable bonus of 3-5%. No relocation assistance or sign on bonus. Based in NJ. Location is closer to all my friends and family
(Continued)

like

I have code pairing round for data engineer profile.

Please can anyone provide me with heads up.
I'm really looking forward to join TW.

Hi Fishes, can anyone tell me how is Infosys Consulting in Financial Services domain for a consultant role?

ThanksInfosys

like

Hi everyone!

After years of hard work, I just got my first position in a leadership role! Yay! I’ll be leading a team of 12.
I wanted to know if you had any tips for me, things you wish you knew before, or things previous leaders did for/to you that you found admirable or stayed with you. I want to make sure I’m there for them and want to be a leader they will remember positively.

Thank you so much!!

like

As it’s been getting colder I’ve been dabbling in soups. This is a brie and mushroom soup paired with balsamic onion & mushroom toast. It was super tasty and really hit the spot. It can also be used in place of cream of mushroom from a can in recipes if you’re looking for a different taste.

Post Photo
likeuplifting

In TCS,After completing onboarding process and getting ur employee Id ,what's the process to get tagged into any project.Can you please share your experience?Can we reject any project if we don't find it not aligned to our expected work ?

like

KPMG fishes and the sharks of the industries,

If anyone can help me in understanding that what is DT CDSG in KPMG? Have seen this query many times here but still waiting for responses.

Your thoughts and inputs are appreciated,
Many Thanks!

KPMG Deloitte PwC EY Accenture Infosys IBM

like

Interviewed for a GS-15 (same agency but different office) and totally aced the interview with excellent answers. They know I’m a top performer with senior references. However I noticed there was an internal candidate who has been there for few years and interviewed that’s a veteran. I feel my chances just sank and want to gauge thoughts.

like

Anyone knows how much we can ask for accenture level 11 role with 4 years experience. Cctc is 5.2 ? Analyst role

like

The Albertsons (Jewel) and Kroger (Mariano’s) merger would be terrible for Chicago. I doubt antitrust will allow them to retain all stores here. Maybe a player trying to enter the region will buy out those stores.

like

What are some good commuter towns outside the city for first time property buyers? Ideally commute by rail.

like

What’s the best answer/action when a partner asks you for a deliverable but it’s been sitting for manager review for a couple days?

like

Hey guys, Can anybody tell me how much time does it takes the location to be updated in Accenture. Its already been 3 weeks, and the Hr has no update regarding the same.

Hi all,

Are ppl eligible for VP to be announced in November end if they joined accenture in May 2022? Please help me understand

Hello Fishes, Can someone please help me with a referral with an Investment Bank or financial services ?
Work experience -2.5 years experience
CFA level 2 candidate and MBA in finance
Help with a referral please

like

Any Ramboll fishes here!!
I need your help for a referral. I have the job I'd. Can anyone please help

like

Anyone wear open heart or skeleton watches? Post your pics or ones you’d like to own! (Maybe not everyone post a tourbillon)

How do some agencies take all the awards yearly while others get severely shafted?

like

Engineers who work entirely from home, what kind of work do you do?

like

Huge delays in biometrics

like

Additional Posts in Advertising

I've written nearly all my friends' Tinder bios. And they're actually getting more matches. Definitely gonna put that shit in my book.

like

If I’m 6 years in, and the stars haven’t aligned for any (real) awards yet, am I screwed? I’m making fun work but am at a shop that doesn’t prioritize awards, how do I get into one of the greats?

like

Need to update my LinkedIn page. Anyone have tips on the best things to call out? Clients, projects etc?

like

If the open office concept is so great for collaboration why does everyone wear gigantic noise cancelling headphones to try to ignore everyone around them?

like

Just got laid off do I need cobra? I plan to hopefully have a job soon

like

Finally wrote the 3 social scripts 2 hours before they were due when I was briefed over 2 weeks ago, what are you doing?

likefunnyuplifting

Laid off, 10 years exp, tired of acct management. Feel so lost. Don't want to go back to agency side. What should I do? I feel like 💩

like

Raise your ✋🏾 if you’ve noticed morale at Fcb Chicago heading south...

like

I’m looking for some new things to read or listen to — doesn’t need to be ad-related. Books, podcasts, whaddya got?
I’m not really into fiction, but open to anything. Last books I enjoyed were Junior and Moonwalking with Einstein, last podcast I binged was Startup (Gimlet).

like

have you ever accepted a job you were maybe underqualified for? how did it work out?

like

Is anyone else unable to change their title on comments? It switches to my company and won’t let me change it to anything else.

like

Dear Creative Directors who’s only talent is showing up to meeting with a full repertoire of buzzwords, die slow. Thanks, everyone.

likefunnyuplifting

Anyone hiring any jr/mid level art directors in New York?

like

Cool job offer for AD

Post Photo
like

Have you ever seen a client fired in mid-production?

likefunny

“have fun with this brief” they say before telling you the client is pretty conservative and needs to have safer options.

i know we don’t always work on stuff we’re thrilled about but i’ve never dreaded reviews for a client before until now

like

Shoutout to account peeps ready to explain why, actually, it isn't that much work and, actually, EOD tomorrow is plenty of time.

like

Why do people in this industry say "like" so much? It makes it annoying to, like, walk around the building and listen

like

Why do companies do this? I interviewed with a company. They loved my work and told me that I’m going to start the following week. They made me sign all of the onboarding papers and poof ghosted me! 🤦‍♀️ I feel so down right now! And I feel like I won’t be able to ever land a job!

likehelpful

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