Data Analyst/Science Jobs | Udemy certificates | courses | Books | Study material

https://in.linkedin.com/jobs/view/data-science-at-exl-4342305751?position=1&pageNum=0&refId=bhv2YWXlCm9Q0q3RP5aYNA%3D%3D&trackingId=2fH%2Blk%2BerqrTYKfhRNLpCw%3D%3D

https://in.linkedin.com/jobs/view/engineering-analyst-youtube-trust-and-safety-at-google-4390499543?position=2&pageNum=0&refId=VtKgVsXtI76NHP71wLBexA%3D%3D&trackingId=LTxhlHpkIFo2EO2H5PJJ%2Fw%3D%3D

https://in.linkedin.com/jobs/view/data-scientist-at-thomson-reuters-4437376572?position=1&pageNum=0&refId=rvZuk7fU7dGfGfxW6JAKZA%3D%3D&trackingId=ZvUIWJZR89HKRD373wVZPQ%3D%3D

https://in.linkedin.com/jobs/view/data-analyst-at-virtusa-4435674799?position=1&pageNum=0&refId=pypuZZ7PrX2vVL6VtyymUQ%3D%3D&trackingId=VOe2bud9r0vIW5fRebyNLA%3D%3D

https://in.linkedin.com/jobs/view/data-scientist-ml-ai-at-philips-4423244065?position=1&pageNum=0&refId=0n4VJjmMUL6eH%2BtBuUqn6w%3D%3D&trackingId=cVY1b8%2FbiVCMht86E2YGAg%3D%3D

https://in.linkedin.com/jobs/view/analyst-data-science-sql-python-genai-at-american-express-4436587062?position=1&pageNum=0&refId=3puyobSjLlilP4nCdyvdsQ%3D%3D&trackingId=9Z%2BSP3PnPXutVX4X4e1k6w%3D%3D

🔥 Top 10 Excel Functions Every Data Analyst Should Know Excel is still one of the most-used tools in the analytics industry. Master these functions to boost your productivity: ✅ "XLOOKUP()" / "VLOOKUP()" – Find and retrieve data from tables. ✅ "INDEX()" + "MATCH()" – A powerful alternative to VLOOKUP. ✅ "IF()" – Apply logical conditions. ✅ "SUMIFS()" – Sum values based on one or more conditions. ✅ "COUNTIFS()" – Count records that meet multiple criteria. ✅ "TEXT()" – Format dates and numbers. ✅ "LEFT()", "RIGHT()", "MID()" – Extract parts of text. ✅ "TRIM()" – Remove unwanted spaces from data. ✅ "CONCAT()" / "TEXTJOIN()" – Combine text from multiple cells. ✅ "FILTER()" – Dynamically filter data (Excel 365/2021). 💡 Pro Tip: Don't just memorize these functions—practice them on real datasets. That's what interviewers care about. 📌 Save this list and revisit it whenever you're practicing Excel. ❤️ Which topic would you like next? 1️⃣ Power BI 2️⃣ SQL 3️⃣ Python 4️⃣ Statistics

https://in.linkedin.com/jobs/view/python-with-gen-ai-at-infosys-4436215054?position=1&pageNum=0&refId=BqtBftYfjym3Mp5SoXVPJw%3D%3D&trackingId=YhE73b85j%2BBaoX5lFcqoZw%3D%3D

https://in.linkedin.com/jobs/view/data-analyst-at-arcana-4321054720?position=1&pageNum=0&refId=3GgH1KrMC4t9Hn28oegNwQ%3D%3D&trackingId=usBBRV4FSkgu4M0STErElw%3D%3D

https://in.linkedin.com/jobs/view/data-scientist-at-procter-gamble-4433174184?position=1&pageNum=0&refId=sX6EsHKADEh0K7ywfFByTA%3D%3D&trackingId=8OMHbztl99Z3Qa8%2FKo5wgw%3D%3D

https://in.linkedin.com/jobs/view/data-information-management-analyst-at-citi-4435423972?position=1&pageNum=0&refId=tu9dXgg1aX9UKP5nIxfx4w%3D%3D&trackingId=Gh5zvSs35FNVGS%2FWjkcm4A%3D%3D

https://in.linkedin.com/jobs/view/data-scientist-i-at-conduent-4416927235?position=1&pageNum=0&refId=RVTHF7mvlDMgoOgmHGalow%3D%3D&trackingId=7wj66tJITUHyqNszLcm1CQ%3D%3D

https://in.linkedin.com/jobs/view/ai-automation-at-volar-fashion-4433171245?position=1&pageNum=0&refId=P377TUrb5i6FVKuVUP4d5A%3D%3D&trackingId=niNTmNYxKkgHqtZhShQG8w%3D%3D

https://www.linkedin.com/jobs/view/4420253744/

https://www.linkedin.com/jobs/view/4409347177/

https://www.linkedin.com/jobs/view/4400395900/

https://www.linkedin.com/jobs/view/4398106370/

https://www.linkedin.com/jobs/view/4387317748/

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. Like if you need more similar content Hope it helps :)

🧠 Daily Data Analyst Practice Challenge Find the 2nd highest salary from a table. Table: Employees (id, name, salary) Try writing the SQL query before checking answer 👇 Answer: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees); 🔥 Doing 1 question daily = Job-ready in 60 days. React 👍 if you want daily challenges posted regularly!