Data Analyst Interview Questions Pt. 2 ๐ฃ๏ธ
Welcome to Part 2 of this series. After covering 40 questions on Excel, Python & SQL in Pt 1, this thread covers 30 questions on BI tools and Scenario-based analysis encountered in previous interviews. Read and do share #jessithreads
Welcome to Part 2 of this series. After covering 40 questions on Excel, Python & SQL in Pt 1, this thread covers 30 questions on BI tools and Scenario-based analysis encountered in previous interviews. Read and do share #jessithreads
BI Tools General Questions
41. Rate either your Tableau, Looker Studio or Power BI skills?
42. Whatโs your process for creating a new dashboard for stakeholders?
43. How would you improve user-friendliness on a dashboard?
44. How do you determine KPIs for a new dashboard project?
41. Rate either your Tableau, Looker Studio or Power BI skills?
42. Whatโs your process for creating a new dashboard for stakeholders?
43. How would you improve user-friendliness on a dashboard?
44. How do you determine KPIs for a new dashboard project?
BI Tools General Questions (contd.)
45. Have you dealt with situations where stakeholders were not savvy with using dashboards? how did you drive adoption?
46. How do you determine refresh frequency for a dashboard?
45. Have you dealt with situations where stakeholders were not savvy with using dashboards? how did you drive adoption?
46. How do you determine refresh frequency for a dashboard?
BI Tools General Questions (contd.)
47. In what ways have you improved efficiency of a reporting process in the past?
48. What are your go-to best practices for creating a dashboard?
47. In what ways have you improved efficiency of a reporting process in the past?
48. What are your go-to best practices for creating a dashboard?
Power BI Questions
49. What do you know about DAX & have you used it in the past?
50. What are the different views in Power BI?
51. How would you optimize the performance of a Power BI report?
52. What challenges did you encounter & how did you address those challenges? (f. 51)
49. What do you know about DAX & have you used it in the past?
50. What are the different views in Power BI?
51. How would you optimize the performance of a Power BI report?
52. What challenges did you encounter & how did you address those challenges? (f. 51)
Power BI Questions (contd.)
53. Can you walk me through your process of creating a dashboard in Power BI?
54. Are you familiar with Power Query?
55. How would you implement row level security?
56. Whatโs the difference between Filters and Slicers?
53. Can you walk me through your process of creating a dashboard in Power BI?
54. Are you familiar with Power Query?
55. How would you implement row level security?
56. Whatโs the difference between Filters and Slicers?
Power BI Questions (contd.)
57. How do you manage relationships when creating a Power BI report? And what are the types of cardinality?
Tableau
58. Difference between measures and dimensions?
59. Are you familiar with LOD expressions?
60. Do you know about blending in Tableau?
57. How do you manage relationships when creating a Power BI report? And what are the types of cardinality?
Tableau
58. Difference between measures and dimensions?
59. Are you familiar with LOD expressions?
60. Do you know about blending in Tableau?
Tableau (contd.)
61. How do you create calculated fields in Tableau?
62. Have you worked with Tableau Prep before?
63. Whatโs your process of creating a Tableau dashboard?
61. How do you create calculated fields in Tableau?
62. Have you worked with Tableau Prep before?
63. Whatโs your process of creating a Tableau dashboard?
Scenario questions
64. You are told to open a lemonade stand, what would you consider before opening one in a particular location?
65. Have you done a customer segmentation analysis before? How did you approach it?
66. Say we noticed decline in customer retention. How wouldโฆ
64. You are told to open a lemonade stand, what would you consider before opening one in a particular location?
65. Have you done a customer segmentation analysis before? How did you approach it?
66. Say we noticed decline in customer retention. How wouldโฆ
Good luck to anyone currently interviewing for roles. Please do add more questions from your interview experience in the comment section.
Loading suggestions...