Amazon BI Engineer Interview - Executive Metrics | Business Case + SQL

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 44

  • @chaosstudios4330
    @chaosstudios4330 2 роки тому +9

    Don't know why metrics would be a ambiguous analytics problem cause leadership will always have priorities as part of business goals so they are aware of what metrics they need to make decisions. I'd assume logically business intelligence would need to show those specific metrics as requested and then perhaps an analysis of various areas of the business as a guidance for leadership to focus on. Giving random unsolicited reports and metrics makes no sense.

  • @lenka4662
    @lenka4662 4 місяці тому +1

    1 total trend
    - total # of customers
    - # total of transactions
    - total # of sales revenue
    2 customers
    - # of customers based on the signup
    -
    3 transactions
    - # of transactions over time
    - revenue of transactions over time
    - # of sales based on items
    - # of sales revenue based on items

  • @helovesdata8483
    @helovesdata8483 2 роки тому +9

    I'm interviewing for BIE roles now and this is very helpful in general.

  • @sandrahu7122
    @sandrahu7122 2 роки тому +8

    this guy who answered the question either didn't have experience or doesn't have business acumen. he didn't get the thing right, the executives only want to see the big picture of the transactions, not the details. as an analyst, you need to know who is your audience. he is talking no sense around

  • @SwatiTirthramGulia
    @SwatiTirthramGulia 5 місяців тому +1

    Thank you, Dan, for consistently providing us with valuable and practical content

  • @underdogmorphling8488
    @underdogmorphling8488 2 роки тому +6

    This is exactly how a BIE interview at amazon is. The evaluation of response is spot on.

    • @DataInterview
      @DataInterview  2 роки тому

      Thanks for the input :)

    • @underdogmorphling8488
      @underdogmorphling8488 2 роки тому +1

      @@DataInterview btw I got my BIE offer from Amazon :) Thank you so much!

    • @DataInterview
      @DataInterview  2 роки тому

      @@underdogmorphling8488 congrats! 🥂

    • @alexisspence4050
      @alexisspence4050 2 роки тому

      Hey can you message me I’m about to interview for this as well and have questions

    • @DataInterview
      @DataInterview  2 роки тому

      @@alexisspence4050 or just email me at dan@datainterview.com

  • @MaxenceRonzié
    @MaxenceRonzié Рік тому +3

    If I may, the data architecture with Customer & Transaction tables is not optimized at all. You should put a customer id in transaction table and remove the transaction id from the customer table because with this implementation the customer_id & sign_up_date are duplicated as many times as a customer made a transaction.

    • @And_Nunes
      @And_Nunes Рік тому

      I thought the same thing

  • @kevinkevin1712
    @kevinkevin1712 2 роки тому +8

    Hey dan, interviewing for BIE role and they are mentionning « opportunity sizing » as part of the final interview. Can you help prepare for this?

    • @donndonnn
      @donndonnn 2 роки тому +2

      Hi Kevin, how did your interview go? Did you find out what they meant by that term?

  • @meikelwis
    @meikelwis 2 роки тому +2

    Thanks Dan, your content is really helpful. I learned that sometimes a simple solution can give more insight. Keep uploading Dan!

  • @leassis91
    @leassis91 2 роки тому +2

    thanks for the content, Dan! Can you provide for us beginners the SQL solution?

  • @tysong9883
    @tysong9883 Рік тому

    are you sure the last line "limit 100" will correctly give top 100 VIP customer? Actually it's customer/date level data.

  • @kanchidoshi6907
    @kanchidoshi6907 2 роки тому

    Is it more relevant to Loop round or initial Technical screening?

  • @baderalhousainy
    @baderalhousainy Рік тому

    Thank you guys for this interview. wondering about two things. dose amazon use power bi or tableau? also, why would he need to write the query if this Dax is almost ready if he could load the data from the server to the dashboard?

  • @kunalrath5352
    @kunalrath5352 9 місяців тому

    SELECT AVG(items) AS average_order_size
    FROM Customer AS c
    JOIN Transaction AS t ON c.transaction_id = t.transaction_id;
    I optimized the SQL query. Can't we use this?

  • @djjiang3718
    @djjiang3718 2 роки тому

    Thank you Sir! Great stuff!

  • @laurab6180
    @laurab6180 7 місяців тому +1

    I excelled the SQL but couldn't ace the Python part

    • @OjasBhanarkar
      @OjasBhanarkar 7 місяців тому

      Hey! Can you please share what exactly in Python were you asked?

    • @vinayanayak1228
      @vinayanayak1228 6 місяців тому

      hey , can you tell what questions were asked to you?

  • @TyTyBoro
    @TyTyBoro 2 роки тому

    Very helpful!! Thank you!!

  • @nareshvadlamudi
    @nareshvadlamudi 2 роки тому +6

    Thanks Dan, very helpful. Just wondering in which level does this interview belong to - starting/Intermediary/Advanced level?

  • @tigerbear3038
    @tigerbear3038 3 роки тому +3

    Hey Dan, how did you come up with this format for the Amazon BI Engineer interview? Was it based on actual BI Engineer interviews?

    • @jonathanl7204
      @jonathanl7204 3 роки тому +3

      Amazon interviews are structured like this. They usually do not ask you questions on metrics but 3 SQL questions immediately

    • @GokulGourav
      @GokulGourav 2 роки тому +2

      @@jonathanl7204 what are those 3 questions?

    • @donndonnn
      @donndonnn 2 роки тому +2

      @@jonathanl7204 mind sharing what those questions are ?

  • @princebansal5483
    @princebansal5483 2 роки тому

    Very helpful video.

  • @Rohit_Ankita
    @Rohit_Ankita 2 роки тому

    Don't miss the explanation at the end.

  • @Slamo28
    @Slamo28 2 роки тому

    Super helpful

  • @BINTETA.42CAORIS
    @BINTETA.42CAORIS 6 місяців тому

    Walk. Physical

  • @sandrahu7122
    @sandrahu7122 2 роки тому +4

    why is it so difficult for that person to answer the first question: metic-total sales, number of transactions, he is fxxking talking no sense for so long.

  • @baloney_sandwich
    @baloney_sandwich Рік тому

    U know this isn’t real because it violates Amazon confidentiality clause

  • @teddy911
    @teddy911 2 роки тому +3

    这兄弟的英语听得我便秘

    • @od2437
      @od2437 2 роки тому +1

      😂