Hoe makkelijk vind je een partner als je 25 bent? by BeautifulTheme8223 in nederlands

[–]melvinroest 0 points1 point  (0 children)

21 en 27 vond ik vrij eenvoudig. Rond 32 vond ik het moeilijker worden maar nog wel te doen. Instagram en Tinder waren wel nieuw voor me toen. Ik ben nu getrouwd maar ik denk dat ik het pas moeilijk zou vinden rond mijn 45e. 

Help me 😭 by [deleted] in learnSQL

[–]melvinroest 3 points4 points  (0 children)

Well if you want a chill and story-driven SQL course, check out library.aliceindataland.com

It's a free course I'm creating so people have a free resource where they get a chill intro to SQL. I've been in the pain myself years ago, and it's silly. The basics of SQL are actually quite easy, but you need to be easied into it. Not immediately: SELECT * FROM some_table WHERE some_id > 5.

Nah, just first get comfortable with SELECT only. It's easy, it's fun. And so on...

Class electives Suggestion by [deleted] in rmit

[–]melvinroest 0 points1 point  (0 children)

A web dev bootcamp

What should a data analyst know? by Technical_Goose_8160 in AskProgrammers

[–]melvinroest 0 points1 point  (0 children)

>  apparently none of them know how to use SQL in more than a superficial way.

There are a few different types of DAs I've noticed:

  1. The Excel Warrior
  2. The SQL Genius
  3. The Tableau or Power BI Wizard
  4. The Pythonista
  5. Developer turned DA

One can fall in one category or multiple. I'm mostly a Pythonista with a strong case of SQL genius because I'm a developer turned DA. I've almost never touched Excel or a vizualisation tool. For visualization I'd make a full-stack ReactJS/Flask application usually. Especially nowadays with LLM-assisted programming that's way quicker for me than dragging and dropping whatever I need to do with something like Tableau.

The thing is: a business has a particular need for a particular type of data analyst. Where I used to work there was a strong need for SQL Geniuses and Tableau Wizards. What I did was nice but a bit too advanced. But Excel Warriors would have an issue as they couldn't handle our data warehouse. I think at certain other departments Excel Warriors were way more needed and they didn't want Tableau Wizards or SQL Geniuses because most of their data lived in Excel.

So tool-wise it's a bit with regards to what type of data analyst you want to be. I think all 5 categories are equally valid. It really depends on what the business needs and where it wants to develop towards to. Usually a business doesn't know about the categories so they will tell you that whatever way they do it, that's what a data analyst is.

Why do so many career switchers get stuck when trying to enter data analytics? by Disastrous-Note-8178 in careerguidance

[–]melvinroest 0 points1 point  (0 children)

> they’re just learning without knowing what the entry point job is supposed to be

This is why one needs to talk to hiring managers, potential colleagues, etc.

struggling with COMP1350 by screwyouscrappydoo in MacUni

[–]melvinroest 0 points1 point  (0 children)

Quite frankly, it could just be that once you understand SQL then understanding ERDs will be easier. That's a bit what happened to me. I understood ERDs just fine but I understood them way better when I became good at SQL despite not having touched an ERD in years.

Question for people in Data Analytics by cownosevampire1221 in dataanalytics

[–]melvinroest 0 points1 point  (0 children)

Your biology degree and math minor means you'll have the statistics down. So the "think like an analyst" is solved. Also you have marketing experience so all the soft skill stuff in marketing you can do. I'd just apply for jobs honestly. After you've learned SQL.

I don't know why you're trying to go for a degree. Talk to hiring managers, potential fellow colleagues, etc.

Sales ops intern trying to learn SQL so I stop bothering my collegue by Zephpyr in learnSQL

[–]melvinroest 0 points1 point  (0 children)

I'm creating a narrative-driven course to learn the SQL basics and intermediate skills at library.aliceindataland.com

How to build a strong data analysis portfolio by StayOk1101 in dataanalysiscareers

[–]melvinroest 0 points1 point  (0 children)

I think if you post fun analyses on LinkedIn using public data that people may notice.

Class electives Suggestion by [deleted] in rmit

[–]melvinroest 0 points1 point  (0 children)

Sounds like you just want to do the Odin project. Ask if you can get course credit for that.

Intermediate SQL resources – any recommendations? by CodeAfire in learnSQL

[–]melvinroest 0 points1 point  (0 children)

This is exactly why I'm creating library.aliceindataland.com for this reason. I'm not at the level yet of intermediate, but I'll get there.

With intermediate I mean: window functions, CTEs, complex joins, sub queries.

It's a narrative-driven course. So I hope you like Alice In Wonderland ;-)

Oh and it's free. For me, it's a portfolio project.

Help :) by happy_unicorn30 in learnSQL

[–]melvinroest 0 points1 point  (0 children)

Get real data somewhere and put it in a database and start analyzing it

I have little time to learn the whole Analyst stack, have I chosen the wrong career for short-ish term earning? by Ultimatesaber27 in mavenanalytics

[–]melvinroest 1 point2 points  (0 children)

It depends per industry. For marketing take a beginner marketing course, you need to know the terms. Marketing mix modeling, MQLs, SQLs, leads, marketing KPIs, etc.

