Data Analyst Interview Resources

𝗠𝘂𝘀𝘁-𝗞𝗻𝗼𝘄 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗮𝗻𝗱 𝗧𝗶𝗽𝘀 𝘁𝗼 𝗔𝗰𝗲 𝗬𝗼𝘂𝗿 𝗡𝗲𝘅𝘁 𝗝𝗼𝗯 𝗶𝗻 𝟮𝟬𝟮𝟱😍 If you’re preparing for your first data analyst job or making a career switch in 2025🎊 This guide will give you the edge. We’ve curated a list of real-world interview questions along with smart tips to help you answer confidently.🎯📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3Fr5h1d ENJOY LEARNING ✅️

SQL Interview Questions (0-5 Year Experience)!! Are you preparing for a SQL interview? Here are some essential SQL concepts to review: 𝐁𝐚𝐬𝐢𝐜 𝐒𝐐𝐋 𝐂𝐨𝐧𝐜𝐞𝐩𝐭𝐬: 1. What is SQL, and why is it important in data analytics? 2. Explain the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN. 3. What is the difference between WHERE and HAVING clauses? 4. How do you use GROUP BY and HAVING in a query? 5. Write a query to find duplicate records in a table. 6. How do you retrieve unique values from a table using SQL? 7. Explain the use of aggregate functions like COUNT(), SUM(), AVG(), MIN(), and MAX(). 8. What is the purpose of a DISTINCT keyword in SQL? 𝐈𝐧𝐭𝐞𝐫𝐦𝐞𝐝𝐢𝐚𝐭𝐞 𝐒𝐐𝐋: 1. Write a query to find the second-highest salary from an employee table. 2. What are subqueries and how do you use them? 3. What is a Common Table Expression (CTE)? Give an example of when to use it. 4. Explain window functions like ROW_NUMBER(), RANK(), and DENSE_RANK(). 5. How do you combine results of two queries using UNION and UNION ALL? 6. What are indexes in SQL, and how do they improve query performance? 7. Write a query to calculate the total sales for each month using GROUP BY. 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐒𝐐𝐋: 1. How do you optimize a slow-running SQL query? 2. What are views in SQL, and when would you use them? 3. What is the difference between a stored procedure and a function in SQL? 4. Explain the difference between TRUNCATE, DELETE, and DROP commands. 5. What are windowing functions, and how are they used in analytics? 6. How do you use PARTITION BY and ORDER BY in window functions? 7. How do you handle NULL values in SQL, and what functions help with that (e.g., COALESCE, ISNULL)? Here you can find essential SQL Interview Resources👇 https://t.me/mysqldata Like this post if you need more 👍❤️ Hope it helps :)

𝗠𝗲𝗴𝗮 𝗜𝗻𝘁𝗲𝗿𝗻𝘀𝗵𝗶𝗽𝘀 + 𝗣𝗿𝗲-𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗢𝗳𝗳𝗲𝗿 - 𝗪𝗮𝗹𝗸𝗜𝗻 𝗛𝗶𝗿𝗶𝗻𝗴 𝗗𝗿𝗶𝘃𝗲😍 💼 Roles: AI/ML Intern, Backend Intern,& Frontend Intern  📍 Location: Hyderabad ,Pune  💰 Stipend: ₹20K – ₹25K (for 3 months)  🎯 CTC (Post Internship): ₹4.5 LPA – ₹6 LPA 🔹 Frontend Intern:- https://pdlink.in/4kvxN0L 🔹 Backend Intern:-  https://pdlink.in/4k3A0jX 🔹 AI/ML Intern :- https://pdlink.in/3YYGM27 🎟️ Limited slots available – Apply Now

𝐏𝐚𝐲 𝐀𝐟𝐭𝐞𝐫 𝐏𝐥𝐚𝐜𝐞𝐦𝐞𝐧𝐭 𝐓𝐫𝐚𝐢𝐧𝐢𝐧𝐠 𝐏𝐫𝐨𝐠𝐫𝐚𝐦😍 Learn Full Stack Development & Data Analytics from IIT Alumni & Top Tech Experts. 𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝘀:- 60+ Hiring Drives Every Month 🌟 Trusted by 7500+ Students 🤝 500+ Hiring Partners 💼 Avg. Package: ₹7.2 LPA | Highest: ₹41 LPA Eligibility: BTech / BCA / BSc / MCA / MSc 𝐑𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐍𝐨𝐰 👇:-  𝗙𝘂𝗹𝗹 𝗦𝘁𝗮𝗰𝗸 :- https://pdlink.in/4hO7rWY 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀:- https://bit.ly/4g3kyT6 Hurry, limited seats available!. 🏃‍♀️

