Anyone have any good resources for learning about how to optimize SQL for larger data sets?

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

First things first… are you using an appropriate DBMS, something geared for analysis? (column store)

Yes

Why SQL for large data sets and not the hadoop big data ecosystem?

Presto is commonly used for large datasets

Related Posts

What’s the difference between FAAS and FDD? Also which one pay better?

like

Are there any books or other resources that mid levels/seniors/counsel/partners on here have found helpful for the project management / managing junior attorney aspects of your job?

I am not finding a lot of stuff written for lawyers specifically , but there is a lot directed at “managers” in business generally that I imagine could be applicable.

like

Can anyone let me know how easy it is to apply to a consulting firm in Dubai directly coming from London? I am currently working at a T2 strategy firm in London and my partner and I want to relocate in ~1.5 years. My firm does not have an office in Dubai whilst my partners firm does. Is it possible to apply straight (rather than moving laterally in London, waiting a few years then transferring?) interested in MBB views too. (I would have roughly 2.5 YOE by then)

How can I earn more money as a Oracle Fusion Technical Consultant? Do you guys know way to freelance or something?
Help would be appreciated.

like

which model deloitte usi banglore follows is it wfo or wfh?

like

How do you hire for a role that fluctuates? I currently am the designer + support specialist @ my job. Sometimes support takes up all my time and design projects get pushed back. Other times support is dead for two days. Does anyone have solutions? Our team has thought about outsourcing but as a company that relies on maintaining websites, having a non-native English speaker can have the impression on our clients that “We don’t care”..

like

Exit to Amazon London L6 with £95k TC (68 base, 10 bonus, and 19 shares, vesting 0-3-8-8). Is this a fair offer?
I was hoping for £100k TC.

like

Hey everyone, I’m looking for a referral for tech consulting, have 1 offer from another B4 and I’m in my last year of undergrad

like

Hi All,

Anyone have a recommendation for a good headhunter? I am currently a 2nd year associate (many years paralegaling before that) at a mid-sized firm in NY and am looking for a change.

Also, any cons of working with a headhunter?

like

Any Bay Area peeps want to meet up next week? Going to be in town for work, but looking for a distraction.

like

What books would you recommend for someone wanting to get better at sales?

like

Ready to leave NYC. Tired of the expense, taxes, COL, bustle, generally burned out, etc. Southern and would like to go back down south. Thinking of Charlotte, Dallas or Houston—any thoughts on those? For reference, in late 20s and been practicing leveraged finance.

like

Would you accept a job offer where pair programming is mandated 100% of the time? I have no real experience pair programming so would like some perspective.

like

Miami fishes! If you had a choice, would you stay at the Ritz Carlton South Beach? Or at the Miami Beach Edition? And why? Thanks!

like

Please help! Do these fees look within normal range or are they too high? I am especially concerned about the title company fees!

Post Photo
like

I think having a Maggi station at a wedding would be really cool.

likefunny

I wouldn't have nearly as many issues with conservative principles if they weren't so hypocritical in how they enact them.

I'm not opposed to lowering taxes, smaller government, and respecting individual rights, but they simultaneously support bailing out big businesses, expanding church and state, and massive deficit spending to pay for dumb wars and tax loopholes for hedge fund managers.

I'd rather see our government provide food, healthcare, and shelter than any of the above things.

likefunny

Does the electric cord of liberty spark in your heart?

funny

Any idea when is the noida office starting to function?

like

What all wellsfargo check in BGV ??

Additional Posts in Data & Analytics Consultants

from God import pandemic
From China import coronavirus, mortality_rate

covid_19 = pandemic.coronavirus.set_mortality(mortality = 1.)

like

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

Single book recommendation for user research?

Goal is interview prep. Ideally focused on applications in tech.

like

Thoughts on Power BI vs Tableau for analysis and data visualizations?

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

Fellow data 🐟, plz recommend me something to do tomorrow. Existing weekend plans went up in smoke and I'm feeling like trying something new

like

How does everyone in this bowl feel towards master’s degrees in data science/analytics? I didn’t study this in undergrad so I’m looking to get an analytics degree but I’ve heard mixed reviews.

like

I have a undergrad finance degree and 5 years of big 3 credit rating agency work experience, what will help me more to get into a SFA role or product role at a tech company, a T15 MBA or a Georgia tech masters in analytics degree?

like
like

Best analytics tools to learn? Know Alteryx but I've heard people say they don't consider it an advanced analytics tool

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

Is anyone working with Elastic at DoD?

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

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

likefunny

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.

Best way to explain to new firms that you are leaving your current firm because of the toxic culture and frankly, a President who talk down to people every chance he gets?

like

New data offering: name.co, or namesoftware.com for the main domain? I’m leaning toward name.co, but I worry about not having the .com.

like

Do any of the top consulting firms have analytics roles (preferably not super technical) that don’t require weekly travel?

I was hired a few months ago by D to do data science. I am not doing data science currently, is there a way I can switch roles internally? Should I talk to my coach? Or should I just start looking for a new job. I’m starting to feel that the field is so hot rn my small stint at D won’t be a big deal to other firms.

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