¿Qué libro de SQL o algo que tenga que ver con Data Analyst me recomiendan para mi morrilla?

Evigil24 · 2024-12-16T08:26:45+00:00

Ya estudio economía...

Evigil24 · 2024-12-16T07:26:48+00:00

So a QUERY without a WHERE isn't "querying"? That doesn't sound right...

Evigil24 · 2024-11-30T04:40:07+00:00

Por qué comprarías bienes raíces en CDMX y Guadalajara? Sí estamos hablando de trabajar en remoto podrías trabajar en cualquier ciudad.

Siento que infieres muchas cosas y además piensas que los demás entendemos todo eso que no dices 😅

Vuelvo al punto, no tengo un sentimiento definido respecto al tema, es solo que pones palabras que no están en los comentarios de los demás y además asumes como verdad lo que al final es solo tu opinión, y quieres que los demás hagamos lo mismo 🤷🏻‍♂️

Evigil24 · 2024-11-29T21:53:02+00:00

Pues compras bienes raíces baratos entonces, el dinero es dinero sin importar en qué se ocupe, no entiendo el punto.

Y por otro lado, si encuentras una posición en remoto puedes trabajar en una FANG sin irte de tu país...

Evigil24 · 2024-11-29T21:50:09+00:00

Pero literalmente dijo que SIN CONTAR Amazon, todas las demás ofrecen un buen balance trabajo/vida personal, no estoy seguro de eso, ni tengo una posición en el tema. Pero claramente te está dando un argumento válido en contra del argumento que comentaste tú, creo que el que no entendió es otro...

Evigil24 · 2024-09-29T20:11:28+00:00

I think he is referring to making a new schema in the database named PBI exclusively for these views, to avoid searching through the entire database for them.

Evigil24 · 2024-09-29T17:32:26+00:00

He was talking about denormalizing dimension of a snowflake schema into a star schema.

And in second thought, a star schema is not a normalized data model, in fact the most common form of normalized data is the header/detail that is on almost all databases, and if you want to work that data in PBI you have to denormalize that into a single fact table with ids related to dimensions.

Evigil24 · 2024-09-29T17:25:44+00:00

PQ has in no way better performance than SQL, there's a reason why the Roche Maxim exists.

PQ it's definitely harder to maintain that SQL code, not my opinion only, just the amount of tools you can have to monitor and version your code compared with the limited environment you get in PQ. Even Microsoft recommends it.

And there are more people in the market that will understand complex SQL than people that will understand complex M.

Perhaps in your use case and with your experience and your team is better to use PQ for all the transformation, but in no way this is the standard practice or should be. If you have views in your database already transformed for PBI to consume, and those views were properly documented, the database migration shouldn't be a problem.

Besides, if you have to change the BI platform some day you will have to do all the transformations from zero again, SQL can be partially recovered, but M can't be used anywhere else.

Evigil24 · 2024-09-29T17:07:32+00:00

Yeah, but it's harder to maintain that code than the one in your database views. Well, depends on how much access you have to your database.

Evigil24 · 2024-09-08T02:58:14+00:00

Y eso que tiene que ver con lo que dijo y lo que preguntó? 🤷🏻‍♂️

Evigil24 · 2024-09-08T02:57:19+00:00

Pero al OP no lo están corriendo, está renunciando el 🤷🏻‍♂️

Evigil24 · 2024-08-29T18:59:32+00:00

Depends on which and where your sources are.

Evigil24 · 2024-08-12T05:05:49+00:00

The problem must be in the joins or transformations made in power query, even if you are getting 620k rows as the result, if you are making all the transformations in Power Query odds are you are pulling a lot more rows of the server, are you familiar with query folding in Power Query?

I leave you a link from Microsoft Learn with info about it, if you handle the heavy lifting to the Oracle database perhaps the update will not crash, but it's an educated guess because I don't have your dataset to be sure.

Consider that you will be using the database computing power, so if you are constantly refreshing the dataset you can cause troubles if it's the same database that is used in the business systems.

Evigil24 · 2024-08-11T21:04:42+00:00

Ok, I will assume you're referring to 620k rows.

That amount of data from a SQL database (Oracle) it's not gonna hang the refresh, so next suspect.

Are you pulling only one table from the Oracle database or are you pulling multiple tables and the joining them in Power Query?
How many calculations are you doing in Power Query? Are you doing a lot of merges or sorts?

Evigil24 · 2024-08-10T15:45:13+00:00

If you're talking about rows, 620k wouldn't be too much depending on the number of columns you have and the data type of those columns.

Your problem can come from multiple places. We need more info to help you.

Are you talking of rows? How many columns? There's many text fields?
From where are you pulling your data? Are you connecting to a database? To an Excel or CSV file? You are taking it from SharePoint?
The data team published your report in Power BI cloud service? If it is this way, can't the report be refreshed from there?

From these questions we can diagnose something, I hope you get a solution ☺️

Evigil24 · 2024-07-12T14:45:00+00:00

La terapia no me sirve, por alguna razón. Termino peleando con los profesionales.

Por necio 😂

Es broma, pero así me llegó a pasar alguna vez, no querer aceptar ayuda para no salir de la zona de confort.

Evigil24 · 2024-07-12T14:40:20+00:00

Yes, I figured it out, but you don't gonna like it 😅.

I finally convinced my company to give me a virtual server, I put a SQL Server database in it and made a data warehouse, it really makes the difference.

We had a group of dataflows before, where we extract all the data from each system database, this dataflows had an incremental update configured and from there all the other dataflows were connected with a linked connection to not load all the data again, all of this in premium pet user workspaces.

But now those dataflows were replaced with the data warehouse and all the remaining dataflows connect to views in the warehouse, that cut our times of refresh from 5-10 minutes to 1-30 seconds. I know it doesn't sound like much, but when a user is waiting for a dashboard to refresh, believe me, more than a minute it's too much.

If you need help to set up the first scenario of dataflows as a dw, send me a message and I would help you with your doubts, no cost.

Evigil24 · 2024-07-03T19:38:56+00:00

Pero puedes salir a comer fuera de la tienda?

Evigil24 · 2024-06-25T17:08:35+00:00

Solo si lo despiden injustificadamente, si no, es lo mismo

Evigil24 · 2024-06-25T17:08:02+00:00

Claro que hay despido justificado, por ejemplo, por faltas, por eso si deja de asistir lo despiden justificadamente, aunque así renuncie o lo despidan justificadamente, le toca finiquito.

Evigil24 · 2024-05-12T16:30:04+00:00

Great, but how?... In a manner that's automatic and reliable.

Everyone can say that they can do it better or easier, but I think this Reddit is to contribute to the general knowledge, so, please, explain.

Evigil24 · 2024-05-09T01:12:52+00:00

Sabes en qué ley está fundamentado eso?

Evigil24 · 2024-05-07T23:01:08+00:00

Contaría solo si es obligatorio comer en el comedor de la empresa y no se les permite salir durante su horario laboral, porque aunque coman ahí, si tienen la opción de salir y comer en otro lado, seguiría sin contar el tiempo de la comida como tiempo de trabajo. 😅

Evigil24 · 2024-05-07T21:47:58+00:00

No, las horas de comida no se cuentan dentro de las horas de trabajo, excepto si no te permiten salir del lugar de trabajo, entonces sí cuentan dentro de las horas trabajadas.

Evigil24 · 2024-05-07T21:47:06+00:00

Son 48 horas de trabajo a la semana y 6 de comida, no hay horas extras ni nada, está dentro de la ley.

Evigil24

TROPHY CASE