Power BI Interview Question: Imagine you have two tables - 1. Sales: Contains sales transactions with columns like ProductID, SalesAmount, and Date. 2. Products: Contains product information with columns like ProductID and Category. A relationship exists between

SQL Interview Question: How to calculate 3-month rolling sales using window functions in SQL? Answer: SELECT sale_date, SUM(sale_amount) OVER (ORDER BY sale_date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_3month_sales FROM sales_table; Explanation:

Excel Interview Question: If the lookup column is present on the right, how do you look up values in Excel? Answer: VLOOKUP is designed to search from left to right, so it is not ideal. 1. INDEX and MATCH: This is the most versatile and recommended method. INDEX and

The madness continues… and we’re down to the Final Four. 🏀 Florida, Auburn, Duke, and Houston are all that remain—and you know we had to ask Numbers Station to break down how this weekend might play out. Same drill: 📂 Uploaded Evan Miyakawa’s CSV 📓 Asked in plain English ⚡ Got

Frequently Asked Power BI DAX Interview Question: Situation: You are working on a Power BI report where you need to analyze year-to-date (YTD) sales performance. Your data model includes a Sales table with columns like SaleDate, Amount, and ProductID, along with a properly

Power BI Associate Interview Question: You are working on a Power BI report for a retail company. The data model includes two tables: Sales and Calendar. There are two relationships between these tables: Active Relationship – Connects Sales[OrderDate] to Calendar[Date] (used

SQL Interview Question: Situation: You are working on a complex SQL query that involves multiple subqueries to analyze sales data across different regions. The query is becoming difficult to read and maintain due to nested subqueries and repeated logic. Problem: The current

Financial Analyst - Excel Interview Question: Situation: You are working on a financial report in Excel that consolidates sales data from multiple regions. The report uses a large dataset where each region's sales figures are updated monthly. You need to quickly retrieve

Omitted Variable Bias Explained: Leaving out a relevant variable can cause the model to have a biased or misleading result. Omitted variable bias, also known as confounding or missing variable bias, occurs when a relevant variable is not included in a statistical model, leading

Baidu Doubles Down: Meet the Turbo ERNIE Models – Faster, Smarter & 80% Cheaper! Just over a month after the blockbuster launch of ERNIE 4.5 and ERNIE X1, Baidu is back with an even bigger surprise:  ERNIE 4.5 Turbo and ERNIE X1 Turbo—delivering blazing speed, sharper