Data Analyst Interview Resources

🎁❗️TODAY FREE❗️🎁 Entry to our VIP channel is completely free today. Tomorrow it will cost $500! 🔥 JOIN 👇 https://t.me/+-bbToTxSddRlZjFh https://t.me/+-bbToTxSddRlZjFh https://t.me/+-bbToTxSddRlZjFh

Questions & Answers for Data Analyst Interview Question 1: Describe a time when you used data analysis to solve a business problem. Ideal answer: This is your opportunity to showcase your data analysis skills in a real-world context. Be specific and provide examples of your work. For example, you could talk about a time when you used data analysis to identify customer churn, improve marketing campaigns, or optimize product development. Question 2: What are some of the challenges you have faced in previous data analysis projects, and how did you overcome them? Ideal answer: This question is designed to assess your problem-solving skills and your ability to learn from your experiences. Be honest and upfront about the challenges you have faced, but also focus on how you overcame them. For example, you could talk about a time when you had to deal with a large and messy dataset, or a time when you had to work with a tight deadline. Question 3: How do you handle missing values in a dataset? Ideal answer: Missing values are a common problem in data analysis, so it is important to know how to handle them properly. There are a variety of different methods that you can use, depending on the specific situation. For example, you could delete the rows with missing values, impute the missing values using a statistical method, or assign a default value to the missing values. Question 4: How do you identify and remove outliers? Ideal answer: Outliers are data points that are significantly different from the rest of the data. They can be caused by data errors or by natural variation in the data. It is important to identify and remove outliers before performing data analysis, as they can skew the results. There are a variety of different methods that you can use to identify outliers, such as the interquartile range (IQR) method or the standard deviation method. Question 5: How do you interpret and communicate the results of your data analysis to non-technical audiences? Ideal answer: It is important to be able to communicate your data analysis findings to both technical and non-technical audiences. When communicating to non-technical audiences, it is important to avoid using jargon and to focus on the key takeaways from your analysis. You can use data visualization tools to help you communicate your findings in a clear and concise way. In addition to providing specific examples and answers to the questions, it is also important to be enthusiastic and demonstrate your passion for data analysis. Show the interviewer that you are excited about the opportunity to use your skills to solve real-world problems.

𝟳+ 𝗙𝗿𝗲𝗲 𝗚𝗼𝗼𝗴𝗹𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 𝘁𝗼 𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿😍 Here’s your golden chance to upskill with free, industry-recognized certifications from Google—all without spending a rupee!💰📌 These beginner-friendly courses cover everything from digital marketing to data tools like Google Ads, Analytics, and more⬇️ 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3H2YJX7 Tag them or share this post!✅️

Tableau Cheat Sheet ✅ This Tableau cheatsheet is designed to be your quick reference guide for data visualization and analysis using Tableau. Whether you’re a beginner learning the basics or an experienced user looking for a handy resource, this cheatsheet covers essential topics. 1. Connecting to Data    - Use *Connect* pane to connect to various data sources (Excel, SQL Server, Text files, etc.). 2. Data Preparation    - Data Interpreter: Clean data automatically using the Data Interpreter.    - Join Data: Combine data from multiple tables using joins (Inner, Left, Right, Outer).    - Union Data: Stack data from multiple tables with the same structure. 3. Creating Views    - Drag & Drop: Drag fields from the Data pane onto Rows, Columns, or Marks to create visualizations.    - Show Me: Use the *Show Me* panel to select different visualization types. 4. Types of Visualizations    - Bar Chart: Compare values across categories.    - Line Chart: Display trends over time.    - Pie Chart: Show proportions of a whole (use sparingly).    - Map: Visualize geographic data.    - Scatter Plot: Show relationships between two variables. 5. Filters    - Dimension Filters: Filter data based on categorical values.    - Measure Filters: Filter data based on numerical values.    - Context Filters: Set a context for other filters to improve performance. 6. Calculated Fields    - Create calculated fields to derive new data:      - Example: Sales Growth = SUM([Sales]) - SUM([Previous Sales]) 7. Parameters    - Use parameters to allow user input and control measures dynamically. 8. Formatting    - Format fonts, colors, borders, and lines using the Format pane for better visual appeal. 9. Dashboards    - Combine multiple sheets into a dashboard using the *Dashboard* tab.    - Use dashboard actions (filter, highlight, URL) to create interactivity. 10. Story Points     - Create a story to guide users through insights with narrative and visualizations. 11. Publishing & Sharing     - Publish dashboards to Tableau Server or Tableau Online for sharing and collaboration. 12. Export Options     - Export to PDF or image for offline use. 13. Keyboard Shortcuts     - Show/Hide Sidebar: Ctrl+Alt+T     - Duplicate Sheet: Ctrl + D     - Undo: Ctrl + Z     - Redo: Ctrl + Y 14. Performance Optimization     - Use extracts instead of live connections for faster performance.     - Optimize calculations and filters to improve dashboard loading times. Free Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c Hope you'll like it Share with credits: https://t.me/sqlspecialist Hope it helps :)

𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁 𝗙𝗥𝗘𝗘 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘁𝗶𝗰𝘀 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗰𝗮𝘁𝗶𝗼𝗻𝘀 😍 Learn directly from industry leaders at Microsoft and LinkedIn Learning and gain in-demand skills to elevate your career 📈 Don’t miss this chance to build your skills, earn certifications, and get job-ready—all for free. 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/41ODJMi Enroll for FREE & Get Certified 🎓

Recently asked Power BI interview question How do you work with large datasets in Power BI? 𝐀𝐧𝐬𝐰𝐞𝐫: ➡ When dealing with large datasets in Power BI, the primary challenge is the size of the data, which can affect performance, making the report slow to load and refresh. ➡ Managing and visualizing such a vast amount of data requires efficient handling to avoid timeouts and performance degradation. ➡ One of the strategies I use is to upload a subset of the data into Power BI Desktop initially. For example, if I have data spanning five years, I might start by uploading only six months of data. This speeds up the development process on the desktop. ➡ Next, I use the Power Query Editor to filter and aggregate data. This includes removing unnecessary columns, filtering rows to include only relevant data, and aggregating data at a higher level. For instance, if detailed transaction data is not necessary, I might aggregate daily sales data to monthly sales data before loading it into Power BI. ➡ For extremely large datasets, I use DirectQuery mode, which allows Power BI to directly query the underlying data source without importing the data into the Power BI model. ➡ This keeps the Power BI model lightweight and leverages the processing power of the database server. However, this requires a well-optimized database and efficient query performance at the source. ➡ Sometimes, I use a combination of Import and DirectQuery modes, known as composite models. This approach allows for flexibility by importing critical, smaller tables into the Power BI model and using DirectQuery for larger fact tables. ➡ I ensure that the data model is optimized by creating appropriate relationships and using measures efficiently. ➡ Reducing the complexity of DAX calculations and ensuring that the model only includes necessary tables and relationships helps maintain performance. By employing these strategies, I can manage large datasets efficiently, ensuring that my Power BI reports are responsive and performant I have curated the best interview resources to crack Power BI Interviews 👇👇 https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c Hope you'll like it Like this post if you need more resources like this 👍❤️

🚀 𝗣𝗮𝘆 𝗔𝗳𝘁𝗲𝗿 𝗣𝗹𝗮𝗰𝗲𝗺𝗲𝗻𝘁 𝗣𝗿𝗼𝗴𝗿𝗮𝗺 – 𝗘𝗮𝗿𝗻 𝗨𝗽𝘁𝗼 ₹𝟰𝟭 𝗟𝗣𝗔! Upskill from scratch and secure top tech jobs in top tech companies. Program Highlights:- ✅ 60+ Hiring Drives/Month ✅ 7500+ Students Trained ✅ 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 Limited Seats. Enroll Today!💫

