Data Analytics

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Sales

John 12,000
Sarah 18,000
Mike 15,000
David 20,000
Alice 10,000

Find the running total of sales for each employee.

𝗠𝗲: Challenge accepted! 💪

=SUM(B2:B2)

Copy the formula down.

💡 Explanation:
The formula calculates a cumulative total as you move down the rows.
B2 keeps the starting cell fixed.
B2 changes as the formula is copied down.

Each row adds the current employee's sales to all previous sales.

🎯 Expected Output Example

Employee Sales Running Total

John 12,000 12,000
Sarah 18,000 30,000
Mike 15,000 45,000
David 20,000 65,000
Alice 10,000 75,000

🚀 Bonus — Using Excel Table References
If your data is formatted as an Excel Table named SalesData:

=SUM(INDEX(SalesData[Sales],1):[@Sales])

This approach automatically expands as new rows are added to the table.

🚀 Tip for Excel Job Seekers:
Running-total questions are common in Excel interviews because they test whether you understand cell references and cumulative calculations.

Also practice:
• Running totals
• Running averages
• Monthly cumulative sales
• YTD calculations
• Cumulative percentages

These are frequently used in real-world reporting and dashboards.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000


Find the employees whose salary is above the average salary of their department.

𝗠𝗲: Challenge accepted! 💪

=C2>AVERAGEIF(B2:B6,B2,C2:C6)


💡 Explanation:

The formula compares each employee's salary with the average salary of their own department.

• AVERAGEIF() calculates the average salary for the employee's department.
• B2 identifies the current employee's department.
• C2 is the employee's salary.

The formula returns TRUE when the employee earns more than their department average.


🎯 Expected Output Example

Employee Department Salary Above Dept. Average?

John IT 75,000 FALSE
Sarah HR 60,000 FALSE
Mike IT 82,000 TRUE
David Finance 90,000 FALSE
Alice HR 65,000 TRUE


🚀 Bonus — Return the Employee Name Only

In Excel 365:

=FILTER(
A2:A6,
C2:C6>AVERAGEIF(B2:B6,B2:B6,C2:C6)
)

This returns the employees whose salaries are above their respective department averages.


❤️ React with ❤️ for more Excel interview challenges!

30+ companies are hiring through AccioJob right now 🚀

From Software Development to Data & Analytics — AccioJob learners get access to hiring opportunities across multiple roles.
And the outcomes speak for themselves:

✅ 2,100+ Students Placed
✅ ₹7.4 LPA Avg | ₹41 LPA Highest
✅ Real-world Projects
✅ Mock Interviews + 100% Placement Support

Learn job-ready skills with Data Analytics and prepare for opportunities that actually exist.

👉 Register now: https://go.acciojob.com/55G3bH

🚀 DATA ANALYTICS + AI: YOUR NEXT CAREER MOVE!

Data is everywhere. The right skills can put you ahead.
Join the PW Skills Data Analytics With AI Course and learn Excel, SQL, Python, Power BI & AI tools through live sessions and real-world projects.

✨ What you get:
✅ Industry-relevant Data Analytics skills
✅ AI-powered learning
✅ Microsoft collaboration
✅ Hands-on projects
✅ Job assistance*
✅ Live classes in Hinglish

📅 Starts: 14th August 2026
⏳ Duration: 5 Months
🔥 Ready to become a future-ready Data Analyst?
👉
Enroll Now & Start Your Upskilling Journey!
https://lp.pwskills.com/data-analytics-with-gen-ai-online-course?utm_source=telegram&utm_medium=influencer&utm_campaign=deepakDAonline

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄e𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000


How would you find the second highest salary in the IT department?

𝗠𝗲: Challenge accepted! 💪

=LARGE(FILTER(C2:C6,B2:B6="IT"),2)

💡 Explanation:

This formula combines FILTER() and LARGE() to find the second highest salary within a specific department.

- FILTER(C2:C6,B2:B6="IT") returns only salaries from the IT department.
- LARGE(...,2) returns the second largest value from those salaries.