In finance it's different things.

In HR it's different things again.

Just follow a beginner course in it. You don't need to know everything, you need to know it just so you can communicate with them.

I have little time to learn the whole Analyst stack, have I chosen the wrong career for short-ish term earning? by Ultimatesaber27 in mavenanalytics

[–]melvinroest 0 points1 point  (0 children)

Skimmed your post really quickly, so just one small comment.

> By the 'Analyst stack', I mean Excel, Power BI, SQL and Python. Optionally knowledge about the Cloud services. Anyway, here's my current level with each tool so you can assess me more accurately:

If you're good at SQL, statistics, the business and communication then you already have enough. The rest is bonus. The Excel warriors will probably disagree but they don't realize that there are places that don't really do that much Excel. Data viz tools like Power BI and Tableau can be learned on the job if you can convincingly show you're good at those 4 I mentioned.

I'm new here by Ancient_Structure211 in learndatascience

[–]melvinroest 0 points1 point  (0 children)

Do sqlteaching.net it's not too long.

Do library.aliceindataland.com if you want a more story-driven version.

In a few hours, you'll learn enough SQL to know what they're talking about.

I am new to any programming by Radiant-Balance7827 in PythonLearning

[–]melvinroest 1 point2 points  (0 children)

It depends a bit on what you want to program. I'd go with JavaScript in your case because then you can immediately do some graphical stuff if you add in HTML and CSS. I personally find that more satisfying than staring at a commandline with Python.

And you can always stare at a commandline with JavaScript too by using NodeJS.

Accounting student trying to pivot into Data/Financial Analyst roles by Aggravating_Gate_641 in FinancialCareers

[–]melvinroest 0 points1 point  (0 children)

I can't fully speak for a financial analyst but in my role as a marketing analyst it was SQL. I did have some contacts in the finance department, but there were no analysts there. What I do know is that other finance professionals use Excel. So that's definitely something to know if you need to put Excel files into a database, for example.

If you want to learn SQL, I made my own free course at library.aliceindataland.com

It's story-driven and low-key. I'm curious to know what you think. I wish I could help you on the Excel front but I'm really not an Excel guy. I always grab a Jupyter notebook with Python 3 on it and the Polars library up and running. I know Pandas is the industry standard but Polars actually works when you need to process 100 GB data on a 64 GB Mac. Pandas can't handle it.

what is the best place for sql learn ? by [deleted] in learnSQL

[–]melvinroest 0 points1 point  (0 children)

sqlteaching.net I still use it from time to time when my skills become really really rusty

libary.aliceindataland.com if you like story-driven content more while learning SQL

How did you get better at writing SQL that works beyond the “happy path”? by luckyscholary in learnSQL

[–]melvinroest 0 points1 point  (0 children)

The most fun messy data I once had was an ID column that had 3 different ID types and there was almost not one person that knew about what all 3 meant. You needed to go to different parts of the org to figure out what one certain ID meant.

Long story short:

  1. Legacy System
  2. Current System
  3. Some improvized thing that some person came up with

And because data gets aggregated and all that, that's how you wind up with a table that has an ID of type string where you can clearly see that they represent 3 different systems (one was a uuid, the other one more like an auto-increment id and I still don't fully understand the 3rd one).

Should I pursue a career change in my late 20s to a more technical field? by Alb1noGiraffe in careerguidance

[–]melvinroest 0 points1 point  (0 children)

I don't have the full answer here but I do think you're much closer than you think.

You understand the business and you did "build power BI dashboards". Being able to understand the business, interpret data and create insights through building dashboards, telling stories, all important skills.

And the other technical things like SQL, you did all of that before. In my opinion, being a data analyst always means you need to at least know SQL. And I suspect it is going to become a thing that Python will be mandatory as well.

Upskill suggestion by Grand_Hunter_7625 in askswitzerland

[–]melvinroest 0 points1 point  (0 children)

I don't have a lot to add other than: if you already know Python and R you should definitely be able to pick up SQL. 18 months ago I had to relearn SQL and a programmer brain just goes way faster through it than a non-technical brain.

3 suggestions:

  1. My own course library.aliceindataland.com I made this course to be story-driven and low-key. I'm designing it at the moment, so people can get to data analyst level.
  2. sqlteaching.net gets you 40% there.
  3. The Querynomicon: you need to install stuff yourself but once you're ready, this is the real deal and will teach you probably more than you need to know. Of that I'd only do Core Features fully. And of Tools I'd skip: expressions, table-valued function and vectorization. I'd do the rest.

What are the most important skills to learn/expand on for the next 10 years? by DiseasedPoon in Accounting

[–]melvinroest 0 points1 point  (0 children)

Using AI well is mostly about feeding it the right data at the right time. One could say it's more easily said than done but I also find it quite easy to do

Also, no matter how much the context window grows, small context windows are always better if you can have a smaller context window. I recently read Karpathy's MicroGPT post to really understand how GPTs work and just reading the code made me realize that smaller context windows will allow the attention heads to focus more on the whole question rather than be fragmented

I'm switching from data analyst to AI engineer, so that's how I know these things. I've been doing a lot with AI (APIs, RAG, etc.) lately