1. What are Query and Query language? A query is nothing but a request sent to a database to retrieve data or information. The required data can be retrieved from a table or many tables in the database. Query languages use various types of queries to retrieve data from databases. SQL, Datalog, and AQL are a few examples of query languages; however, SQL is known to be the widely used query language. 2. What are Superkey and candidate key? A super key may be a single or a combination of keys that help to identify a record in a table. Know that Super keys can have one or more attributes, even though all the attributes are not necessary to identify the records. A candidate key is the subset of Superkey, which can have one or more than one attributes to identify records in a table. Unlike Superkey, all the attributes of the candidate key must be helpful to identify the records. 3. What do you mean by buffer pool and mention its benefits? A buffer pool in SQL is also known as a buffer cache. All the resources can store their cached data pages in a buffer pool. The size of the buffer pool can be defined during the configuration of an instance of SQL Server. The following are the benefits of a buffer pool: Increase in I/O performance Reduction in I/O latency Increase in transaction throughput Increase in reading performance 4. What is the difference between Zero and NULL values in SQL? When a field in a column doesn’t have any value, it is said to be having a NULL value. Simply put, NULL is the blank field in a table. It can be considered as an unassigned, unknown, or unavailable value. On the contrary, zero is a number, and it is an available, assigned, and known value.

𝗚𝗼𝗼𝗴𝗹𝗲 𝗙𝗥𝗘𝗘 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 - 𝗠𝗮𝘀𝘁𝗲𝗿 𝗛𝗶𝗴𝗵 𝗗𝗲𝗺𝗮𝗻𝗱 𝗧𝗲𝗰𝗵 𝗦𝗸𝗶𝗹𝗹𝘀 😍 Ready to dive into the world of programming, AI, and Machine Learning?👨‍💻 Google-certified courses on Kaggle offer an unbeatable opportunity to learn cutting-edge technologies for free. Google Certified🎓 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4drZNA9 Start Learning Today!✅️

Struggling to land interviews at your dream companies, even after applying to 100+ jobs? You are not alone. A recent survey shows that 9 out of 10 professionals struggle to switch to their desired companies, and on average, it takes 4-6 months to make a successful move. To solve this, Newton School has launched a Mentorship followed by Job Referral Program for Software Development and Data Science roles. What you get: ✅ Referral to top companies currently hiring ✅ 1:1 Mentorship from top industry experts from MAANG companies ✅ Skill gap analysis and targeted grooming via projects & assignments ✅ Company-specific prep + mock interviews with expert feedback ✅ Resume & LinkedIn optimization to beat ATS Referrals starting in 3-4 weeks We select only 10 candidates per month for each domain (Software Development & Data Science). Click now: https://shorturl.at/vaa4J

Common Mistakes Data Analysts Must Avoid ⚠️📊 Even experienced analysts can fall into these traps. Avoid these mistakes to ensure accurate, impactful analysis! 1️⃣ Ignoring Data Cleaning 🧹 Messy data leads to misleading insights. Always check for missing values, duplicates, and inconsistencies before analysis. 2️⃣ Relying Only on Averages 📉 Averages hide variability. Always check median, percentiles, and distributions for a complete picture. 3️⃣ Confusing Correlation with Causation 🔗 Just because two things move together doesn’t mean one causes the other. Validate assumptions before making decisions. 4️⃣ Overcomplicating Visualizations 🎨 Too many colors, labels, or complex charts confuse your audience. Keep it simple, clear, and focused on key takeaways. 5️⃣ Not Understanding Business Context 🎯 Data without context is meaningless. Always ask: "What problem are we solving?" before diving into numbers. 6️⃣ Ignoring Outliers Without Investigation 🔍 Outliers can signal errors or valuable insights. Always analyze why they exist before deciding to remove them. 7️⃣ Using Small Sample Sizes ⚠️ Drawing conclusions from too little data leads to unreliable insights. Ensure your sample size is statistically significant. 8️⃣ Failing to Communicate Insights Clearly 🗣️ Great analysis means nothing if stakeholders don’t understand it. Tell a story with data—don’t just dump numbers. 9️⃣ Not Keeping Up with Industry Trends 🚀 Data tools and techniques evolve fast. Keep learning SQL, Python, Power BI, Tableau, and machine learning basics. Avoid these mistakes, and you’ll stand out as a reliable data analyst! Share with credits: https://t.me/sqlspecialist Hope it helps :)