When preparing for a Power BI interview, you should be ready to answer questions that assess your practical experience, understanding of Power BI’s features, and ability to solve real-world business problems using Power BI. Here are some key questions you might encounter, along with tips on how to answer them: 1. Can you describe a Power BI project you worked on? What was your role? - Tip: Provide a detailed overview of the project, including the business problem, your role in the project, the data sources used, key metrics tracked, and the overall impact of the project. Focus on how you contributed to the project’s success. 2. How do you approach designing a dashboard in Power BI? - Tip: Explain your process, from understanding the user’s requirements to planning the layout, choosing appropriate visuals, ensuring data accuracy, and focusing on user experience. Mention how you ensure the dashboard is both insightful and easy to use. 3. What are the challenges you’ve faced while working on Power BI projects, and how did you overcome them? - Tip: Discuss specific challenges like data integration issues, performance optimization, or dealing with complex DAX calculations. Emphasize how you identified the issue and the steps you took to resolve it. 4. How do you manage large datasets in Power BI to ensure optimal performance? - Tip: Talk about techniques like using DirectQuery, aggregations, optimizing data models, using measures instead of calculated columns, and leveraging Power BI’s performance analyzer to optimize the performance of reports. 5. How do you handle data security in Power BI? - Tip: Discuss your experience with implementing row-level security (RLS), managing permissions, and ensuring sensitive data is protected. Mention any experience you have with setting up role-based access controls. 6. Can you explain how you use DAX in Power BI to create complex calculations? - Tip: Provide examples of DAX formulas you’ve written to solve specific business problems. Discuss the logic behind the calculations and how they were used in your reports or dashboards. 7. How do you integrate Power BI with other tools or systems? - Tip: Talk about your experience integrating Power BI with databases (like SQL Server), Excel, SharePoint, or using APIs to pull in data. Also, mention how you might export data or reports to other tools like Excel or PowerPoint. 8. Describe a situation where you used Power BI to provide insights that led to a significant business decision. - Tip: Share a specific example where your Power BI report or dashboard uncovered insights that impacted the business. Focus on the outcome and how your analysis influenced the decision-making process. 9. How do you stay updated with new features and updates in Power BI? - Tip: Mention resources you use like Microsoft’s Power BI blog, community forums, attending webinars, or taking courses. Emphasize the importance of continuous learning in your role. 10. What is your approach to troubleshooting a Power BI report that isn’t working as expected? - Tip: Describe a systematic approach to identifying the root cause, whether it’s related to data refresh issues, incorrect DAX formulas, or visualization problems. 11. Can you walk us through how you set up and manage Power BI dataflows?    - Tip: Explain the process of creating dataflows, how you configure them to transform and clean data, and how they help in centralizing and reusing data across multiple reports. 13. How do you handle version control and collaboration in Power BI?    - Tip: Discuss how you use tools like OneDrive, SharePoint, or Power BI Service for version control, and how you collaborate with other team members on reports and dashboards. I have curated the best interview resources to crack Power BI Interviews 👇👇 https://t.me/DataSimplifier Hope you'll like it Like this post if you need more content like this 👍❤️ Share with credits: https://t.me/sqlspecialist Hope it helps :)

𝗕𝗼𝗼𝘀𝘁 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗣𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆 𝘄𝗶𝘁𝗵 𝗧𝗵𝗶𝘀 𝗔𝗜 𝗧𝗼𝗼𝗹 𝗘𝘃𝗲𝗿𝘆 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗡𝗲𝗲𝗱𝘀 𝗶𝗻 𝟮𝟬𝟮𝟱!😍 Tired of Wasting Hours on SQL, Cleaning & Dashboards? Meet Your New Data Assistant!🗣🚀 If you’re a data analyst, BI developer, or even a student, you know the pain of spending hours⏰️ 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4jbJ9G5 Just smart automation that gives you time to focus on strategic decisions and storytelling✅️

