How does one explain to someone that coding up an Excel model that was made scrapily takes much longer than it did in Excel? The persons view is "isn't it just a bunch of for loops?"

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

Not really sure about the best communication strategy or if you’re just venting - it’s frustrating when people don’t understand what you’re doing but still think they know how long it should take

I think you can point out that it’s harder to read excel functions (or code) and understand what it’s supposed to be doing than it is to write it the first time. Whoever made it understood what they wanted and now you need to reverse engineer the logic

Also, you could point out that you’re addressing a problem they didn’t deal with the first time since excel didn’t scale to the data you needed - if it really worked the first time they could leave it in excel

like

Just to check my understanding, someone gave you an excel model and would like you to replicate it in python or something?

Correct

Tell them that the befenits of coding it vs developing in Excel is to reduce time to modify and to test correctness. But to set that up requires time and effort.

Also is this BCG Gamma? Just curious because why would you need to convert excel models to code?

Not really a Gamma project, just helping out as beach resource. Conversion because some of the matrix operations are getting too big for Excel.

like

Lol the way that someone describes it sounds like it would take forever to run and be a huge memory sink.

Related Posts

like

Good doctors/dentists/optometrists? Just moved here :)

I live just south of park hill

How are SAP Projects in LTI ? Support or implementation?

like

Ladies, did you change your last name after getting married? I’m worried about the impact it will have on my publications.

like

Started/maxed out my 2020 IRA on Friday at the market high without knowing and now my whole portfolio is down 2-5% already 😔

likefunny

I accepted an offer from TCS and later got a better offer from another company. Now if I refused to join TCS, will be able to join TCS later in my career? Asking this cause I heard ex employees can't join back as there was a policy change. Technically I'm not still a TCS employee yet but just asking to make sure. Thank you.

like

I'm looking for some advice. I've been an EA for about 7years now, i have a strong background in it but ready to move on into something else. Any suggestions on how I can do that? Cont

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Hello FishBowl community,

I am a Talent Acquisition Partner with
leadership and management experience,
and my previous role was a Talent
Acquisition Specialist. I have a bachelor
degree in Business Management, and I'm
looking for a remote role.

Any TA referrals or job opportunities
would be greatly appreciated! :)

like
like

Anyone keep cash on hand at home - and if so how much? I just closed some accounts to consolidate and want to keep cash for emergencies

like

Hi! I'm looking to transition into an experience designer role after being a backend dev for the past four years! Feel free to connect if you know of any open roles at your current company 🤗

like

Interviewing for BIOLIFE today and looking to gain insight from anyone who works for the company.

Trying to establish a resume entry for a supporting project manager role. The rope did not require the full PM scope such as financials, but did cover almost all else. I don’t want to oversell it, but would like to take credit.

like

Has anyone in the forensic/investigations field moved to Qatar/lives in Qatar for work? How do you find it? What are the salaries like as a Head of Ethics in Oil and Gas?

like

I am a 32M and have been on several dates with a 23F. We vibe and chemistry is there but a hurdle that she’s been very open with is the difficulty of telling her parents about this (9 year age gap). Completely understand her situation — how do I approach and/or overcome this? What can I do? Anyone had this large of an age gap in their relationships before? Thanks in advance

like

Might be a weird question, but I see a lot of student work featured on Adage and Adweek. How do these publications notice the work?! Is there anyone/anywhere where we should submit our work to?

like

I hit my juul without thinking on a zoom conference during a 2 hour meeting. Nobody said anything but I definitely got some weird looks. Is this going to bite me in the ass? Should I apologize or just not say anything?

likehelpful

Additional Posts in Data & Analytics Consultants

Can anyone please provide the best recommended training link to study for the AWS Cloud Solutions Architect Associate Certification? I want to study for it end-to-end and complete it within a few weeks!

like

Hi All,
I have a question about replicating an Alteryx model in python. Basically the Alteryx model used to clean, combine, prep, run some business rules and spit out a formatted file ready for running further analysis/viz. Can this same process be automated using a python script? I’m new to python and would like to know what packages to learn to do this.
Thanks!

like

AWS big data specialty exam worth taking? Does it involve any coding?

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Can someone explain what’s the difference between EDM technology/tool and DWH?

like

I interviewed for a product analytics DS role at Fb/Meta last week and haven't heard back since. Not sure if I event want to take up the role but nevertheless wondering if I am already rejected? Been about a week.

like

Any highly recommended videos or resources that give a comprehensive approach to sales forecasting?

like

Back end or front end?

Post Photo
funnylike

I studied for 2 months with a friend and doubled my income to 200k+ the consulting game is a a racket and to that extent big tech is too BUT big but tech and large streaming companies actually pay top dollar for good talent that can code . These suits have been lying to you ALL. Wake up in the morning and studying my friends you do not need these consulting firms they need you! Do not feed into there bs…studying for interviews and get you fare share of this tech wave… I am making more than my Ms

likefunny

DC folks: how’s Clarabridge (company)? Thanks

Thoughts on the below role?

Got messaged about an analyst job doing the preliminary discovery stuff including dashboards. But not for the business, but to give recommendations to data scientists about where to focus. Having been a modeling DS, I can't imagine why I'd outsource exploratory analysis. Anyone seen a team like this before?

Also worried about career prospects. I've been wanting to turn business facing, but becoming the only DA on a DS team seems like it'd be a dead end with promos?

like

Anyone in here know much about Georgia Tech’s OMSCS or OMSA programs (Online Masters in CS or Analytics). I’ve been doing a lot of research and may pull the trigger on doing OMSCS part time. Talking to a team member soon about it.

like

Interviewing for a deals analytics role at EY- the interview day will include time with a partner, a senior manager, two managers and a 3 hour case study. What should I expect?

Anyone heard of the Math company Analytics start up? They just got $50m funding in January? Good company or not?

like

My first 2 years was developing algorithms. Since last year I started business development, project management with outperforming achievement. What could be the next step if I don’t want to code?

like

If you’re hiring for sr analyst roles , what tradeoff would you be comfortable ? Business acumen and prior knowledge of industry/ function or core data analytics skills ? Need both at end of day but candidates are strong in only one of the two areas. Assume candidates are coachable and willing to learn.

like

Would recommend data engineer or software engineer for pay and growth potential?

like

Considering a data and analytics role for a data migration project. What kinds of SQL queries will I be expected to know?

like

Any conda users in here have to install a binary and use conda forge? Need some help installing pdftotext. Throwing a weird message saying “Found conflicts!” Any and all help would be appreciated.

like

Can someone tell me how log loss values can be used to compare two classification models? I understand the concept of log loss value but I don't quite get how two models can be compared using this metric. Is it as easy as saying, all things equal, one that has a lower log loss value is a better model?

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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