𝗙𝗿𝗲𝗲 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗝𝗼𝘂𝗿𝗻𝗲𝘆 𝗶𝗻 𝟮𝟬𝟮𝟱😍 Ready to upskill in data science for free?🚀 Here are 3 amazing courses to build a strong foundation in Exploratory Data Analysis, SQL, and Python👨‍💻📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/43GspSO Take the first step towards your dream career!✅️

Everyone thinks being a great data analyst is about advanced algorithms and complex dashboards. But real data excellence comes from methodical habits that build trust and deliver real insights. Here are 20 signs of a truly effective analyst 👇 ✅ They document every step of their analysis ➝ Clear notes make their work reproducible and trustworthy. ✅ They check data quality before the analysis begins ➝ Garbage in = garbage out. Always validate first. ✅ They use version control religiously ➝ Every code change is tracked. Nothing gets lost. ✅ They explore data thoroughly before diving in ➝ Understanding context prevents costly misinterpretations. ✅ They create automated scripts for repetitive tasks ➝ Efficiency isn’t a luxury—it’s a necessity. ✅ They maintain a reusable code library ➝ Smart analysts never solve the same problem twice. ✅ They test assumptions with multiple validation methods ➝ One test isn’t enough; they triangulate confidence. ✅ They organize project files logically ➝ Their work is navigable by anyone, not just themselves. ✅ They seek peer reviews on critical work ➝ Fresh eyes catch blind spots. ✅ They continuously absorb industry knowledge ➝ Learning never stops. Trends change too quickly. ✅ They prioritize business-impacting projects ➝ Every analysis must drive real decisions. ✅ They explain complex findings simply ➝ Technical brilliance is useless without clarity. ✅ They write readable, well-commented code ➝ Their work is accessible to others, long after they're gone. ✅ They maintain robust backup systems ➝ Data loss is never an option. ✅ They learn from analytical mistakes ➝ Errors become stepping stones, not roadblocks. ✅ They build strong stakeholder relationships ➝ Data is only valuable when people use it. ✅ They break complex projects into manageable chunks ➝ Progress happens through disciplined, incremental work. ✅ They handle sensitive data with proper security ➝ Compliance isn’t optional—it’s foundational. ✅ They create visualizations that tell clear stories ➝ A chart without a narrative is just decoration. ✅ They actively seek evidence against their conclusions ➝ Confirmation bias is their biggest enemy. The best analysts aren’t the ones with the most tools—they’re the ones with the most rigorous practices. Which of these habits could transform your data work today? 🚀 Join biggest telegram channel to master data analytics: https://t.me/sqlspecialist

𝟰 𝗙𝗿𝗲𝗲 𝗘𝘅𝗰𝗲𝗹 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘄𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗝𝗼𝘂𝗿𝗻𝗲𝘆 (𝟮𝟬𝟮𝟱)😍 When it comes to data analytics, Excel is more than just a spreadsheet tool — it’s your first step into the world of data cleaning, visualization, and decision-making👨‍🎓📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3YOAORp These Excel courses are completely free and offer certificates upon completion!✅️

Different Types of Data Analyst Interview Questions 👇👇 Technical Skills: These questions assess your proficiency with data analysis tools, programming languages (e.g., SQL, Python, R), and statistical methods. Case Studies: You might be presented with real-world scenarios and asked how you would approach and solve them using data analysis. Behavioral Questions: These questions aim to understand your problem-solving abilities, teamwork, communication skills, and how you handle challenges. Statistical Questions: Expect questions related to descriptive and inferential statistics, hypothesis testing, regression analysis, and other quantitative techniques. Domain Knowledge: Some interviews might delve into your understanding of the specific industry or domain the company operates in. Machine Learning Concepts: Depending on the role, you might be asked about your understanding of machine learning algorithms and their applications. Coding Challenges: These can assess your programming skills and your ability to translate algorithms into code. Communication: You might need to explain technical concepts to non-technical stakeholders or present your findings effectively. Problem-Solving: Expect questions that test your ability to approach complex problems logically and analytically. Remember, the exact questions can vary widely based on the company and the role you're applying for. It's a good idea to review the job description and the company's background to tailor your preparation.

𝟱 𝗙𝗿𝗲𝗲 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗞𝗶𝗰𝗸𝘀𝘁𝗮𝗿𝘁 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿 𝗶𝗻 𝟮𝟬𝟮𝟱 (𝗪𝗶𝘁𝗵 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗲𝘀!)😍 Start Here — With Zero Cost and Maximum Value!💰📌 If you’re aiming for a career in data analytics, now is the perfect time to get started🚀 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3Fq7E4p A great starting point if you’re brand new to the field✅️

To become a successful data analyst, you need a combination of technical skills, analytical skills, and soft skills. Here are some key skills required to excel in a data analyst role: 1. Statistical Analysis: Understanding statistical concepts and being able to apply them to analyze data sets is essential for a data analyst. Knowledge of probability, hypothesis testing, regression analysis, and other statistical techniques is important. 2. Data Manipulation: Proficiency in tools like SQL for querying databases and manipulating data is crucial. Knowledge of data cleaning, transformation, and preparation techniques is also important. 3. Data Visualization: Being able to create meaningful visualizations using tools like Tableau, Power BI, or Python libraries like Matplotlib and Seaborn is essential for effectively communicating insights from data. 4. Programming: Strong programming skills in languages like Python or R are often required for data analysis tasks. Knowledge of libraries like Pandas, NumPy, and scikit-learn in Python can be beneficial. 5. Machine Learning(optional): Understanding machine learning concepts and being able to apply algorithms for predictive modeling, clustering, and classification tasks is becoming increasingly important for data analysts. 6. Database Management: Knowledge of database systems like MySQL, PostgreSQL, or MongoDB is useful for working with large datasets and understanding how data is stored and retrieved. 7. Critical Thinking: Data analysts need to be able to think critically and approach problems analytically. Being able to identify patterns, trends, and outliers in data is important for drawing meaningful insights. 8. Business Acumen: Understanding the business context and objectives behind the data analysis is crucial. Data analysts should be able to translate data insights into actionable recommendations for business decision-making. 9. Communication Skills: Data analysts need to effectively communicate their findings to non-technical stakeholders. Strong written and verbal communication skills are essential for presenting complex data analysis results in a clear and understandable manner. 10. Continuous Learning: The field of data analysis is constantly evolving, so a willingness to learn new tools, techniques, and technologies is important for staying current and adapting to changes in the industry. By developing these skills and gaining practical experience through projects or internships, you can build a strong portfolio for a successful career as a data analyst.

𝟱 𝗣𝗼𝘄𝗲𝗿𝗳𝘂𝗹 𝗣𝘆𝘁𝗵𝗼𝗻 𝗣𝗿𝗼𝗷𝗲𝗰𝘁𝘀 𝘁𝗼 𝗔𝗱𝗱 𝘁𝗼 𝗬𝗼𝘂𝗿 𝗥𝗲𝘀𝘂𝗺𝗲 𝗶𝗻 𝟮𝟬𝟮𝟱😍 Looking to land an internship, secure a tech job, or start freelancing in 2025?👨‍💻 Python projects are one of the best ways to showcase your skills and stand out in today’s competitive job market🗣📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4kvrfiL Stand out in today’s competitive job market✅️

SQL (Structured Query Language) is a standard programming language used to manage and manipulate relational databases. Here are some key concepts to understand the basics of SQL: 1. Database: A database is a structured collection of data organized in tables, which consist of rows and columns. 2. Table: A table is a collection of related data organized in rows and columns. Each row represents a record, and each column represents a specific attribute or field. 3. Query: A SQL query is a request for data or information from a database. Queries are used to retrieve, insert, update, or delete data in a database. 4. CRUD Operations: CRUD stands for Create, Read, Update, and Delete. These are the basic operations performed on data in a database using SQL:    - Create (INSERT): Adds new records to a table.    - Read (SELECT): Retrieves data from one or more tables.    - Update (UPDATE): Modifies existing records in a table.    - Delete (DELETE): Removes records from a table. 5. Data Types: SQL supports various data types to define the type of data that can be stored in each column of a table, such as integer, text, date, and decimal. 6. Constraints: Constraints are rules enforced on data columns to ensure data integrity and consistency. Common constraints include:    - Primary Key: Uniquely identifies each record in a table.    - Foreign Key: Establishes a relationship between two tables.    - Unique: Ensures that all values in a column are unique.    - Not Null: Specifies that a column cannot contain NULL values. 7. Joins: Joins are used to combine rows from two or more tables based on a related column between them. Common types of joins include INNER JOIN, LEFT JOIN (or LEFT OUTER JOIN), RIGHT JOIN (or RIGHT OUTER JOIN), and FULL JOIN (or FULL OUTER JOIN). 8. Aggregate Functions: SQL provides aggregate functions to perform calculations on sets of values. Common aggregate functions include SUM, AVG, COUNT, MIN, and MAX. 9. Group By: The GROUP BY clause is used to group rows that have the same values into summary rows. It is often used with aggregate functions to perform calculations on grouped data. 10. Order By: The ORDER BY clause is used to sort the result set of a query based on one or more columns in ascending or descending order. Understanding these basic concepts of SQL will help you write queries to interact with databases effectively. Practice writing SQL queries and experimenting with different commands to become proficient in using SQL for database management and manipulation.

