Business Intelligence Developer sollicitatievragen


Sollicitatievragen voor Business Intelligence Developer gedeeld door sollicitanten

Meest gestelde sollicitatievragen

Sorteren: Relevantie|Populair|Datum
One Technologies
Er werd een Business Intelligence Developer gevraagd...12 november 2014

None. All questions were relevant to experience and goals.

2 antwoorden

Two different pictures of work environment given by recruiter and manager. One very rosy and the other more realistic. More importantly, recruiter stressed a great work/life balance and manager did too, but added that I'd be required to work 45 hours per week at least to start. They added further that someone had recently left who could not commit to this. This was a red flag for me and I declined an in-office interview. Minder

They have gone through more than 8 developers over a 3 year period. Avoid them if you value your career. They will lie and tar and feather you if they suddenly develop a dislike for you. The manager is insecure, paranoid and plays favorites. Cat lady needs to be medicated. Minder


container_edits: container|units|status |move_time XYZ | 5 |Start |2018-01-01 00:00:15 XYZ | 2 |Add |2018-01-01 00:01:10 XYZ | 3 |Add |2018-01-01 00:02:00 XYZ | |Complete |2018-01-01 00:03:00 XYZ | 5 |Start |2018-01-01 00:04:15 XYZ | 3 |Add |2018-01-01 00:05:10 XYZ | 4 |Add |2018-01-01 00:06:00 XYZ | 5 |Add |2018-01-01 00:07:10 XYZ | 6 |Add |2018-01-01 00:08:00 XYZ | |Complete |2018-01-01 00:09:00 For the above dataset the record should look like loop: container|loop_num|units|start_time |end_time XYZ |1 |10 |2018-01-01 00:00:15|2018-01-01 00:03:00 XYZ |2 |23 |2018-01-01 00:04:15|2018-01-01 00:09:00

2 antwoorden

I couldn't answer this.

Select C.container ,AGG.ROWNUM as loop_num, SUM(Units) , AGG.start_time,AGG.END_TIME from Containers C INNER JOIN ( Select ST.container,ST.ROWNUM, ST.start_time,ET.END_TIME from (Select S.container,row_number() OVER (order by Movetime) rownum, (case when S.status='Start' then S.movetime end ) as start_time from containers S WHERE STATUS IN ('Start') ) ST , (Select S.container,row_number() OVER (order by Movetime) rownum, (case when S.status='Complete' then S.movetime end ) as end_time from containers S WHERE STATUS IN ('Complete') ) ET where ST.container=ET.container and ST.rownum=ET.rownum) AGG ON (C.container=AGG.container) AND (C.movetime >=AGG.start_time AND C.movetime <=AGG.end_time) group by C.container,AGG.rownum,AGG.start_time,AGG.end_time Minder

Universal Health Services, Inc.

What is a clustered/non clustered index.

2 antwoorden

I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type but the two guys interviewing me just seemed so confused and lost. I think I would have been better of simply saying "it makes lookup faster". Minder

I explained how a clustered index was in sequential physical order on disk and a non clustered index used pointers or a hash table for index lookup. I started to explain the advantages/disadvantages of each index type and how I would use them. Minder


They ask about your work, Agile methodology concepts, the BI tool you worked on.

2 antwoorden

All the information about BI tool should be known to us.

You basically need to know the different ways of Agile. Who the Scrum master is and what your role in it would be. Also, knowing the difference between kanban and sprints would be helpful. Also, it's okay if you do not know 'all' of the BI tools. If you have only used SSRS then you can probably also use Power BI, Tableau, or Excel. You know what you know. As long as you show you can adapt easily you will be fine. Minder

World Wide Technology

Whats the difference between inner join and outer join?

2 antwoorden

Inner Join returns values where the key between the two tables are the same, and values are present in both tables. Outer Join returns the Values from both tables, based on the key, even if there is not any data the joining table. If not value is available, then NULL is returned for that specific Row Data based on the Key Minder

Specified in the WHERE clause, joins simply combine data from multiple tables in the result. INNER JOIN, the most common, returns the rows for which the given ON condition is satisfied for both tables. LEFT/RIGHT OUTER JOIN statements return all the rows from the specified table regardless if there is a match in the unspecified table, with the matching rows specified in the ON condition in the unspecified table. Minder

Western Australia Department of Health

Just very formal welcome (you are lucky if they smile at you); No time for introduce yourself.. They just asking selection criteria, that we already filled and given to them (repetition is boring).. Don't care about their attitudes, because government is tax payer money and go ahead. Answer statements with examples. Always smile and behave like a professional

1 antwoorden

Talk slowly, listen carefully and answer with examples

PCS Global Tech

how to exchange variable a and b's value without using a third variable?

1 antwoorden

a = a+b; b = a-b; a=a-b;

Huawei Technologies

Usually technical questions they were.

1 antwoorden

Explaining my experiences, showing similarities.

Aveanna Healthcare

Build a public Tableau Dashboard. Present. Asked questions about what features could be implemented with more work.

1 antwoorden

Explained the different conditional formatting and tooltip sizing options that I could have implemented. Minder

Weergave: 1 - 10 van 288 sollicitatievragen

Glassdoor heeft 288 sollicitatievragen en verslagen van Business intelligence developer sollicitaties. Bereid uw sollicitatiegesprek voor. Bedrijven ontdekken. Uw droombaan vinden.