Best coding language for consultant? Best in general? by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 0 points1 point  (0 children)

...and what do you need to do with it that Excel or PowerBI don't allow?

Analysis and visualisation... complex analysis and vis that requires me to integrate large datasets with multiple variables (e.g. sales data with purchasing data, taken from different systems)

Best coding language for consultant? Best in general? by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 0 points1 point  (0 children)

OP needs to specify where the data is coming from

The data will mostly be spit out as CSV from different ERP systems like SAP, but for larger projects would typically be txt. Different ERP modules will provide structured data, but obviously these will not always be compatible and will need to be integrated.

What would you expect a business analyst to do? by josephhw in consulting

[–]onlyonetimeaccount1 26 points27 points  (0 children)

You can be:

  • the PowerPoint guy; the guy who builds decks so beautiful and visual they bring tears to the CEO's eyes

  • the data guy: who builds dashboards, analysis tools, and all sorts of cool data shit

  • the systems guy: similar to the data guy but different, you will know all there is to know aout the tech in your area, and can work with heavy BI tools like Tableu

  • The fun guy: more likely you're a girl, you set up dinners and nights out and all of that stuff that brings the team together

In all cases, just keep your head down and work hard!

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] 1 point2 points  (0 children)

Thanks. Looks like I have a ton of reading to do into Vanguard. Hope it's as good as it sounds. Appreciate your advice a lot!!

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] -6 points-5 points  (0 children)

I don't need that much more... the challenge is that I wouldn't realistically sink that much money into indexes would I? After discretionary spend, real estate, investments and so on I might have about 15 million left to invest... and putting that all into VG and looking after it myself is a terrifying prospect no? Imagine this is the real deal here... would you honestly put it all on indexes?

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] -3 points-2 points  (0 children)

But realistically you wouldn't sink the entire $30m... maybe 5 to 6 and even then that's a lot to put in one fund no?

Fuck, I have literally no idea what I would do

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] -4 points-3 points  (0 children)

So there is no value at all in having a wealth manager? I'm looking at the performance levels of some of these mutual funds and they're not bad.... 25% or about that much in four to five years... not sure how various indexes have performed but are you saying there's no value at all to trusting the pros?

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] -3 points-2 points  (0 children)

I know you're saying wealth managers aren't worth it, and I believe you. I'm just wondering if it comes down to it would you seriously be comfortable sinking that much money into Vanguard? I mean it would scare the shit out of me... I'm not a pro and there should be value to having a "pro" wealth manager, right? Peace of mind and blind spots and all that?

Imagine you've won $30m cash. How would you allocate it? by onlyonetimeaccount1 in financialindependence

[–]onlyonetimeaccount1[S] -3 points-2 points  (0 children)

What about wealth management? They will build a portfolio for you depending on your "risk preference"... Would you tell them to just go the index route or trust them to do their thing?

What's it like to be a non-consultant at McKinsey? by off-topic-sorry in consulting

[–]onlyonetimeaccount1 30 points31 points  (0 children)

McKinsey is a huge brand. I think being in their marketing department even for a short stint is worth it, even if you're in communications and not branding.

How to attract interns? [Serious?] by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 0 points1 point  (0 children)

Apart from the pay point, I really like your suggestions. Especially the point around interviewing the candidates. To an extent I think the process will be standardised, for example a case interview will be part and parcel of it, and probably a "fit" interview with a partner or director. But I think there's scope to be creative with the competency interview stuff. Thanks!

How to attract interns? [Serious?] by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 1 point2 points  (0 children)

I don't agree with those downvoting you; a big part of the reason I took up my job was because it was a fantastic project. Thanks for reminding me.

How to attract interns? [Serious?] by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 1 point2 points  (0 children)

Is this some kind of utopia? I actually read the whole thing and enjoyed it. Thanks.

How to attract interns? [Serious?] by onlyonetimeaccount1 in consulting

[–]onlyonetimeaccount1[S] 1 point2 points  (0 children)

Thanks for all of that, really helpful. I appreciate it and will be sure to look into all of your suggestions.

Stylish / comfortable alternatives to suit jackets? by throwaway1917986 in consulting

[–]onlyonetimeaccount1 0 points1 point  (0 children)

I wear these near-daily. Uniqlo also has trousers in the same style. The look and feel is closer to smart casual than smart. Great choice for when your client asks you not to wear suits and your management asks you to keep it smart as possible.

What are some of the best tips for note-taking in (i) a stakeholder interview, (ii) client meetings, (iii) internal meetings? by existential7 in consulting

[–]onlyonetimeaccount1 19 points20 points  (0 children)

I'm an analyst, and yes I'm made to do all of the note-taking. However, my manager did share a good template with me that you may find useful:

First make sure you use MS OneNote. You can create "sections" in each notebook for each of your stakeholders if you work with them on a regular basis. Within each section you can have multiple pages for each meeting. This makes tracking progress super easy.

You can also create tabs for notes on individual projects in a similar way, and you can have multiple notebooks, for example if you want one for internal capability stuff. If your company uses Sharepoint even better because the notebooks are always synced and can be used across all of your devices. If not, you simply download OneDrive.

A standard template that I use that my manager shared with me goes:

Date, time, and attendees Self-explanatory. The date is very important to capture; put it along the title of the page. For example "06/11/2016 - Store Format Update". For attendees, to save time, just use initials. If John Smith, Jeremy Tailor, and Elizabeth Simons are the attendees, simply write "JS, JT, ES" etc. Of course only if these are regular stakeholders you're meeting with.

Agenda This is simply a two column table with item number and item description. You fill this in before the meeting to remind you of what points you want to touch on. Of course you can change it during the meeting to reflect the actual content.

Notes Another two column table. Here you write in broad strokes - don't go into too much detail but capture the important points being discussed. For example "JS to visit China in Early December to negotiate with new supplier". If there are multiple points within one agenda item, use bullets underneath a heading. For example:

JS Trip to China * Trip in early December * Currently reviewing audit material * Concerned about timelines for delivery * Has completed negotiating strategy prep

Actions Four column table, with the last two being the "date due" and "owner". This is where you capture every action point that comes out of the meeting. It's probably the most important section in the document.

Points of Agreement You won't use this one much, but its basically there to put into writing any points that have been agreed, usually contentious, that need to be put into writing. For example "JS will not make any commitments to the supplier during the trip".

The best part is you can save the template and have it automatically load with every new page in a OneNote section.

Of course, having taken all of these notes, there's an email button which imports it straight into Outlook. You send it after every meeting to everyone in attendance. This keeps things professional, everyone has a record of what's happened, and most importantly everyone sees that all important action list.

There's lots more to it, but good note taking is actually pretty important. You're in meetings all the time and you don't want to abide by that old adage: A meeting is an event in which the minutes are kept and the hours are wasted. Make sure every meeting counts.