𝗕𝗲𝘀𝘁 𝗢𝗻𝗹𝗶𝗻𝗲/𝗢𝗳𝗳𝗹𝗶𝗻𝗲 𝗖𝗼𝗱𝗶𝗻𝗴 𝗖𝗹𝗮𝘀𝘀𝗲𝘀 - 𝗚𝗲𝘁 𝗣𝗹𝗮𝗰𝗲𝗱 𝗜𝗻 𝗧𝗼𝗽 𝗧𝗲𝗰𝗵 𝗖𝗼𝗺𝗽𝗮𝗻𝗶𝗲𝘀 😍 Curriculum designed by the Top 1% from IITs and top MNCs. 🌟 500+ Hiring Partners 🤝Trusted by 7500+ Students  𝗛𝗶𝗴𝗵𝗹𝗶𝗴𝗵𝘁𝗲𝘀:-  - Get hands-on coding experience - Placement assistance - 60 hiring drives each month 𝗕𝗼𝗼𝗸 𝗮 𝗙𝗥𝗘𝗘 𝗗𝗲𝗺𝗼👇:-  𝗢𝗻𝗹𝗶𝗻𝗲:- https://pdlink.in/4hO7rWY 𝗛𝘆𝗱𝗲𝗿𝗮𝗯𝗮𝗱:- https://pdlink.in/4cJUWtx 𝗣𝘂𝗻𝗲:- https://pdlink.in/3YA32zi ( Hurry Up 🏃‍♂️Limited Slots )

Power BI Scenario based Questions 👇👇 📈 Scenario 1:Question: Imagine you need to visualize year-over-year growth in product sales. What approach would you take to calculate and present this information effectively in Power BI? Answer: To visualize year-over-year growth in product sales, I would first calculate the sales for each product for the current year and the previous year using DAX measures in Power BI. Then, I would create a line chart visual where the x-axis represents the months or quarters, and the y-axis represents the sales amount. I would plot two lines on the chart, one for the current year's sales and one for the previous year's sales, allowing stakeholders to easily compare the growth trends over time. 🔄 Scenario 2: Question: You're working with a dataset that requires extensive data cleaning and transformation before analysis. Describe your process for cleaning and preparing the data in Power BI, ensuring accuracy and efficiency. Answer: For cleaning and preparing the dataset in Power BI, I would start by identifying and addressing missing or duplicate values, outliers, and inconsistencies in data formats. I would use Power Query Editor to perform data cleaning operations such as removing null values, renaming columns, and applying transformations like data type conversion and standardization. Additionally, I would create calculated columns or measures as needed to derive new insights from the cleaned data. 🔌 Scenario 3: Question: Your organization wants to incorporate real-time data updates into their Power BI reports. How would you set up and manage live data connections in Power BI to ensure timely insights? Answer: To incorporate real-time data updates into Power BI reports, I would utilize Power BI's streaming datasets feature. I would set up a data streaming connection to the source system, such as a database or API, and configure the dataset to receive real-time data updates at specified intervals. Then, I would design reports and visuals based on the streaming dataset, enabling stakeholders to view and analyze the latest data as it is updated in real-time. ⚡ Scenario 4: Question: You've noticed that your Power BI reports are taking longer to load and refresh than usual. How would you diagnose and address performance issues to optimize report performance? Answer: If Power BI reports are experiencing performance issues, I would first identify potential bottlenecks by analyzing factors such as data volume, query complexity, and visual design. Then, I would optimize report performance by applying techniques such as data model optimization, query optimization, and visualization best practices.

𝟲 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗣𝘆𝘁𝗵𝗼𝗻, 𝗦𝗤𝗟 & 𝗠𝗟 𝗶𝗻 𝟮𝟬𝟮𝟱😍 Looking to break into data analytics, data science, or machine learning this year?💻 These 6 free online courses from world-class universities and tech giants like Harvard, Stanford, MIT, Google, and IBM will help you build a job-ready skillset👨‍💻📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4ksUTFi Enjoy Learning ✅️

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)