The questions are straight forward. The questions asked of me fell into two categories: subject matter expertise, foreign contacts, and criminal history.
Business Intelligence Engineer Interview Questions
Business Intelligence Engineer Interview Questions
Business Intelligence Engineers oder kurz BI Engineers erhalten wahrscheinlich mehrere Fragen zu ihren Kenntnissen in der Anwendung von Skriptsprachen, Prozessoren und Programmen, die vom potenziellen Arbeitgeber verwendet werden. Es können zwar auch einige Fragen zu zwischenmenschlichen Beziehungen gestellt werden, doch wird es beim Vorstellungsgespräch für Business Intelligence Engineers eher um Ihre Erfahrungen im Bereich Datenanalyse gehen.
Typische Bewerbungsfragen als Business Intelligence Engineer (m/w/d) und wie Sie diese beantworten
Question 1
Frage 1: Auf welches Projekt, an dem Sie gearbeitet haben, sind Sie stolz?
How to answer
So beantworten Sie die Frage: Vor dem Vorstellungsgespräch sollten Sie sich darauf vorbereiten, über ein früheres Projekt ausgiebig referieren zu können. Egal, ob es aufgrund Ihres Teams oder Ihres individuellen Beitrags so erfolgreich war: Der Schlüssel ist, dass Sie zeigen, wie leidenschaftlich Sie arbeiten. Heben Sie unbedingt die für das Projekt angewendeten Kompetenzen hervor.
Question 2
Frage 2: Mit welchen Sprachen/Programmen/Softwareprodukten sind Sie bereits sehr vertraut?
How to answer
So beantworten Sie die Frage: Beim BI Engineering geht es vor allem um die Anwendung von Tools für die Datenanalyse. Ihnen wird wahrscheinlich eine Frage zu den Tools gestellt, mit denen Sie gut vertraut sind. Achten Sie darauf, dass Sie sich zu den Sprachen, Programmen und Softwareprodukten, mit denen Sie nach eigenen Angaben gut vertraut sind, kompetent äußern.
Question 3
Frage 3: Wie würden Sie ...?
How to answer
So beantworten Sie die Frage: Wahrscheinlich wird Ihnen bei Ihrem Vorstellungsgespräch für die Position als BI Engineer ein kniffliges Szenario oder Problem vorgegeben, das Sie lösen müssen. Egal, ob es um den Umgang mit einem SQL-Problem oder die Leistungsberechnung in Tableau geht: Sie sollten eine Antwort parat haben. In der Regel helfen fundierte Kenntnisse zu den in der Stellenausschreibung angegebenen Tools Ihnen dabei, solche Fragen erfolgreich zu beantworten.
6,924 business intelligence engineer interview questions shared by candidates
Offering 20% discount increases sales by 25% - what's the impact on financials, operations, marketing
Given the fact that revenue will not increase or even decrease a little bit, but with a higher percentage of email registration, will you say this is acceptable?
Let's say Amazon undercuts the price of a similar barstool by 10%. Should we undercut as well, and if we undercut and don't see any improvement in selling performance, what may be the cause for this?
You have a table called Order with Cust_ID, Order_Date, Order_ID, Tran_Amt. Select the top 100 customers with high spend over a year long period.
salary(department_id,employee_id,salary) List all employees with salary greater than the everage department salary and also greather than $50K
Was asked to write queries for two problems - Q. Table: Customer_orders customer_id order_id order_day 123 27424624 25Dec2011 123 89690900 25Dec2010 797 12131323 25Dec2010 876 67145419 15Dec2011 Write SQL for customers who placed orders on both the days, 25th Dec 2010 and 25th Dec 2011? Customer_id order_id order_datetime 1234 4141-4814 25/12/2010:06:15:00 1234 4141-4815 25/12/2010:06:20:00 1234 4141-4816 25/12/2010:06:41:00 1234 4141-4817 25/12/2010:06:50:00 8153 2525-1414 26/12/2010:07:13:00 8153 2525-1415 26/12/2010:13:10:10 Let's say I can combine two orders that are placed by the same customer within 20 mins of each other, what % of orders can be combined.
No questions at all were asked about business intelligence analyst or data analytics The only question asked was -How much do i rate myself on SQL on the scale of 1 to 10
Question 1 : An ad campaign has generated 1 million ad impressions and 6000 clicks.What is the CTR (ClickThrough Rate)? (in percentage) Question 2 : An ad campaign has generated 5000 clicks and 100 transactions. What is the conversion rate (in percentage)? Question 3 : With a budget of $5000 and a CPC (Cost per click) = $0.4, how many clicks an advertiser can buy (integer without unit)? Question 4 : An ad campaign has a CTR = 0.6% and a CPC = $0.4.What is the equivalent CPM (in dollar)? Question 5 : An ad campaign has a CPC = $0.5, a conversion rate = 3% and an average transaction value of $260.What is the Cost of Sales of the campaign (cost of the ad campaign divided by the revenues generated, in percentage)? Question 6 : With a margin on revenues of 13%, an average transaction value of $290 and a conversion rate = 0.7%, what is the maximum CPC an advertiser can afford without losing money (in dollar)? Question 7 : During his browsing, a user is randomly exposed to two ad banners A & B. Those two banners are equally likely to be shown. One and only one banner is shown per page. After two pages of browsing, what’s the probability that the user was shown only banners A (in percentage)? Question 8 : A/B Testing campaign: Measuring the impact of Criteo retargeting ads compared to a control group. Number of transactions on client site : • Group A exposed to Criteo banners 600,000 • Group B Control group not exposed 50,000a. a. Is it a problem to have a control group smaller than the CompanyA group? No - what you want to know is if the transaction rate for the experiment group is significantly greater than that of the control group. As long as the results are statistically significant, the uneven sample size between groups should not be a problem. b. What incremental revenues per user CompanyA has generated for the client advertiser (in dollar, rounded to the cent)? For this question you need to first calculate the revenue per user for both groups and then take the difference between them to arrive at the incremental revenue per user. c. What total incremental revenues CompanyA has generated for the client advertiser? Total incremental revenue is simply the incremental revenue per user multiplied by the number of users exposed to Company A's retargeting. d. With $200.000 revenues following clicks on banners for group A (post click), what is the related post view (view through) effect in revenues generated by CompanyA campaign?
Name a research project that you have completed, and the role that you took.
Viewing 21 - 30 interview questions