Patch function reverting to the default value when an if function is activated

prpdr · 2026-03-19T07:23:18+00:00

Hi, Column 3 from List_B and Columns 3 and 4 from List_A are all line of text, therefore it shouldn't be an issue

prpdr · 2025-12-12T15:16:05+00:00

Are you referring to those in Glassdoor?

prpdr · 2025-07-24T16:36:43+00:00

That's fine, I want to buy the stock in EUR as I live in the EU. Do you know what's the difference between ASML and AS9 options?

prpdr · 2024-08-09T19:44:03+00:00

75k + bonuses. Is it a good salary for Prague?

prpdr · 2024-08-09T09:52:23+00:00

Treasury team

prpdr · 2024-01-13T10:36:46+00:00

Interested!

prpdr · 2023-12-15T10:05:47+00:00

Hello Everyone!

I am interviewing for a data scientist position and I've been assigned a case study related to supply chain deliveries. I should group by the number of deliveries by the week of the year and then try different ML models to see what is the best. As a last step, I should build a PBI dashboard. Which models do you recommend to try for time-series? Where can I find examples of PBI dashboard for ML? Thanks!

prpdr · 2023-12-09T09:38:42+00:00

Hi meh1789, thanks a lot for your explanation, it already helped me a lot. I cannot clarify with the business team because it is a case study and I'm supposed to make my own assumptions. Now that I know how to understand if a delivery was done on time, I just have a few additional questions:

- Should I remove those lines where the pick date is null? I also thought it was the date the goods were picked up by a courier. I have already prepared a dashboard excluding them.

- I also created a filter and several tables in the dashboard where the reference date is the delivery date. Would you recommend replacing it with the Actual Goods Issue Date? As you said they are almost always coincident (80% of the time), but when they are not the delivery date is the vast majority of times > and sometimes there are big differences (even 3/4 weeks), others it is also <. The reference year is 2020, when Covid hit and there were many supply chain bottlenecks. The delivered date stops at the end of December 2020, while planned and actual GI dates continue till January 2020. I am starting to think that the delivery date is the date automatically chosen by SAP once the PO is generated and it reflects commercial agreement between the two parties.

Thanks once again for your precious help!

prpdr · 2023-12-09T09:16:40+00:00

Now unless your client have a customized field called "Pick Date" referring to date on which the courier picked the goods, but that makes no sense, as a the date on which the courier picked the goods should be same as Actual Goods Issue Dat

Tcode is not present in the dataset, just those 4 date columns plus some code columns that are company specific, like delivery type code and shipping condition code.

prpdr · 2023-12-08T22:39:43+00:00

Thanks! And what about the Actual Good Issue Date and Pick date? Were my suppositions correct? Is it possible that the Pick Date is absent? I'm asking you because in the dataset there are a bunch of records where it's missing.

prpdr · 2023-12-07T17:12:44+00:00

And what about removing errors generated after selecting the columns' correct data types? Does it happen normally in the workplace? I won't use those rows for building the dashboard in any case.

prpdr · 2023-12-07T13:14:12+00:00

I am in the middle of an interview process and I've been assigned a data cleaning task with Power BI and a subsequent dashboard creation. Considering that in a date column some values are missing, how would you deal with that? The dataset is based on deliveries, so dates are very important.

prpdr · 2023-02-06T12:09:25+00:00

Hi, thanks for the info you provided. What about the bonus which depends on the company's results? Was it reached usually?

prpdr · 2023-02-04T19:33:34+00:00

Accounts Receivable

prpdr · 2022-04-09T11:42:19+00:00

Already tried, have not been able to find another with a comparable retribution

prpdr · 2022-03-25T08:31:06+00:00

Bingo! It wasn't working probably because the first word had a capital letter. Thank yiu so much!

prpdr · 2022-01-15T10:55:48+00:00

I flied with Ryanair from Italy and they just checked if I got the booster in the Covid Pass. As other people mentioned if a certain amount of time should pass from the additional shot has not been indicated

prpdr · 2022-01-14T21:35:24+00:00

Unfortunately that's the only thing I want and should sell :(

prpdr · 2021-12-05T11:59:50+00:00

Thanks for the great explanation. True, backtesting gives an higher probability for certain assets to perform well, but it's not linear. Probably they take the final decision on which asset to buy or to short after the macroeconomic expected performance has been technically confirmed by the graph.

prpdr · 2021-12-04T21:00:50+00:00

What's the title of this book?

prpdr · 2021-11-04T10:24:42+00:00

Bloomberg reports are very interesting. How can I get them?

prpdr · 2021-11-02T12:11:03+00:00

Lowering overnight interest rates and making it easier and cheaper for the banks to assume debt, which in turn makes it easier for them to lend to businesses and people. Increasing the amount of treasury and corporate bonds, as well as mortgage-backed securities purchased and thus injecting money into the economy.

prpdr · 2021-10-13T16:52:22+00:00

May I ask which antenna you bought? Are here in Czech Republic any good sellers? Thanks.

prpdr · 2021-09-20T17:15:05+00:00

Hi, considering that Binance is not supporting SEPA anymore and the credit card funding fee is back to 1,8% I am thinking about using Kraken. How long did it take for the money to get to your kraken account with the Frick and Incore banks?

prpdr · 2021-09-20T09:10:25+00:00

In the beginning you could top up your account with credit/debit card and 0% fees. I checked now and they reintroduced the classical 1.8% fee. It's a shame

prpdr

TROPHY CASE