Scenario based Interview Questions & Answers for Data Analyst
1. Scenario: You are working on a SQL database that stores customer information. The database has a table called "Orders" that contains order details. Your task is to write a SQL query to retrieve the total number of orders placed by each customer.
Question:
- Write a SQL query to find the total number of orders placed by each customer.
Expected Answer:
SELECT CustomerID, COUNT(*) AS TotalOrders
FROM Orders
GROUP BY CustomerID;
2. Scenario: You are working on a SQL database that stores employee information. The database has a table called "Employees" that contains employee details. Your task is to write a SQL query to retrieve the names of all employees who have been with the company for more than 5 years.
Question:
- Write a SQL query to find the names of employees who have been with the company for more than 5 years.
Expected Answer:
SELECT Name
FROM Employees
WHERE DATEDIFF(year, HireDate, GETDATE()) > 5;
Power BI Scenario-Based Questions
1. Scenario: You have been given a dataset in Power BI that contains sales data for a company. Your task is to create a report that shows the total sales by product category and region.
Expected Answer:
- Load the dataset into Power BI.
- Create relationships if necessary.
- Use the "Fields" pane to select the necessary fields (Product Category, Region, Sales).
- Drag these fields into the "Values" area of a new visualization (e.g., a table or bar chart).
- Use the "Filters" pane to filter data as needed.
- Format the visualization to enhance clarity and readability.
2. Scenario: You have been asked to create a Power BI dashboard that displays real-time stock prices for a set of companies. The stock prices are available through an API.
Expected Answer:
- Use Power BI Desktop to connect to the API.
- Go to "Get Data" > "Web" and enter the API URL.
- Configure the data refresh settings to ensure real-time updates (e.g., setting up a scheduled refresh or using DirectQuery if supported).
- Create visualizations using the imported data.
- Publish the report to the Power BI service and set up a data gateway if needed for continuous refresh.
3. Scenario: You have been given a Power BI report that contains multiple visualizations. The report is taking a long time to load and is impacting the performance of the application.
Expected Answer:
- Analyze the current performance using Performance Analyzer.
- Optimize data model by reducing the number of columns and rows, and removing unnecessary calculations.
- Use aggregated tables to pre-compute results.
- Simplify DAX calculations.
- Optimize visualizations by reducing the number of visuals per page and avoiding complex custom visuals.
- Ensure proper indexing on the data source.
Free SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Like if you need more similar content
Hope it helps :)
1. Scenario: You are working on a SQL database that stores customer information. The database has a table called "Orders" that contains order details. Your task is to write a SQL query to retrieve the total number of orders placed by each customer.
Question:
- Write a SQL query to find the total number of orders placed by each customer.
Expected Answer:
SELECT CustomerID, COUNT(*) AS TotalOrders
FROM Orders
GROUP BY CustomerID;
2. Scenario: You are working on a SQL database that stores employee information. The database has a table called "Employees" that contains employee details. Your task is to write a SQL query to retrieve the names of all employees who have been with the company for more than 5 years.
Question:
- Write a SQL query to find the names of employees who have been with the company for more than 5 years.
Expected Answer:
SELECT Name
FROM Employees
WHERE DATEDIFF(year, HireDate, GETDATE()) > 5;
Power BI Scenario-Based Questions
1. Scenario: You have been given a dataset in Power BI that contains sales data for a company. Your task is to create a report that shows the total sales by product category and region.
Expected Answer:
- Load the dataset into Power BI.
- Create relationships if necessary.
- Use the "Fields" pane to select the necessary fields (Product Category, Region, Sales).
- Drag these fields into the "Values" area of a new visualization (e.g., a table or bar chart).
- Use the "Filters" pane to filter data as needed.
- Format the visualization to enhance clarity and readability.
2. Scenario: You have been asked to create a Power BI dashboard that displays real-time stock prices for a set of companies. The stock prices are available through an API.
Expected Answer:
- Use Power BI Desktop to connect to the API.
- Go to "Get Data" > "Web" and enter the API URL.
- Configure the data refresh settings to ensure real-time updates (e.g., setting up a scheduled refresh or using DirectQuery if supported).
- Create visualizations using the imported data.
- Publish the report to the Power BI service and set up a data gateway if needed for continuous refresh.
3. Scenario: You have been given a Power BI report that contains multiple visualizations. The report is taking a long time to load and is impacting the performance of the application.
Expected Answer:
- Analyze the current performance using Performance Analyzer.
- Optimize data model by reducing the number of columns and rows, and removing unnecessary calculations.
- Use aggregated tables to pre-compute results.
- Simplify DAX calculations.
- Optimize visualizations by reducing the number of visuals per page and avoiding complex custom visuals.
- Ensure proper indexing on the data source.
Free SQL Resources: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v
Like if you need more similar content
Hope it helps :)
โค1
SQL Interview Questions with Answers Part-1: โ๏ธ
1. What is SQL?
SQL (Structured Query Language) is a standardized programming language designed to manage and manipulate relational databases. It allows you to query, insert, update, and delete data, as well as create and modify schema objects like tables and views.
2. Differentiate between SQL and NoSQL databases.
SQL databases are relational, table-based, and use structured query language with fixed schemas, ideal for complex queries and transactions. NoSQL databases are non-relational, can be document, key-value, graph, or column-oriented, and are schema-flexible, designed for scalability and handling unstructured data.
3. What are the different types of SQL commands?
โฆ DDL (Data Definition Language): CREATE, ALTER, DROP (define and modify structure)
โฆ DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE (data operations)
โฆ DCL (Data Control Language): GRANT, REVOKE (permission control)
โฆ TCL (Transaction Control Language): COMMIT, ROLLBACK, SAVEPOINT (transaction management)
4. Explain the difference between WHERE and HAVING clauses.
โฆ
โฆ
5. Write a SQL query to find the second highest salary in a table.
Using a subquery:
Or using DENSE_RANK():
6. What is a JOIN? Explain different types of JOINs.
A JOIN combines rows from two or more tables based on a related column:
โฆ INNER JOIN: returns matching rows from both tables.
โฆ LEFT JOIN (LEFT OUTER JOIN): all rows from the left table, matched rows from right.
โฆ RIGHT JOIN (RIGHT OUTER JOIN): all rows from right table, matched rows from left.
โฆ FULL JOIN (FULL OUTER JOIN): all rows when thereโs a match in either table.
โฆ CROSS JOIN: Cartesian product of both tables.
7. How do you optimize slow-performing SQL queries?
โฆ Use indexes appropriately to speed up lookups.
โฆ Avoid SELECT *; only select necessary columns.
โฆ Use joins carefully; filter early with WHERE clauses.
โฆ Analyze execution plans to identify bottlenecks.
โฆ Avoid unnecessary subqueries; use EXISTS or JOINs.
โฆ Limit result sets with pagination if dealing with large datasets.
8. What is a primary key? What is a foreign key?
โฆ Primary Key: A unique identifier for records in a table; it cannot be NULL.
โฆ Foreign Key: A field that creates a link between two tables by referring to the primary key in another table, enforcing referential integrity.
9. What are indexes? Explain clustered and non-clustered indexes.
โฆ Indexes speed up data retrieval by providing quick lookups.
โฆ Clustered Index: Sorts and stores the actual data rows in the table based on the key; a table can have only one clustered index.
โฆ Non-Clustered Index: Creates a separate structure that points to the data rows; tables can have multiple non-clustered indexes.
10. Write a SQL query to fetch the top 5 records from a table.
In SQL Server and PostgreSQL:
In SQL Server (older syntax):
React โฅ๏ธ for Part 2
1. What is SQL?
SQL (Structured Query Language) is a standardized programming language designed to manage and manipulate relational databases. It allows you to query, insert, update, and delete data, as well as create and modify schema objects like tables and views.
2. Differentiate between SQL and NoSQL databases.
SQL databases are relational, table-based, and use structured query language with fixed schemas, ideal for complex queries and transactions. NoSQL databases are non-relational, can be document, key-value, graph, or column-oriented, and are schema-flexible, designed for scalability and handling unstructured data.
3. What are the different types of SQL commands?
โฆ DDL (Data Definition Language): CREATE, ALTER, DROP (define and modify structure)
โฆ DML (Data Manipulation Language): SELECT, INSERT, UPDATE, DELETE (data operations)
โฆ DCL (Data Control Language): GRANT, REVOKE (permission control)
โฆ TCL (Transaction Control Language): COMMIT, ROLLBACK, SAVEPOINT (transaction management)
4. Explain the difference between WHERE and HAVING clauses.
โฆ
WHERE filters rows before grouping (used with SELECT, UPDATE).โฆ
HAVING filters groups after aggregation (used with GROUP BY), e.g., filtering aggregated results like sums or counts.5. Write a SQL query to find the second highest salary in a table.
Using a subquery:
SELECT MAX(salary) FROM employees
WHERE salary < (SELECT MAX(salary) FROM employees);
Or using DENSE_RANK():
SELECT salary FROM (
SELECT salary, DENSE_RANK() OVER (ORDER BY salary DESC) as rnk
FROM employees) t
WHERE rnk = 2;
6. What is a JOIN? Explain different types of JOINs.
A JOIN combines rows from two or more tables based on a related column:
โฆ INNER JOIN: returns matching rows from both tables.
โฆ LEFT JOIN (LEFT OUTER JOIN): all rows from the left table, matched rows from right.
โฆ RIGHT JOIN (RIGHT OUTER JOIN): all rows from right table, matched rows from left.
โฆ FULL JOIN (FULL OUTER JOIN): all rows when thereโs a match in either table.
โฆ CROSS JOIN: Cartesian product of both tables.
7. How do you optimize slow-performing SQL queries?
โฆ Use indexes appropriately to speed up lookups.
โฆ Avoid SELECT *; only select necessary columns.
โฆ Use joins carefully; filter early with WHERE clauses.
โฆ Analyze execution plans to identify bottlenecks.
โฆ Avoid unnecessary subqueries; use EXISTS or JOINs.
โฆ Limit result sets with pagination if dealing with large datasets.
8. What is a primary key? What is a foreign key?
โฆ Primary Key: A unique identifier for records in a table; it cannot be NULL.
โฆ Foreign Key: A field that creates a link between two tables by referring to the primary key in another table, enforcing referential integrity.
9. What are indexes? Explain clustered and non-clustered indexes.
โฆ Indexes speed up data retrieval by providing quick lookups.
โฆ Clustered Index: Sorts and stores the actual data rows in the table based on the key; a table can have only one clustered index.
โฆ Non-Clustered Index: Creates a separate structure that points to the data rows; tables can have multiple non-clustered indexes.
10. Write a SQL query to fetch the top 5 records from a table.
In SQL Server and PostgreSQL:
SELECT * FROM table_name
ORDER BY some_column DESC
LIMIT 5;
In SQL Server (older syntax):
SELECT TOP 5 * FROM table_name
ORDER BY some_column DESC;
React โฅ๏ธ for Part 2
โค4
๐๐ฅ๐๐ ๐๐ฎ๐ฟ๐ฒ๐ฒ๐ฟ ๐๐ฎ๐ฟ๐ป๐ถ๐๐ฎ๐น ๐ฏ๐ ๐๐๐ ๐๐จ๐ฉ๐๐
Prove your skills in an online hackathon, clear tech interviews, and get hired faster
Highlightes:-
- 21+ Hiring Companies & 100+ Open Positions to Grab
- Get hired for roles in AI, Full Stack, & more
Experience the biggest online job fair with Career Carnival by HCL GUVI
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4bQP5Ee
Hurry Up๐โโ๏ธ.....Limited Slots Available
Prove your skills in an online hackathon, clear tech interviews, and get hired faster
Highlightes:-
- 21+ Hiring Companies & 100+ Open Positions to Grab
- Get hired for roles in AI, Full Stack, & more
Experience the biggest online job fair with Career Carnival by HCL GUVI
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐๐ผ๐ฟ ๐๐ฅ๐๐๐:-
https://pdlink.in/4bQP5Ee
Hurry Up๐โโ๏ธ.....Limited Slots Available
โค1
โ
Real-World Data Science Interview Questions & Answers ๐๐
1๏ธโฃ What is A/B Testing?
A method to compare two versions (A & B) to see which performs better, used in marketing, product design, and app features.
Answer: Use hypothesis testing (e.g., t-tests for means or chi-square for categories) to determine if changes are statistically significantโaim for p<0.05 and calculate sample size to detect 5-10% lifts. Example: Google tests search result layouts, boosting click-through by 15% while controlling for user segments.
2๏ธโฃ How do Recommendation Systems work?
They suggest items based on user behavior or preferences, driving 35% of Amazon's sales and Netflix views.
Answer: Collaborative filtering (user-item interactions via matrix factorization or KNN) or content-based filtering (item attributes like tags using TF-IDF)โhybrids like ALS in Spark handle scale. Pro tip: Combat cold starts with content-based fallbacks; evaluate with NDCG for ranking quality.
3๏ธโฃ Explain Time Series Forecasting.
Predicting future values based on past data points collected over time, like demand or stock trends.
Answer: Use models like ARIMA (for stationary series with ACF/PACF), Prophet (auto-handles seasonality and holidays), or LSTM neural networks (for non-linear patterns in Keras/PyTorch). In practice: Uber forecasts ride surges with Prophet, improving accuracy by 20% over baselines during peaks.
4๏ธโฃ What are ethical concerns in Data Science?
Bias in data, privacy issues, transparency, and fairnessโespecially with AI regs like the EU AI Act in 2025.
Answer: Ensure diverse data to mitigate bias (audit with fairness libraries like AIF360), use explainable models (LIME/SHAP for black-box insights), and comply with regulations (e.g., GDPR for anonymization). Real-world: Fix COMPAS recidivism bias by balancing datasets, ensuring equitable outcomes across demographics.
5๏ธโฃ How do you deploy an ML model?
Prepare model, containerize (Docker), create API (Flask/FastAPI), deploy on cloud (AWS, Azure).
Answer: Monitor performance with tools like Prometheus or MLflow (track drift, accuracy), retrain as needed via MLOps pipelines (e.g., Kubeflow)โuse serverless like AWS Lambda for low-traffic. Example: Deploy a churn model on Azure ML; it serves 10k predictions daily with 99% uptime and auto-retrains quarterly on new data.
๐ฌ Tap โค๏ธ for more!
1๏ธโฃ What is A/B Testing?
A method to compare two versions (A & B) to see which performs better, used in marketing, product design, and app features.
Answer: Use hypothesis testing (e.g., t-tests for means or chi-square for categories) to determine if changes are statistically significantโaim for p<0.05 and calculate sample size to detect 5-10% lifts. Example: Google tests search result layouts, boosting click-through by 15% while controlling for user segments.
2๏ธโฃ How do Recommendation Systems work?
They suggest items based on user behavior or preferences, driving 35% of Amazon's sales and Netflix views.
Answer: Collaborative filtering (user-item interactions via matrix factorization or KNN) or content-based filtering (item attributes like tags using TF-IDF)โhybrids like ALS in Spark handle scale. Pro tip: Combat cold starts with content-based fallbacks; evaluate with NDCG for ranking quality.
3๏ธโฃ Explain Time Series Forecasting.
Predicting future values based on past data points collected over time, like demand or stock trends.
Answer: Use models like ARIMA (for stationary series with ACF/PACF), Prophet (auto-handles seasonality and holidays), or LSTM neural networks (for non-linear patterns in Keras/PyTorch). In practice: Uber forecasts ride surges with Prophet, improving accuracy by 20% over baselines during peaks.
4๏ธโฃ What are ethical concerns in Data Science?
Bias in data, privacy issues, transparency, and fairnessโespecially with AI regs like the EU AI Act in 2025.
Answer: Ensure diverse data to mitigate bias (audit with fairness libraries like AIF360), use explainable models (LIME/SHAP for black-box insights), and comply with regulations (e.g., GDPR for anonymization). Real-world: Fix COMPAS recidivism bias by balancing datasets, ensuring equitable outcomes across demographics.
5๏ธโฃ How do you deploy an ML model?
Prepare model, containerize (Docker), create API (Flask/FastAPI), deploy on cloud (AWS, Azure).
Answer: Monitor performance with tools like Prometheus or MLflow (track drift, accuracy), retrain as needed via MLOps pipelines (e.g., Kubeflow)โuse serverless like AWS Lambda for low-traffic. Example: Deploy a churn model on Azure ML; it serves 10k predictions daily with 99% uptime and auto-retrains quarterly on new data.
๐ฌ Tap โค๏ธ for more!
โค2
๐ง๐ผ๐ฝ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป๐ ๐ง๐ผ ๐๐ฒ๐ ๐๐ถ๐ด๐ต ๐ฃ๐ฎ๐๐ถ๐ป๐ด ๐๐ผ๐ฏ ๐๐ป ๐ฎ๐ฌ๐ฎ๐ฒ๐
Opportunities With 500+ Hiring Partners
๐๐๐น๐น๐๐๐ฎ๐ฐ๐ธ:- https://pdlink.in/4hO7rWY
๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐:- https://pdlink.in/4fdWxJB
๐ Start learning today, build job-ready skills, and get placed in leading tech companies.
Opportunities With 500+ Hiring Partners
๐๐๐น๐น๐๐๐ฎ๐ฐ๐ธ:- https://pdlink.in/4hO7rWY
๐๐ฎ๐๐ฎ ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐:- https://pdlink.in/4fdWxJB
๐ Start learning today, build job-ready skills, and get placed in leading tech companies.
โค1
Data Analyst Interview Questions
1. What do Tableau's sets and groups mean?
Data is grouped using sets and groups according to predefined criteria. The primary distinction between the two is that although a set can have only two optionsโeither in or outโa group can divide the dataset into several groups. A user should decide which group or sets to apply based on the conditions.
2.What in Excel is a macro?
An Excel macro is an algorithm or a group of steps that helps automate an operation by capturing and replaying the steps needed to finish it. Once the steps have been saved, you may construct a Macro that the user can alter and replay as often as they like.
Macro is excellent for routine work because it also gets rid of mistakes. Consider the scenario when an account manager needs to share reports about staff members who owe the company money. If so, it can be automated by utilising a macro and making small adjustments each month as necessary.
3.Gantt chart in Tableau
A Tableau Gantt chart illustrates the duration of events as well as the progression of value across the period. Along with the time axis, it has bars. The Gantt chart is primarily used as a project management tool, with each bar representing a project job.
4.In Microsoft Excel, how do you create a drop-down list?
Start by selecting the Data tab from the ribbon.
Select Data Validation from the Data Tools group.
Go to Settings > Allow > List next.
Choose the source you want to offer in the form of a list array.
1. What do Tableau's sets and groups mean?
Data is grouped using sets and groups according to predefined criteria. The primary distinction between the two is that although a set can have only two optionsโeither in or outโa group can divide the dataset into several groups. A user should decide which group or sets to apply based on the conditions.
2.What in Excel is a macro?
An Excel macro is an algorithm or a group of steps that helps automate an operation by capturing and replaying the steps needed to finish it. Once the steps have been saved, you may construct a Macro that the user can alter and replay as often as they like.
Macro is excellent for routine work because it also gets rid of mistakes. Consider the scenario when an account manager needs to share reports about staff members who owe the company money. If so, it can be automated by utilising a macro and making small adjustments each month as necessary.
3.Gantt chart in Tableau
A Tableau Gantt chart illustrates the duration of events as well as the progression of value across the period. Along with the time axis, it has bars. The Gantt chart is primarily used as a project management tool, with each bar representing a project job.
4.In Microsoft Excel, how do you create a drop-down list?
Start by selecting the Data tab from the ribbon.
Select Data Validation from the Data Tools group.
Go to Settings > Allow > List next.
Choose the source you want to offer in the form of a list array.
โค1
๐ง๐ผ๐ฝ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป๐ ๐ข๐ณ๐ณ๐ฒ๐ฟ๐ฒ๐ฑ ๐๐ ๐๐๐ง ๐ฅ๐ผ๐ผ๐ฟ๐ธ๐ฒ๐ฒ & ๐๐๐ ๐ ๐๐บ๐ฏ๐ฎ๐ถ๐
Placement Assistance With 5000+ Companies
Deadline: 25th January 2026
๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ & ๐๐ :- https://pdlink.in/49UZfkX
๐ฆ๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ ๐๐ป๐ด๐ถ๐ป๐ฒ๐ฒ๐ฟ๐ถ๐ป๐ด:- https://pdlink.in/4pYWCEK
๐๐ถ๐ด๐ถ๐๐ฎ๐น ๐ ๐ฎ๐ฟ๐ธ๐ฒ๐๐ถ๐ป๐ด & ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ :- https://pdlink.in/4tcUPia
Hurry..Up Only Limited Seats Available
Placement Assistance With 5000+ Companies
Deadline: 25th January 2026
๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ & ๐๐ :- https://pdlink.in/49UZfkX
๐ฆ๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ ๐๐ป๐ด๐ถ๐ป๐ฒ๐ฒ๐ฟ๐ถ๐ป๐ด:- https://pdlink.in/4pYWCEK
๐๐ถ๐ด๐ถ๐๐ฎ๐น ๐ ๐ฎ๐ฟ๐ธ๐ฒ๐๐ถ๐ป๐ด & ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ :- https://pdlink.in/4tcUPia
Hurry..Up Only Limited Seats Available
โ
๐ Power BI Interview Questions (For Analyst/BI Roles)
1๏ธโฃ Explain DAX CALCULATE() Function
Used to modify the filter context of a measure.
โ Example:
2๏ธโฃ What is ALL() function in DAX?
Removes filters โ useful for calculating totals regardless of filters.
3๏ธโฃ How does FILTER() differ from CALCULATE()?
FILTER returns a table; CALCULATE modifies context using that table.
4๏ธโฃ Difference between SUMX and SUM?
SUMX iterates over rows, applying an expression; SUM just totals a column.
5๏ธโฃ Explain STAR vs SNOWFLAKE Schema
- Star: denormalized, simple
- Snowflake: normalized, complex relationships
6๏ธโฃ What is a Composite Model?
Allows combining Import + DirectQuery sources in one report.
7๏ธโฃ What are Virtual Tables in DAX?
Tables created in memory during calculation โ not physical.
8๏ธโฃ What is the difference between USERNAME() and USERPRINCIPALNAME()?
Used for dynamic RLS.
- USERNAME(): Local machine login
- USERPRINCIPALNAME(): Cloud identity (email)
9๏ธโฃ Explain Time Intelligence Functions
Examples:
-
Used for date-based calculations.
๐ Common DAX Optimization Tips
- Avoid complex nested functions
- Use variables (VAR)
- Reduce row context with calculated columns
1๏ธโฃ1๏ธโฃ What is Incremental Refresh?
Only refreshes new/changed data โ improves performance in large datasets.
1๏ธโฃ2๏ธโฃ What are Parameters in Power BI?
User-defined inputs to make reports dynamic and reusable.
1๏ธโฃ3๏ธโฃ What is a Dataflow?
Reusable ETL layer in Power BI Service using Power Query Online.
1๏ธโฃ4๏ธโฃ Difference Between Live Connection vs DirectQuery vs Import
- Import: Fast, offline
- DirectQuery: Real-time, slower
- Live Connection: Full model lives on SSAS
1๏ธโฃ5๏ธโฃ Advanced Visuals Use Cases
- Decomposition Tree for root cause analysis
- KPI Cards for performance metrics
- Paginated Reports for printable tables
๐ Tap for more!
1๏ธโฃ Explain DAX CALCULATE() Function
Used to modify the filter context of a measure.
โ Example:
CALCULATE(SUM(Sales[Amount]), Region = "West")2๏ธโฃ What is ALL() function in DAX?
Removes filters โ useful for calculating totals regardless of filters.
3๏ธโฃ How does FILTER() differ from CALCULATE()?
FILTER returns a table; CALCULATE modifies context using that table.
4๏ธโฃ Difference between SUMX and SUM?
SUMX iterates over rows, applying an expression; SUM just totals a column.
5๏ธโฃ Explain STAR vs SNOWFLAKE Schema
- Star: denormalized, simple
- Snowflake: normalized, complex relationships
6๏ธโฃ What is a Composite Model?
Allows combining Import + DirectQuery sources in one report.
7๏ธโฃ What are Virtual Tables in DAX?
Tables created in memory during calculation โ not physical.
8๏ธโฃ What is the difference between USERNAME() and USERPRINCIPALNAME()?
Used for dynamic RLS.
- USERNAME(): Local machine login
- USERPRINCIPALNAME(): Cloud identity (email)
9๏ธโฃ Explain Time Intelligence Functions
Examples:
-
TOTALYTD(), DATESINPERIOD(), SAMEPERIODLASTYEAR()Used for date-based calculations.
๐ Common DAX Optimization Tips
- Avoid complex nested functions
- Use variables (VAR)
- Reduce row context with calculated columns
1๏ธโฃ1๏ธโฃ What is Incremental Refresh?
Only refreshes new/changed data โ improves performance in large datasets.
1๏ธโฃ2๏ธโฃ What are Parameters in Power BI?
User-defined inputs to make reports dynamic and reusable.
1๏ธโฃ3๏ธโฃ What is a Dataflow?
Reusable ETL layer in Power BI Service using Power Query Online.
1๏ธโฃ4๏ธโฃ Difference Between Live Connection vs DirectQuery vs Import
- Import: Fast, offline
- DirectQuery: Real-time, slower
- Live Connection: Full model lives on SSAS
1๏ธโฃ5๏ธโฃ Advanced Visuals Use Cases
- Decomposition Tree for root cause analysis
- KPI Cards for performance metrics
- Paginated Reports for printable tables
๐ Tap for more!
โค3
๐๐ป๐ฑ๐ถ๐ฎโ๐ ๐๐ถ๐ด๐ด๐ฒ๐๐ ๐๐ฎ๐ฐ๐ธ๐ฎ๐๐ต๐ผ๐ป | ๐๐ ๐๐บ๐ฝ๐ฎ๐ฐ๐ ๐๐๐ถ๐น๐ฑ๐ฎ๐๐ต๐ผ๐ป๐
Participate in the national AI hackathon under the India AI Impact Summit 2026
Submission deadline: 5th February 2026
Grand Finale: 16th February 2026, New Delhi
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐๐:-
https://pdlink.in/4qQfAOM
a flagship initiative of the Government of India ๐ฎ๐ณ
Participate in the national AI hackathon under the India AI Impact Summit 2026
Submission deadline: 5th February 2026
Grand Finale: 16th February 2026, New Delhi
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐๐:-
https://pdlink.in/4qQfAOM
a flagship initiative of the Government of India ๐ฎ๐ณ
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.
๐ 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.
โค4๐1
๐ผ Pandas Interview Question (Data Analyst)
Q. How do you find missing values in a Pandas DataFrame and count them column-wise?
โ Answer
df.isna().sum()
Explanation:
isna() / isnull() detects missing values
sum() gives the count for each column
๐ก Pro tip:
Total missing values in the DataFrame:
df.isna().sum().sum()
๐ React to this post if you want more daily interview questions on Pandas, SQL & Data Analytics. ๐
Q. How do you find missing values in a Pandas DataFrame and count them column-wise?
โ Answer
df.isna().sum()
Explanation:
isna() / isnull() detects missing values
sum() gives the count for each column
๐ก Pro tip:
Total missing values in the DataFrame:
df.isna().sum().sum()
๐ React to this post if you want more daily interview questions on Pandas, SQL & Data Analytics. ๐
โค6๐1
๐ ๐ฐ ๐๐ฅ๐๐ ๐ง๐ฒ๐ฐ๐ต ๐๐ผ๐๐ฟ๐๐ฒ๐ ๐ง๐ผ ๐๐ป๐ฟ๐ผ๐น๐น ๐๐ป ๐ฎ๐ฌ๐ฎ๐ฒ ๐
๐ Upgrade your career with in-demand tech skills & FREE certifications!
1๏ธโฃ AI & ML โ https://pdlink.in/4bhetTu
2๏ธโฃ Data Analytics โ https://pdlink.in/497MMLw
3๏ธโฃ Cloud Computing โ https://pdlink.in/3LoutZd
4๏ธโฃ Cyber Security โ https://pdlink.in/3N9VOyW
More Courses โ https://pdlink.in/4qgtrxU
๐ 100% FREE | Certificates Provided | Learn Anytime, Anywhere
๐ Upgrade your career with in-demand tech skills & FREE certifications!
1๏ธโฃ AI & ML โ https://pdlink.in/4bhetTu
2๏ธโฃ Data Analytics โ https://pdlink.in/497MMLw
3๏ธโฃ Cloud Computing โ https://pdlink.in/3LoutZd
4๏ธโฃ Cyber Security โ https://pdlink.in/3N9VOyW
More Courses โ https://pdlink.in/4qgtrxU
๐ 100% FREE | Certificates Provided | Learn Anytime, Anywhere
๐ Pandas Interview Question (Frequently Asked!)
โ Interviewers love to ask this:
โYour dataset has duplicate records. How will you handle them in Pandas?โ
โ Answer:
โก๏ธ Use df.duplicated() to identify duplicate rows.
โก๏ธ Use df.drop_duplicates() to remove them cleanly.
โก๏ธ You can also target specific columns using the subset parameter.
๐ React if you want more frequently asked Pandas, SQL, PowerBI interview questions for Data Analyst roles!
โ Interviewers love to ask this:
โYour dataset has duplicate records. How will you handle them in Pandas?โ
โ Answer:
โก๏ธ Use df.duplicated() to identify duplicate rows.
โก๏ธ Use df.drop_duplicates() to remove them cleanly.
โก๏ธ You can also target specific columns using the subset parameter.
๐ React if you want more frequently asked Pandas, SQL, PowerBI interview questions for Data Analyst roles!
๐6โค2
๐๐๐น๐น ๐ฆ๐๐ฎ๐ฐ๐ธ ๐๐ฒ๐๐ฒ๐น๐ผ๐ฝ๐บ๐ฒ๐ป๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐ฃ๐ฟ๐ผ๐ด๐ฟ๐ฎ๐บ ๐
* JAVA- Full Stack Development With Gen AI
* MERN- Full Stack Development With Gen AI
Highlightes:-
* 2000+ Students Placed
* Attend FREE Hiring Drives at our Skill Centres
* Learn from India's Best Mentors
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ๐ :-
https://pdlink.in/4hO7rWY
Hurry, limited seats available!
* JAVA- Full Stack Development With Gen AI
* MERN- Full Stack Development With Gen AI
Highlightes:-
* 2000+ Students Placed
* Attend FREE Hiring Drives at our Skill Centres
* Learn from India's Best Mentors
๐๐๐ ๐ข๐ฌ๐ญ๐๐ซ ๐๐จ๐ฐ๐ :-
https://pdlink.in/4hO7rWY
Hurry, limited seats available!
๐๐๐ ๐๐๐ฌ๐ ๐๐ญ๐ฎ๐๐ข๐๐ฌ ๐๐จ๐ซ ๐๐ง๐ญ๐๐ซ๐ฏ๐ข๐๐ฐ:
Join for more: https://t.me/sqlanalyst
1. Dannyโs Diner:
Restaurant analytics to understand the customer orders pattern.
Link: https://8weeksqlchallenge.com/case-study-1/
2. Pizza Runner
Pizza shop analytics to optimize the efficiency of the operation
Link: https://8weeksqlchallenge.com/case-study-2/
3. Foodie Fie
Subscription-based food content platform
Link: https://lnkd.in/gzB39qAT
4. Data Bank: Thatโs money
Analytics based on customer activities with the digital bank
Link: https://lnkd.in/gH8pKPyv
5. Data Mart: Fresh is Best
Analytics on Online supermarket
Link: https://lnkd.in/gC5bkcDf
6. Clique Bait: Attention capturing
Analytics on the seafood industry
Link: https://lnkd.in/ggP4JiYG
7. Balanced Tree: Clothing Company
Analytics on the sales performance of clothing store
Link: https://8weeksqlchallenge.com/case-study-7
8. Fresh segments: Extract maximum value
Analytics on online advertising
Link: https://8weeksqlchallenge.com/case-study-8
Join for more: https://t.me/sqlanalyst
1. Dannyโs Diner:
Restaurant analytics to understand the customer orders pattern.
Link: https://8weeksqlchallenge.com/case-study-1/
2. Pizza Runner
Pizza shop analytics to optimize the efficiency of the operation
Link: https://8weeksqlchallenge.com/case-study-2/
3. Foodie Fie
Subscription-based food content platform
Link: https://lnkd.in/gzB39qAT
4. Data Bank: Thatโs money
Analytics based on customer activities with the digital bank
Link: https://lnkd.in/gH8pKPyv
5. Data Mart: Fresh is Best
Analytics on Online supermarket
Link: https://lnkd.in/gC5bkcDf
6. Clique Bait: Attention capturing
Analytics on the seafood industry
Link: https://lnkd.in/ggP4JiYG
7. Balanced Tree: Clothing Company
Analytics on the sales performance of clothing store
Link: https://8weeksqlchallenge.com/case-study-7
8. Fresh segments: Extract maximum value
Analytics on online advertising
Link: https://8weeksqlchallenge.com/case-study-8
โค4
๐ Pandas Interview Question (Frequently Asked!)
โ Interviewers love to ask this:
โYour dataset has duplicate records. How will you handle them in Pandas?โ
โ Answer:
โก๏ธ Use df.duplicated() to identify duplicate rows.
โก๏ธ Use df.drop_duplicates() to remove them cleanly.
โก๏ธ You can also target specific columns using the subset parameter.
๐ React if you want more frequently asked Pandas, SQL, PowerBI interview questions for Data Analyst roles!
โ Interviewers love to ask this:
โYour dataset has duplicate records. How will you handle them in Pandas?โ
โ Answer:
โก๏ธ Use df.duplicated() to identify duplicate rows.
โก๏ธ Use df.drop_duplicates() to remove them cleanly.
โก๏ธ You can also target specific columns using the subset parameter.
๐ React if you want more frequently asked Pandas, SQL, PowerBI interview questions for Data Analyst roles!
โค7
๐ SQL Interview Question (Must-Know)
Question:
You have a table orders with the following columns:
order_id, customer_id, order_date, order_amount
๐ Write an SQL query to find the total order amount for each customer who has placed more than 3 orders.
โ Solution:
SELECT
customer_id,
SUM(order_amount) AS total_order_amount
FROM orders
GROUP BY customer_id
HAVING COUNT(order_id) > 3;
๐ง Explanation:
GROUP BY customer_id โ groups orders per customer
SUM(order_amount) โ calculates total spending
HAVING COUNT(order_id) > 3 โ filters customers with more than 3 orders
๐ React with ๐ฅ or ๐ if this helped
๐ Want more SQL interview questions & real-world scenarios? React and stay tuned!
Question:
You have a table orders with the following columns:
order_id, customer_id, order_date, order_amount
๐ Write an SQL query to find the total order amount for each customer who has placed more than 3 orders.
โ Solution:
SELECT
customer_id,
SUM(order_amount) AS total_order_amount
FROM orders
GROUP BY customer_id
HAVING COUNT(order_id) > 3;
๐ง Explanation:
GROUP BY customer_id โ groups orders per customer
SUM(order_amount) โ calculates total spending
HAVING COUNT(order_id) > 3 โ filters customers with more than 3 orders
๐ React with ๐ฅ or ๐ if this helped
๐ Want more SQL interview questions & real-world scenarios? React and stay tuned!
โค2
๐ ๐๐๐ง ๐ฅ๐ผ๐ผ๐ฟ๐ธ๐ฒ๐ฒ ๐๐ฎ๐๐ฎ ๐ฆ๐ฐ๐ถ๐ฒ๐ป๐ฐ๐ฒ & ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป
Placement Assistance With 5000+ companies.
โ Open to everyone
โ 100% Online | 6 Months
โ Industry-ready curriculum
โ Taught By IIT Roorkee Professors
๐ฅ Companies are actively hiring candidates with Data Science & AI skills.
โณ Deadline: 31st January 2026
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐ ๐ :-
https://pdlink.in/49UZfkX
โ Limited seats only
Placement Assistance With 5000+ companies.
โ Open to everyone
โ 100% Online | 6 Months
โ Industry-ready curriculum
โ Taught By IIT Roorkee Professors
๐ฅ Companies are actively hiring candidates with Data Science & AI skills.
โณ Deadline: 31st January 2026
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ก๐ผ๐ ๐ :-
https://pdlink.in/49UZfkX
โ Limited seats only
โค1
โ
Top 10 Excel Interview Questions & Answers ๐๐ผ
1๏ธโฃ What is Excel and why is it used?
Excel is a spreadsheet program used for organizing, analyzing, and storing data in tabular form. It's widely used for data analysis, reporting, and financial modeling.
2๏ธโฃ Key Excel components?
- Ribbon: Main menu
- Worksheet: A single sheet
- Workbook: A collection of worksheets
- Cell: Intersection of a row and column
3๏ธโฃ What are Excel Functions?
Predefined formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP).
4๏ธโฃ VLOOKUP vs. INDEX/MATCH?
- VLOOKUP: Searches for a value in the first column and returns a corresponding value.
- INDEX/MATCH: More flexible and overcomes VLOOKUP limitations, better for larger datasets.
5๏ธโฃ What are Pivot Tables?
Interactive tables that summarize and analyze large datasets, allowing you to easily rearrange and filter data.
6๏ธโฃ Conditional Formatting?
Applies formatting (e.g., colors, icons) to cells based on specific criteria, making it easier to identify trends and outliers.
7๏ธโฃ How to remove duplicates?
Use the "Remove Duplicates" feature in the Data tab to eliminate redundant rows based on selected columns.
8๏ธโฃ What are Excel Charts?
Visual representations of data (e.g., bar charts, line charts, pie charts) that help communicate trends and insights.
9๏ธโฃ How to protect a worksheet?
Use the "Protect Sheet" feature in the Review tab to prevent unauthorized changes to the worksheet structure and content.
๐ What are Macros?
Automated sequences of commands that can be recorded and replayed to perform repetitive tasks efficiently.
๐ React โค๏ธ if you found this helpful!
1๏ธโฃ What is Excel and why is it used?
Excel is a spreadsheet program used for organizing, analyzing, and storing data in tabular form. It's widely used for data analysis, reporting, and financial modeling.
2๏ธโฃ Key Excel components?
- Ribbon: Main menu
- Worksheet: A single sheet
- Workbook: A collection of worksheets
- Cell: Intersection of a row and column
3๏ธโฃ What are Excel Functions?
Predefined formulas that perform specific calculations (e.g., SUM, AVERAGE, IF, VLOOKUP).
4๏ธโฃ VLOOKUP vs. INDEX/MATCH?
- VLOOKUP: Searches for a value in the first column and returns a corresponding value.
- INDEX/MATCH: More flexible and overcomes VLOOKUP limitations, better for larger datasets.
5๏ธโฃ What are Pivot Tables?
Interactive tables that summarize and analyze large datasets, allowing you to easily rearrange and filter data.
6๏ธโฃ Conditional Formatting?
Applies formatting (e.g., colors, icons) to cells based on specific criteria, making it easier to identify trends and outliers.
7๏ธโฃ How to remove duplicates?
Use the "Remove Duplicates" feature in the Data tab to eliminate redundant rows based on selected columns.
8๏ธโฃ What are Excel Charts?
Visual representations of data (e.g., bar charts, line charts, pie charts) that help communicate trends and insights.
9๏ธโฃ How to protect a worksheet?
Use the "Protect Sheet" feature in the Review tab to prevent unauthorized changes to the worksheet structure and content.
๐ What are Macros?
Automated sequences of commands that can be recorded and replayed to perform repetitive tasks efficiently.
๐ React โค๏ธ if you found this helpful!
โค2
๐ Want to Excel at Data Analytics? Master These Essential Skills! โ๏ธ
Core Concepts:
โข Statistics & Probability โ Understand distributions, hypothesis testing
โข Excel โ Pivot tables, formulas, dashboards
Programming:
โข Python โ NumPy, Pandas, Matplotlib, Seaborn
โข R โ Data analysis & visualization
โข SQL โ Joins, filtering, aggregation
Data Cleaning & Wrangling:
โข Handle missing values, duplicates
โข Normalize and transform data
Visualization:
โข Power BI, Tableau โ Dashboards
โข Plotly, Seaborn โ Python visualizations
โข Data Storytelling โ Present insights clearly
Advanced Analytics:
โข Regression, Classification, Clustering
โข Time Series Forecasting
โข A/B Testing & Hypothesis Testing
ETL & Automation:
โข Web Scraping โ BeautifulSoup, Scrapy
โข APIs โ Fetch and process real-world data
โข Build ETL Pipelines
Tools & Deployment:
โข Jupyter Notebook / Colab
โข Git & GitHub
โข Cloud Platforms โ AWS, GCP, Azure
โข Google BigQuery, Snowflake
Hope it helps :)
Core Concepts:
โข Statistics & Probability โ Understand distributions, hypothesis testing
โข Excel โ Pivot tables, formulas, dashboards
Programming:
โข Python โ NumPy, Pandas, Matplotlib, Seaborn
โข R โ Data analysis & visualization
โข SQL โ Joins, filtering, aggregation
Data Cleaning & Wrangling:
โข Handle missing values, duplicates
โข Normalize and transform data
Visualization:
โข Power BI, Tableau โ Dashboards
โข Plotly, Seaborn โ Python visualizations
โข Data Storytelling โ Present insights clearly
Advanced Analytics:
โข Regression, Classification, Clustering
โข Time Series Forecasting
โข A/B Testing & Hypothesis Testing
ETL & Automation:
โข Web Scraping โ BeautifulSoup, Scrapy
โข APIs โ Fetch and process real-world data
โข Build ETL Pipelines
Tools & Deployment:
โข Jupyter Notebook / Colab
โข Git & GitHub
โข Cloud Platforms โ AWS, GCP, Azure
โข Google BigQuery, Snowflake
Hope it helps :)
โค4
๐ ๐ฆ๐ผ๐ณ๐๐๐ฎ๐ฟ๐ฒ ๐๐ป๐ด๐ถ๐ป๐ฒ๐ฒ๐ฟ๐ถ๐ป๐ด ๐ช๐ถ๐๐ต ๐๐ ๐๐ฒ๐ฟ๐๐ถ๐ณ๐ถ๐ฐ๐ฎ๐๐ถ๐ผ๐ป ๐ฏ๐ ๐๐๐ง ๐ฅ๐ผ๐ผ๐ฟ๐ธ๐ฒ๐ฒ (๐&๐๐๐ง ๐๐ฐ๐ฎ๐ฑ๐ฒ๐บ๐)
Get guidance from IIT Roorkee experts and become job-ready for top tech roles.
โ Open to all graduates & students
โ Industry-focused curriculum
โ Online learning flexibility
โ Placement Assistance With 5000+ Companies
๐ผ Companies are hiring candidates with strong Software Engineering skills!
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐๐ถ๐ป๐ธ๐:
https://pdlink.in/4pYWCEK
โณ Donโt miss this opportunity to upskill with IIT Roorkee.
Get guidance from IIT Roorkee experts and become job-ready for top tech roles.
โ Open to all graduates & students
โ Industry-focused curriculum
โ Online learning flexibility
โ Placement Assistance With 5000+ Companies
๐ผ Companies are hiring candidates with strong Software Engineering skills!
๐ฅ๐ฒ๐ด๐ถ๐๐๐ฟ๐ฎ๐๐ถ๐ผ๐ป ๐๐ถ๐ป๐ธ๐:
https://pdlink.in/4pYWCEK
โณ Donโt miss this opportunity to upskill with IIT Roorkee.