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

hiring aggressive... anyone looking for referal at Accenture technology operations strategy consulting drop cv @ mail ayush.splunk@gmail.com

minimum 2.5 years experience mention you skill - Date of Birth nd mobile number. (mandatory fields in referal form ) Accenture #refer

like

Any know of any tech transactions opps?

like

How much would orange theory cost if you went 2-3x each week?

like

Hi,

Need 11 likes to start DM.

Thanks😇

like

Any thoughts on Peter Millar suits? Quality, look, wear over time, etc..thinking of buying a couple while on sale at Nordstroms

Hi Fishes, I am a Consultant with approx 11 Yrs of exp being offered Senior Consultant II within IN3 and I want to understand if this is appropriate as per my exp. Can someone please explain how many levels exist within IN3 ?

Hello Fishies,

How much salary does Accenture offer for Level10 candidate
Profile : SAP EWM
Experience : 3+ yrs
Current CtC : 11.7lpa

like

To NYC members: Anyone here planning on sitting for FAR in December or January and would like to join a weekly (or biweekly) study group on the UES?

like

Really urgent, should i share the company name in sharing holding offer letter to second companh..or only compensation part shall be enough.I am not sure if i should share the part where they are addressing with my name as well for authentication because it has company logo and name as well.

Please reply fast if u have any idea.

like

Hi all, my name is Alex and I just joined the bowl :)
Im graduating in may with a BS in Industrial Engineering. Ive also held a Data Analyst Internship for 1 year with a small construction company. Anyone have advice where this combination of education and experience would make me most competitive in terms of roles/companies?

like

Hi all, what salary range would be good for Head of Content (UX writing+ content strategy + direct reports) who reports to VP of Product at a series B, fully remote fintech company?
(MBA, 5+ years experience)

Hi sharks,
Bowl seems so silent. Can we keep it interactive? Please suggest.

like

Joining Deloitte. I just submitted my documents to immigration. How long will it take to file my H1B case with USCIS? It’s wired big company like Deloitte is using third party law firm for H1B transfers.

How do you tell your boss that their work is sloppy and doesn't make sense? They sent me something to proof read before he presents today, and there are spelling mistakes all over and...

like

Hi All, Any opportunity for PMO? I have overall 10 years of exp in which 8 years of PMO exp in the area of Project mgt, Resource mgt, Cost Budgeting, Contract Mgt, Revenue forecast, MIS reporting, Risk and Compliance.

I am new in oracle . Just wanted to know is there any yearly hikes in oracle idc and are hikes project dependent and manager dependent here?

like

What do I do?
Just switched to a gud org with gud perk,pay,project work but My boss is the epitome of a**h*** reasons-
Onboarded me on a huge project (12 phase proj) with no KT, only gave docs to read from.
He was handling this proj till phase 4 but has completely withdrawn out without proper transition.
I cannot make decisions and my decisions are overridden by him.
I have 2 yrs experience and it's now my onus to negotiate with PPL in VP,EVP position and also handle testing & dev team.

like

How do I prepare a strong story for exit conv to industry? My leadership will try their best to retain me. They have strongly supported me throughout my career, so I might end up burning bridges. I want to leave because I don’t want to continue with the project (don’t have option of changing projects, I am a SME, strong knowledge dependencies, been here for 3+ years). Plus the move will be to industry in different kind of work, which is a big big learning opportunity. Any advice? TIA!

like

I’ve noticed a pattern of vets in my area not reporting animal hoarding, even though it’s required by the state. Should I speak up?

like

Additional Posts in Data & Analytics Consultants

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

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

like

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

like

What is the best way to handle group financial consolidation in a multinational company?

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

Hiring for data scientists and BI analysts across a couple levels, DM me if interested!!

like

Business practice: "can you guys build a model that overlays where Coronavirus is going to break out with client sites"

likefunny

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

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

like

Anyone have a ballpark range on dataiku price per seat or however they price? It looks like an interesting product.

When industries refer to business intelligence engineers, are they looking at a senior level or entry level? Some of these job descriptions seem rather outlandish in terms of years of experience required like 5+

like

MBB data science expert role (i.e., mostly identical progression as generalists but less up or out pressure) or third (?) tier tech companies (DataRobot, C3, etc.)?

Assume starting TC is same at both or 10% more at the tech companies. That's the figure they're roughly giving me during interviews. Also coming from Deloitte.

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

So pretty much you work In consulting, get paid half of what fang people make and In many cases work IB hours to meet clients continually changing demands . All the while the consulting project is built on a half thought out rushed tech stack/architecture? Meanwhile tech companies expose their employees to best in bread tech stacks? I really don’t understand why anyone in the field would work as a consultant doing data work? The only + is in consulting there are lots of low hangin fruit 🍎.

like

What tech companies are best for Data Analysts? Looking for $120k base + equity that’s gonna be worth a lot + other great benefits + possible remote.

funny

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

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.

Partner: Let’s take the data in the spreadsheet and put it in PowerBI so we can cut it up.

Me: What? It’s already cut up in the spreadsheet. I don’t get it.

Also me: Yeah! Analytics!

likefunny

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

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

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