Genuinely curious, if Tableau can easily make joins, filter out data quality issues, create calculations (counts,sums, etc.) with millions of rows of data, why would one need to learn SQL to perform those same operations?

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

You want to do ALL data transformations and aggregations in raw data. That is best practice for business intelligence reports handling millions of rows of raw data

like

Well there are a lot of reason to work with data outside Tableau. SQL can do much more complicated functions as well.

like

Reproducibility and performance. Much easier to read a sql script than open up each calculation in a workbook and verify that it is correct

like

Other than using SQL for basic extraction to get the raw data into Tableau…

like

Tableau costs money. Companies don't have bottomless budgets.

like

Tableau installed locally can at best be only as fast as your processor and RAM allow. SQL servers can be beasts in comparison with capabilities to deal with massive datasets with indexing capabilities for acceleration. Tableau installed on a server to do big data engineering work instead of dataviz is not a good solution, though you can still pull it off for smaller datasets.

like

Related Posts

Hi People,
Please let me know if teams in Novartis are helpful to newbies! Does Novartis have an agile or a standalone working environment.

Do people get help in code if they get stuck anywhere in any project?

Await replies🙂

like

I have a JP Morgan code interview happening soon for a data science position. Anything I should know before I get started?

like

Hello! I’m a US citizen and I work for a big four firm. I love Dubai and I’m interested in moving here for a couple of years. What’s the salary for a senior consultant within the risk advisory practice? TIA!

like

What's a guilty pleasure you indulge in at work?

like

ACCA and CPA qualifications. How useful are they in the line of consulting. I work in the M&A space focusing on FDD. Happy to have a chat to see what qualifications if any are actually useful in our line of work.

like

I'm a product engineer and it's hard to turn off work mode at the end of the day, I think of how products *should* be packaged when I'm shopping and can't understand why my wife doesn't care 🤷

likefunny

In SAP what we can expect in welcome kit

like

How does Visa bonuses work? Does everyone with an average strong rating automatically get the target 8, 10, or 12%, etc. bonus? Do they get more or less for other reasons?
Who gets equity?

like

I am a Reliability Maintenance 3P contractor for Amazon. I graduated with my Bachelor’s in Electrical Engineering on June 2022. I’ve been working with Amazon for a year, but there’s a lack of prospective EE positions within the company. The job postings I see are either less or barely above my current salary. I’m not sure if staying longer is beneficial for my future career as an Electrical engineer. I plan on getting my FE license within the next 6 months. Any suggestions will be appreciated

like

With the way the economy seems to be going/progressing, what do you see as the future of fintech? How will it be impacted by a potential economic downturn?

like

Looking like I'm moving to Houston early next year from DC for work. Any favorite neighborhoods for someone in their late 20s? Priorities are really just good food/bars. Would love to be in the $2-2.5k range.

like

Moving to Philly Nov 1, just signed a lease in Queen Village. Coming from LA where I was part of a volleyball group and had a lot of options at the beach. Suggestions on making friends and being active (while still being respectful of covid rules & health of all)? 36 F

like

Unfit for the office.

Post Photo
likefunnysmart

What is the total no of technical rounds for Java developer in IQVIA ?

Democrat outrage baiting thing is getting really tired and old. I don’t think I will ever vote D again.

likefunny

Lately I’ve been seriously considering making the transition to product marketing. Current PMMs please weigh in — on average, how many hours do you actively work in a day?

like

Looking for a home office chair…I need something really ergonomic/comfortable but given the visibility of the office in the house the wife wants something stylish. She keeps calling all my ideas ‘gamer chairs’ even though they’re definitely not. Anyone have any chairs they really like that may be worth looking at? I feel like I’ve looked everywhere (Steelcase, Herman Miller, humanscale, Haworth, xchair, etc).

like

Starting salary for a creative in Dallas?

helpful

First time pregnant about 10weeks. Worried about exposure to Covid. We were at a wedding and most guests came down with Covid. Anyone heard about big risks to pregnancy this early on due to Covid?

like

Additional Posts in Data & Analytics Consultants

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

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

Quick survey: Do you guys think having a template package to envelope an ML model as an application would be helpful. The package could contain boiler plate template for unit test, docker image, CI/CD, database connectors etc and act as a starting point for doing that. Tech firms usually have that internally but limited options in open source.

like

Is anyone working with Elastic at DoD?

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

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

like

What’s the best/simplest way to understand Sets vs Groups in tableau?

like

I need to do a timeline with lots of information over a long period of time. I wanted to that in Tableau, but partner will not pay license and data is sensitive so I cannot use Tableau public.
Do you have suggestions?
The requirements are the following:
- No online input data upload (so local editing)
- The produced output file must be local and easily exportable and readable
-timeline must be interactive (filter/click/zoom in/out/view detals etc.)
- free

Any kind of help is really appreciated

like

Coming to the realization that consulting is not for me (tech person) feeling angry that salaries at D will never be on pair with FANG and that leadership is not tech focused. For example you could be a soul contributor at fang making 240k and people at Deloitte wait 10+ years to earn that as Senior Managers because they need to climb the corporate ladder. It seems super clear cut to me now, if you want to make money in tech don’t join consulting firms. Am I wrong?

like

Folks applying for Data and Analytics roles in the industry at M, SM, D Levels, what technical/functional topics do you prepare for on the Analytics side?

like

Hi! Does anyone know what kind of knowledge is needed to crack the Data Scientist interview at Google?

I'm currently working in Marketing Analytics (primarily using SQL and a bit of pyspark). Apart from mastering SQL, I wanted to know from people working at Google what does it take to get there as a Data Scientist? (I'm very interested in Strategy Ops)

I plan to another 6-8 months in preparation and upskilling myself before I even apply.
Any help and guidance is appreciated! Thanks :)

like

What is a data lake in basic terms?

like

What are the top sales & marketing metrics that tech companies track? I have an interview for a Data architect role and the data aspect is my strength but need to brush up on the business insight part

like

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

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

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

Anyone have any suggestions for front end guis for users to run python code? I’ve created a few tools for webscraping data, automation, and modeling but non technical users freak out when they try to run the code themselves. Any suggestions? (Have tried Juypter Notebooks and a few other IDEs)

like

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

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