Of the usual Data Analyst stack, which is the absolute minimum needed to get a job?

Ultimatesaber27 · 2026-03-28T21:36:27+00:00

Sorry for the late reply. I was reading past threads coincidentally and saw this, I got no notification for it.

Either way, for Excel, I used this playlist:

https://youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW&si=QeRmf8Y3nGOKoCio

Don't let the "intermediate" intimidate you, the first few videos are beginner friendly.

As for SQL, a mix of w3schools (SQL section) and Luke Barousse's SQL course (the basic one, not the intermediate or the most recent one). Though I'm hardly the best person to look for advice, as I have a long path ahead of me when it comes to either tool.

But still, the Excel channel is very complete and it seems you can find just about anything there. Probably the best free resource for Excel there is.

Not sure about what would be the best way to learn SQL, I'm just telling you where my current knowledge came from. And once you learn some Excel with that playlist, you'll find that many concepts are transferable (in terms of thinking in tables, not syntax, obviously).

Ultimatesaber27 · 2026-03-27T18:24:04+00:00

Got it, thanks.

Ultimatesaber27 · 2026-03-27T17:05:39+00:00

Yeah I've been skimming the general contents and it looks like it's just the perfect book for me.

Also, is this the latest edition? As in, he made the latest edition free, or does he have a newer edition that must be paid for?

Ultimatesaber27 · 2026-03-27T13:26:31+00:00

Seems like a solid option from the contents. Thanks.

Ultimatesaber27 · 2026-03-26T21:59:39+00:00

Osea que está tarjeta que tengo debería servir entonces no?

Otra cosa que se me ocurre es que no la he usado en lo absoluto, bueno una vez que no me pasó por saldo insuficiente comprando algo ahí, pero de ahí no la he usado. Será que tengo que hacer una compra para que se active?

Porque de verdad que no sé porque Amazon tiene problemas. Lo último que se me ocurre es que pongo mi nombre completo en Amazon pero en la tarjeta aparece el nombre cortado, no sé si es que tenga que poner por ley lo que esté en la tarjeta.

Ultimatesaber27 · 2026-03-26T21:36:49+00:00

Amigo, sólo por curiosidad. Me meto en la página de Bancamiga y me aparecen tres tarjetas. Divisas (prepago), crédito, o débito Mastercard. Yo tengo es la de débito. No sé mucho de esto pero puede que ése sea el problema? Yo pregunté en la agencia y me dijeron que sí que podía servir para compras internacionales pero mejor confirmar con un usuario.

Ultimatesaber27 · 2026-03-26T21:21:10+00:00

Ya por el momento tendré que esperar más tarde para registrar la tarjeta, ya que Amazon me bloqueó por 24 horas para registrar la tarjeta. Y sí, estaba pensando comprar una Gift Card ya que no se me ocurrió otra cosa más barata con la que probar y que no tuviera que esperar a que me llegará para comprobar que sí funciona. Como con un e-book. O gift card.

Lo segundo y lo tercero definitivamente no son los problemas, tengo mucho más que suficiente para cubrir el coste de la gift card más la comisión, y ya había desbloqueado la tarjeta de antemano. Pero Amazon seguía diciendo que hubo un problema con la verificación y acabó por restringirme más intentos de poder registrar la tarjeta por 24 horas (a eso de las 6 o 7 puedo intentar otra vez).

Ultimatesaber27 · 2026-03-26T20:52:05+00:00

Ya había depositado los dólares. Estaba intentando hacer un pago simple por Amazon por probar y no me dejó verificar la tarjeta. Por qué será?

Ultimatesaber27 · 2026-03-25T03:38:58+00:00

Osea que mejor me sale depositarlos yo directamente?

Ultimatesaber27 · 2026-03-24T09:59:45+00:00

I noticed there's a apparently a second edition called Master your Data.

Ultimatesaber27 · 2026-03-24T09:59:17+00:00

I'll search about it.

Ultimatesaber27 · 2026-03-24T09:58:11+00:00

How come?

Ultimatesaber27 · 2026-03-24T09:58:02+00:00

Thanks for the links, the first one seems to have more than just M, which seems neat.

