Sundae posted:His website, emphasis mine: Which one of them is this, Acampora or Du Soleil?
|
|
#
?
Dec 19, 2022 21:40
|
|
|
|
| # ? Jun 7, 2024 11:18 |
|
|
Discendo Vox posted:Which one of them is this, Acampora or Du Soleil? Du Soleil. Jon's profile is boring.
|
|
#
?
Dec 19, 2022 21:44
|
|
|
Welcome back to the 2022 excel championship. We are joining Chester, an associate analyst in Goldman’s investment arm. He’s entered the third tab and seems to be cruising along. Right you are Ken, it was touch and go for a minute in the “numbers formatted as text” sandtrap last tab, but he chipped out of it. It was impressive how he- Hold on Alec, are you seeing what I’m seeing? Oh indeed, Chester is hard coding the year into his lookup formula instead of pointing to a reference cell! I can’t imagine what he’s thinking, this classic blunder will undoubtedly earn a demerit with the judges who are looking for scalability of the model. We see this with investment bankers - they churn through jobs quickly and prioritize speed, figuring they won’t be around to clean up the model when the next year rolls around. Whatever the reason, this is thrilling stuff. Let’s see if our on desk reporter Roland can dig up any insights from Chester’s coach..
|
|
#
?
Dec 19, 2022 22:17
|
|
|
Sundae posted:It's the backup table for when someone in the audience doesn't like your data. Picturing one of those blackboards that flips over Chart going down -> chart going up!
|
|
#
?
Dec 19, 2022 23:23
|
|
|
Democratic Pirate posted:Welcome back to the 2022 excel championship. We are joining Chester, an associate analyst in Goldman’s investment arm. He’s entered the third tab and seems to be cruising along.
|
|
#
?
Dec 20, 2022 05:24
|
|
|
Fourier Series posted:Is this a joke? Or is it really that tone of sport commentating for the Excel championships? I don't know, but I'm on the edge of my seat here.
|
|
#
?
Dec 20, 2022 06:45
|
|
|
TraderStav posted:I don't know, but I'm on the edge of my seat here. But are you on the edge of the table?
|
|
#
?
Dec 20, 2022 07:01
|
|
|
priznat posted:But I’m serious I still don’t have a clue what a pivot table is. Serious answer: Let's say you have a spreadsheet with a list of computers, with hard drive size and RAM as columns. Using the pivot table wizard, you can learn how many machines have 8GB RAM and how many have 16GB. Or, it does CountOF and Average calculations for you.
|
|
#
?
Dec 20, 2022 07:11
|
|
|
priznat posted:I would just always ask “what is a pivot table?” So often he just blocks me on Teams it's a way of representing an n-way (or n-rank tensor if you're a huge nerd like me) dataset in 2-way manner. A normal spreadsheet is a 2-way dataset, but you could have five, ten or a million dimensions and those can't be shown on a screen in any meaningful sense. In a pivot table you select which parameters you want to see and it helps you make sense of the maddness. edit: I realized what I wrote might not be helpful. 2-way would be 2 dimensions
|
|
#
?
Dec 20, 2022 07:32
|
|
|
JohnCompany posted:But are you on the edge of the table? *checks ticket* "Row 1,048,576" 
|
|
#
?
Dec 20, 2022 07:51
|
|
|
we'll give you the entire pivot graph but you'll only need the edge
|
|
#
?
Dec 20, 2022 07:53
|
|
|
champagne posting posted:it's a way of representing an n-way (or n-rank tensor if you're a huge nerd like me) dataset in 2-way manner. 
|
|
#
?
Dec 20, 2022 08:35
|
|
|
*Brian under his breath* Oh goddammit she's one of those anti-OOP people gently caress.
|
|
#
?
Dec 20, 2022 11:53
|
|
|
priznat posted:I would just always ask “what is a pivot table?” So often he just blocks me on Teams
|
|
#
?
Dec 20, 2022 12:54
|
|
|
Data reduction for executives i like 90% of my job. I like pivot tables. I can change the data as fast as they change their minds, arbitrarily.
|
|
#
?
Dec 20, 2022 13:33
|
|
|
Pivot tables are great for rapid prototyping and bloody awful for most other things.
|
|
#
?
Dec 20, 2022 14:05
|
|
|
Fil5000 posted:Pivot tables are great for rapid prototyping and bloody awful for most other things. Yeah it’s this. Want a quick read on a distribution of a bunch of categoricals, or some quick and dirty cross tabs? Pivot tables are great. For any kind of repeatable analysis, advanced work, or consistent reporting they suck.
|
|
#
?
Dec 20, 2022 14:26
|
|
|
Threadkiller Dog posted:Data reduction for executives i like 90% of my job. I like pivot tables. I can change the data as fast as they change their minds, arbitrarily. Best pithy description of what pivot tables are for I've ever seen right here.
|
|
#
?
Dec 20, 2022 15:13
|
|
|
Eric the Mauve posted:Best pithy description of what pivot tables are for I've ever seen right here. Oh, you want to 'drill down'? Sure ,drop-down menu, select "CA" market, listen to impressed shooting.
|
|
#
?
Dec 20, 2022 15:19
|
|
|
I fired up R to do a chi squared test in a meeting the other day. Even though we're supposedly scientists, people behaved like I was a wizard practicing the dark arts. Good job it was a teams meeting or I could have met a fiery end.
|
|
#
?
Dec 20, 2022 15:30
|
|
|
Alt-tab, Ctrl-Arrow keys to select data, Ctrl-c, Ctrl-v, Ctrl-Shift-L: arcane spells lifted from a Tome of Tabs.
|
|
#
?
Dec 20, 2022 16:17
|
|
|
nerds
|
|
#
?
Dec 20, 2022 17:16
|
|
|
knox_harrington posted:I fired up R to do a chi squared test in a meeting the other day. Even though we're supposedly scientists, people behaved like I was a wizard practicing the dark arts. Good job it was a teams meeting or I could have met a fiery end. EVERY MORNING I OPEN PALM SLAM AN INDEPENDENCE TEST INTO R.
|
|
#
?
Dec 20, 2022 18:03
|
|
|
Took read:barely passed the whole Calc sequence and Linear Algebra and now the hardest math I do is long division. I still spend an inordinate amount of time correcting analysts’ work and making their charts legible and nice to look at.
|
|
#
?
Dec 20, 2022 18:57
|
|
|
tumblr hype man posted:Took read:barely passed the whole Calc sequence and Linear Algebra and now the hardest math I do is long division. I still spend an inordinate amount of time correcting analysts’ work and making their charts legible and nice to look at. yea
|
|
#
?
Dec 21, 2022 04:40
|
|
|
Threadkiller Dog posted:Data reduction for executives i like 90% of my job. I like pivot tables. I can change the data as fast as they change their minds, arbitrarily. You want to REALLY impress those executives? Get a license for ThinkCell and bring your PowerPoint game to the big leagues.
|
|
#
?
Dec 21, 2022 05:08
|
|
|
TraderStav posted:You want to REALLY impress those executives? Get a license for ThinkCell and bring your PowerPoint game to the big leagues. I embedded a powerbi report page inside a PowerPoint slide and my managers manager lost his poo poo.
|
|
#
?
Dec 21, 2022 07:45
|
|
|
tumblr hype man posted:Took read:barely passed the whole Calc sequence and Linear Algebra and now the hardest math I do is long division. Extremely this.
|
|
#
?
Dec 21, 2022 20:10
|
|
|
My managers shut me down hard when I showed up with some pivot tables, because they didn't know how they worked and didn't want to learn.
|
|
|
#
?
Dec 22, 2022 01:27
|
|
|
Aah another practitioner of the dark arts
|
|
#
?
Dec 22, 2022 01:35
|
|
|
My business unit has 2 primary teams. One manager likes pivot tables, the other prefers lookup formulas and such. Entry level applicants are basically getting to choose their skill tree for basic excel analysis.
|
|
#
?
Dec 22, 2022 02:55
|
|
|
I had a manager who liked to use macros for everything. Frequently I would need to have multiple workbooks open at one time. For some reason he was fond of “ctrl f” for deleting all data on a worksheet. He did not understand why I had a problem with this. You might think this was intentional, but this guy also didn’t like music and once drove from San Diego to Vancouver BC with the radio off. He did not understand why anyone thought this was strange. In retrospect I think he may have had ASD.
|
|
#
?
Dec 22, 2022 04:54
|
|
|
I have a question about recruiters in the US - is there any point to using them? My partner runs an Australian-based data reporting start-up and he's at the point where he probably needs someone on the ground in America to manage their clients there due to the time zone differences causing support delays. Since the company is willing to offer the same leave benefits available to our Australian employees I don't think there's going to be any issue in attracting candidates. Mr bee met with a recruiter this morning and the recruiter's fee is 25% of the salary which seems excessive considering when we've used a tech-specific recruiter here it's been around 13-15%. Is there something I'm missing here that the recruiter does that is worth that extra 10% fee?
|
|
#
?
Dec 22, 2022 06:25
|
|
|
25% isn't that unusual in my experience, though it's on the high end. Pharma rather than tech though.
|
|
#
?
Dec 22, 2022 08:03
|
|
|
Democratic Pirate posted:My business unit has 2 primary teams. One manager likes pivot tables, the other prefers lookup formulas and such. Entry level applicants are basically getting to choose their skill tree for basic excel analysis. There is nothing I can do with a Pivot Table that I can't do with 900 sheets each with its own VLOOKUP, motherfucker 
|
|
#
?
Dec 22, 2022 10:45
|
|
|
bee posted:I have a question about recruiters in the US - is there any point to using them? My partner runs an Australian-based data reporting start-up and he's at the point where he probably needs someone on the ground in America to manage their clients there due to the time zone differences causing support delays. Since the company is willing to offer the same leave benefits available to our Australian employees I don't think there's going to be any issue in attracting candidates. Mr bee met with a recruiter this morning and the recruiter's fee is 25% of the salary which seems excessive considering when we've used a tech-specific recruiter here it's been around 13-15%. Is there something I'm missing here that the recruiter does that is worth that extra 10% fee? Have you asked the local recruiter if they have any relationships with US firms? If you’re looking at specific fields, it’s a real small world.
|
|
#
?
Dec 22, 2022 12:37
|
|
|
Encountered a “bio break” this morning. I took my break happily ignorant of human waste and all its producers and outlets.
|
|
#
?
Dec 22, 2022 16:25
|
|
|
I didn’t realize people used that term outside of Warcraft raids lol.
|
|
#
?
Dec 22, 2022 17:33
|
|
|
bee posted:I have a question about recruiters in the US - is there any point to using them? My partner runs an Australian-based data reporting start-up and he's at the point where he probably needs someone on the ground in America to manage their clients there due to the time zone differences causing support delays. Since the company is willing to offer the same leave benefits available to our Australian employees I don't think there's going to be any issue in attracting candidates. Mr bee met with a recruiter this morning and the recruiter's fee is 25% of the salary which seems excessive considering when we've used a tech-specific recruiter here it's been around 13-15%. Is there something I'm missing here that the recruiter does that is worth that extra 10% fee? Depending what you're looking for it may be more of a challenge to find what you're looking for. Good leave benefits are great but I don't know that that by itself will make finding someone trivial. I agree 25% is high but within the regular bounds, the guys I use usually do 2 months salary. Is it worth it? It depends. If you are looking for something hard to find.I can see a search sucking up a lot of time. If you do have time I'd probably suggest casting your net first on your own and seeing what you find. If your in a time crunch then I'd probably say just pay the recruiter.
|
|
#
?
Dec 22, 2022 17:50
|
|
|
|
| # ? Jun 7, 2024 11:18 |
|
|
remigious posted:I didn’t realize people used that term outside of Warcraft raids lol. Perhaps my coworker has outed themselves. Appropriately corporate term though.
|
|
#
?
Dec 22, 2022 18:03
|
|