{ "media_type": "text", "post_content": "Interview for a Data Analytics consultant role and have been told there will be white-boarding exercises. How would you prepare for this? I’m guessing it will mostly be SQL but don’t want to assume.", "post_id": "5e1a038e72cfa2001a706b3a", "reply_count": 4, "vote_count": 1, "bowl_id": "5ace5097be6e660013abcc42", "bowl_name": "Data & Analytics Consultants" }

Interview for a Data Analytics consultant role and have been told there will be white-boarding exercises. How would you prepare for this? I’m guessing it will mostly be SQL but don’t want to assume.

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

Sql, python. Do online modules, get comfortable coding without seeing the data.

like

Maybe some basic python? Also we do a dashboard white boarding exercise, along the lines of giving a basic request and schema, ask clarifying questions, lay out your assumption, write some sql and then mock up a rough dashboard

like

Thanks! They do do some dashboard work so I could definitely see this being a possibility.

Which company is this for?

Related Posts

like

Can anyone share what the interview process looks like for Google Professional Services? I have a recruiter phone call coming up soon ? I have 10 years of consulting experience

likefunny

The project manager and recruiter reached out via LinkedIn and suggested to apply for a opening position as they thought I was fit for this position, filled up all the application and later the same recruiter reached out saying they are moving forward with other candidates 🤦‍♂️ why waste people’s time?

like

Best exit for experienced Healthcare FDD manager? Ideally looking to maximize WLB, while maintaining relatively competitive compensation.

like

Took all rounds of interviews and had successful HR discussion,shared my documents to them but it's been very long time didn't heard back from HR. this happens to me for 4 organisation in last 2-3 weeks of time period. I am still waiting. For how many of you guys this things has happened and what happened with the offer in the last?

like

Is it recommended to stick with a traditional suit when interviewing for various industry positions? I am a female. Appreciate any input!

like

Any books/self help materials for someone who is constantly worrying (and waste a lot of unnecessary time)? E.g. No matter if i pass or fail an interview, there is always something to worry about. The worrying/anxiety multiplies when I proceeded further in the interview stages. Now that I signed the offer and is pending background checks, my anxiety is off the roof as it itches closer to my starting date.

like

Hi I'm an electrical engineering student looking for an internship. Can someone help with a referral

like

Exit opps for someone with deep expertise in supply chain planning at the SC level? Exp in process design, system implementation, advanced analytics/ report building across several industries.

like

What is your reason for leaving consulting that you tell companies interviewing you? I’m not sure I want to use burnout as a reason and would defer to travel but that is nonexistent.

like

About to lateral to another V10 firm, being brought by two partners moving there from my current firm and doing transactional PE work. Would welcome any tips on who to speak to (and when) to negotiate signing bonus/class year bump. HR? Interviewing partners? And also, what is reasonable to ask without starting on the wrong foot?

like

☝️What's your best hard-earned advice for someone interviewing, job seeking, or negotiating a salary? Drop it below! 👇

like

Has anyone worked for or interviewed at Zenda? I have an interview as a Sr PM and would like to know ahead about culture, pay, benefits, etc…

like

Hello Fishes, Does anyone know the grade hierarchy at Optum? My candidature is in process for Security Engineer Consultant role within Optum. Can anyone suggest which grade level does it belong and what is the salary bracket at this level?

likehelpful

Recently got approached by a Natural Language Processing (NLP) company for a sales engineer position. What is everyone’s opinion on the viability of this area in machine learning? Any legs or future prospects?

like

Hi folkes.. how much are Principal Software Engineering Manager paid on average? Base pay for cities like Atlanta Microsoft 10 years of experience,. Thank you. Any tip for the interview process? @microsoft

like

Up for promotion at a media agency. What should a Vice President, Digital Business Development, be making in NYC? It’s a Biz Dev focused role vs client services. Help, please :)

Additional Posts

Hi All, does anyone here work at Google or Facebook and could provide a referral? I know it’s a long shot but I’m aiming for growth marketing/partner management roles. Background in paid media, SEO and affiliate marketing at agencies and client side. [Google + Facebook]

like

McK 🐠, I received an offer to join as an Associate (yay!). Is it normal to have a fixed dollar performance bonus in the contract, i.e. you may be eligible for $xk (or more or less pending performance)? And is 10% too low? TIA McKinsey & Company

like

Apologies for the dumb question but what exactly does partner mean in today’s world? In olden times it would have meant you were a partial owner right? Does it still? Or does it just mean extra highly paid employee with a lot of leadership responsibilities? We don’t use the term at Accenture of course since we’re public, but I’m curious what it really means at b4 or MBB, beyond just extra high paychecks? Are there actual partner benefits, like owning private shares of the company?

like

Can any Deloitte fish tell me about the Application & Program Analyst position? I’d love to chat and a possible referral

helpful

Hi guys, I have an offer from Axtria. Can you please let me know the work culture and job security in this organization. I know WLB is a concern here but is it worth puting in that much effort. Also, have not heard good reviews about management.

like

Just got fired from RSM. I have a final interview tomorrow, do I have to disclose this information to my new employer?

like

For those who got fired, what were the reasons given?

like

I’ve heard the recruiting strategy at lots of firms is changing from MBA to experienced hires and PHDs. I see that is true at MBB but what about Big 4 and smaller firms?

like

I'm in my 30s and have spent 10+ years in the industry on production/account related fields. I have a good job that pays ok, but I'm struggling to find the drive I once had. I feel like I have zero love left for advertising and if I have to deal with one more of client's completely unrealistic asks I'll snap. Anyone out there have any recommendations on how to handle burnout if you are someone who's life has always been very career driven?

like

Thank you notes after an interview with ECD / GCD / whoever the final decision maker is - are these done still? Haven't interviewed in a long time and unsure of it's still important (I'm freelance).

like

Average end of year bonus for C1 and C2?

like

I’m considering quitting my job w/o another offer but do have several interviews lined up. Job has been terrible for my mental health and no time to interview prep. Anybody have experience w/ this?

like

Hi fishes Having 5 years of .NET fullstack development experience. Looking for job switch. Please let me know if any referrals or openings...

like

High(ish) performing staff to senior in transfer pricing. What can I expect in terms of raise?

like

I really don’t understand why some employers are going to force employees back in the office after they’ve proven to work just fine fully remote for almost 2 years. Is this worth losing employees over?

likefunny

Thoughts on exiting MBB to revolut? Seems like culture there isn't great, but RSUs could make it worth it?

like

Wonder what the discrepancy in salary was between these sexual predators and their prey... #timesup

Post Photo
like

When you’re on point to lead a call, and your manager is on the call, is it normal for them to constantly “add points”/interrupt you every minute? I’ve had a couple managers and noticed that every one of them that did this, didn’t add any value beyond what I was saying most of the time. On the contrary, when I had SMs or MDs on the call, they never interrupted.

like

Culture question. I’ve always been environment where you get your work done, bill your hours, you’re good. This new job is focused on hours in the office. Is this normal? More in comments

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
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

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal