What is Power BI Desktop
What is Power Pivot?
What is Power Query?
What are the Types of Filters in Power BI?
What are the major differences between visual-level, page-level, and report-level
filters in Power BI?
Name the different connectivity modes available in Power BI?
How will schedule PowerBI report?
How to use POwerAutomate?
How to export & send pdf?
How to subscribe excel weekly?
How would you implement row-level security in Power BI?
How do you share reports and dashboards securely with external users?
Define bi-directional cross filtering.
Where is data stored in Power BI?
What's the difference between a measure and a calculated column in Power BI?
What is the CALCULATE function in DAX?
What is a summarize function in DAX? GIve example
USERELATIONSHIP
ALL(<table> or <column>) Vs ALL SELECTED
Write Lookvalue
SUm vs SUMX
How would you calculate the running total of sales in Power BI using DAX?
How do you create a measure that calculates year-to-date sales using DAX?
WHAT IS Identity column?
Mention what is OFFSET-FETCH filter in tsql?
Name 5 commands that can be used to manipulate text in T-SQL code
When should I use primary key or index?
How can you delete duplicate records in a table with no primary key?
Mention what are the Join Types in TSQL?
What are the practical differences between COALESCE() and ISNULL(,'')?
What's the difference between TRUNCATE and DELETE in SQL?
What is the difference between PARTITION BY and GROUP BY
What is the difference between EXEC vs sp_executesql?
Question 1:
Consider a table named "Orders" with the following columns: OrderID, OrderDate,
CustomerID. Write a SQL query to find the customers who have placed orders on
consecutive days.
Question 2:
You have three tables: "Employees," "Departments," and "Salaries." The "Employees"
table has the following columns: EmployeeID, EmployeeName, DepartmentID. The
"Departments" table has the following columns: DepartmentID, DepartmentName. The
"Salaries" table has the following columns: EmployeeID, Salary, EffectiveDate.
Write a SQL query to retrieve the employee who has had the highest salary increase
within the last year, along with their name, department, and the percentage
increase.
Question 3:
You have a table named "Logs" with the following columns: LogID, LogTime, UserID.
Write a SQL query to find the top 5 users who have logged in the most.
Question 4:
Consider a table named "Transactions" with the following columns: TransactionID,
TransactionDate, Amount, UserID. Write a SQL query to calculate the average
transaction amount for each user, including users who have no transactions, and
display the result as zero for those users.
Question 5:
You have two tables: "Customers" and "Purchases." The "Customers" table has the
following columns: CustomerID, CustomerName. The "Purchases" table has the
following columns: PurchaseID, PurchaseDate, CustomerID, ProductID. Write a SQL
query to find the customers who have purchased all products.
Eecution or Explain Plan
Version of SQL server
how to schedule a procedure
The candidate possesses a good background in Data Analysis, with a notable focus on
Data Visualization using PowerBI. Notably, the candidate excels in the creation of
comprehensive reports and dashboards in PowerBI, adeptly addressing client
requirements. His expertise extends to various data sources, including SQL server,
APIs, and flat files. He demonstrates a commendable command of DAX commands, M
query, and Power Query, showcasing their ability to write intricate code in both
Direct Query and Import methods. However, it's worth noting that his exposure to
PowerBI Server/Service is limited, particularly in post-development activities such
as deployments, scheduling refreshes, and report sharing/subscribing, areas
currently managed by a separate team.
Regarding SQL, the candidate boasts a robust background, with a wealth of
experience in crafting SQL queries using joins and handling complex SQL tasks.
Overall, the candidate is a valuable asset with a solid foundation in Data
Analysis, PowerBI and SQL, with the potential for growth in PowerBI Service-related
activities.
Overall a good candidate with enough experience on Data handling & Data
visualisation.
The candidate possesses a good background in Data Analysis, with a good focus on
Data Visualization using PowerBI. Notably, the candidate excels in the creation of
comprehensive reports and dashboards in PowerBI, adeptly addressing client
requirements. His expertise extends to various data sources, including SQL server
and flat files. He demonstrates a commendable command of DAX commands, M query, and
Power Query, showcasing their ability to write intricate code in both Direct Query
and Import methods. Also, it's worth noting that his exposure to PowerBI
Server/Service is also good, particularly in post-development activities such as
deployments, scheduling refreshes, and report sharing/subscribing.
Regarding SQL, the candidate has a basic background & can handle medium complexity
sql queries however he struggled with writing complex scenario based sql. He can
perform data anlaysis & cleanup activities that does not require much complexity
but lacking in doing deep dive data anlaysis.
Overall, the candidate is a valuable asset with a solid foundation in PowerBI, with
the potential for growth in SQL activities. He can apply for BI roles only & to
move to the BI + Analyst role, he has to work on SQL.