The result is 75,000.


This challenge tests your understanding of: ✅ FILTER()
✅ LARGE()
✅ Conditional Filtering
✅ Combining Excel Functions


🚀 Bonus (Without FILTER)

For older Excel versions, you can use:

=AGGREGATE(14,6,C2:C6/(B2:B6="IT"),2)

Here:

14 represents LARGE.

6 ignores errors.

B2:B6="IT" filters the calculation to the IT department.

2 returns the second largest value.


❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000

How would you find the average salary of employees who earn more than 70,000?

𝗠𝗲: Challenge accepted! 💪

=AVERAGEIF(C2:C6,">70000",C2:C6)

💡 Explanation:

AVERAGEIF() calculates the average of values that meet a specific condition.

C2:C6 is the salary range.

">70000" filters salaries greater than 70,000.

The result is the average of the qualifying salaries.

This challenge tests your understanding of: ✅ AVERAGEIF()
✅ Conditional Calculations
✅ Criteria-Based Analysis

🎯 Expected Output Example

Employee Salary

John 75,000
Mike 82,000
David 90,000

Average salary:

82,333.33

🚀 Bonus (Multiple Conditions)

Find the average salary of employees in the IT department who earn more than 70,000:

=AVERAGEIFS(C2:C6,B2:B6,"IT",C2:C6,">70000")

This combines multiple criteria using AVERAGEIFS().

❤️ React with ❤️ for more Excel interview challenges!

15 Advanced Excel Shortcut Keys

• Navigation
1. Move to last used cell → Ctrl + End
2. Move to first cell → Ctrl + Home
3. Select to last used cell → Ctrl + Shift + End
4. Select to first cell → Ctrl + Shift + Home

• Rows  Columns
5. Insert entire row → Ctrl + Shift + +
6. Delete entire row → Ctrl + -
7. Hide selected rows → Ctrl + 9
8. Unhide rows → Ctrl + Shift + 9
9. Hide selected columns → Ctrl + 0
10. Unhide columns → Ctrl + Shift + 0

• Formatting
11. Open Format Cells → Ctrl + 1
12. Apply General format → Ctrl + Shift + ~
13. Apply Number format → Ctrl + Shift + !
14. Apply Percentage format → Ctrl + Shift + %
15. Apply Currency format → Ctrl + Shift + $

Double Tap ♥️ For More

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:
Employee | Department | Salary
John | IT | 75,000
Sarah | HR | 60,000
Mike | IT | 82,000
David | Finance | 90,000
Alice | HR | 65,000

How would you find the employee with the highest salary in the IT department?

𝗠𝗲: Challenge accepted! 💪

=XLOOKUP(
    MAXIFS(C2:C6,B2:B6,"IT"),
    C2:C6,
    A2:A6
)

💡 Explanation:
This formula combines MAXIFS() and XLOOKUP() to find the employee with the highest salary within a specific department.

MAXIFS() finds the highest salary where the department is IT.
XLOOKUP() searches for that salary in the Salary column.
It returns the corresponding employee name.

This challenge tests your understanding of:
✅ MAXIFS()
✅ XLOOKUP()
✅ Multiple Criteria
✅ Combining Excel Functions

🎯 Expected Output Example
Department | Highest Salary | Employee
IT | 82,000 | Mike

🚀 Bonus (Dynamic Department)
If cell E2 contains the department name:

=XLOOKUP(
    MAXIFS(C2:C6,B2:B6,E2),
    C2:C6,
    A2:A6
)

Now you can change E2 to HR, Finance, or another department and get the corresponding highest-paid employee.

⚠️ Interview Tip:
If two employees have the same highest salary, XLOOKUP() returns the first matching employee. Be ready to explain how you would modify the formula if the interviewer wants all employees tied for the highest salary.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:

You have 2 minutes to solve this Excel problem.

You have the following data:

Employee | Department | Salary

John | IT | 75,000

Sarah | HR | 60,000

Mike | IT | 82,000

David | Finance | 90,000

Alice | HR | 65,000

Question: How would you calculate the total salary for employees who belong to the IT department and earn more than 80,000?

𝗠𝗲: Challenge accepted! 💪

=SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000")

💡 Explanation:

The SUMIFS() function adds values based on multiple conditions.

• C2:C6 is the range to sum (Salary)

• B2:B6,"IT" includes only employees from the IT department

• C2:C6,">80000" includes only salaries greater than 80,000

Excel returns the total salary for employees meeting both conditions.

This challenge tests your understanding of:

✅ SUMIFS()

✅ Multiple Criteria

✅ Conditional Aggregation

✅ Data Analysis

🎯 Expected Output Example

Formula: =SUMIFS(C2:C6,B2:B6,"IT",C2:C6,">80000")

Result: 82,000

(Only Mike meets both conditions.)

🚀 Bonus (Using Cell References for Dynamic Criteria)

=SUMIFS(C2:C6,B2:B6,E2,C2:C6,">"&F2)

If:

E2 = IT

F2 = 80000

The formula becomes dynamic and updates automatically when the criteria change.

🚀 Tip for Excel Job Seekers:

SUMIFS() is one of the most frequently used Excel functions in reporting and dashboards. Be comfortable using it with multiple conditions such as:

Department + Salary

Region + Month

Product + Category

Employee + Performance

Mastering SUMIFS() is essential for Excel interviews and real-world business reporting.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee Department Salary

John IT 75,000
Sarah HR 60,000
Mike IT 82,000
David Finance 90,000
Alice HR 65,000

How would you calculate the highest salary in each department?

𝗠𝗲: Challenge accepted! 💪

For Excel 365 / Excel 2021:

=MAXIFS(C2:C6,B2:B6,E2)

(Assume cell E2 contains the department name, such as IT.)

💡 Explanation:

The MAXIFS() function returns the maximum value that meets one or more conditions.

C2:C6 is the salary range.

B2:B6 is the department range.

E2 contains the department to search for.

Excel returns the highest salary for the selected department.


This challenge tests your understanding of: ✅ MAXIFS()
✅ Conditional Functions
✅ Data Analysis

🎯 Expected Output Example

Department Highest Salary

IT 82,000
HR 65,000
Finance 90,000


🚀 Bonus (For Older Excel Versions)

=MAX(IF(B2:B6=E2,C2:C6))

Note: In older Excel versions, confirm this as an array formula by pressing Ctrl + Shift + Enter instead of just Enter.

🚀 Tip for Excel Job Seekers:

The MAXIFS() and MINIFS() functions are frequently used in business reporting. Make sure you also practice:

SUMIFS()

COUNTIFS()

AVERAGEIFS()

MAXIFS()

MINIFS()


These are among the most commonly tested Excel functions in interviews and are essential for real-world reporting and dashboard creation.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:
Employee | Salary
John | 75,000
Sarah | 60,000
Mike | 82,000
David | 90,000
Alice | 65,000

How would you return the second highest salary?

𝗠𝗲: Challenge accepted! 💪

=LARGE(B2:B6,2)

💡 Explanation:
The LARGE() function returns the Nth largest value from a range.
B2:B6 is the range containing salary values.
2 tells Excel to return the second largest value.
In this example, the result is 82,000.

This challenge tests your understanding of:
✅ LARGE()
✅ Ranking Values
✅ Statistical Functions

🎯 Expected Output Example
Formula: =LARGE(B2:B6,2) | Result: 82,000

🚀 Bonus: Return the Employee Name with the Second Highest Salary
For Microsoft 365 / Excel 2021:
=XLOOKUP(LARGE(B2:B6,2),B2:B6,A2:A6)

For older versions of Excel:
=INDEX(A2:A6,MATCH(LARGE(B2:B6,2),B2:B6,0))

These formulas return Mike, who has the second highest salary.

