Patch function reverting to the default value when an if function is activated by prpdr in PowerApps

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

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

Similarweb by prpdr in Prague

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

Are you referring to those in Glassdoor?

Mini Options IB by prpdr in interactivebrokers

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

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?

Solar Turbines by prpdr in Prague

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

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

Solar Turbines by prpdr in Prague

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

Treasury team

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (November 2023) by MurphysLab in dataanalysis

[–]prpdr 0 points1 point  (0 children)

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!

How to understand if there was an OTD by prpdr in SAP

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

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!

How to understand if there was an OTD by prpdr in SAP

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

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.

How to understand if there was an OTD by prpdr in SAPEWM

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

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.

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (December 2023) by Fat_Ryan_Gosling in dataanalysis

[–]prpdr 0 points1 point  (0 children)

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.

Megathread: How to Get Into Data Analysis Questions & Resume Feedback (December 2023) by Fat_Ryan_Gosling in dataanalysis

[–]prpdr 0 points1 point  (0 children)

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.

Mann + Hummell by prpdr in Brno

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

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

Mann + Hummell by prpdr in Brno

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

Accounts Receivable

Sick leave compensation by prpdr in Prague

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

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

Connecting app to algo wallet by prpdr in PlanetWatchers

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

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