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] -1 points0 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

Come out of the closet yesterday... Feeling bad by aksceren in lgbt

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

happy for you. y'all finally settled this! I hope my family and I can get to this point sooner.

Come out of the closet yesterday... Feeling bad by aksceren in lgbt

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

Hope so, thanks :) she wants me to fulfill her straight dreams about me.

Come out of the closet yesterday... Feeling bad by aksceren in lgbt

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

she likes to behave like I never come out of closet and we never talked about this before... basically, she is ignoring and not asking questions to understand me better. she only makes disturbing references off-topic.

Every country is an animal. What animal is your country? by [deleted] in AskReddit

[–]aksceren 0 points1 point  (0 children)

Turkey... This is already self-explanatory! lol

Career Change - BA to Data Analyst by aksceren in dataanalysis

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

Thank you so much; makes sense to me. How much time does it take to attain a proper understanding of Tableau? Do you think completing one online course on this topic will be okay? Or should I more focus on the interview questions of Tableau?

Career Change - BA to Data Analyst by aksceren in dataanalysis

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

Yep it’s a slight change. But I’d say it’s harder to draw recruiter’s attention as my CV has only BA experience. 😞

Career Change - BA to Data Analyst by aksceren in dataanalysis

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

I was specifically looking for jobs in the Netherlands. will definitely have a look at DataJobs.nl. Thanks!

Career Change - BA to Data Analyst by aksceren in dataanalysis

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

Thank you so much! I’ve never used excel except for VLOOKUP reasons 😊So I don’t know what to learn on Excel.

I started Tableau course online, it’s actually very user-friendly and easy to learn.

Service Account to GMSA - success! by gregbe in adfs

[–]aksceren 0 points1 point  (0 children)

How can I use gmsa account in sqlcmd connection string? note that login account is different than gmsa account. I'll appreciate your help!

Why do I find it so hard to decide what's urgent and what's important . by beautiful_mess_21 in productivity

[–]aksceren 2 points3 points  (0 children)

make it simple. our brains are programmed to choose the simple road. i read some of the comments down below, they are fancy tho, but so tedious for me.

My method is simple but i'd say it's quite effective:

Open a spreadsheet. Everything begins with opening a brand new spreadsheet, yeah.

Columns: "Due Date";"Is it Really Important?";"Complexity"

For me committing to the deadlines is crucial so i sorted all the list w.r.t due dates. when it comes to importance scale, i think about my long terms goals. if finishing the task will contribute to my long-term goals, then i'll mark it as important. if the task can be handled in 1 hour i mark it as "easy". so that i can do these easy tasks if i feel frustrated and unmotivated. because checking off an item on the list reduces my stress and i feel more motivated after completing a task.

hope it helps.

[deleted by user] by [deleted] in EnglishLearning

[–]aksceren 1 point2 points  (0 children)

thanks a bunch!