1. List the different types of relationships in SQL.

One-to-One - This can be defined as the relationship between two tables where each record in one table is associated with the maximum of one record in the other table.
One-to-Many & Many-to-One - This is the most commonly used relationship where a record in a table is associated with multiple records in the other table.
Many-to-Many - This is used in cases when multiple instances on both sides are needed for defining a relationship.
Self-Referencing Relationships - This is used when a table needs to define a relationship with itself.

2. What are the different views available in Power BI Desktop?

There are three different views in Power BI, each of which serves another purpose:
Report View - In this view, users can add visualizations and additional report pages and publish the same on the portal.
Data View - In this view, data shaping can be performed using Query Editor tools.
Model View - In this view, users can manage relationships between complex datasets.


3. What are macros in Excel?

Excel allows you to automate the tasks you do regularly by recording them into macros. So, a macro is an action or a set of them that you can perform n number of times. For example, if you have to record the sales of each item at the end of the day, you can create a macro that will automatically calculate the sales, profits, loss, etc and use the same for the future instead of manually calculating it every day.

Here's Part 3 of the phone interview series for data analysts:

𝐃𝐞𝐬𝐜𝐫𝐢𝐛𝐞 𝐲𝐨𝐮𝐫 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐟𝐨𝐫 𝐬𝐨𝐥𝐯𝐢𝐧𝐠 𝐚 𝐝𝐚𝐭𝐚 𝐚𝐧𝐚𝐥𝐲𝐬𝐢𝐬 𝐩𝐫𝐨𝐛𝐥𝐞𝐦.

𝐇𝐑: [Your Name], can you describe your process for solving a data analysis problem?

[Your Name]: Certainly! When approaching a data analysis problem, I typically follow a structured process that involves several key steps:

1. Understanding the Problem: The first step is to clearly understand the problem at hand. I make sure to define the objectives and identify the key questions that need to be answered. This often involves communicating with stakeholders to ensure we're aligned on the goals.

2. Data Collection: Once the problem is defined, I gather the necessary data. This could involve extracting data from databases, collecting data from various sources, or working with existing datasets. Ensuring data quality is crucial at this stage.

3. Data Cleaning: Data often comes with inconsistencies, missing values, or errors. I spend time cleaning the data to ensure it's accurate and reliable. This step involves handling missing data, removing duplicates, and correcting errors.

4. Exploratory Data Analysis (EDA): After cleaning the data, I perform exploratory data analysis to uncover initial insights and patterns. This involves visualizing the data, calculating summary statistics, and identifying any outliers or trends.

5. Data Modeling: Depending on the problem, I might apply statistical models or machine learning algorithms to analyze the data. This step involves selecting the appropriate model, training it on the data, and evaluating its performance.

6. Interpretation and Presentation: Once the analysis is complete, I interpret the results and draw meaningful conclusions. I create visualizations and reports to present the findings in a clear and concise manner, making sure to tailor the presentation to the audience.

7. Recommendations and Actionable Insights: Finally, I provide recommendations based on the analysis. The goal is to offer actionable insights that can help the stakeholders make informed decisions.

𝐇𝐑: That's a comprehensive process. Can you give me an example of a project where you applied this process?

[Your Name]: Sure! During my internship at [Internship Company], I worked on a project to analyze customer purchase behavior. We aimed to identify patterns and trends to help the marketing team develop targeted campaigns.

𝐇𝐑: Can you walk me through how you applied each step to that project?

[Your Name]: Absolutely. First, I met with the marketing team to understand their objectives and the specific questions they had. We defined our goals as identifying key customer segments and their purchasing habits.

Next, I collected data from the company's CRM and sales databases. The data was then cleaned to remove duplicates and correct any inconsistencies.

During the exploratory data analysis, I used visualizations to identify initial trends and patterns. For example, I discovered that certain customer segments had distinct purchasing patterns during different seasons.

I then applied clustering algorithms to segment the customers based on their behavior. This helped us identify distinct groups with unique characteristics.

The results were presented to the marketing team using dashboards and visualizations created in Tableau. I highlighted the key findings and provided actionable recommendations for targeted marketing campaigns.

𝐇𝐑: That's an excellent example. It sounds like you have a solid approach to tackling data analysis problems.

[Your Name]: Thank you! I believe a structured process is essential to ensure thorough and accurate analysis.

Share with credits: https://t.iss.one/jobs_SQL

Like this post if you want me to continue this 👍❤️

Netflix Analytics Engineer Interview Question (SQL) 🚀
---

