The Modeller's Miscellany - #73

Financial Modeller vs data analyst

· Modellers Miscellany

Video // Financial Modeller vs data analyst

Last week Giles Male from Full Stack and John Pauler from Maven Analytics got together to discuss the Financial Modeller & Data Analyst roles and careers.

 Topics covered include:

  • The key similarities and differences between your typical modeller and analyst
  • The most important tools used by both
  • Personality types
  • Advice for new modellers and analysts

Excel // New navigation pane announced

Finding navigating around your model a bit of a pain? Then you are going to love Excel's new navigation pane feature. (See what I did there?).

The new feature, which is currently only available in beta, provides a clear list of all the worksheets in the current workbook in a table of contents style. Expanding a worksheet name lists all of the objects, such as tables, named ranges, etc in that worksheet.

I can't wait for it to come into the live version as it feels like a real winner for improving model transparency. Read more. Myles.

Leadership // Why do so many incompetent men become leaders?

Have you ever worked with people who are not as good as they think? Statistically, these people are more likely to be male than female. One doesn't have to look very far in the world to see this trend at work.

This article from TED discusses 3 reasons why so many incompetent men become leaders.

Tech // Into the Metaverse

The concept of the technological metaverse has started to gain more traction. First named by Neal Stephenson in his 1992 book Snow Crash,  it was mentioned by Satya Nadella in May, when he characterised a collection of Azure offerings as a metaverse. It has also been discussed by Mark Zuckerberg who described it as the future of the mobile internet. This article by Stratechery gives a good history of the idea. Also check out this ten part primer published earlier this year. 

P.S. If you're looking for a great holiday read, and hard sci-fi is your thing, Neal Stephensen's Seven Eves.

Education // The Human Library

The Human Library is a not-for-profit based in Copenhagen where real people are the "books" you can borrow. Its purpose is to facilitate personal conversations between people from different backgrounds to challenge prejudice and contribute to greater human cohesion across social, religious and ethnic divisions. Check out your first book from the human library.

Modeller's Miscellany Jobs

Featured Job 

Finance Associate -  Mountside Ventures - United Kingdom, remote-first 

Financial Modelling Analyst - Barclays  - United Kingdom, Chigwell

Senior Manager, Financial Modelling - CommBank -  Australia, Sydney

Financial Modelling, Senior - EY -  San Francisco, CA

Senior Credit Analyst - Shell - Thailand, Bangkok City,

And finally . . .

This 2015 cartoon from the New Yorker is getting steadily less funny with the passage of time.

Get the Miscellany delivered to you inbox every Sunday.

No spam. No silliness. Just modelling goodness.

All Posts

Almost done…

We just sent you an email. Please click the link in the email to confirm your subscription!