Data Modeling. SQL queries. ETL pipeline questions.
Bi Data Analyst Interview Questions
4,386 bi data analyst interview questions shared by candidates
SQL questions -Joins,sub queries, etl and business.
Interview focuses on basics related to BI and DWH. If you're applying to an ETL role be prepared to talk about a project situation or share some job exp. Data modelling and data mining is also key topics.
What is an example of when you've used teamwork to solve a problem?
how to communicate differently to different stakeholders
Field requirement in report?How can we we bring it
Create DS in Ecc and explain steps with transports to till movement in BW
1.How to identify Duplicate Rows in a table 2.how to identify a year from rows 3. About Date functions 4. sort the country column in a way that first two rows should be usa,Canada rest of the rows in alphabetical order(how to write in SQL ,and in power Bi) 5.write a query on how many employs are join in each year 6.In power Bi about filters and how many types of filters 7.About Drill through and Drill down filter 8.when we map visualisation 9.about refresh in power Bi (why we use refresh) 10.how to connect data into SQL 11power Query and Power pivot 12.what is power BI Dashboard 13.how we publish report in power Bi 14. what is Stored Procedures 15.what is VIEW 16. INDEXES why we use in sql
It is based on the work you have done and showing in the interview.
Scenario based case studies about go-to-market strategies
Viewing 2181 - 2190 interview questions