{ "media_type": "text", "post_content": "Doing a technical interview for a transactions group involving SQL and Power BI. I've brushed up on the two, but wondering if anyone has suggestions for practice cases or practical applications? Any sample cases would be very helpful, thank you in advance", "post_id": "5ef1ccfbac696d0028527eaf", "reply_count": 5, "vote_count": 1, "bowl_id": "552d1d24dc1c586b09d2d051", "bowl_name": "Consulting" }

Doing a technical interview for a transactions group involving SQL and Power BI. I've brushed up on the two, but wondering if anyone has suggestions for practice cases or practical applications? Any sample cases would be very helpful, thank you in advance

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

SQL gives you access to data and Power BI lets you present it to communicate insights. The utility of both depends entirely on the quality of your insights and how effective you are at communication. Pick an example of an material insight presented well and work backwards from there. Say in the meeting your stakeholder had a question you hadn't prepared for, you were able to quickly rebuild a dashboard live to answer his question, avoiding the whole "good question, I'll get back to you" and proving you actually know what the data means.

like

Have you ever created a table or a graph in excel and copy/pasted them into a slide to speak about them? That is what is replaced.

Check Guy in a cube and curbal channels on YouTube

like

Thank you! I will check it out

like

Related Posts

Have you even felt completely grilled in an interview? I feel as if one of the interviewers didn’t want to see me succeed in the process.

like

I am eager to work out of Europe for a few years. Is there anyone who has done this move recently and has managed to get a job searching from India? How was the interview experience? Where did you find the vacancies? YOE - 6 Skillset - Data Analyst

like

After technical round on an average how many days citiustech take for 2nd round of interview ???

like

has anyone created a research plan? applying for faculty roles at a university and a recent PhD, with only a published dissertation to my name

like

How is slaloms interview process for a solution owner?

Expected Salary for SAP Manager in Canada? Have interviews with Deloitte, EY and PwC lined ip? But being from US want to understand the ceiling in Canada not not sound rediculous and not get a second round

Applying to some roles at Spotify (business analyst, does anyone have any tips to stand out?

Hi I heard even after clearing the interview and join sapient, we need to attend client round and that much tougher than sapient interview. Is it true? Please give inputs. Profile: UI developer

like

My new job is not what they made it out to be in the interview and I feel like I’m not living up to my potential. I feel like my skills would be a better fit elsewhere on the team and I would also learn more and be more productive. Have been with the for 7 months is this too soon to bring it up with boss/boss’ boss?

like

I got selected in Infosys and offer was about to get release today but at last minute suddenly today infy HR told I was interviewed 5 months 20 days before in infosys so they cannot proceed now as 6 months cool off period. I am AWS cloud architect with 10yoe. For just 10 days difference they are stopping my offer even when I can join immediately in a week.. Please help in this situation what to do

Has anyone here done an analyst interview for postmates? Please comment or dm me! I’m curious about the process and questions asked

like

How is the situation at Scholz after the whole drama? Is it worth applying to?

Hi all, Need help with a resume review referral or another resource (cover letter critique, etc) you've used that helped you get a job. Sibling finished up MAin UK (History) w/ 2YOE, now back in US, and has comms/event management/program management experience. But she's having difficulty getting any interviews in the Northeast areas. It's been about 6 months now, and any resources y'all have would be greatly appreciated.

like

Looking for a new mentor. Background- I previously practiced environmental law for some time and transitioned to health care about 4 years ago. Recently picked up pharmacy (in-house). I was interviewed for a Medicare/Medicaid role, but the hiring counsel thought I’d be great at pharmacy so placed me there. Was upfront about not knowing pharmacy one bit, but expressed my willingness to learn. Fast forward a year later- still struggling with Pharmacy knowledge. Looking for resources.. cont’d below

like

I work in a small cpa firm that only does govt audit, but I don’t want to be pigeonholed. What can I do in my interview to show I can work in big4 & do non govt work (even if I have 0 experience)? TIA

like

Interview with Deloittes Finance & Ent. Performance group. Anyone have any tips as to what I can expect from the case? Much appreciated.

like

Please help with your suggestions to this Depressed fish! 10 YOE and worked diligently with sub standard package relying on bosses alms without realised the exploitation until recently. But now I really want to make it big. So got some offers, but not those which I am looking for. Skillset is cutting edge cloud.cold applying on LinkedIn job openings aren't helping getting decent interview calls! Can you please show me some path? Or am I estimating myself beyond my capabilities! Really frustrated. SOS

like

IHello Fishes. I have received positive feedback from KPMG interviews for consultant position and have submitted documents. It has been 4 days since I haven't received any call for negotiation or offer letter. How long does it take to get that?

Interviewing for an Amazon Senior Program Manager. Any recommendations for the initial phone screening? What will the phone screening cover?

like

Additional Posts

What are the benefits that ey gds has as compared to deloitte ? Like in deloitte we have smartphone policy, well being subsidy, internet bill reimbursement, hybrid home office setup etc etc.. what do we have in EY GDS ?

like

When you work above a nightclub and every night at 6:01 they start jamming. #leavingat6

like

DC Metro folks, we should do brunch/happy hour

likehelpful

Random question for the folks in H-town. What's your fav study spot (preferably open till late)?

How are you coping with the uncertainty of the beginning of this school year?

like

Submitted application to amazon about 1.5months ago. In the portal it still says application submitted and it’s radio silence. Am I still being considered..? Did anyone even read my resume 😞

like

Lay-offs! Which firms are doing them? Accenture Strategy had big layoffs in 2016 but were doing well as of 2018. How about your respective firms?

like

Tips on note taking? Having a hard time turning around notes quickly after meetings

like

Have competing offers from EY and KPMG UK Economic advisory teams( Manager/Snr Exec level). KPMG's UK technical rep and comp offer is better, but the hours appear longer. EY UK Director has had several calls selling culture (diversity and work life balance). Is there actually a substantive emphasis on this by EY? Or are 50+ hour weeks quite common? I suspect it's going to be quite team dependent/ project dependent, and therefore a gamble in any case. Thanks for any perspectives.

Ha anyone (with an MBA) been brought into their firm as an experienced hire at a non-MBA salary? If so, have you attempted getting back into the MBA salary pool? Success/fail?

Looking for a licensed rep in the Landrum, SC or Hendersonville,NC area. Salary plus commission position. Great starting position for a junior rep

like

Any fellow fish who has their own YouTube channel?

like

I don't have a great work set-up in my small apartment (i.e., no desk, no work chair, headphones, mouse, etc.). What are the top 5 wfh "accessories" you'd recommend on a budget? Thanks!

likehelpful

Hi fishes, Need your help. I have offers from likewize and eurofins. Which one I should join ? Offered ctc is same for both. 8 YOE , .net fullstack

like

Anyone use solicitor Agreements? Any success with attorneys or cpa's? What is you split and is it one time or on going?

like

Bain 🐠: Is NYC industry recruiting backlogged? A manager reached out to discuss the process this week, though they have yet to respond to my reply. Should I reach out EOD tomorrow if I receive no updates by then?

like

Has anyone ever gotten scholarship $$ from a T15 school with a sub-3.0 GPA?

like

App not available in stores here in the region? Asked a friend to join and we see it's not listen on any stores

likesmart

Best agencies in Washington DC area?

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