Prepping for Analytics consultant interview at Deloitte.
JD says 1+ year of experience for Tableu/power BI, R, Python, SQL, Access, VBA etc.

How tough the technical round could go ?
Considering I only have a very basic knowledge of all these tools, I am not sure if I be able to crack the interview.
Any tips for preparation will be helpful.
TIA

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

If its a very tech one, you are done. Those are not skills that you can gain overnight reading a bit.
It may vary from interviewer to interviewer depending what they need for the project or team, and how many other candidates they have, but in general, technical interviews can be very tough if you dont have the tech knowledge, there is no way to improvise when you have no idea.

like

You need to have done one thing end to end and have knowledge on other things with a commitment to scale when the time is right.

Have a good understanding of basic analytics concepts, explain how they are implemented in the tool of your choice.
Prepare one end to end use case - where you have built a dashboard or some data analysis that was complex. Anchor your responses to that experience. Be good as SQL concepts - type of joins and how to manage large volumes. We like people who have strong foundation and are willing to learn.

We know consultant level folks have experienced and stay within that range - giving you the opportunity to share your experience. Good luck!
Good luck!

like

Any resources that you would recommend to prepare end to end use case

Also if you have or are preparing for a certification - say it. Helps in tech eval.

like

Thanks @D1
This is really helpful.

What offering is this under? Analytics and Cognitive?

Correct!

Related Posts

Hi All, How many days do I need to wait to receive offer letter from @ Wells Fargo. I have submitted all required documents. How can I know the status?

like

Who all agrees PWC is full of toxic interviewers who just come to satisfy their ego & pass the frustration

Is it same with work culture too ?

like

CFGI offers anyone recently? Consultant level NYC what did you get offered

like

Hi Fishies, I was hired for wealth and asset management project EY . It is capital market domain. Any body have any idea about this project going on in EY and the tools used for it.

Please advise if anyone have idea about it.

Just want to know any global tool they use for wealth and asset management, so it's a plus for me to join.

Thanks in advance

like

Is AlixPartners healthcare or Alvarez & Marsal HIG recruiting now?

like

Does tech mahindra provide sabatical leave to employees for higher education?

How is the KPMG client in wipro? Anyone working for KPMG in Wipro? TIA Wipro KPMG

like

I have an offer from Wipro for apple account as Lead Engineer (Site Reliability Engineer). Can anyone tell me how the project is for apple account? Does they have on-site opportunities for Wipro emplo… more

like

How was work from home in Deloitte before COVID?

like

Hello fishes of LTI!
How is WLB in LTI. I am joining LTI next month currently working in Capgemini. WLB in Capgemini was good. Can I expect the same in LTI?

like

FTI Senior Director base + bonus in NYC?

like

I have one query, i received survey mail from ey gds regarding joining date and location preference, so it mean iam selected or any other round happens? Because i give self recorded video interview on 7th feb and i recive survey mail on 7th March which i filled on same day and in joining date there are two options 25 March and 25 April ,wheres i select 25 april but there is no communication after survey mail so what should i do?

like

What is the expected salary for a Director of Platform Strat position at MasterCard based out of NY?

like

Hi there fishers!!
Can I get a referral or a job opportunity from your end?
Can I DM you with my resume??
(Please!)

like

Does anyone know about Sage Group? Seems to be a boutique firm but not sure about their culture and overall dealflow in the market.

like

Does Barclays give joining bonus???

like

Anyone interested in practicing the fit interview? McKinsey PEI, BCG fit

like

Should you discuss salary range with an internal company recruiter prior to setting up an interview? With external recruiters it’s pretty easy to talk about the expected range. I am trying to avoid wasting all of our time if i get to the last interview and they are expecting a salary that is too low for me.

like

Maximum ctc that TCS can offer to 5yr full stack developer .....

like

Hi I got selected in Nagarro i.e. I cleared all the tech rounds but now HR is saying there is no vacancy , they are saying as soon as there is a vacancy they will give me an offer and asked me to wait until then. My tech stack is. java backend . Yoe - 2years. What should i do ? I want to join Nagarro, I resigned based on my Nagarro interview result also I hated TCS, hoping HR would call me in week . Pls guide me ? Why do these companies keep interviews when they don’t have vacancy?

like

More Posts

I am interviewing with Accenture UK for AWS Architect role. Total exp is 12 years. What base pay should I be looking at? I am moving from another country. So, no idea about UK pay-scales.

like
like
like

Any recommendations for resume revamp?

How is work culture in S&P Global platts segment for Software Engineer II role?
And weekends may not be on Saturday and Sunday?

