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.
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
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.
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
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?
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?
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.