### Scenario Overview
Netflix wants to analyze user engagement with their platform. Imagine you have a table called netflix_data with the following columns:
- user_id: Unique identifier for each user
- subscription_plan: Type of subscription (e.g., Basic, Standard, Premium)
- genre: Genre of the content the user watched (e.g., Drama, Comedy, Action)
- timestamp: Date and time when the user watched a show
- watch_duration: Length of time (in minutes) a user spent watching
- country: User’s country

The main objective is to figure out how to get insights into user behavior, such as which genres are most popular or how watch duration varies across subscription plans.

---

### Typical Interview Question

> “Using the netflix_data table, find the top 3 genres by average watch duration in each subscription plan, and return both the genre and the average watch duration.”

This question tests your ability to:
1. Filter or group data by subscription plan.
2. Calculate average watch duration within each group.
3. Sort results to find the “top 3” within each group.
4. Handle tie situations or edge cases (e.g., if there are fewer than 3 genres).

---

### Step-by-Step Approach

1. Group and Aggregate
Use the GROUP BY clause to group by subscription_plan and genre. Then, use an aggregate function like AVG(watch_duration) to get the average watch time for each combination.

2. Rank Genres
You can utilize a window function—commonly ROW_NUMBER() or RANK()—to assign a ranking to each genre within its subscription plan, based on the average watch duration. For example:

   AVG(watch_duration) OVER (PARTITION BY subscription_plan ORDER BY AVG(watch_duration) DESC)
   

(Note that in many SQL dialects, you’ll need a subquery because you can’t directly apply an aggregate in the ORDER BY of a window function.)

3. Select Top 3
After ranking rows in each partition (i.e., subscription plan), pick only the top 3 by watch duration. This could look like:

   SELECT subscription_plan,
          genre,
          avg_watch_duration
   FROM (
       SELECT subscription_plan,
              genre,
              AVG(watch_duration) AS avg_watch_duration,
              ROW_NUMBER() OVER (
                  PARTITION BY subscription_plan 
                  ORDER BY AVG(watch_duration) DESC
              ) AS rn
       FROM netflix_data
       GROUP BY subscription_plan, genre
   ) ranked
   WHERE rn <= 3;
   

4. Validate Results
- Make sure each subscription plan returns up to 3 genres.
- Check for potential ties. Depending on the question, you might use RANK() or DENSE_RANK() to handle ties differently.
- Confirm the data type and units for watch_duration (minutes, seconds, etc.).

---

### Key Takeaways
- Window Functions: Essential for ranking or partitioning data.
- Aggregations & Grouping: A foundational concept for Analytics Engineers.
- Data Validation: Always confirm you’re interpreting columns (like watch_duration) correctly.

By mastering these techniques, you’ll be better prepared for SQL interview questions that delve into real-world scenarios—especially at a data-driven company like Netflix.

Quick Power BI Dax Revision

1. Measures: Measures in DAX are calculations that are used in Power BI to perform aggregations, calculations, and comparisons on data. They are defined using the DEFINE MEASURE or CALCULATE functions.

2. Calculated Columns: Calculated columns are columns that are created in a table by using DAX expressions. They are calculated row by row when the data is loaded into the model.

3. DAX Functions: DAX provides a wide range of functions for data manipulation and calculation. Some common functions include SUM, AVERAGE, COUNT, FILTER, CALCULATE, RELATED, ALL, ALLEXCEPT, and many more.

4. Context: DAX calculations are performed within a context, which can be row context or filter context. Understanding how context works is crucial for writing accurate DAX expressions.

5. Relationships: Power BI data models are built on relationships between tables. DAX expressions can leverage these relationships to perform calculations across related tables.

6. Time Intelligence Functions: DAX includes a set of time intelligence functions that enable you to perform calculations based on dates and time periods. Examples include TOTALYTD, SAMEPERIODLASTYEAR, DATESBETWEEN, etc.

7. Variables: DAX allows you to declare and use variables within expressions to improve readability and performance of complex calculations.

8. Aggregation Functions: DAX provides aggregation functions like SUMX, AVERAGEX, COUNTX that allow you to iterate over a table and perform aggregations based on specified conditions.

9. Logical Functions: DAX includes logical functions such as IF, AND, OR, SWITCH that help in implementing conditional logic within calculations.

10. Error Handling: DAX provides functions like ISBLANK, IFERROR, BLANK, etc., for handling errors and missing data in calculations.

React ❤️ for more quick recaps

Power BI Resources: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c

Complete SQL Topics for Data Analysts 😄👇

1. Introduction to SQL:
- Basic syntax and structure
- Understanding databases and tables

2. Querying Data:
- SELECT statement
- Filtering data using WHERE clause
- Sorting data with ORDER BY

3. Joins:
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- Combining data from multiple tables

4. Aggregation Functions:
- GROUP BY
- Aggregate functions like COUNT, SUM, AVG, MAX, MIN

5. Subqueries:
- Using subqueries in SELECT, WHERE, and HAVING clauses

6. Data Modification:
- INSERT, UPDATE, DELETE statements
- Transactions and Rollback

7. Data Types and Constraints:
- Understanding various data types (e.g., INT, VARCHAR)
- Using constraints (e.g., PRIMARY KEY, FOREIGN KEY)

8. Indexes:
- Creating and managing indexes for performance optimization

9. Views:
- Creating and using views for simplified querying

10. Stored Procedures and Functions:
- Writing and executing stored procedures
- Creating and using functions

11. Normalization:
- Understanding database normalization concepts

12. Data Import and Export:
- Importing and exporting data using SQL

13. Window Functions:
- ROW_NUMBER(), RANK(), DENSE_RANK(), and others

14. Advanced Filtering:
- Using CASE statements for conditional logic

15. Advanced Join Techniques:
- Self-joins and other advanced join scenarios

16. Analytical Functions:
- LAG(), LEAD(), OVER() for advanced analytics

17. Working with Dates and Times:
- Date and time functions and formatting

18. Performance Tuning:
- Query optimization strategies

19. Security:
- Understanding SQL injection and best practices for security

20. Handling NULL Values:
- Dealing with NULL values in queries

Ensure hands-on practice on these topics to strengthen your SQL skills.

Since SQL is one of the most essential skill for data analysts, I have decided to teach each topic daily in this channel for free. Like this post if you want me to continue this SQL series 👍♥️

Share with credits: https://t.iss.one/sqlspecialist

Hope it helps :)

Here's Part 4 of the phone interview series for data analysts:

𝐂𝐚𝐧 𝐲𝐨𝐮 𝐝𝐞𝐬𝐜𝐫𝐢𝐛𝐞 𝐚 𝐭𝐢𝐦𝐞 𝐰𝐡𝐞𝐧 𝐲𝐨𝐮 𝐟𝐚𝐜𝐞𝐝 𝐚 𝐜𝐡𝐚𝐥𝐥𝐞𝐧𝐠𝐞 𝐢𝐧 𝐚𝐧𝐚𝐥𝐲𝐳𝐢𝐧𝐠 𝐝𝐚𝐭𝐚 𝐚𝐧𝐝 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐨𝐯𝐞𝐫𝐜𝐚𝐦𝐞 𝐢𝐭?

𝐇𝐑: [Your Name], can you describe a time when you faced a challenge in analyzing data and how you overcame it?

[Your Name]: Certainly. One challenging situation I encountered was during my internship at [Internship Company]. I was tasked with analyzing sales data to forecast future sales trends, but the data we had was incomplete and contained numerous inconsistencies.

𝐇𝐑: That sounds difficult. How did you approach this challenge?

[Your Name]: First, I conducted a thorough assessment of the data to understand the extent of the issues. I identified gaps, missing values, and inconsistencies. Realizing that the data needed significant cleaning, I developed a plan to address these issues systematically.

𝐇𝐑: What specific steps did you take to clean and prepare the data?

[Your Name]: I started by addressing the missing values. For numerical data, I used imputation techniques such as mean or median imputation where appropriate. For categorical data, I used the most frequent category or created a new category for missing values. I also removed any duplicate entries and corrected errors based on cross-references with other data sources.

To ensure the cleaned data was reliable, I performed data validation checks. This involved verifying the consistency of the data across different time periods and segments. I also consulted with the sales team to understand any anomalies and incorporate their insights into the data cleaning process.

𝐇𝐑: Once the data was cleaned, how did you proceed with the analysis?

[Your Name]: With the cleaned data, I conducted exploratory data analysis to identify trends and patterns. I used statistical techniques to smooth out short-term fluctuations and highlight long-term trends.

For the sales forecasting, I applied time series analysis techniques such as ARIMA (AutoRegressive Integrated Moving Average) models. I split the data into training and testing sets to validate the model’s accuracy. After fine-tuning the model, I was able to generate reliable forecasts for future sales trends.

𝐇𝐑: How did you present your findings and ensure they were actionable?

[Your Name]: I created a detailed report and a set of interactive dashboards using Tableau. These visualizations highlighted key trends, forecasted sales figures, and potential growth areas. I also included a section on the data cleaning process and the assumptions made during the analysis to provide full transparency.