🚀 Tip for Excel Job Seekers:
Interviewers often ask questions involving the Nth highest or Nth lowest value. Make sure you're comfortable with:
• LARGE()
• SMALL()
• RANK()
• SORT()
• FILTER()

These functions are frequently used in dashboards, reports, and data analysis tasks.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee: Joining Date
John: 15-Jan-2022
Sarah: 20-Mar-2021
Mike: 10-Jul-2023
David: 05-Nov-2020

How would you calculate the number of years each employee has worked in the company?

𝗠𝗲: Challenge accepted! 💪

Formula:
=DATEDIF(B2,TODAY(),"Y")

💡 Explanation:
The DATEDIF() function calculates the difference between two dates.
B2 is the employee's joining date.
TODAY() returns the current date.
"Y" returns the number of completed years between the two dates.

Copy the formula down to calculate the years of service for all employees.

This challenge tests your understanding of:
✅ DATEDIF()
✅ TODAY()
✅ Date Functions
✅ Employee Tenure Calculation

🎯 Expected Output Example

Employee: Joining Date: Years of Service
John: 15-Jan-2022: 4
Sarah: 20-Mar-2021: 5
Mike: 10-Jul-2023: 3
David: 05-Nov-2020: 5

Results will change automatically as time passes because TODAY() is dynamic.

🚀 Bonus: Calculate Complete Years and Months
=DATEDIF(B2,TODAY(),"Y")&" Years "&DATEDIF(B2,TODAY(),"YM")&" Months"

Example Output:
4 Years 6 Months
2 Years 3 Months

🚀 Tip for Excel Job Seekers:
Date functions are commonly asked in Excel interviews. Make sure you're comfortable with:
TODAY(), NOW(), DATEDIF(), EDATE(), EOMONTH(), YEAR(), MONTH(), DAY()

These functions are widely used in HR, finance, payroll, and reporting.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

+----------+--------+
| Employee | Sales  |
+----------+--------+
| John     | 12,000 |
| Sarah    | 18,000 |
| Mike     | 15,000 |
| David    | 20,000 |
| Alice    | 10,000 |
+----------+--------+

How would you return "High Performer" if sales are greater than or equal to 18,000, "Average Performer" if sales are between 12,000 and 17,999, otherwise return "Low Performer"?

𝗠𝗲: Challenge accepted! 💪

=IFS(
C2>=18000,"High Performer",
C2>=12000,"Average Performer",
TRUE,"Low Performer"
)

💡 Explanation:
The IFS() function checks multiple conditions in sequence and returns the result for the first condition that evaluates to TRUE.

• If sales are 18,000 or more, it returns "High Performer".
• If sales are 12,000 or more, it returns "Average Performer".
• Otherwise, it returns "Low Performer".

This challenge tests your understanding of:
✅ IFS()
✅ Logical Functions
✅ Multiple Conditions
✅ Data Categorization

🎯 Expected Output Example

Employee: John
Sales: 12,000
Performance: Average Performer

Employee: Sarah
Sales: 18,000
Performance: High Performer

Employee: Mike
Sales: 15,000
Performance: Average Performer

Employee: David
Sales: 20,000
Performance: High Performer

Employee: Alice
Sales: 10,000
Performance: Low Performer

🚀 Bonus (Compatible with Older Excel Versions)

=IF(C2>=18000,
"High Performer",
IF(C2>=12000,
"Average Performer",
"Low Performer"))

Nested IF() functions provide the same result and work in Excel versions that don't support IFS().

🚀 Tip for Excel Job Seekers:
Logical functions are heavily used in reporting and dashboards. Make sure you're comfortable with:

• IF()
• IFS()
• AND()
• OR()
• IFERROR()

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 
You have 2 minutes to solve this Excel problem.

You have the following data:

+----------+--------+
| Employee | Sales  |
+----------+--------+
| John     | 12,000 |
| Sarah    | 18,000 |
| Mike     | 15,000 |
| David    | 20,000 |
| Alice    | 10,000 |
+----------+--------+

How would you rank each employee based on their sales, with the highest sales getting Rank 1?

𝗠𝗲: Challenge accepted! 💪

=RANK(C2,C2:C6,0)

💡 Explanation:

The RANK() function returns the rank of a number within a list.

• C2 is the sales value to rank.
• C2:C6 is the fixed range containing all sales values.
• 0 ranks values in descending order, so the highest sales receive Rank 1.
• Copy the formula down to rank all employees.

This challenge tests your understanding of: ✅ RANK() 
✅ Relative & Absolute References 
✅ Ranking Data 
✅ Excel Formulas 

🎯 Expected Output Example

+----------+--------+------+
| Employee | Sales  | Rank |
+----------+--------+------+
| John     | 12,000 | 4    |
| Sarah    | 18,000 | 2    |
| Mike     | 15,000 | 3    |
| David    | 20,000 | 1    |
| Alice    | 10,000 | 5    |
+----------+--------+------+

🚀 Bonus (Handle Duplicate Rankings)

=RANK.EQ(C2,C2:C6,0)

Or use:

=RANK.AVG(C2,C2:C6,0)

RANK.EQ() assigns the same rank to duplicate values. 
RANK.AVG() assigns the average rank to duplicate values.

🚀 Be comfortable using:

• RANK()
• RANK.EQ()
• RANK.AVG()
• LARGE()
• SMALL()

These functions are frequently used in sales reports, leaderboards, and performance dashboards.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee | Department | Salary
John | IT | 75,000
Sarah | HR | 60,000
Mike | IT | 82,000
David | Finance | 90,000
Alice | HR | 65,000

How would you count the number of unique departments?

𝗠𝗲: Challenge accepted! 💪

=COUNTA(UNIQUE(B2:B6))

💡 Explanation:
The UNIQUE() function extracts distinct department names, and COUNTA() counts how many unique values are returned.

UNIQUE(B2:B6) returns: IT, HR, Finance.
COUNTA() counts these unique values.

The result is the total number of unique departments.

This challenge tests your understanding of: ✅ UNIQUE()
✅ COUNTA()
✅ Dynamic Arrays
✅ Data Analysis

🎯 Expected Output Example

Formula | Result
=COUNTA(UNIQUE(B2:B6)) | 3

(The unique departments are IT, HR, and Finance.)

🚀 Bonus (For Older Excel Versions)
=SUMPRODUCT((B2:B6<>"")/COUNTIF(B2:B6,B2:B6))

This formula counts unique values without using the UNIQUE() function, making it compatible with older versions of Excel.

🚀 Tip for Excel Job Seekers:
Modern Excel functions are becoming increasingly common in interviews. Be familiar with:

UNIQUE()
FILTER()
SORT()
SEQUENCE()
TEXTSPLIT()

These dynamic array functions simplify complex formulas and are widely used in Microsoft 365.

❤️ React with ❤️ for more Excel interview challenges!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿:
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee ID | Employee Name | Sales
--- | --- | ---
101 | John | 12,000
102 | Sarah | 18,000
103 | Mike | 15,000
104 | David | 20,000

How would you return "Yes" if an employee's sales are greater than or equal to 15,000, otherwise return "No"?

𝗠𝗲: Challenge accepted! 💪

=IF(C2>=15000,"Yes","No")

💡 Explanation:

The IF() function checks whether a condition is true or false.

C2>=15000 checks if the sales value is at least 15,000.

If the condition is TRUE, Excel returns "Yes".

If the condition is FALSE, Excel returns "No".

🎯 Expected Output Example

+----------+--------+----------+
| Employee | Sales  | Eligible |
+----------+--------+----------+
| John     | 12,000 | No       |
| Sarah    | 18,000 | Yes      |
| Mike     | 15,000 | Yes      |
| David    | 20,000 | Yes      |
+----------+--------+----------+

🚀 Bonus (Using Nested IF)

