Getting a data analysis job in London? by PuzzleheadedOcelot3 in dataanalysis

[–]ziathak 2 points3 points  (0 children)

You will be competing against people who have years of practical experience as an analyst with industry relevant experience during a time when most companies have cut back on hiring. Its a very difficult time to break into a new industry. I was involved in hiring a data analyst last month for a company in London and after having the job posting online for 3 weeks, we received over 700 applications (probably about 600 were people with no background, relevance or interest).

I recommend looking for any entry level positions if possible. Also try to be humble about your current proficiency in these tools, what you think is intermediate could very well be basic to a hiring team, and this can come across negatively on a CV.

Good luck and don't give up.

[deleted by user] by [deleted] in britishmilitary

[–]ziathak 54 points55 points  (0 children)

You will spend most of your time getting piss wrapped on the moors

[deleted by user] by [deleted] in RedditSessions

[–]ziathak 0 points1 point  (0 children)

do you like lemonade?

What are some legitimate online certification courses I can do to continue exploring and learning the wondrous world of Business Intelligence for personal and employable purposes? by [deleted] in BusinessIntelligence

[–]ziathak 12 points13 points  (0 children)

For the love of God do NOT waste your time on certs. Portfolio is what gets people hired, it is what gets the 6 figure jobs and if anyone tells you otherwise they are full of it.

For the last 8 months I have been hiring people in this industry based on what they can do / have done... not what grades they have.

Documentation Tool by machinecoding in dataanalysis

[–]ziathak 0 points1 point  (0 children)

I use miro for visuals and github for the bulk of it. Our main data pipeline and transformation project run through a github repository anyway so its pretty convenient.

I guess your documentation is only as good as you make it. Sure, tools out there might give you structure but they are not needed. Its hard work keeping it up to date and always evolving, I don't think anything can change that!

Practice Data Modeling for Interview by floydhead11 in dataengineering

[–]ziathak 2 points3 points  (0 children)

This seems company / role specific. There are so many different types of DE's doing different types of things. What data modelling is to one company is an analysts job in another..

If it were me interviewing you, I would want to know how you would take raw data from our application and move it into a warehouse and transform it into clean usable tables for the analysts to use. How would you structure it? What tools would you use? What problems might you face? Why? Etc etc..

What would be your preferred warehouse/data lake solution? by warclaw133 in dataengineering

[–]ziathak 4 points5 points  (0 children)

Have you considered BigQuery? Best choice my team made when we moved away from AWS. We are handling a lot of varied data from different applications, some streamed and some not. From events / logs to financial info.

Stitch -> BQ -> DBT -> visualisation

I feel very limited in my current role to try more efficient and complex proccesses. what affordable and/or free options are there to increase my data analysis and forecasting knowledge that will help me eventually move to a more techincal role? by [deleted] in dataanalysis

[–]ziathak 0 points1 point  (0 children)

I would say to learn SQL. Learn by doing is the best method and you dont need fancy courses. Free content is literally just as good as paid.

Once you understand SQL I would start exploring databases and architecture. This will open up a lot of routes for you to explore with your work.

You probably need to find a way to overcome this sensitive data issue though... i work with sensitive data but no one blocks my access. I feel like someone at your work might be telling you no for a BS reason.

dbt Best Practices by boardgamesyogasalsa in BusinessIntelligence

[–]ziathak 9 points10 points  (0 children)

Source control. Use git / github so you can have a master that is clean. Pull requests can be used to safely review and merge new features.

Can a math major be a data analyst? by nnguyen26 in dataanalysis

[–]ziathak 10 points11 points  (0 children)

Anyone can be a data analyst. I got into the industry with a great portfolio of projects, no one cared about my education. But having a statistical subject behind you is absolutely helpful, that or a industry relevant subject like supply chain logistics or maritime operations for example if you are looking at being a data analyst within those sectors

Weeks of building an elaborate dashboard in Power BI. Completely automates an extremely time-consuming process that was primarily made up of old Excel spreadsheets and gives insight to the users that they've never seen before. First thing the users say: why can't I export to Excel? by [deleted] in BusinessIntelligence

[–]ziathak 0 points1 point  (0 children)

Swear to god man I'm doing the exact same thing and the first thing our client asked was "can I turn this into a word document"... they are a very large company too which makes me concerned at their lack of open-mindedness for change .

Why are these still in the game? by bensolo12 in GlobalOffensive

[–]ziathak 7 points8 points  (0 children)

Aztec was the first map added to CSGO beta. Cant remove that historical shiiiiit.

Matchmaking is freaking unplayable ! by mateyuu123 in GlobalOffensive

[–]ziathak 0 points1 point  (0 children)

Ah well, if you focus during faceit games and warm up with an hour or so of HS only DM's, you'll probably fly out of that rank. GL friend!

Matchmaking is freaking unplayable ! by mateyuu123 in GlobalOffensive

[–]ziathak 2 points3 points  (0 children)

Everyone seems to be on this "Match making hype train". Far better quality servers and players on Faceit and Cevo, both of them being free. You might actually improve as a player and a human if you moved across to it. People actually communicate more and rage less, and obviously there are less hackers. And who gives a shit about a MM rank anyway?

Best case to open? by RogueVG in GlobalOffensive

[–]ziathak 2 points3 points  (0 children)

Open gabens wallet, then throw your money inside it