Any dbt experts here? I'm taking over some complicated models from contractors, talking 1000+ lines of sql, with numerous case when statements and window functions to categorize financial accounts by specific years and accounting books for complex business logic. Is SQL the best solution within dbt? Should I template the logic in jinja? I come from a python background and find manipulating dataframes more straightforward but not sure if it defeats the purpose of the tool

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

Related Posts

Is anyone here works at Yahoo ireland( previously knows as Verizon) if yes can you tell me if they convert agnecy worker into full time? I would really appreciate if you guys would help!Yahoo Verizon Media

like

Yearly hike at optum??

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Been with tech consulting for 5 years but no growth - total YOE 11 yrs - in the area of risk and regulatory consulting and implementation - not too many quality calls during this pandemic- seeking inputs from forum fishes and if anyone is interested in referring to Industry or consulting firms.. thanks !

My boyfriend just came out to his mom and she’s been horrible to him... he’s no longer allowed to go home... I’m traveling for work. I want to be there for him. Any partners with advice?

like

Has anyone here been in a situation where following up to the wedding was a lot of stress and fighting, but after you got married things became better?

like

My husband and I are thinking about taking a 6 month career break to travel. Career suicide or worth the risk? For context, I’m a 4th year big law associate (30 years old and no kids).

like

Is internal audit the escape from both public accounting busy season and industry month end close hell?

like

Hi all! Anyone willing to refer my wife to a big4? Ex. Deloitte, EY, KPMG…

She’s not enjoying her time at Amazon and looking to switch out as there’s no opportunities to move within. Currently she’s in QA. She has about a year of experience in IT coming from a background in Education. TIA!

Ryan Murphy is the new Aaron Spelling. Big rich producer making money off of cheesy shlock. I guess you can’t take the Indiana out of the boy. Heart’s in the right place though. Bless his heart.

like

Anyone like Rhaenyra a lot more than Daenerys?

like
like

i'm looking into getting an american express credit card.. this will be my first credit card, i do a lot of driving and traveling what would be the best one to get?

like

I am interested in learning data science and excel in that path. Please let me know any opportunities.

like

Hey guys,

I really need your help.

I recently got a good opportunity in one of the Mncs to work but i was worried as i had absconded from one of the companies just after 2 months of working there due to mental torture.

I have a shown the same as gap for personal reasons in my resume.

Will i have any problem after joining this new MNC during background verification as per the standards?..

Really need your help if anyone has faced this situation or know anything on the same.

Thank you

like

Vanity Marketing Mags (e.g., Vanguard Law)

Anyone done a feature for Vanguard Law or similar? How did that work out for you? Did your outside counsel receive a shake down to sponsor the piece?

I have been stiff arming Vanguard for years but am curious if there’s any actual benefit. Or at least funny stories.

like

Hey All,
Exp : 8.6
Exp On Mulesoft : 4.8
CTC : 20 LPA
Offer holding :
31 Fixed Infinite Computer Solutions
32 fixed from @Nahil (Saudi based gave 32 fixed (no TDS))

Current company: Infosys
I am waiting for the offer letters from
EPAM Systems asked 35, but selected for D3 role so 31/32 LPA.
Genpact (Enquero global) asked 35, not sure they can give or Match?

Which one to join, I am planning for long term commitment. Please provide your thoughts.

like

Looking for wfh opportunity currently working as a business consultant

like

Considering doing Shrooms or LSD in quarantine. Any experience and/or tips are welcomed 🙃

likeuplifting

Additional Posts in Data & Analytics Consultants

Has anyone interviewed for a Data Scientist position at Facebook and have any advice on the coding and product sense interview?

like

Anyone know of an alternative to StackOverflow for asking tech questions? The community is super toxic and I'm looking for a place I can casually ask questions that might seem dumb without being hrangued for not providing an essay proof of the research I've already done. Or some sort of buddy system where I can ping a person of relevant experience those questions. It's better to poke someone's brain for a minute than to spin in circles reading docs/dead end articles sometimes.

like

Learning cloud architecture right now so apologies if these are obvious questions: Best ways to store video metadata to perform analysis on it? I'm looking at AWS and GCP. Saw that Cassandra would be good for it, but not sure what the GCP equivalent is? But also I'm a bit confused on if Cassandra is just a DB and storage would need to be elsewhere? All help is welcome! I've been spinning my wheels on Google trying to understand

like

What biotech stocks are yall trading right now?

GILD, INO, MRNA

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

What is Accenture’s data scientist interview process like?

like

Mεntal mαth in iηtervieωs. Thoughts, tips, rants, grievances?

like

If you were to hang your own shingle as a consultant what BI tool would you use to deliver dashboarding to clients?

Assume that you aren’t plugging in to source systems as I primarily work in CDD.

like

How should I move to tech as a ML Engineer? How did people here make the transition?

likehelpful

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

Anyone in the KPMG Lighthouse practice that would be willing to take a look at my husband’s resume and put in a referral? He’s interested in the Associate, Data Scientist position.

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

Can anyone from Deloitte provide anymore insight to the differences between the Applied AI and Strategic Analytics divisions within GPS? I am in the data analytics and science space and have had two separate recruiters reach out. Thanks

like

KPMG folks, thoughts about Lighthouse relative to other big 4s? About to start the interview process. Coming from EY FSO DDnA

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

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

What do you think when associates/senior associates misspeak on a concept during a meeting or interview?

I’ve learned something new on each project, and I’m afraid of coming off as an idiot so I rarely contribute to conversations; only after I have done research on the topic and have prepared do I speak/give ideas

like

What is a data lake in basic terms?

like

Newish to data analytics. Have some experience in power BI, sql, and R. I wanted to get some exposure to aws and saw the AWS cloud practitioner as an available course at my job. Is this cert worth it? Or should I try one of the more advanced ones ? The data analytics one for example but wasn’t sure if it would be difficult to get through as a beginner. Will it look good on my resume?

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