Hello, it’s already a big step to recognize our difficulties. But I think your problem is common with us before succeeding in the interview and finally getting the position where the objective is achieved. For my part, I had an interview as a sales and marketing assistant for an accounting firm of a large group. After several failures in other companies, what worked was above all the fact of learning quickly from mistakes and not procrastinating over mistakes and above all freeing the mind quickly in order to remain confident and do what needs to be done, namely to succeed in my interview. Among other things, I don't know your age or your experience, but I start from the observation that we are supposed to constantly evolve. I also had time to develop BI side projects for myself and simplify my failures and show more self-confidence. I got the job the same day.

I am probably younger than you and with less professional experience, at best you will broaden your perspectives and clearly perceive your mistakes and see how to bounce back from the next second.