Is it normal to see a 664 line SQL query powering 1 visual on a dashboard

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

Sadly, not out of the ordinary.

like

🚩

like

I mean it could go either way - on one hand you can have line break for all attributes and on the other hand some a hole can be dropping tripled nested sub queries

like

Not super surprising, a lot of it could be due to formatting and commenting, and also just developing many many features on a person level so it would involve multiple CTEs. You’d be less likely to see that on a “transaction level” query and more likely on a “person level” query. Really depends what the whole query’s purpose is.

(I’m speaking as someone who has also developed these kinds of lengthy SQL queries to power both Tableau dashboards and also Looker’s LookML data views.)

like

Only if built it...cause I jist code shit on top of problems

like

Does anybody else here work in analytics? If all you know is it takes 664 lines to build the etl to create the view that powers the visual, how can you possibly know anything else about the query’s optimization? And if the visual has a lot of parameter controls?

like

What do y’all define as ETL? I agree I don’t think a sql query is ETL.

Based on D1's comment, let me say few things.

1. "powering" a visual is consultant speak. That could mean a lot of things.
2. To build a successful and good dashboard, there's need for data engineering.
3. Building a dashboard needs designing a friendly dimensional table that has wrangled, sanitized and prepared data before you drop the first bar chart on the dashboard.
4. Having said all this, one query of 664 line is out of the ordinary and could indicate bad dashboard design, lack of separation between data wrangling and metrics.
5. With all that being said, if out of 664 lines, you got 200 lines with just column names, then may be it's a different issue here.

Also, you say a 664 line query is powering ONE visual on a dashboard and NOT the dashboard entirely. That seems to indicate you have tremendous scope to improve

like

Related Posts

Any FAST TRACK offers out there for airlines?

like
funnylike

Anyone can please share your experience with Global Logic

My father in law just said he’d pay for MBA if I get into a top 3.
So guess I’m not getting MBA paid for 🤪

likefunny

I’m currently on Notice period:
Can i ask my manager to match salary (40% hike) and permanent wfh or 2 years wfh. Will infosys be agree with this ?

Please suggest.

What are some smaller firms/consulting practices that would value talent from a B4? I need a change.

like

Hi fishes,
Can someone please suggest some study materials for proficiency assessment in functional test planning?

like

I have received letter of intent from wipro. Is this same as offer letter?
Also received link to upload document for BGV

like

In Wipro portal is showing my career stream : project management

What is the meaning

like

I have 18 days to study for CIA EXAM Part 1.

I can dedicate 5-6 hours a day. Is that doable?

Hi, My partner applied in Accenture few days back and received an email today, that they have a great opportunity for her and not able to reach out to her. They asked, did she change her number and mentioned to reach out to the recruiter. Now since we had been in a no network zone, she didn't receive any call, therefore there is no number to reach out to her recruiter. Also the email she received is from no-reply email id. Who can we reach out to? Is there a support email id?Accenture

likeuplifting

Jos. A. Banks vs Indochino. Where do you go to get your suits and why?

like

Hey all looking for front end developer for my team

If you are serving notice period and have a short window dm me or comment . We want to immediately onboard

Have onshore opportunity, as it's a new program . WLF is good

like

I have a my one year work anniversary coming up next week as well as a review with my supervisor. He asked that I prepare by thinking about what I would like to do in the next year……..I have no idea what to say or bring up. Does anyone have any suggestions for preparing for a performance review?

like

Does anyone know of any dog-friendly employers in the public sector (local, state, or fed gov or non-profit) located in the Westchester County/NYC area?

like

Can anyone refer me to a worker’s compensation contract attorney? Looking for someone with Defense experience. Los Angeles, CA.

I got selected in @walmart for in4. How much ctc should I ask for, given my current CTC is 36 lpa (30.33 fixed + 6 variable) , along with that I have stocks of 20000$ ( vested over 3 years) and 16000$ (vested over 4 years), along with that I am top performer of my company

like

Going to Milan for the first time in a couple of weeks. Any travel tips or must visit places?

like

I read the Clinic and UH could be rolling out drive-through testing. Anyone have details on when it will be available? And how are you all planning to vote in Tuesday’s primary?

Additional Posts in Data & Analytics Consultants

How do I bring Alteryx offering to my boutique firm? These guys live in the past and love excel.

Anyone know much about World Wide Technology (WWT)? Interviewing there soon but can’t find much about company culture.

like

Anyone here knows about Facebook's Marketing Science team?
FB recruiter reached out for a Marketing Science Partner role. Wondering if anyone here has first or second hand experience with them

like

Best free visualization tools?

like

I’m about to get staffed on an assessment analytics role using Microsoft Access and SQL, neither which I have any familiarity with. Role starts in 2 weeks. Any suggestions on resources and quick maths

like

I feel like rushing my career in Data science. The market is moving very quickly. I have this urge to jump to new adventures seeking more interesting challenges and trying to be always up to date.

Currently have 5 YOE in DS consulting

what do you all think about online data MS programs as opposed to in person?

like

Do you follow some standard for what constitutes good documentation, or just kinda wing it and hope it's good enough for the next poor sap to decipher?

like

What is comp for data scientists in industry? Searching around it seems pretty low 100-130k for non senior or management roles.

like

Best consulting firm to work at - under the Data and Analytics branch?

like

Looking to create a personal portfolio website for my data visualization and dashboard work with the firm. Is it okay to use screenshots (scrubbed with fake data obviously) from my client dashboards on my portfolio? I would blur out Deloitte logo and such , but it would be great to showcase my work dashboards on personal portfolio just because I’ve done so much solid stuff there. Would this be okay from a legal standpoint or risky?

like

Hoping to switch from current role to data & analytics focused role. Looking for advice on what steps to take (i.e. any certifications to get or other trainings to begin) and best entry level jobs to apply for.
Background: Have some basic knowledge of Alteryx, Tableau, PowerBI, Google Analytics, and SQL. Currently working in Deals and make around $80k.

like

Two months ago I started using Datacamp and this week finished their data science frack in python + ~10 more courses. I feel like now I know enough to learn and read stackoverflow, but can anyone

like

I’ve been interested in entertainment / streaming analytics for some time (e.g. amazon, Netflix, Hulu etc.). Anyone know any useful skills, classes or certifications that might be good to have in this arena?

like

New to power bi and Dax... anyone have some bandwidth this weekend to help me write some Dax please 😕

What are the best firms for D&A consulting?

like

I see a lot of people looking to transition from analytics to strategy consulting. What is driving this trend? I am thinking about making the opposite move as strategy work does not bring me fulfillment

like

Has anyone worked/does work at AnyVan? (or similar mid-sized platform companies). I've applied for a data role and would like to know more about the culture as I've previously worked only in consulting

like

How’s EY’s hiring/interview process structured for data and analytics roles?

like

Really interested in ML Engineering/DS type work and considering an online MS in either CS or DS. Specifically online MSCS at GATech or UofI, or MIDS @ Berkeley. I have a non-CS engineering degree and ~3 YOE working in a data engineer type role. Should I go for a data science or computer science route?

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