Upskilling on Analyst Requirements

SieIso

Hi,

I have noticed that several jobs are just slightly out of scope for me as I don't have the following, is there anywhere I can upskill on these or are they a little more difficult than that?

Power BI dashboards
SQL and power query.

Any advice would be appreciated.

Devongardener

There are plenty of YouTube articles on both.  The problem you might have is proving actual experience in these skills to new employers.     In the past I’ve interviewed candidates who claimed various software experience and skills but had little experience applying them in commercial situations.   However willingness to learn in your own time can be a positive for prospective employers.

Doshwaster

SieIso said:

Hi,

I have noticed that several jobs are just slightly out of scope for me as I don't have the following, is there anywhere I can upskill on these or are they a little more difficult than that?

Power BI dashboards
SQL and power query.

Any advice would be appreciated.

I'd say pick one of those and try to use it in your daily work - it's important to do actual real world work with them rather than just text book examples. Both are useful but if you try to learn them at the same time you will spread yourself too thinly. Sometimes it's better to be good at one thing than just be able to hack around with two different things.

There are plenty of other analytics tools available - Spotfire, Tableau, R etc and different companies will prefer different applications so you need to be flexible in learning something new so it's important to show an ability and willingness to learn..  I may be old fashioned now but I still think you can't go wrong with a good foundation in SQL as it is at the core of a lot of data science. I'm pretty rubbish at Power Query though.

DullGreyGuy

SieIso said:

Hi,

I have noticed that several jobs are just slightly out of scope for me as I don't have the following, is there anywhere I can upskill on these or are they a little more difficult than that?

Power BI dashboards
SQL and power query.

Any advice would be appreciated.

Are you wanting to transition into a Data Analyst? What's the long term aim?

SieIso

This one is available through work concerning SQL, it looks decent:

15 Days of SQL: The Complete SQL Masterclass 2024

SieIso

DullGreyGuy said:

SieIso said:

Hi,

I have noticed that several jobs are just slightly out of scope for me as I don't have the following, is there anywhere I can upskill on these or are they a little more difficult than that?

Power BI dashboards
SQL and power query.

Any advice would be appreciated.

Are you wanting to transition into a Data Analyst? What's the long term aim?

I do sit partly within that field at the moment but my experience is heavily focused towards Excel.

Doshwaster

SieIso said:

DullGreyGuy said:

SieIso said:

Hi,

I have noticed that several jobs are just slightly out of scope for me as I don't have the following, is there anywhere I can upskill on these or are they a little more difficult than that?

Power BI dashboards
SQL and power query.

Any advice would be appreciated.

Are you wanting to transition into a Data Analyst? What's the long term aim?

I do sit partly within that field at the moment but my experience is heavily focused towards Excel.

In which case I would start by trying to do some of your usual work in Power Query within Excel as you will already have everything you need to get started. It's a good way of automating repetitive steps in data analysis so that you can show off to your boss that you can get work done quicker.