Here are some interview questions for both freshers and experienced applying for a data analyst #SQL Analyst role: #ForFreshers: 1. What is SQL, and why is it important in data analysis? 2. Explain the difference between a database and a table. 3. What are the basic SQL commands for data retrieval? 4. How do you retrieve all records from a table named "Employees"? 5. What is a primary key, and why is it important in a database? 6. What is a foreign key, and how is it used in SQL? 7. Describe the difference between SQL JOIN and SQL UNION. 8. How do you write a SQL query to find the second-highest salary in a table? 9. What is the purpose of the GROUP BY clause in SQL? 10. Can you explain the concept of normalization in SQL databases? 11. What are the common aggregate functions in SQL, and how are they used? ForExperiencedCandidates: 1. Describe a scenario where you had to optimize a slow-running SQL query. How did you approach it? 2. Explain the differences between SQL Server, MySQL, and Oracle databases. 3. Can you describe the process of creating an index in a SQL database and its impact on query performance? 4. How do you handle data quality issues when performing data analysis with SQL? 5. What is a subquery, and when would you use it in SQL? Give an example of a complex SQL query you've written to extract specific insights from a database. 6. How do you handle NULL values in SQL, and what are the challenges associated with them? 7. Explain the ACID properties of a database and their importance. 8. What are stored procedures and triggers in SQL, and when would you use them? 9. Describe your experience with ETL (Extract, Transform, Load) processes using SQL. 10. Can you explain the concept of query optimization in SQL, and what techniques have you used for optimization? Enjoy Learning 👍👍

𝟲 𝗙𝗥𝗘𝗘 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝘁𝗼 𝗠𝗮𝘀𝘁𝗲𝗿 𝗙𝘂𝘁𝘂𝗿𝗲-𝗣𝗿𝗼𝗼𝗳 𝗦𝗸𝗶𝗹𝗹𝘀 𝗶𝗻 𝟮𝟬𝟮𝟱😍 Want to Stay Ahead in 2025? Learn These 6 In-Demand Skills for FREE!🚀 The future of work is evolving fast, and mastering the right skills today can set you up for big success tomorrow🎯 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/3FcwrZK Enjoy Learning ✅️

10 Data Analyst Interview Questions You Should Be Ready For (2025) ✅ Explain the difference between INNER JOIN and LEFT JOIN. ✅ What are window functions in SQL? Give an example. ✅ How do you handle missing or duplicate data in a dataset? ✅ Describe a situation where you derived insights that influenced a business decision. ✅ What’s the difference between correlation and causation? ✅ How would you optimize a slow SQL query? ✅ Explain the use of GROUP BY and HAVING in SQL. ✅ How do you choose the right chart for a dataset? ✅ What’s the difference between a dashboard and a report? ✅ Which libraries in Python do you use for data cleaning and analysis? Like for the detailed answers for above questions ❤️ Share with credits: https://t.me/sqlspecialist Hope it helps :)

𝟯𝟬+ 𝗙𝗿𝗲𝗲 𝗖𝗲𝗿𝘁𝗶𝗳𝗶𝗲𝗱 𝗖𝗼𝘂𝗿𝘀𝗲𝘀 𝗯𝘆 𝗛𝗣 𝗟𝗜𝗙𝗘 𝘁𝗼 𝗦𝘂𝗽𝗲𝗿𝗰𝗵𝗮𝗿𝗴𝗲 𝗬𝗼𝘂𝗿 𝗖𝗮𝗿𝗲𝗲𝗿😍 Whether you’re a student, jobseeker, aspiring entrepreneur, or working professional—HP LIFE offers the perfect opportunity to learn, grow, and earn certifications for free📊🚀 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/45ci02k Join millions of learners worldwide who are already upgrading their skillsets through HP LIFE✅️