What will be the inhand salary at tcs on 10 lpa

like

Hi folks,
Please help me calculate the monthly in hand salary before I accept.
Thanks & regards.
My current pay is 7 lakh fixed, with 60000 variable/year. Which comes to around 54,000 monthly in hand

Post Photo

Would ey gds renegotiate the package with just few days of joining..?

like
like

ETL developer, skills : Python, RDBMS, SQL, Power BI, SSIS, SSMS, SSRS, Informatica data quality, alteryx, ADF, Azure synapse, Azure services.
Planning to switch role to Data Analyst / BI Analyst.
Current CTC: 14LPA. EOE 6yrs
What CTC and roles can I expect with these skills?

like

I’m looking into exiting consulting and moving into product management. Picked up a few books to read. Would a PM certification provide a lot of value? Any other tips are appreciated! Thank you.

like

Ghosted by salesforce after final round. Has this happened to anyone?

like
like

Hi fishes

I want a referral in the data science domain. I have an experience of 2.5+ years in data science and analytics with skills in python, sql, data Analytics, machine learning and SAS.

Currently having a notice period of 1 month, I’m looking for a change.

Please let me know if you have a suitable role for me in your organisation.

Thanks.

like

what are recruiters generally seeking in cover letters of applicants moving into a role from a different industry? I am an AD in advertising looking to move into a design role in tech, maybe even film

What is the salary range in Accenture for Level 7 in the Applied Intelligence Team? Job location - Bangalore

like

Does anyone know how to get early release from the notice period I don't want to serve 90 days I need to spend 30 days only pls let me know what to do.

like

How long does Synechron take to release offer after final interview?

What was your career path to becoming a director?

like

Hi fishes,
Anyone have hybris knowledge based on java springboot. Please let me know.

like

Additional Posts in Consulting

Hey D1, you left a copy of your resume in the conference room. You know who you are. Now the entire team knows too.

funny

Accenture Strategy vs. Accenture Consulting vs. Accenture Technology? What's the difference and which is the best (WLB, Compensation, lifestyle etc)? Looking to pivot and wondering which to include as my top pick...

like

Any book recommendations for the summer vacation season? What's your favorite book over the last year?

like

What are the best consulting companies in the US focused on Sustainability, either Strategy or Ops?

likefunny

Looking for some material for a crash course in IT strategy consulting - books article etc. any recommendations would be appreciated

like

I wish I had a doggo with me to be my quarantine buddy...

like

Does anyone know where I can go for a short period of time to get a business work setup? Two monitors + keyboard + mouse and good WiFi? I have a timed case study coming up and would ideally go into the office to do it but it is closed and i don’t have a good wfh setup.

like

Essential WFH gear set up. Go.

like

Sacklers made a rookie mistake of not starting with a big4. Had they come to us, our partners would have recommended a phased digital transformation journey to enhance value maximization and increase share of wallet. We’d do this by implementing SAP, Workday, and Salesforce using power point based accelerators to create a 360 degree view of the customer that empowers the frontline, increases loyalty and enhance employee collaboration. We’d still be in pilot assuming start date similar to McK.

likefunnyupliftinghelpful

Difficulty balancing daily demands of executing on project needs while creating collateral/tangible assets for my practice.

like

My office chair stinks even though I wash it with carpet cleaner every few weeks. Fellow 24/7 WFH workers, how do you keep your office chair clean?

likefunny

Started getting targeted for Recoop after I started working in consulting. Do you think my affinity has changed to “potential adderall user”?

likefunny

Thoughts on getting a resume writer? I’m personally pretty happy with my resume. However, I am curious to see if this a thing that is done in the consulting industry.

like

So this boring interview ... is it really for 30 min???

like

Currently found myself with a lot of free time and looking to learn a useful tech skill. I have experience in solution architecture, but nothing more technical than that. Any recs on a hot skill that would be useful to know (e.g., analytics, cloud, AI, ML, etc.)? Don’t know where to start..

like

Question from a newbie consultant - What are some good online courses/ books to improve consulting skills?

like

Gay bars, places to go to in Montreal? Recommendations please

like

My background isn’t in marketing/branding/PR but I’m being thrown into an engagement for a small organization who has many different sub-brands. I now how to give them high level guidance on how to ensure their branding and message is consistent. Any resources/books you’d recommend I could crash course this on?

like

Is MBB hiring right now ?

like

I'm a recovering engineer in consulting and want to learn more about finance. Are there any online programs that would also look good on resume? There are certificate programs by MIT, Harvard, Princeton, but not sure if they are worth the cost. TIA!

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