BI / Tableau / PowerBI

Select rows from a DataFrame where the value in column "col1" is greater than 1 and less than 3. df = pd.DataFrame([[1, "A"], [2, "B"], [3, "C"]], columns = ["col1", "col2"])

What will you do in the first days after joining a team that already has managerial and thematic dashboards?

Write a Python function that determines whether a number is even.

What is the difference between INNER JOIN and LEFT JOIN?

Is this your usual pace of work or were you rushing due to excitement?

What questions would you ask the client if they came with a request "build me a shopping dashboard"?

What happens if you pass a string to the even check function, and how to handle it?

Solve the same SQL task using a window function.

What Python libraries and frameworks have you used in your work?

How to strategically build the perfect analytics from scratch?

Write an SQL query that outputs the names of users from the third to the seventh in alphabetical order.

How does PARTITION BY work in the ROW_NUMBER() OVER (...) construct?

Why did you decide to change your current job after three months?

Оптимизировать запрос SELECT p.id AS project_id, p.name AS project_name, i.id AS issue_id, i.subject AS issue_subject, i.status_name AS last_status, h.status AS current_status, h.date_update FROM project AS p LEFT JOIN issue AS i ON p.id=i.project_id LEFT JOIN issue_history AS h ON h.id_issue=i.id WHERE h.code IN (1,4,6)

What is the difference between list, tuple, and set in Python?