Best way to implement automation with Excel filters and deriving counts?

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

Power Query, my friend.

Related Posts

Did anyone lateral into big law? First year in insurance litigation defense and I’m looking to see if it’s even possible to break into big law in a year or two

like

I used to hate growing up poor. Now I'm still poor but I've learned a lot of really practical things. I make most of my wooden furniture, know basic electrical and plumbing work, can cook and bake delicious food, can do most of the basics in car repairs, garden, and make a lot of my own clothes. Not to brag but I'm proud of myself 🥰

likeuplifting

What’s the comparable Audi to the bmw 540 and which one (Audi vs BMW) is the best bang for the buck?

like

Interested in eventually exiting into wellness tech.... what are the best consulting firms to start at?

like

Am I the only one left at the end of the month trying to bill 10hour days to meet hours because I slacked off at the beginning of the month? It’s a vicious cycle. Then the end of the month hits and I’m so exhausted that I need to take it was the next week... and the cycle continues

like

Can anyone explain why insurance defence work in the US is such a terrible place to be? I work in insurance defence / coverage (financial lines) based in London and it doesn’t seem like it has as negative of a reputation as it does in the US, why is that? 👀

like

How do people feel about Gordon Rees? Anyone currently working there? I’d be doing commercial litigation/employment as a 2nd - 3rd year.

likefunny

Hi all, I have recently received an entry level offer from BCG Dubai.
I have 3+ years of experience out which half in consulting and half in managerial role in corporate.

Would you take such an offer or would you look for better seniority at another consulting ? Is it a fair treatment?

like

Who’s working on the twitter acquisition? The dataroom has to be nuts.

likefunny

Kleinberg Kaplan thoughts anyone?

like

Any predictions on when the drop will happen?

funnylike

Would you buy SQ here for long term hold?

like

Joined tcs around 1 month back and submitted all the joining related documents but still didn't received my employee Id.upon checking with hr i am getting information that there is technical glitch due to which employee Id is not getting generated. Is one else facing this issue ? What can be done in this situation ?

like

Hi, Tomorrow is my last working day at Infosys. I need to submit my laptop. My DC is Mysore but I live in Hubli, so can I handover the laptop at Hubli DC?

like

Hello everyone! I am unable to put the work that I’ve been doing as case studies on a portfolio site, even if password protected. I was thinking about making a slideshow style case study on Figma. Is it better to send it in a PDF format anyway or can a Figma link work?

like

i just need insight on Global Life Liberty National Division or any other branch of Global Life. what was the work environment like? is the money as good the first year as they say?

like

Finished Stern interview and think I have a good shot of getting in. Trying to determine if 200k is worth it for an EMBA? The debt scares the shit out of me. Thoughts?

like

Anyone from or at client side data analytics/media science? Wondering how the worlds differ, agency vs client.

Additional Posts in Data & Analytics Consultants

I'm non US citizen and thinking of moving back to EU. My plan is getting remote opportunities across the world and work as a freelancer. My speciality is Data analytics and BI (Qlikview, Tableau). 1) How likely I can get a gig from the US? 2) if a job looking for a remote 2-3 months contract do they care what country I'm in? 3) how can I compete Indian rates as I'm in Europe 60-70$ per hour as a BI consultant is a good rate but I see online rates as low 10$😫?

like

Any cyber security folks here? or those interested in systems engineering? Potential role with TC 120-180, awesome team and wlb, at least compared to consulting.

like

Does your company split data science roles into different practices like data & analytics and software engineering? Does this inhibit collaboration & Where does a data engineer fall?

like

Hello, Anyone here from Deloitte Omnia AI who could refer me for an open opportunity.

like

What are some of the best online resources to learn Power BI?

like

Can anyone at Ford Motor Company tell me more about the “Learning Analytics and Engagement Specialist” remote position? Very curious and would love a referral!

like

What is it about D&A that most clients (or even partners) don't appreciate? Thinking about the painpoints or opportunities that are unseen at the top or require lateral thinking

like

Anyone have any tips or material on effective storytelling to leadership? I have to present an analysis and recommendation to a VP and really need to put together a good story. Thanks!

like

Any recommended courses or books on customer care/cust success analytics or marketing analytics in general?

like

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

like

Is 128k a fair base salary for Consultant in Deloitte Analytics & Cognitive. MS CS and about 3 yrs experience. In one of the fastest growing but midtier tech cities in the US.

like

This might be a long shot ... but I have a Statistics assignment due for tonight in a few hours

Does anyone know how to do Linear Discriminant Analysis with more than one predictor - by hand? I know how to compute in R but my professor wants it done by hand .... fml

likefunny

Have you ever failed to deliver? What was it and why?

like

Would you give a referral to someone you haven't talked to in years and don't know much about their ability?

like

Has anyone else begun to resent data science?

like

What’s so good about the Georgia Tech OMSC and OMSA? Is it just the cost? Seems to be recommended by most of reddit

likehelpful

My manager continues to ask me to help other teams and do work on other billable projects. I’m sick of it .. and I’m going to explicitly say that no I can’t do it because my hours are taken by the existing project we are doing. Is this appropriate?

like

Is anyone working with Elastic at DoD?

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

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