=IF(C2>=20000,"Excellent", IF(C2>=15000,"Good","Needs Improvement"))

This formula categorizes employees into three performance levels:

• Excellent → Sales ≥ 20,000
• Good → Sales ≥ 15,000
• Needs Improvement → Sales < 15,000

🚀 The IF() function is one of the most frequently asked Excel interview topics. Once you're comfortable with it, practice:

IFS()

IFERROR()

AND()

OR()

SWITCH()

These logical functions are widely used in reports, dashboards, and business decision-making.

❤️ React with ❤️ for more Excel interview challenges!

✅SQL Roadmap: Step-by-Step Guide to Master SQL 🧠💻

Whether you're aiming to be a backend dev, data analyst, or full-time SQL pro — this roadmap has got you covered 👇

📍 1. SQL Basics
⦁  SELECT, FROM, WHERE
⦁  ORDER BY, LIMIT, DISTINCT 
   Learn data retrieval & filtering.

📍 2. Joins Mastery
⦁  INNER JOIN, LEFT/RIGHT/FULL OUTER JOIN
⦁  SELF JOIN, CROSS JOIN 
   Master table relationships.

📍 3. Aggregate Functions
⦁  COUNT(), SUM(), AVG(), MIN(), MAX() 
   Key for reporting & analytics.

📍 4. Grouping Data
⦁  GROUP BY to group
⦁  HAVING to filter groups 
   Example: Sales by region, top categories.

📍 5. Subqueries & Nested Queries
⦁  Use subqueries in WHERE, FROM, SELECT
⦁  Use EXISTS, IN, ANY, ALL 
   Build complex logic without extra joins.

📍 6. Data Modification
⦁  INSERT INTO, UPDATE, DELETE
⦁  MERGE (advanced) 
   Safely change dataset content.

📍 7. Database Design Concepts
⦁  Normalization (1NF to 3NF)
⦁  Primary, Foreign, Unique Keys 
   Design scalable, clean DBs.

📍 8. Indexing & Query Optimization
⦁  Speed queries with indexes
⦁  Use EXPLAIN, ANALYZE to tune 
   Vital for big data/enterprise work.

📍 9. Stored Procedures & Functions
⦁  Reusable logic, control flow (IF, CASE, LOOP) 
   Backend logic inside the DB.

📍 10. Transactions & Locks
⦁  ACID properties
⦁  BEGIN, COMMIT, ROLLBACK
⦁  Lock types (SHARED, EXCLUSIVE) 
   Prevent data corruption in concurrency.

📍 11. Views & Triggers
⦁  CREATE VIEW for abstraction
⦁  TRIGGERS auto-run SQL on events 
   Automate & maintain logic.

📍 12. Backup & Restore
⦁  Backup/restore with tools (mysqldump, pg_dump) 
   Keep your data safe.

📍 13. NoSQL Basics (Optional)
⦁  Learn MongoDB, Redis basics
⦁  Understand where SQL ends & NoSQL begins.

📍 14. Real Projects & Practice
⦁  Build projects: Employee DB, Sales Dashboard, Blogging System
⦁  Practice on LeetCode, StrataScratch, HackerRank

📍 15. Apply for SQL Dev Roles
⦁  Tailor resume with projects & optimization skills
⦁  Prepare for interviews with SQL challenges
⦁  Know common business use cases

💡 Pro Tip: Combine SQL with Python or Excel to boost your data career options.

💬 Double Tap ♥️ For More!

𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄𝗲𝗿: 
You have 2 minutes to solve this Excel problem.

You have the following data:

Employee  Department  Salary 
John  IT 75,000 
Sarah  HR 60,000 
Mike  IT 82,000 
David  IT 78,000 
Alice   HR 65,000

How would you count the number of employees in the IT department?

𝗠𝗲: Challenge accepted! 💪

=COUNTIF(B2:B6,"IT")

💡 Explanation: 
The COUNTIF() function counts the number of cells that meet a specific condition. 