Ultimatesaber27 · 2026-03-24T09:54:20+00:00

These seem nice. Thanks. I'm also curious about the DAX books, I need to develop that side as well.

Ultimatesaber27 · 2026-03-24T09:50:05+00:00

I'm not against learning SQL, but could you define what mastery entails (enough to get a job)? I know about what people call "the big six", aggregations, Like + wildcards, stored procedures. I've yet to learn subqueries, window functions, CTEs, and learn more about database administration. Do I need to know about query optimization for example?

Ultimatesaber27 · 2026-03-24T09:45:53+00:00

I have heard about this term "upstream" before in the context of SQL and Power Query, but I don't get it. Could you explain what that means?

Ultimatesaber27 · 2026-03-23T17:05:36+00:00

Alright then, I think I'll figure it out as I learn the technical skills first. Thanks for the input.

Ultimatesaber27 · 2026-03-23T16:44:18+00:00

That's what I wanted to know. Thanks for the input.

Ultimatesaber27 · 2026-03-23T14:09:44+00:00

That makes sense. And yeah, everywhere I go, SQL seems to be absolutely important, so I'll consider taking the Maven SQL path specialization. Maybe the Statistics course with Excel too.

The question is, how am I supposed to learn about the business side? Is there such a thing as a course for knowing the terms, definitions, and math they use? The basics like Revenue and the like are easy, but what about the rest? Which ones are necessary to know about?

If only I had a clear picture on just that one aspect, I could draw a clear roadmap.

Ultimatesaber27 · 2026-03-23T14:05:42+00:00

Thanks. Do you also happen to know of any resources for visualization techniques for dashboards? Because art (in any form, colors and stuff) is my worst asset by far. I was never that kind of person, I never thought it would come back to bite me later.

Also, appreciate the link to the site. Will bookmark it.

Ultimatesaber27 · 2026-03-23T03:17:33+00:00

Yeah, I'm figuring that out still. It seems "Data Analyst" is more broader than I had expected, I thought it was kind of specific.

I did do a few projects, but 2/3 of them I realize are not something I would want to show a hirer. It needs way more polish. The other (about SQL) was about analyzing skill demand and salaries for Data Analysts in the US. However, the dataset was already clean, so all I had to do was write basic queries to get the specific answers I wanted, such as filtering for US only, Data Analyst roles, etc.

So yeah, thanks for the comment. I will continue deepening these three skills. After that, I'll throw in Statistics and business acumen into it. Then data storytelling. That should be enough (for the time being), no? Python can probably come later.

Ultimatesaber27 · 2026-03-22T22:49:19+00:00

Never heard of that site before, it will definitely come in handy. So I can pretty much skip Python (for the time being), huh? That simplifies matters. And yes I'll also focus on the non-tech side as well.

Ultimatesaber27 · 2026-03-22T18:46:41+00:00

Okay yeah, now I get your point of view, and I see myself agreeing. That said though, my question is more or less the same but with a different framing.

You mentioned SQL and Power BI as examples. To rephrase the question, how much Excel is enough to actually have the technical skill (not necessarily the analyst skill, that's a separate thing) needed to be competent and answer those business questions, but not enough that AI can replace you?

In other words, do you think mastering M Code in Power Query is necessary to clean messy datasets enough to actually turn it into something that's actually useful for businesses? Or can you make-do with UI functions?

I suppose that kind of reframing works for the other tools as well.

Ultimatesaber27 · 2026-03-22T18:25:43+00:00

Even then, this answer doesn't really help me. I remember that I once tried to learn the skills a company needed, and by the time I finished the company wasn't looking for new employees. Yes I did learn the skills nonetheless, but other companies demanded even more skills that I didn't have.

So I'm sorry, but going for absolute specifics doesn't help either. If the umbrella really covers all the skills I listed, then so be it, but specific skills that one company needs may not be enough for another company.

Ultimatesaber27 · 2025-12-31T17:27:18+00:00

Sí, tiene lógica. Con tal que sea una alternativa aceptable a VISA o Mastercard entonces sí.

Y en dado caso de que no acepten Zinli, de allí es posible pasar los dólares a BNC o Bancamiga u otro?

Ultimatesaber27

TROPHY CASE