“Revolutionizing Actuarial Science: The Role of Blockchain in Solving Industry Challenges.“ by Olutusin, Mahfuz Adegbola on Medium: https://t.co/yeUDi8wOs0
Muslims are this, Muslims are that. Now all of you are comfortable being called shareholders in a business that was established by a muslim years back. 🌚
That's not even the point
Take a look at this women; well cultured, mannered, dress decently, and speak politely in a lower tone.
In a world where basic decency is rapidly declining, women like this are the best fit for inspiration and models and not the ones constantly dressing half naked on the internet.
Thank you!
🎯 📊 DATA ANALYST MOCK INTERVIEW (WITH ANSWERS)
🧠 1️⃣ Tell me about yourself
✅ Sample Answer:
“I have around 3 years of experience working with data. My core skills include SQL, Excel, and Power BI. I regularly work with data cleaning, transformation, and building dashboards to generate business insights. Recently, I’ve also been strengthening my Python skills for data analysis. I enjoy solving business problems using data and presenting insights in a simple and actionable way.”
📊 2️⃣ What is the difference between WHERE and HAVING?
✅ Answer:
WHERE filters rows before aggregation
HAVING filters after aggregation
Example:
SELECT department, COUNT(*)
FROM employees
GROUP BY department
HAVING COUNT(*) > 5;
🔗 3️⃣ Explain different types of JOINs
✅ Answer:
INNER JOIN → only matching records
LEFT JOIN → all left + matching right
RIGHT JOIN → all right + matching left
FULL JOIN → all records from both
👉 In analytics, LEFT JOIN is most used.
🧠 4️⃣ How do you find duplicate records in SQL?
✅ Answer:
SELECT column, COUNT(*)
FROM table
GROUP BY column
HAVING COUNT(*) > 1;
👉 Used for data cleaning.
📈 5️⃣ What are window functions?
✅ Answer:
“Window functions perform calculations across rows without reducing the number of rows. They are used for ranking, running totals, and comparisons.”
Example:
SELECT salary, RANK() OVER(ORDER BY salary DESC)
FROM employees;
📊 6️⃣ How do you handle missing data?
✅ Answer:
Remove rows (if small impact)
Replace with mean/median
Use default values
Use interpolation (advanced)
👉 Depends on business context.
📉 7️⃣ What is the difference between COUNT(_) and COUNT(column)?
✅ Answer:
COUNT(*) → counts all rows
COUNT(column) → ignores NULL values
📊 8️⃣ What is a KPI? Give example
✅ Answer:
“KPI (Key Performance Indicator) is a measurable value used to track performance.”
Examples: Revenue growth, Conversion rate, Customer retention
🧠 9️⃣ How would you find the 2nd highest salary?
✅ Answer:
SELECT MAX(salary)
FROM employees
WHERE salary < ( SELECT MAX(salary) FROM employees );
📊 🔟 Explain your dashboard project
✅ Strong Answer:
“I created a sales dashboard in Power BI where I analyzed revenue trends, top-performing products, and regional performance. I used DAX for calculations and added filters for better interactivity. This helped stakeholders identify key areas for growth.”
🔥 1️⃣1️⃣ What is normalization?
✅ Answer:
“Normalization is the process of organizing data to reduce redundancy and improve data integrity.”
📊 1️⃣2️⃣ Difference between INNER JOIN and LEFT JOIN?
✅ Answer:
INNER JOIN → only matching data
LEFT JOIN → keeps all left table data
👉 LEFT JOIN is preferred in analytics.
🧠 1️⃣3️⃣ What is a CTE?
✅ Answer:
“A CTE (Common Table Expression) is a temporary result set defined using WITH clause to improve readability.”
📈 1️⃣4️⃣ How do you explain insights to non-technical people?
✅ Answer:
“I focus on storytelling. Instead of technical terms, I explain insights in simple business language with visuals and examples.”
📊 1️⃣5️⃣ What tools have you used?
✅ Answer:
SQL, Excel, Power BI, Python (basic/advanced depending on you)
💼 1️⃣6️⃣ Behavioral Question: Tell me about a challenge
✅ Answer:
“While working on a dataset, I found inconsistencies in data. I cleaned and standardized it using SQL and Excel, ensuring accurate analysis. This improved the dashboard reliability.”
Double Tap ♥️ For More
All Paid Courses – FREE for the First 450 People Only Excel Friends!
Complete List of Premium Courses You Can Get for Free:
1. Agile
2. AI for Business Analysts
3. BA Interview Preparation
4. BA Resume Building
5. BA Technical Skills
6. Big Data
7. Data Analytics
8. Data Dictionary
9. Data Visualization
10. Data Analysis Fundamentals
11. Day-to-Day Business Analysis
12. Domain Documents
13. Glossary for Business Analysts
14. IIBA Certifications
15. Microsoft Excel Mastery
16. PMP Certification
17. Process Mapping
18. Product Management
19. Product Owner
20. Project Management
21. Quality Assurance
22. Requirement Documents
23. Requirement Modelling
24. Requirements Gathering
25. Scrum Master
26. SQL
27. SQL + Tableau + Power BI
28. Test Case Document
29. UI/UX Designing
⏰ Available for only 24 Hours!
How to Claim:
1. Follow me @gudanglifehack (so I can send you the DM)
2. Like + RT this post
3. Reply with the word “Excel”
4. Turn on post notifications 🔔
Don’t miss out — spots are limited to the first 450 people only!
Friendly reminders:
Arabic = language
Arab = people
Not all Arabs are Muslim
Not all Muslims are Arab
Not all people/countries from SWANA (Southwest Asia & North Africa) are Arab
Turkey is not an Arab country
Iran is not an Arab country
Afghanistan is not an Arab country
Allah is the Arabic word for God and Arab Christians say Allah along with inshallah, mashallah, etc
@BambuluMen Men have 2 choices
Prenuptial agreement
or
Have high standards and stop trying to make every decent looking woman you get along with your wife/gf
@oraimomate Good day, I've a complication with my oraimo buds
I purchased this Oraimo SpaceBuds N SKU: OTW-626N-BLACK August 2025, kindly see attachment for more information.
I noticed this night after having a long day at school wanting to relax with my buds in my ear and....1
@oraimomate listen to some old school burna boy I realized it have bulged and this is very shocking and the same time surprising its also giving some itchy feeling when I tried to manage to use it. I'm very certain this product comes with a 365 days warranty...... 2
Instead of some of you to ask questions, WHY... The main reason not good to Put Solar Panel on roof is simply because of fire outbreak, even those people you're referring to as professional can make a mistake in fixing your panel up, and any mistake from them you will be the one to pay for it, safest way to install solar panels is to build a separate structure with iron base for them