It depends on the country and “tier” you work for.
The top 3 strategy consultancy firms known as MBB (McKinsey, Bain & Company, BCG) tend to accept almost exclusively MBA students from the top business schools in the world.
Then you’ve got other firms including the big 4 (Accenture, PwC, EY, Deloitte, Capgemini, etc) that will tend to accept degrees in business (usually MBA not necessary), but that can vary depending on which “branch” of consultancy you’re in, you could be a techy and go into technology consulting, or even technology strategy consulting for example.
And then there’s a whole range of boutique and smaller firms of which I’ve got no clue what you need to get in.
To your question on technology/computer: in this day and age, almost every single consultancy project has at least some element of technology involved, so knowing tech is always a big plus.
For analysis etc, I’m not going to lie, I tend to simply boot all my needs to one of our teams in India or Eastern Europe and let them deal with it for me, it’s cheaper for the client to let them do this rather than someone based in the West anyway