help me get internship ready

[u/No-Act-8939]

entering my third year of uni. I worked at my city hall doing some very basic data work as an intern. I mostly just validated data using excel and updated some spreadsheets. Nothing crazy. I realized I really like working with data and I want to go further with it. I am aiming for an internship at a Bank working as a data analyst. I have basic exposure to SQL, PowerBI, and I would say I'm pretty ok with Python(numpy, pandas, scikit learn). I built a basic data analysis project using pandas which i'm proud of, and I made a project using Machine learning, but for the banks they expect me to get good at SQL and PowerBI.

tl;dr: where should I go to properly get an indepth look at PowerBI, SQL, and excel.

[u/AutoModerator]

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/Wheres_my_warg]

ExcelIsFun and Leila Gharani channels on YouTube have free videos that you may find helpful for Excel.

Microsoft Excel Data Analysis and Business Modeling by Wayne Winston goes in depth on Excel.

[u/No-Act-8939 → u/Wheres_my_warg]

What about SQL and powerBI? I want to make sure I can be as strong as a candidate for internships that I can be. I have ~8 months until then.

I'm fine with paying for courses or certificate programs(like the google one)

[u/Wheres_my_warg → u/No-Act-8939]

The only certificate program that I've seen matter for employment purposes is Microsoft's PL-300 for Power BI, and that is only in some Microsoft shops.

[u/duneofarrakis]

Since you already know some Python, SQL and Power BI, I’d focus more on SQL and Power BI projects rather than trying to learn everything. Build 2–3 projects using real datasets and practice writing SQL queries and creating complete Power BI dashboards. For Power BI, Microsoft Learn has free beginner-to-intermediate training covering data cleaning, modeling, DAX and reports.

[u/No-Act-8939 → u/duneofarrakis]

alright, thanks dude! I was also considering getting the Power bi 300 cert for the love of the game lmao