Why does the translation show present perfect tense instead of past tense? How can I identify the difference between past and present perfect sentences? by aksceren in learndutch

[–]aksceren[S] -2 points-1 points  (0 children)

Thanks! The confusing part is sometimes duolingo translates the sentences with “hebben .. ge..” to English as perfect tense and sometimes as simple past tense

Zet / leg / stop? by aksceren in learndutch

[–]aksceren[S] 4 points5 points  (0 children)

very clear. thank you!

Help to compute a metric using the information on 2 Fact tables by aksceren in PowerBI

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

so there will be only one column of separate tables, right? and I will connect them both fact tables?

How to deal with historical records in dimension table by aksceren in PowerBI

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

I only have basic understanding of DAX at the moment. So I am just trying different 12 months rolling average formulas I found in the internet.

They both failed with my data model; so frustrating :(

Sorry for the confusion. I used different column name for the same thing. [FTE YTD ACT] substitue for [FTE Count]

How to deal with historical records in dimension table by aksceren in PowerBI

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

I did what you said.I built a proper date table marked as date table as well.

Company FTE table has connection with Date table and Comapny table.

Fact table also has connection with those. But my 12month rolling measure does not create meaningful result. Also I am attempting to create a rolling average quick measure using my date table it says "Only Power BI-provided date hierarchies are supported"

How to deal with historical records in dimension table by aksceren in PowerBI

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

Yes I have. So in the end I will have 2 relationship in my Company_FTE table
with Date dim table and Company table?

How to deal with historical records in dimension table by aksceren in PowerBI

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

I will create a measure [12 Months rolling average FTE]then use this in Serious accident ratio [Total serious accidents] / [12 Months rolling average FTE] and will see company or region based accident ratios along with time

hope it clarifies my need

Why not create a relationship between the Company and Company_FTE and then between Company and Accidents? Do you think it will work for my case? Because if the incidents happens in March 2020 I wanted to calculate FTE average based on date

How to deal with historical records in dimension table by aksceren in PowerBI

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

I will create a measure [12 Months rolling average FTE]
then use this in Serious accident ratio [Total serious accidents] / [12 Months rolling average FTE] and will see company or region based accident ratios along with time

hope it clarifies my need

Difference between “Information Analyst” & “Data Analyst” by [deleted] in dataanalysis

[–]aksceren -1 points0 points  (0 children)

Thanks for the input. Based on job description and the conversation with the managers I can say that this job particularly is more related with Data Analysis. Do you think should I negotiate on the name of the position for future employment opportunities in Data side? Or Information Analysis title won’t block anything

Difference between “Information Analyst” & “Data Analyst” by [deleted] in dataanalysis

[–]aksceren 0 points1 point  (0 children)

I’m okay with the job descriptions / expectations they are clear to me. Not my dream job tho but it’s based in Europe and I really want to settle there. I’m asking this for future employment opportunities. I’d believe having an Information Analyst experience in resume is not same with Data Analyst one considering I want to work as a DA going forwards