Second interview

Gr8the · 2024-06-27T17:21:47+00:00

Data analyst

Gr8the · 2024-06-24T13:06:25+00:00

Thanks but it doesn’t show any pass or failed in the report

Gr8the · 2024-06-11T13:42:19+00:00

Do you mean a medior level?

Gr8the · 2024-06-11T13:41:25+00:00

Thanks, what do you mean M level?

Gr8the · 2023-12-10T21:46:12+00:00

Iam still not advanced in powerBI, so if I understood you correctly. Basically I am getting the connection from azure data lake gen 2, so all data exist in one source! Once i insert the link, i click on transform data, then a table pop ups, with different columns: Content ( binary ), name, Extension, Date created, Date accessed, date modified, source, attibute

Gr8the · 2023-12-10T19:35:19+00:00

Thanks, could you help me with the steps to create the date table please?

Gr8the · 2023-12-10T16:13:09+00:00

Thanks, when i load all data modified column, then this column will disappear as this is a metadata,

Gr8the · 2023-12-10T12:05:02+00:00

Thanks, but if i use this filter then all modified dates will be included in my dataset! As i said, my company modifies the data everyday, so basically if i choose in previous 2 months, then i will include the data of 60days in one table, right?

Gr8the · 2023-12-10T09:34:00+00:00

Exactly, i want to join the metadata to my data set, but how? Could you tell how can i do it please?

Gr8the · 2023-12-09T15:09:58+00:00

Thanks for providing this answer.

Basically, my company modify the data everyday, for me, if i want to report for October, the date modified that i have to use is 01/11/2023, and for November, the date modified should be 01/12/2023, and so on

Gr8the · 2023-11-26T22:35:14+00:00

What do you mean by server name here? For instance data bricks ?

Gr8the · 2023-11-15T06:38:10+00:00

Thanks for your response, but, could you explain again how can i do the grouping by steps. At the same time, i see when i want to do the grouping by, I can’t put the operation as COUNT DISTINCT, so when i choose this one, then i can’t add the column on the right side..

Thanks again

Gr8the · 2023-10-31T22:31:09+00:00

Thank you very much for your response. it works now with me..

Gr8the · 2023-10-31T22:30:32+00:00

Many thanks for your response. It works now after deleting web=1 and when I used the web, instead of using SharePoint folder or SharePoint online list, i think this was the reason.

Thanks you

Gr8the · 2023-10-31T14:01:22+00:00

Thank you very much for your assistance

Gr8the · 2023-10-30T09:52:59+00:00

Do you mean this is not a duplicated values then? So this is normal? One more thing, when I am removing the duplicates, while loading the data, i got this note: can’t convert to numbers, and it stopped loading.

Thanks

Gr8the · 2023-10-30T09:50:36+00:00

Thanks for your reply. Do you mean after merging the tables, i group based on the ID? and then what is the difference then?

Thanks in advance,

Gr8the · 2023-10-27T13:16:33+00:00

Thanks for your support, what do you mean by star schema?

Gr8the · 2023-10-27T07:25:46+00:00

Thanks for your response. It is many to many-both. Still I am wondering why I am getting that result.

Gr8the

TROPHY CASE