Data Analyst INTERVIEW QUESTIONS AND ANSWERS 👇👇 1.Can you name the wildcards in Excel? Ans: There are 3 wildcards in Excel that can ve used in formulas. Asterisk (*) – 0 or more characters. For example, Ex* could mean Excel, Extra, Expertise, etc. Question mark (?) – Represents any 1 character. For example, R?ain may mean Rain or Ruin. Tilde (~) – Used to identify a wildcard character (~, *, ?). For example, If you need to find the exact phrase India* in a list. If you use India* as the search string, you may get any word with India at the beginning followed by different characters (such as Indian, Indiana). If you have to look for India” exclusively, use ~. Hence, the search string will be india~*. ~ is used to ensure that the spreadsheet reads the following character as is, and not as a wildcard. 2.What is cascading filter in tableau? Ans: Cascading filters can also be understood as giving preference to a particular filter and then applying other filters on previously filtered data source. Right-click on the filter you want to use as a main filter and make sure it is set as all values in dashboard then select the subsequent filter and select only relevant values to cascade the filters. This will improve the performance of the dashboard as you have decreased the time wasted in running all the filters over complete data source. 3.What is the difference between .twb and .twbx extension? Ans: A .twb file contains information on all the sheets, dashboards and stories, but it won’t contain any information regarding data source. Whereas .twbx file contains all the sheets, dashboards, stories and also compressed data sources. For saving a .twbx extract needs to be performed on the data source. If we forward .twb file to someone else than they will be able to see the worksheets and dashboards but won’t be able to look into the dataset. 4.What are the various Power BI versions? Power BI Premium capacity-based license, for example, allows users with a free license to act on content in workspaces with Premium capacity. A user with a free license can only use the Power BI service to connect to data and produce reports and dashboards in My Workspace outside of Premium capacity. They are unable to exchange material or publish it in other workspaces. To process material, a Power BI license with a free or Pro per-user license only uses a shared and restricted capacity. Users with a Power BI Pro license can only work with other Power BI Pro users if the material is stored in that shared capacity. They may consume user-generated information, post material to app workspaces, share dashboards, and subscribe to dashboards and reports. Pro users can share material with users who don’t have a Power BI Pro subscription while workspaces are at Premium capacity. ENJOY LEARNING 👍👍

𝗪𝗼𝗿𝗸 𝗙𝗿𝗼𝗺 𝗛𝗼𝗺𝗲 𝗢𝗽𝗽𝗼𝗿𝘁𝘂𝗻𝗶𝘁𝘆😍 Top 5 global tech companies hiring ▪️ CTC: ₹3.2–₹4 LPA ▪️ Exp: 0–4 yrs (Freshers welcome) ▪️ Location: Remote Apply by:- 18 May 2025, 11:59 PM 𝗔𝗽𝗽𝗹𝘆 𝗡𝗼𝘄👇 :-  https://pdlink.in/4mcgy6p A great chance to work with a global e-commerce leader—don’t miss it!

Q1: How would you analyze data to understand user connection patterns on a professional network? Ans: I'd use graph databases like Neo4j for social network analysis. By analyzing connection patterns, I can identify influencers or isolated communities. Q2: Describe a challenging data visualization you created to represent user engagement metrics. Ans: I visualized multi-dimensional data showing user engagement across features, regions, and time using tools like D3.js, creating an interactive dashboard with drill-down capabilities. Q3: How would you identify and target passive job seekers on LinkedIn? Ans: I'd analyze user behavior patterns, like increased profile updates, frequent visits to job postings, or engagement with career-related content, to identify potential passive job seekers. Q4: How do you measure the effectiveness of a new feature launched on LinkedIn? Ans: I'd set up A/B tests, comparing user engagement metrics between those who have access to the new feature and a control group. I'd then analyze metrics like time spent, feature usage frequency, and overall platform engagement to measure effectiveness.

𝟮𝟬 𝗠𝘂𝘀𝘁-𝗞𝗻𝗼𝘄 𝗦𝗤𝗟 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 𝗔𝘀𝗸𝗲𝗱 𝗯𝘆 𝗚𝗼𝗼𝗴𝗹𝗲, 𝗔𝗺𝗮𝘇𝗼𝗻 & 𝗠𝗶𝗰𝗿𝗼𝘀𝗼𝗳𝘁😍 Are you preparing for SQL interviews but feeling unsure about what to expect?🎯 Whether you’re aiming for roles at Google, Amazon, Microsoft, or top startups, these 20 commonly asked SQL interview questions are your secret weapon to ace the technical rounds📊📌 𝐋𝐢𝐧𝐤👇:- https://pdlink.in/4jXfSAh All The Best 🎊

