Data Analyst Interview QnA

1. Find avg of salaries department wise from table.

Answer-

SELECT department_id, AVG(salary) AS avg_salary
FROM employees
GROUP BY department_id;

2. What does Filter context in DAX mean?

Answer - Filter context in DAX refers to the subset of data that is actively being used in the calculation of a measure or in the evaluation of an expression. This context is determined by filters on the dashboard items like slicers, visuals, and filters pane which restrict the data being processed.

3. Explain how to implement Row-Level Security (RLS) in Power BI.

Answer - Row-Level Security (RLS) in Power BI can be implemented by:

- Creating roles within the Power BI service.
- Defining DAX expressions that specify the data each role can access.
- Assigning users to these roles either in Power BI or dynamically through AD group membership.

4. Create a dictionary, add elements to it, modify an element, and then print the dictionary in alphabetical order of keys.

Answer -

d = {'apple': 2, 'banana': 5}
d['orange'] = 3  # Add element
d['apple'] = 4   # Modify element
sorted_d = dict(sorted(d.items()))  # Sort dictionary
print(sorted_d)

5. Find and print duplicate values in a list of assorted numbers, along with the number of times each value is repeated.

Answer -

from collections import Counter

numbers = [1, 2, 2, 3, 4, 5, 1, 6, 7, 3, 8, 1]
count = Counter(numbers)
duplicates = {k: v for k, v in count.items() if v > 1}
print(duplicates)

Like ❤️ & Share the post if you want me to post more similar content. 😊

120+ Python Projects with Source Codes 🔽

https://drive.google.com/drive/folders/1TvjOQx_XfxARi8qNtDwpZNwmcor5lJW_?usp=share_link


WhatsApp:
https://whatsapp.com/channel/0029VacdBsc0lwgnyDoW9a1Z

Instagram:
https://www.instagram.com/codinginpy?igsh=MXVpcnppNTg5Zm5hcA==

Telegram: https://t.me/codinginpyofficial

S&P Global is hiring for the role of Software Development Engineer 1!

Expected salary: INR 7 - 19 LPA via Glassdoor)

Link: https://openinapp.link/3e7kt

Cognizant is hiring for the role of Associate - Projects!

Expected salary: INR 8 - 14 LPA (via Glassdoor)

Link: https://unstop.com/jobs/associate-projects-cognizant-1119972?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Cognizant13082024&ref=Codinginpy

Rebel Foods is hiring!

1. PPI Offer:- CTC upto 20 Lakhs
2. Cash Prize Pool of INR 1.5 Lakhs

Application Link: https://unstop.com/competitions/rebel-foods-eatsure-cloud-2024-rebel-foods-1116221?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=RebelFood13082024&ref=Codinginpy

Eligibility: Open to all

Apply Now!

Genpact is hiring for the role of Associate-Procurement!

Expected salary: INR 3 - 6 LPA via Glassdoor)

Link: https://unstop.com/jobs/associate-procurement-genpact-1116562?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Genpact12082024&ref=Codinginpy

BCG is hiring for the role of AI Engineer!

Expected salary: INR 6 - 14 LPA (via Glassdoor)

Link : https://unstop.com/jobs/ai-engineer-boston-consulting-group-1118084?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=BCG09082024&ref=Codinginpy

BlackRock is hiring for the role of Applied Analytics Associate!

Expected salary: INR 7 - 11 LPA via Glassdoor)

Link: https://unstop.com/jobs/applied-analytics-associate-blackrock-1116431?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=BlackRock14082024&ref=Codinginpy

Salesforce is hiring for the role of Software Engineering AMTS!

Expected salary: INR 15 - 18 LPA via Glassdoor)

Link: https://unstop.com/jobs/software-engineering-amts-salesforce-1125686?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Salesforce14082024&ref=Codinginpy

Bentley Systems is hiring for the role of Associate Software Quality Analyst!

Expected salary: INR 4 - 10 LPA (via Glassdoor)

Link: https://unstop.com/jobs/associate-software-quality-analyst-bentley-systems-1114814?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=BS09082024&ref=Codinginpy

NTT Data is hiring for the role of Associate Engineer!

Expected salary: INR 4 - 11 LPA via Glassdoor)

Link: https://unstop.com/jobs/associate-engineer-ntt-data-1123001?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=NTT15082024&ref=Codinginpy

Google is hiring for the role of Embedded Software Engineer!

Expected salary: INR 10 - 20 LPA (via Glassdoor)

Link: https://unstop.com/jobs/embedded-software-engineer-google-1114765?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Google08082024&ref=Codinginpy

Ericsson is hiring for the role of Data Analyst!

Expected salary: INR 4 - 7 LPA via Glassdoor)

Link: https://unstop.com/jobs/data-analyst-ericsson-1125680?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Ericsson15082024&ref=Codinginpy

Hi Champs Don't Miss this Opportunity, Mostly for Data roles We have less Openings as a freshers
So Apply fast.

Cummins is hiring for the role of Electronic Systems Product Engineer!

Expected salary: INR 4 - 12 LPA via Glassdoor)

Link: https://unstop.com/jobs/electronic-systems-product-engineer-cummins-india-1123885?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=Cummins16082024&ref=Codinginpy

Tata is hiring through Imagination Challenge!

1. PPI Offer: - Chance to work in TAS (Tata Administrative Services)
2. Cash Prize Pool of INR 26 Lakhs

Application Link: https://unstop.com/competitions/tata-imagination-challenge-2024-student-track-tata-imagination-challenge-2024-tata-group-1096490?utm_source=Codinginpy&utm_medium=Affiliates&utm_campaign=TATA16082024&ref=Codinginpy

Eligibility: Open to all

Apply Now!

Thank you all for your Constant support!

This page started on 4th August 2023, and in just 1 year and 14 days, we've grown into a 200k+ family on Instagram and nearly 30k on Telegram.

Your likes, shares, and comments inspire me to keep delivering the best content. Let’s keep learning and keep growing together.
Thank you for being a part of this journey!🙌❤️