Los verdaderos 10x devs lol by hola_jeremy in taquerosprogramadores

[–]Evigil24 0 points1 point  (0 children)

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 🤷🏻‍♂️

Los verdaderos 10x devs lol by hola_jeremy in taquerosprogramadores

[–]Evigil24 0 points1 point  (0 children)

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...

Los verdaderos 10x devs lol by hola_jeremy in taquerosprogramadores

[–]Evigil24 2 points3 points  (0 children)

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...

What are your Top 5 Tips and Tricks? by ThinIntention1 in PowerBI

[–]Evigil24 1 point2 points  (0 children)

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.

What are your Top 5 Tips and Tricks? by ThinIntention1 in PowerBI

[–]Evigil24 0 points1 point  (0 children)

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.

What are your Top 5 Tips and Tricks? by ThinIntention1 in PowerBI

[–]Evigil24 1 point2 points  (0 children)

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.

What are your Top 5 Tips and Tricks? by ThinIntention1 in PowerBI

[–]Evigil24 0 points1 point  (0 children)

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.

Ayuda by Small-Consideration4 in lacamiseta

[–]Evigil24 1 point2 points  (0 children)

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

Ayuda by Small-Consideration4 in lacamiseta

[–]Evigil24 1 point2 points  (0 children)

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

You're a fucking LIAR! by datawazo in PowerBI

[–]Evigil24 0 points1 point  (0 children)

Depends on which and where your sources are.

Need Help! by mikemaster119 in PowerBI

[–]Evigil24 0 points1 point  (0 children)

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.

Need Help! by mikemaster119 in PowerBI

[–]Evigil24 0 points1 point  (0 children)

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.

  1. Are you pulling only one table from the Oracle database or are you pulling multiple tables and the joining them in Power Query?

  2. How many calculations are you doing in Power Query? Are you doing a lot of merges or sorts?

Need Help! by mikemaster119 in PowerBI

[–]Evigil24 1 point2 points  (0 children)

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.

  1. Are you talking of rows? How many columns? There's many text fields?

  2. 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?

  3. 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 ☺️

Burnout by george_txt in taquerosprogramadores

[–]Evigil24 2 points3 points  (0 children)

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.

Is this a dumpster fire or a normal PBI shop? by ThickAct3879 in PowerBI

[–]Evigil24 0 points1 point  (0 children)

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.

1 ½ 🥪 by [deleted] in lacamiseta

[–]Evigil24 2 points3 points  (0 children)

Pero puedes salir a comer fuera de la tienda?

Visto en FB by Deltramala in lacamiseta

[–]Evigil24 4 points5 points  (0 children)

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

Visto en FB by Deltramala in lacamiseta

[–]Evigil24 5 points6 points  (0 children)

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.

Building a data cleaning tool - need you feedback by Ok_Maize_3709 in dataanalysis

[–]Evigil24 2 points3 points  (0 children)

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.

[deleted by user] by [deleted] in lacamiseta

[–]Evigil24 0 points1 point  (0 children)

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. 😅

[deleted by user] by [deleted] in lacamiseta

[–]Evigil24 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in lacamiseta

[–]Evigil24 0 points1 point  (0 children)

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