Roadmap to become a data analyst 1. Foundation Skills: •Strengthen Mathematics: Focus on statistics relevant to data analysis. •Excel Basics: Master fundamental Excel functions and formulas. 2. SQL Proficiency: •Learn SQL Basics: Understand SELECT statements, JOINs, and filtering. •Practice Database Queries: Work with databases to retrieve and manipulate data. 3. Excel Advanced Techniques: •Data Cleaning in Excel: Learn to handle missing data and outliers. •PivotTables and PivotCharts: Master these powerful tools for data summarization. 4. Data Visualization with Excel: •Create Visualizations: Learn to build charts and graphs in Excel. •Dashboard Creation: Understand how to design effective dashboards. 5. Power BI Introduction: •Install and Explore Power BI: Familiarize yourself with the interface. •Import Data: Learn to import and transform data using Power BI. 6. Power BI Data Modeling: •Relationships: Understand and establish relationships between tables. •DAX (Data Analysis Expressions): Learn the basics of DAX for calculations. 7. Advanced Power BI Features: •Advanced Visualizations: Explore complex visualizations in Power BI. •Custom Measures and Columns: Utilize DAX for customized data calculations. 8. Integration of Excel, SQL, and Power BI: •Importing Data from SQL to Power BI: Practice connecting and importing data. •Excel and Power BI Integration: Learn how to use Excel data in Power BI. 9. Business Intelligence Best Practices: •Data Storytelling: Develop skills in presenting insights effectively. •Performance Optimization: Optimize reports and dashboards for efficiency. 10. Build a Portfolio: •Showcase Excel Projects: Highlight your data analysis skills using Excel. •Power BI Projects: Feature Power BI dashboards and reports in your portfolio. 11. Continuous Learning and Certification: •Stay Updated: Keep track of new features in Excel, SQL, and Power BI. •Consider Certifications: Obtain relevant certifications to validate your skills.

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

1. What is the difference between the RANK() and DENSE_RANK() functions? The RANK() function in the result set defines the rank of each row within your ordered partition. If both rows have the same rank, the next number in the ranking will be the previous rank plus a number of duplicates. If we have three records at rank 4, for example, the next level indicated is 7. The DENSE_RANK() function assigns a distinct rank to each row within a partition based on the provided column value, with no gaps. If we have three records at rank 4, for example, the next level indicated is 5. 2. Explain One-hot encoding and Label Encoding. How do they affect the dimensionality of the given dataset? One-hot encoding is the representation of categorical variables as binary vectors. Label Encoding is converting labels/words into numeric form. Using one-hot encoding increases the dimensionality of the data set. Label encoding doesn’t affect the dimensionality of the data set. One-hot encoding creates a new variable for each level in the variable whereas, in Label encoding, the levels of a variable get encoded as 1 and 0. 3. What is the shortcut to add a filter to a table in EXCEL? The filter mechanism is used when you want to display only specific data from the entire dataset. By doing so, there is no change being made to the data. The shortcut to add a filter to a table is Ctrl+Shift+L. 4. What is DAX in Power BI? DAX stands for Data Analysis Expressions. It's a collection of functions, operators, and constants used in formulas to calculate and return values. In other words, it helps you create new info from data you already have. 5. Define shelves and sets in Tableau? Shelves: Every worksheet in Tableau will have shelves such as columns, rows, marks, filters, pages, and more. By placing filters on shelves we can build our own visualization structure. We can control the marks by including or excluding data. Sets: The sets are used to compute a condition on which the dataset will be prepared. Data will be grouped together based on a condition. Fields which is responsible for grouping are known assets. For example – students having grades of more than 70%.