I presented the findings to the sales team and senior management. During the presentation, I emphasized the implications of the forecast and offered recommendations based on the analysis. The clear visualization and actionable insights helped the team make informed decisions on inventory management and marketing strategies.

𝐇𝐑: That’s an impressive way to handle a challenging situation. It seems like your structured approach and attention to detail were crucial.

[Your Name]: Thank you! I believe that thorough data preparation and clear communication are key to overcoming challenges in data analysis.

Share with credits: https://t.iss.one/jobs_SQL

Like this post if you want me to continue this 👍❤️

Python Programming Interview Questions for Entry Level Data Analyst

1. What is Python, and why is it popular in data analysis?

2. Differentiate between Python 2 and Python 3.

3. Explain the importance of libraries like NumPy and Pandas in data analysis.

4. How do you read and write data from/to files using Python?

5. Discuss the role of Matplotlib and Seaborn in data visualization with Python.

6. What are list comprehensions, and how do you use them in Python?

7. Explain the concept of object-oriented programming (OOP) in Python.


8. Discuss the significance of libraries like SciPy and Scikit-learn in data analysis.

9. How do you handle missing or NaN values in a DataFrame using Pandas?

10. Explain the difference between loc and iloc in Pandas DataFrame indexing.

11. Discuss the purpose and usage of lambda functions in Python.

12. What are Python decorators, and how do they work?

13. How do you handle categorical data in Python using the Pandas library?

14. Explain the concept of data normalization and its importance in data preprocessing.

15. Discuss the role of regular expressions (regex) in data cleaning with Python.

16. What are Python virtual environments, and why are they useful?

17. How do you handle outliers in a dataset using Python?

18. Explain the usage of the map and filter functions in Python.

19. Discuss the concept of recursion in Python programming.

20. How do you perform data analysis and visualization using Jupyter Notebooks?

Python Interview Q&A: https://topmate.io/coding/898340

Like for more ❤️

ENJOY LEARNING 👍👍

Do not wait till you've mastered SQL till you apply to your first Data Analyst Job.

You can do both at the same time.

𝗔𝗰𝗲 𝗬𝗼𝘂𝗿 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝘄𝗶𝘁𝗵 𝗧𝗵𝗲𝘀𝗲 𝗠𝘂𝘀𝘁-𝗞𝗻𝗼𝘄 𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀! 🔥

Are you preparing for a 𝗗𝗮𝘁𝗮 𝗔𝗻𝗮𝗹𝘆𝘀𝘁 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄? Hiring managers don’t just want to hear your answers—they want to know if you truly understand data.

Here are 𝗳𝗿𝗲𝗾𝘂𝗲𝗻𝘁𝗹𝘆 𝗮𝘀𝗸𝗲𝗱 𝗾𝘂𝗲𝘀𝘁𝗶𝗼𝗻𝘀 (and what they really mean):

📌 "𝗧𝗲𝗹𝗹 𝗺𝗲 𝗮𝗯𝗼𝘂𝘁 𝘆𝗼𝘂𝗿𝘀𝗲𝗹𝗳."

🔍 What they’re really asking: Are you relevant for this role?

✅ Keep it concise—highlight your experience, tools (SQL, Power BI, etc.), and a key impact you made.

📌 "𝗛𝗼𝘄 𝗱𝗼 𝘆𝗼𝘂 𝗵𝗮𝗻𝗱𝗹𝗲 𝗺𝗲𝘀𝘀𝘆 𝗱𝗮𝘁𝗮?"

🔍 What they’re really asking: Do you panic when you see missing values?

✅ Show your structured approach—identify issues, clean with Pandas/SQL, and document your process.

📌 "𝗛𝗼𝘄 𝗱𝗼 𝘆𝗼𝘂 𝗮𝗽𝗽𝗿𝗼𝗮𝗰𝗵 𝗮 𝗱𝗮𝘁𝗮 𝗮𝗻𝗮𝗹𝘆𝘀𝗶𝘀 𝗽𝗿𝗼𝗷𝗲𝗰𝘁?"

🔍 What they’re really asking: Do you have a methodology, or do you just wing it?

✅ Use a structured approach: Define business needs → Clean & explore data → Generate insights → Present effectively.

📌 "𝗖𝗮𝗻 𝘆𝗼𝘂 𝗲𝘅𝗽𝗹𝗮𝗶𝗻 𝗮 𝗰𝗼𝗺𝗽𝗹𝗲𝘅 𝗰𝗼𝗻𝗰𝗲𝗽𝘁 𝘁𝗼 𝗮 𝗻𝗼𝗻-𝘁𝗲𝗰𝗵𝗻𝗶𝗰𝗮𝗹
𝘀𝘁𝗮𝗸𝗲𝗵𝗼𝗹𝗱𝗲𝗿?"

