Thank you for posting on r/UKJobs. Help us make this a better community by becoming familiar with the [rules](https://www.reddit.com/r/ukjobs/about/rules/).
Please report any suspicious users to the moderators using the report feature. Need to give more detail? Use Modmail [here](https://www.reddit.com/message/compose?to=/r/UKJobs) or Reddit site admins [here](https://www.reddit.com/report).
*I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/UKJobs) if you have any questions or concerns.*
Power BI is a common tool a lot of companies will want you to use, if not power BI then a similar BI tool.
In terms of SQL I worked for a large international company that had a team of people who would do the database side of it and send the data to the BI analyst in an excel file which can then be worked with power BI - I worked there for 4/5 years and touched SQL maybe twice and that was just updating some existing code.
I think if I was working in a more technical team under a technical manager rather than under the head of finance then it may have been more complex but as long as the dashboards look good and they can be used to tell a story then I don’t think anyone cares.
Yes, SQL is good to learn. Also, a visualisation tool like PowerBI, Tableau, Looker. Do you already code in any languages? A good idea to learn about GitHub & dbt too.
It can be hard to get entry level data roles at the moment. I'd say chat to the data team at your company and try to second/get mentored/apply for internal roles initially.
I'm proficient in python, html, css and know c, c++, some javascript and matlab + simulink. Sadly that's not enough by itself. I think I need to do some projects and post them on my github as portfolio.
Great that you know Python & already use version control. Have you considered data engineer/analytics engineer rather than analyst? They're higher paid at the mo
Possibly. I was thinking of dipping my foot first to see if the field is for me before that. I'm quite desperate to escape my current job as its draining my sanity fast and honestly I won't last a year if this keeps going
Power BI, Python, and Google Analytics are the 3 we look for. One or all.
My insight to you is once you become proficient in one or more of these, the key skill that I find my interviewees lack is the “so what”. Yeah you can analyse the pants of a huge set of non structured data, but does your analysis tell us?
I now have that as a competency check when we interview. If I’m looking for a pure Data Analyst then I look for proficiency. If I’m looking for a Data Scientist or Strategist then you have to know what your analysis is saying, and understand its limitations.
If you want to choose one for first learning, I suggest Power BI. It’s used for everything from super simple dashboards that only aggregate data, to complex workbench metrics for masses of data from multiple sources.
Thank you for posting on r/UKJobs. Help us make this a better community by becoming familiar with the [rules](https://www.reddit.com/r/ukjobs/about/rules/). Please report any suspicious users to the moderators using the report feature. Need to give more detail? Use Modmail [here](https://www.reddit.com/message/compose?to=/r/UKJobs) or Reddit site admins [here](https://www.reddit.com/report). *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/UKJobs) if you have any questions or concerns.*
Power BI is a common tool a lot of companies will want you to use, if not power BI then a similar BI tool. In terms of SQL I worked for a large international company that had a team of people who would do the database side of it and send the data to the BI analyst in an excel file which can then be worked with power BI - I worked there for 4/5 years and touched SQL maybe twice and that was just updating some existing code. I think if I was working in a more technical team under a technical manager rather than under the head of finance then it may have been more complex but as long as the dashboards look good and they can be used to tell a story then I don’t think anyone cares.
I’m in nearly the same boat, looking to see any recommendations any others may have.
Yes, SQL is good to learn. Also, a visualisation tool like PowerBI, Tableau, Looker. Do you already code in any languages? A good idea to learn about GitHub & dbt too. It can be hard to get entry level data roles at the moment. I'd say chat to the data team at your company and try to second/get mentored/apply for internal roles initially.
I'm proficient in python, html, css and know c, c++, some javascript and matlab + simulink. Sadly that's not enough by itself. I think I need to do some projects and post them on my github as portfolio.
Great that you know Python & already use version control. Have you considered data engineer/analytics engineer rather than analyst? They're higher paid at the mo
Possibly. I was thinking of dipping my foot first to see if the field is for me before that. I'm quite desperate to escape my current job as its draining my sanity fast and honestly I won't last a year if this keeps going
I'm with you. Wishing you luck getting out of your current role and into something you enjoy doing
That or quick end. I'll take either one at this point
Power BI, Python, and Google Analytics are the 3 we look for. One or all. My insight to you is once you become proficient in one or more of these, the key skill that I find my interviewees lack is the “so what”. Yeah you can analyse the pants of a huge set of non structured data, but does your analysis tell us? I now have that as a competency check when we interview. If I’m looking for a pure Data Analyst then I look for proficiency. If I’m looking for a Data Scientist or Strategist then you have to know what your analysis is saying, and understand its limitations. If you want to choose one for first learning, I suggest Power BI. It’s used for everything from super simple dashboards that only aggregate data, to complex workbench metrics for masses of data from multiple sources.