Hey, Hi !

I'm Rakesh, and I'm passionate about building businesses that thrive, not just survive. I invite you to join the conversation. Whether you're a seasoned professional, a budding entrepreneur, or simply curious about the world of building things, this blog is for you. It's a space to learn, grow, and share your experiences on the journey from ideas to impact.
Labels

Amazon Data Analyst Interview Questions

 


Power BI Questions

1. Create a dynamic visual to display the total sales by product category and allow users to filter by region.
2. Write a DAX measure to calculate the year-over-year growth in revenue for each month.
3. Explain the difference between calculated columns and measures with examples related to sales analysis.
4. Explain how to implement Row-Level Security (RLS) to ensure that regional sales managers can only view data for their assigned regions.
5. Write a DAX formula to calculate cumulative sales for each product across the entire sales period.
6. Create a KPI visual to show quarterly revenue growth and flag whether the target has been achieved.
7. Design a custom fiscal date table in Power BI where the fiscal year starts in July.
8. Write a DAX formula to display the top 10 customers by total purchase value in a card visual.
9. Write a DAX formula to calculate the total revenue from repeat customers who placed orders in more than one month.
10. Explain the process to clean data, remove duplicate records, and split a full name column into first and last names.

Comments

Post a Comment