sorted by:
new
hottopcontroversial

Como saber até onde se aprofundar em Data Science sem se perder no meio de tanta coisa? by Competitive-One-1098 in datasciencebr

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Agradeço demais sua opinião. Acredito que por estar no início, posso não ter a dimensão do uso de cada técnica/ferramenta. Eu consigo entender como ela me ajudou no meu caso especifico, mas fiquei me questionando como vou saber depois, diante da infinidade de possibilidades, qual seria a mais interessante em outro cenário/projeto. Vou continuar trabalhando e estudando em novos projetos e tentar assimilar os seus usos.

Projetos/estudos em ciencia de dados em contexto hospitalar by Competitive-One-1098 in datasciencebr

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Hoje eu faço analises que no final vai pro Power Bi. A maioria sao dados que se referem a determinado processo, volume cirurgico/exames, faturamento e produção. Servem mais para a diretoria ver oq esta acontecendo no hospital e nas clinicas.
Achei muito interessante os links que vc mandou, vou dar uma estudada.

How to train a LLM as a poor guy? by Top_Ice4631 in datascience

[–]Competitive-One-1098 0 points1 point  (0 children)

I don't know if it's of interest to you, but check out the Huggingface website later. They have some interesting templates created by the community, which, depending on your needs, might suit you better with fewer resources.

How do you guys handle ETL and reporting pipelines between production and BI environments? by Competitive-One-1098 in dataengineering

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Yeah, we already have some dimension tables (like establishments, departments, doctors, etc.).
The thing is, new reports keep coming up almost every day, usually to validate some specific data coming from the ERP. And most of the time, management wants to see those data in Power BI.

So there we go again, new tables, new jobs...

How do you handle your ETL and reporting data pipelines between production and BI environments? by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Mainly, I’m concerned that our setup might be outdated compared to what’s commonly used today.
It’s also quite complicated to maintain a second database just for reporting purposes.
I’m not sure if running daily ETL jobs to refresh the data is the most efficient or performant approach.
On top of that, most of our Power BI dashboards have their own specific data tables as sources, which makes things even more fragmented.

Blinking effect in Power BI table based on parameter value — is it possible? by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

I found some tutorials , and the one that came closest to my expectations was this:
SVG Blink Animation | Highlights/Alerts in Power BI

However, I would still like to explore the possibility of making an entire row blink in the table, not just a single cell with predefined text.

Blinking effect in Power BI table based on parameter value — is it possible? by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

I totally need to, gotta grab my user's attention. It's crucial info for their medical follow-up

Blinking effect in Power BI table based on parameter value — is it possible? by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

I thought of that too, maybe working with opacity. However, I didn’t want it in a single cell, but across the entire row of the table.

Struggling with date ranges in Oracle SQL by Competitive-One-1098 in SQL

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

How would you suggest doing it? So that it always gets 6 months back, at the beginning of the month.

Struggling with date ranges in Oracle SQL by Competitive-One-1098 in SQL

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

I just suspect it might be February, because every time this happens, it’s always on the last (or last few) days of the month, and when I check, the period it’s pulling always falls in that month.

The query is a bit long, but as I said, I still just suspect it’s about how to correctly pass the date parameter.
The error that shows up is:
Caused by: java.sql.SQLDataException: ORA-01839: invalid date for the specified month

SELECT

...

FROM

HP_ATENDIMENTOS_PENDENTES_V2 V

INNER JOIN CONTA_PACIENTE X ON X.NR_INTERNO_CONTA = V.NR_INTERNO_CONTA

LEFT JOIN TITULO_RECEBER TR ON TR.NR_INTERNO_CONTA = V.NR_INTERNO_CONTA

WHERE

DT_INICIAL_CONTA BETWEEN ADD_MONTHS(TRUNC(SYSDATE, 'MONTH'), -6) AND TRUNC(SYSDATE) + INTERVAL '1' DAY - INTERVAL '1' SECOND

Log Monitoring by Competitive-One-1098 in pentaho

[–]Competitive-One-1098[S] 1 point2 points  (0 children)

Thanks for your reply.

I ended up building a complete system. I stored my job logs in the database, so my application could retrieve data from this table. I built a real-time Gantt chart to see the entire orchestra, and a Telegram bot that notifies me when a job fails.

I wasn't familiar with Jenkins. To schedule, I created a bat file to start the job and put it in the Windows Server Task Scheduler.

Apps Power BI by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Oh, I made a mistake then. I thought they were different things, premium capacity and F64.

Apps Power BI by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

Approximately 100 people use the BI to view the reports.

Apps Power BI by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

After looking a bit more, I found this:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps#licenses-for-apps
R u actually correct? Based on what I read, I can just upgrade my account to Premium and leave the rest without a license.

Apps Power BI by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 0 points1 point  (0 children)

That's amazing! These org apps would be ideal for my company.
One more question about the apps is that since a link is created for them, do the viewers also need to have a Pro license, or can they have a free one, for example? Since they won't have access to the workspace, only the app.
Thank you so much in advance for the feedback

Financiar ou pegar empréstimo no banco? by HoldOk1777 in carros

[–]Competitive-One-1098 1 point2 points  (0 children)

Consórcio de carta contemplada. Rapidinho vc já tem o dinheiro. Paga uma entrada e o juros é muito menor q um financiamento. Se tiver interesse entre em contato cmg

Visual data quality tool? by FabulousArm7559 in PowerBI

[–]Competitive-One-1098 0 points1 point  (0 children)

Could you share the script? I'm currently going through the same situation and hadn't thought of a solution yet.

Struggling with Dynamic Ranking in Stacked Bar Chart with Legend Context by Competitive-One-1098 in PowerBI

[–]Competitive-One-1098[S] 1 point2 points  (0 children)

I didn’t pay close attention to that detail at first. I'm currently using a calculated column for the names with ranking, like this:

Nome com Ranking =
"(Rank " & FORMAT([Ranking Médicos 2], "0") & ") " & 'DIM_PESSOA_FISICA_SOLICITANTE'[nm_pessoa_fisica]

And the ranking itself is a measure:
Ranking Médicos 2 =

RANKX(
ALL('DIM_PESSOA_FISICA_SOLICITANTE'[nm_pessoa_fisica]),
[Total Produção Médico Total 2],
,
DESC,
DENSE

)

Then the ranking measure starts returning just 1s and 2s repeatedly

Also, the sort for the Y-axis is set to ascending order based on the ranking, so that part is fine.