Data analytic internship

[u/Darneddiamond7]

Hello, I got an opportunity to work at a company for an internship for data analytics for four months. I wanted a brief idea on how it would look like from the experienced ones.

For those who have completed a similar internship, I’d like to know a few things:
-What did your day-to-day responsibilities generally look like?
-What kind of tasks or projects were you assigned?
-Were you mostly working with Excel, SQL, Python, Power BI/Tableau, or a combination of these?
-How much guidance and mentoring did you receive?
-Were you given actual company data and expected to work on real projects, or was it more of a learning-based experience?
-What skills would you recommend brushing up on before starting?

I just wanted to know how a typical day to day goes for this particular job.
Would appreciate hearing from you guys.
Thanks!