• B2:B6 is the range containing department names.
• "IT" is the condition (criteria).
• Excel counts all rows where the department is IT.

This challenge tests your understanding of: 
✅ COUNTIF() 
✅ Conditional Counting 
✅ Data Analysis

🎯 Expected Output Example 
Formula Result 
=COUNTIF(B2:B6,"IT") -> 3 
(John, Mike, and David belong to the IT department.)

🚀 Bonus (Using a Cell Reference as Criteria) 
=COUNTIF(B2:B6,E2)

If cell E2 contains IT, the formula becomes dynamic and automatically updates when the value in E2 changes.

🚀  COUNTIF() is one of the most commonly used Excel functions. After mastering it, practice: 
• COUNTIFS()
• SUMIF()
• SUMIFS()
• AVERAGEIF()
• AVERAGEIFS()

These functions are essential for reporting, dashboards, and Excel interviews.

❤️ React with ❤️ for more interview challenges!

If you want to Excel as a Data Analyst, master these powerful skills:

• SQL Queries – SELECT, JOINs, GROUP BY, CTEs, Window Functions
• Excel Functions – VLOOKUP, XLOOKUP, PIVOT TABLES, POWER QUERY
• Data Cleaning – Handle missing values, duplicates, and inconsistencies
• Python for Data Analysis – Pandas, NumPy, Matplotlib, Seaborn
• Data Visualization – Create dashboards in Power BI/Tableau
• Statistical Analysis – Hypothesis testing, correlation, regression
• ETL Process – Extract, Transform, Load data efficiently
• Business Acumen – Understand industry-specific KPIs
• A/B Testing – Data-driven decision-making
• Storytelling with Data – Present insights effectively

Like it if you need a complete tutorial on all these topics! 👍❤️

Top 10 Power BI interview questions with answers:

1. What are the key components of Power BI?

Solution:

Power Query: Data transformation and preparation.

Power Pivot: Data modeling.

Power View: Data visualization.

Power BI Service: Cloud-based sharing and collaboration.

Power BI Mobile: Mobile reports and dashboards.

2. What is DAX in Power BI?

Solution:
DAX (Data Analysis Expressions) is a formula language used in Power BI to create calculated columns, measures, and tables.
Example:

TotalSales = SUM(Sales[Amount])

3. What is the difference between a calculated column and a measure?

Solution:

Calculated Column: Computed row by row in the data model.

Measure: Computed at the aggregate level based on filters in a visualization.

4. How do you connect Power BI to a database?

Solution:

1. Open Power BI Desktop.


2. Go to Home > Get Data > Database (e.g., SQL Server).


3. Enter server and database details, then load or transform data.

5. What is the role of relationships in Power BI?

Solution:
Relationships define how tables in a data model are connected. Power BI uses relationships to filter and calculate data across multiple tables.

6. What are slicers in Power BI?

Solution:
Slicers are visual filters that allow users to interactively filter data in reports.
Example: A slicer for "Region" lets users view data specific to a selected region.

7. How do you implement Row-Level Security (RLS) in Power BI?

Solution:

1. Define roles in Modeling > Manage Roles.


2. Use DAX expressions to restrict data (e.g., [Region] = "North").


3. Assign roles to users in the Power BI Service.

8. What are the different types of joins in Power BI?

Solution:
Power BI offers the following join types in Power Query:

Inner Join

Left Outer Join

Right Outer Join

Full Outer Join

Anti Join (Left/Right Exclusion)

9. What is the difference between Power BI Pro and Power BI Premium?

Solution:

Power BI Pro: Allows sharing and collaboration for individual users.

Power BI Premium: Provides dedicated resources, larger dataset sizes, and supports enterprise-level usage.

10. How can you optimize Power BI reports for performance?

Solution:

- Use summarized datasets.

- Reduce visuals on a single page.

- Optimize DAX expressions.

- Enable aggregations for large datasets.

- Use query folding in Power Query.

Share with credits: https://t.me/sqlspecialist

Hope it helps :)