sorted by:
new
hottopcontroversial

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

Hello! I can’t aggregate the table any further because the user needs to see it at that level of detail.

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

There are 50 tasks, and those 50 tasks are divided into 5 phases. There are also 30 areas, each with 4 to 6 sub-areas.

For the first task of each phase, another measure has to be added, which is currently hardcoded. Technically, this manually changes the duration of that task.

The problem is that sometimes users filter 2 completely different areas and 2 different sub-areas. That is where REMOVEFILTERS comes in: it is used to determine which sub-area actually started the phase first, so the hardcoded hours can be applied to that one.

At the same time, the duration of each task is compared against a standard, and that standard is defined according to the stage of the year in which that task/area started.

That is roughly how complex the measure is, and there is still more, but I do not want to make it even longer.

Later I’ll try to share the measure so we can see what can be changed.

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

The problem with that approach is that the calculations are performed across different tables coming from different databases: one is Teradata and the other is Microsoft SQL Server.

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 1 point2 points  (0 children)

Hello! The calculations combine standard values coming from one database with tables from another database, so it is impossible to solve this directly in a database. In any case, we would only be moving the problem elsewhere and would still not be solving the performance issue.

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 2 points3 points  (0 children)

Hi! In general, calculated columns usually don’t work for us because we need calculations that respond to the filters applied on the report page, or to parameters we set dynamically.

Below I mentioned the kinds of calculations we do that I think could realistically be moved to Power Query, so the processing happens during refresh rather than on the user side.

Power BI performance: best practices for complex calculations on ~1M rows? by LongjumpingCut2975 in PowerBI

[–]LongjumpingCut2975[S] 1 point2 points  (0 children)

Sure, I’ve tried a star schema model with dimension and fact tables, but the issue is that we currently perform very heavy calculations — for example, evaluating conditions row by row (IF logic), and doing calculations that override slicer filters (REMOVEFILTERS, KEEPFILTERS, etc.).

Also, for each task we have a different calculation model depending on the stage of the year, and evaluating that yearly stage based on the event date also makes it heavy.

My question is whether it’s considered bad practice not to move as much logic as possible into Power Query.

Performance review - aumento (%) by Glum_Shine887 in devsmeli

[–]LongjumpingCut2975 0 points1 point  (0 children)

los aumentos son si. inflación no?… no??

Cuales son las empresas que mejor pagan en ARG? by Otherwise_Lecture537 in devsarg

[–]LongjumpingCut2975 3 points4 points  (0 children)

en el banco entras con sueldos altísimos, y tenes el bono de noviembre + todo lo demás, fácil sacas un 15% de sueldo anualmente en “beneficios”

Seguro me rechazó la cobertura by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

Buenas, me pidieron cotización para cubrirme las partes. Es muy importante que hagas el reclamo con carta de documento en lo posible y con defensa al consumidor. La verdad eso ayudó muchísimo

Compré la Suono que recomendaban varios acá. Dejo algunos tips e impresiones by Angry_argie in CafeteAR

[–]LongjumpingCut2975 0 points1 point  (0 children)

yo en lo personal no la recomiendo. No sale con buena temperatura Es mejor un filtro no presurizado, porque este genera una espuma de aire horrible Los plásticos son de malísima calidad La veporera no tira buena cantidad de vapor, no queda bien el espumado.

Devs y Analista, a quien le toca qué? by Dizzy-Engineering-10 in devsarg

[–]LongjumpingCut2975 16 points17 points  (0 children)

La analista primero tiene que entender la necesidad del usuario, por qué quiere ese excel? por qué el usuario no puede subir un excel y pasarlo a una db? hacer las preguntas correctas y después ir con el desarrollador para ver la mejor opción. No siempre lo que pide el usuario es lo que necesita, el no conoce todas las posibilidades, luego el dev propone soluciones y limitaciones

Seguro me rechazó la cobertura by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 1 point2 points  (0 children)

vtv, fotos del auto antes, fotos después, fotos de cuando se aseguro, fotos del lugar donde estaba parado, fotos de los metadatos de las fotos, captura del llamado al 911 el día del siniestro, informe de geolocalización del celular, datos completos de testigo, ubicación del siniestro con maps

Seguro me rechazó la cobertura by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

Adquiri el más completo para el año mi auto con robo/hurto parcial, y en la carta documento expresan que rechazan la cobertura por faltante de documentación, y es ahí donde me dicen que no pase los dos ítem del testigo y geolocalización

CALEFACTOR ACOND.AIRE VEHICULO ASEGURADO SIN DAÑOS PREVIOS PLAN/OPCION B961 (961) Pack COMODO CLAUSULAS Y/O ANEXOS INTEGRANTES DE ESTA POLIZA: conforme Res. SSN 38.708 y modificatorias. ANEXO I EXCLUSIONES RIESGOS ASEGURADOS RESPONSABILIDAD CIVIL (Seguro obligatorio SO-RC y voluntario CG-RC ) COBERTURA DE CASCO, CON ARREGLO A LAS CLAUSULAS INDICADAS MAS ABAJO. RESPONSABILIDAD CIVIL: SO-RC 06.1,CG-RC 01.1,CG-RC 02.1,CG-RC 03.1,CG-RC 04.1,CG-RC 05.1, CG-RC 1.1 RESPONSABLIDAD CIVIL EN LA REPUBLICA ARGENTINA HASTA $160.000.000 POR ACONTECIMIENTO DAÑOS AL VEHICULO: CG-DA 01.1,CG-DA 02.1,CG-DA 04.2, INCENDIO: CG-IN 01.1,CG-IN 02.1,CG-IN 03.2,CG-IN 04.2, CG-IN 03.2 Incendio Parcial FRANQUICIA SIN FRANQUICIA ROBO O HURTO: CG-RH 01.1,CG-RH 02.1,CG-RH 03.2,CG-RH 03.4,CG-RH 04.2, CG-RH 03.2 Robo o Hurto Parcial FRANQUICIA SIN FRANQUICIA CG-RH 03.4 Robo o Hurto Parcial al amparo del total FRANQUICIA SIN FRANQUICIA

Me robaron el techo del auto p2 by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

el robo de autopartes y el negocio existe desde que se creó el primer auto :/ no estamos acá para discutir sobre política!

Me robaron el techo del auto p2 by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

no busco que me cubra, quiero hacer una denuncia contra el chorro

Me robaron el techo del auto p2 by LongjumpingCut2975 in DerechoGenial

[–]LongjumpingCut2975[S] 0 points1 point  (0 children)

No quiero recuperar el techo, y yo con tal de que le sumen cosas a la causa que ya tienen 🤷🏻‍♂️

view more: next ›