🔍 What they’re really asking: Can you simplify data without oversimplifying?

✅ Use storytelling—focus on actionable insights rather than jargon.

📌 "𝗧𝗲𝗹𝗹 𝗺𝗲 𝗮𝗯𝗼𝘂𝘁 𝗮 𝘁𝗶𝗺𝗲 𝘆𝗼𝘂 𝗺𝗮𝗱𝗲 𝗮 𝗺𝗶𝘀𝘁𝗮𝗸𝗲."

🔍 What they’re really asking: Can you learn from failure?

✅ Own your mistake, explain how you fixed it, and share what you do differently now.

💡 𝗣𝗿𝗼 𝗧𝗶𝗽: The best candidates don’t just answer questions—they tell stories that demonstrate problem-solving, clarity, and impact.

🔄 Save this for later & share with someone preparing for interviews!

1. What is a Self-Join?

A self-join is a type of join that can be used to connect two tables. As a result, it is a unary relationship. Each row of the table is attached to itself and all other rows of the same table in a self-join. As a result, a self-join is mostly used to combine and compare rows from the same database table.


2. What is OLTP?

OLTP, or online transactional processing, allows huge groups of people to execute massive amounts of database transactions in real time, usually via the internet. A database transaction occurs when data in a database is changed, inserted, deleted, or queried.


3. What is the difference between joining and blending in Tableau?

Joining term is used when you are combining data from the same source, for example, worksheet in an Excel file or tables in Oracle databaseWhile blending requires two completely defined data sources in your report.


4. How to prevent someone from copying the cell from your worksheet in excel?

If you want to protect your worksheet from being copied, go into Menu bar > Review > Protect sheet > Password.

By entering password you can prevent your worksheet from getting copied.


5. What are the different integrity rules present in the DBMS?

The different integrity rules present in DBMS are as follows:
Entity Integrity: This rule states that the value of the primary key can never be NULL. So, all the tuples in the column identified as the primary key should have a value.
Referential Integrity: This rule states that either the value of the foreign key is NULL or it should be the primary key of any other relation.

Choosing the Right Chart Type

Selecting the appropriate chart can make or break your data storytelling. Here's a quick guide to help you choose the perfect visualization:

↳ 𝐁𝐚𝐫 𝐂𝐡𝐚𝐫𝐭𝐬: Perfect for comparing quantities across categories (Think: regional sales comparison)

↳ 𝐋𝐢𝐧𝐞 𝐂𝐡𝐚𝐫𝐭𝐬: Ideal for showing trends and changes over time (Example: monthly website traffic)

↳ 𝐏𝐢𝐞 𝐂𝐡𝐚𝐫𝐭𝐬: Best for showing parts of a whole as percentages (Use case: market share breakdown)

↳ 𝐇𝐢𝐬𝐭𝐨𝐠𝐫𝐚𝐦𝐬: Great for showing the distribution of continuous data (Like salary ranges across your organization)

↳ 𝐒𝐜𝐚𝐭𝐭𝐞𝐫 𝐏𝐥𝐨𝐭𝐬: Essential for exploring relationships between variables (Perfect for marketing spend vs. sales analysis)

↳ 𝐇𝐞𝐚𝐭 𝐌𝐚𝐩𝐬: Excellent for showing data density with color variation (Think: website traffic patterns by hour/day)

↳ 𝐁𝐨𝐱 𝐏𝐥𝐨𝐭𝐬: Invaluable for displaying data variability and outliers (Great for analyzing performance metrics)

↳ 𝐀𝐫𝐞𝐚 𝐂𝐡𝐚𝐫𝐭𝐬: Shows cumulative totals over time (Example: sales growth across product lines)

↳ 𝐁𝐮𝐛𝐛𝐥𝐞 𝐂𝐡𝐚𝐫𝐭𝐬: Powerful for displaying three dimensions of data (Combines size, position, and grouping)

𝐏𝐫𝐨 𝐓𝐢𝐩: Always consider your audience and the story you want to tell when choosing your visualization type.

I have curated the best interview resources to crack Power BI Interviews 👇👇
https://t.iss.one/PowerBI_analyst

Hope you'll like it

Like this post if you need more resources like this 👍❤️

Hey guys 👋

I was working on something big from last few days.

Finally, I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://topmate.io/analyst/861634

If you go on purchasing these books, it will cost you more than 15000 but I kept the minimal price for everyone's benefit.

I hope these resources will help you in data analytics journey.

I will add more resources here in the future without any additional cost.

All the best for your career ❤️